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

Senior Database Administrator