SQL Server / PostgreSQL
Expertise in relational schema design for manufacturing & operational datasets: process parameters, event logs, genealogy, quality, maintenance and KPIs. I tune indexing, partitioning and retention strategies for sustainable performance under write-heavy ingest and analytical querying.
Tooling: execution plan analysis, statistics management, row vs columnar trade-offs, logical decoding / CDC, temporal tables, snapshot isolation use and automated drift detection.