• Evaluate and redesign heavily denormalized SQL Server database environments. • Architect solutions to separate historical data from real-time OLTP workloads. • Reduce table bloat and optimize large-scale tables for read/write performance. • Optimize indexing strategies, query performance, and access patterns across large datasets. • Assess and execute consolidation of approximately 30 independent database pods into a unified architecture. • Design and implement scalable multi-tenant database models. • Lead migration strategy from SQL Server to PostgreSQL where appropriate. • Work extensively within Azure environments, including Azure SQL Hyperscale. • Establish data lifecycle management practices and ETL/data movement strategies. • Operate directly in production systems, diagnosing and resolving complex technical challenges. • Lead modernization efforts through hands-on execution and technical example.