Design and review relational database schemas for MariaDB across all ICX modules including CRM, Billing System, Customer Portal, Field Service Management, and Smart Metering, ensuring normalisation, referential integrity, and performance optimisation
Design ClickHouse table schemas, data models, and materialised views for ICX reporting, billing analytics, and customer consumption dashboards
Conduct query performance tuning across MariaDB and ClickHouse, including EXPLAIN plan analysis, index design, query rewriting, and partitioning strategies for large tables
...