Description :

Job Title : Sr Database Administrator (PostgreSQL + AWS RDS).

Experience Required : 7+ Years.

Timezone : 12 PM to 9 PM IST.

Work Mode Remote.

Job Summary :

Were 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.

Youll 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.