Job Title : AWS Aurora Database Lead Developer & Administrator
Location : Hyderabad, India (Work from office) Experience : 7+ years Employment Type : Full-time Department : Data Engineering
6–10 years of experience as a PostgreSQL DBA, including 2+ years on Amazon Aurora PostgreSQL
- Lead and mentor a team of 7–8 Database developers.
- Proven experience leading teams in an Agile / Scrum environment.
- Excellent communication and stakeholder management skills.
- Demonstrated expertise in administering, configuring, and maintaining PostgreSQL databases across multiple environments, with at least 2+ years of hands-on experience managing Aurora PostgreSQL clusters on AWS. Proven track record of ensuring high availability, scalability, and security in production-grade database systems. Expertise in schema design, normalization, and indexing strategies.
- Strong understanding of PostgreSQL internals, replication, WAL management, and query execution plans. Deep knowledge of how PostgreSQL handles processes, memory, and storage structures (shared buffers, WAL, vacuum, checkpoints, etc.). Skilled in setting up and managing physical and logical replication, monitoring replication lag, and troubleshooting failover issues. Ability to analyze query execution plans for performance optimization and root-cause analysis.