Database Engineer (PostgreSQL)
Location: Bangalore, India
Experience Required: 8–10 Years
Shift: EST & UK Time Zone (2 PM IST – 1 AM IST, 9-hour shift)
Job Type: Full-Time / Permanent
Job Overview
We are looking for an experienced Database Engineer (PostgreSQL) to design, build, and optimize highly available and scalable database systems on AWS. The ideal candidate will have strong expertise in Aurora PostgreSQL, database automation, migrations, CI/CD, and performance tuning in large-scale production environments. This role involves working closely with SRE and service teams to deliver secure, reliable, and high-performing data solutions.
Key Responsibilities
- Design, implement, and maintain highly available Aurora PostgreSQL systems on AWS.
- Develop automation tools/scripts using Python and SQL to support upgrades, replication, and migrations across clusters/accounts with near-zero downtime.
- Use AWS DMS and Terraform to deploy and manage database migration infrastructure.
- Build and maintain CI/CD pipelines to support automated deployments and repeatable infrastructure processes.
- Work with SREs and service teams to architect database solutions aligned with performance, reliability, and compliance needs.
- Troubleshoot complex production issues using logs, query plans, metrics, and system-level diagnostics.
- Optimize schemas, queries, and indexing strategies to improve performance and scalability.
- Document runbooks, architectural decisions, and best practices for operational consistency.
- Drive a culture of reliability, continuous improvement, and operational excellence.
Required Qualifications
- 5–10 years of hands-on experience managing large-scale, cloud-native databases (preferably Aurora PostgreSQL).
- Strong understanding of PostgreSQL internals, replication strategies, and performance tuning techniques.
- Proven experience with zero-downtime migrations/ upgrades using AWS DMS.
- Solid proficiency in Python for automation and SQL for optimization and development.
- Expertise in AWS services including Aurora PostgreSQL & AWS DMS.
- Experience with CI/CD pipelines, Infrastructure-as-Code, and containerization (Docker).
- Excellent troubleshooting, communication, and cross-functional collaboration skills.