- Maintain complex replication models and high-availability solutions such as clustering or multi-AZ deployments.
- Design, implement, and maintain the primary SQL Server infrastructure.
- Support, monitor, and maintain Oracle Exadata@AWS, AWS Aurora MySQL, and PostgreSQL platforms.
- Design and implement disaster recovery strategies, and participate in DR exercises and automated failover testing.
- Establish data retention, archiving, and purging policies, and implement database security measures.
- Lead performance tuning, query optimization, capacity management, and analysis of performance metrics.
- Advise on database modernization, including transitions to cloud-native or containerized architectures.
- Develop database standards, deployment pipelines, and operating procedures.
- Promote Operations-as-Code by mentoring the team in Terraform, Ansible, and CI/CD automation.
PostgreSQLPythonMicrosoft SQL Server+5 more