- Audit current SQL Server DMP servers and produce a remediation plan.
- Diagnose and resolve SQL Server issues like index bloat, lock contention, and storage pressure.
- Enhance monitoring and alerting through SolarWinds.
- Lead the rollout of Airflow for orchestration.
- Design PostgreSQL schemas and ClickHouse structures for a new multi-tenant platform.
- Build ingestion processes for high-volume data and streaming.
- Model data for read performance using denormalized models and aggregation tables.
- Lead incident response and post-mortem improvements.
- Guide engineering teams on database optimization and best practices.
AWSPostgreSQLSQL+5 more