Senior Database Administrator

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