- Design, deploy, and maintain PostgreSQL clusters in AWS environments using Infrastructure as Code (IaC) tools.
- Develop automation for provisioning, configuration management, and monitoring of PostgreSQL databases.
- Perform regular database maintenance including vacuuming, reindexing, and analyzing statistics to ensure peak performance.
- Identify, analyze, and optimize slow SQL queries and workloads to improve efficiency and throughput.
- Build resilient, high-availability database architectures that minimize downtime during upgrades, maintenance, and failovers.
- Implement robust backup, recovery, and disaster recovery strategies to guarantee data integrity and uptime.
- Support and monitor 24/7 production systems, participating in incident response and root cause analysis when needed.
- Collaborate with SRE, DevOps, and engineering teams to improve scalability, performance, and CI/CD integration for database operations.
AWSPostgreSQLPython+6 more