Senior Database Administrator, Jamnagar

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