Job Title - Sr Database Administrator (PostgreSQL + AWS RDS)
Experience Required - 7+ Years
Timezone: 12 PM to 9 PM IST
Work Mode - Remote
Job Summary
We're looking for a Senior DBA with deep hands-on experience in PostgreSQL, especially around version upgrades and AWS RDS environments.
This role is critical for ensuring database performance, stability, and scalability across on-prem and cloud systems. You'll lead PostgreSQL upgrades, optimize performance, and manage cloud-native database operations with minimal downtime and zero surprises.
Key Responsibilities
PostgreSQL Administration
- Manage, monitor, and optimize PostgreSQL databases (on-prem and AWS RDS)
- Analyze and tune complex and long-running queries
- Optimize performance via indexing, query rewriting, and configuration tuning
- Handle vacuum, autovacuum, memory, and checkpoint tuning
- Ensure high availability, reliability, and data integrity
- Manage backup, restore, and disaster recovery strategies
PostgreSQL Version Upgrades (Core Focus)
- Lead end-to-end PostgreSQL version upgrades across environments
- Perform pre-upgrade assessments for compatibility risks and breaking changes
- Validate extensions, stored procedures, functions, and queries
- Design and execute upgrade testing plans
- Ensure application compatibility and performance post-upgrade
- Plan rollback strategies and production cutovers
AWS RDS PostgreSQL
- Design, provision, and manage AWS RDS PostgreSQL instances
- Configure security, access control, backups, and snapshots
- Monitor and optimize RDS performance
- Implement high availability and failover strategies
- Work closely with DevOps on cloud architecture and deployments
Migration & Modernization
- Lead migrations between on-prem PostgreSQL and AWS RDS
- Ensure minimal downtime and smooth cutovers
- Perform post-migration validation and performance checks
- Recommend modernization strategies and improvements
Automation & DevOps
- Automate database operations (provisioning, monitoring, maintenance)
- Support CI/CD pipelines for database changes
- Use scripting (Python/Bash) and IaC approaches
- Collaborate with DevOps and engineering teams
Required Skills & Experience
- 7+ years of DBA experience with a strong PostgreSQL focus
- Proven hands-on experience with PostgreSQL version upgrades (must-have)
- Strong experience with AWS RDS PostgreSQL
- Deep expertise in query optimisation and performance tuning
- Solid understanding of PostgreSQL internals
- Experience with large-scale or high-traffic systems
- Strong Linux/Unix knowledge
- Experience with backup, recovery, replication, and failover
- Familiarity with monitoring tools and performance diagnostics
- Scripting skills (Python, Bash, or similar)
- Strong communication and stakeholder management skills
Good to Have
- Experience with AWS services like EC2, S3, IAM, VPC
- Exposure to DevOps tools and CI/CD pipelines
- Experience with database automation and infrastructure-as-code
What Success Looks Like
- Zero-downtime PostgreSQL upgrades
- Faster query performance and reduced latency
- Stable, scalable RDS environments
- Smooth migrations with no data loss
- Proactive performance improvements, not reactive firefighting
