Senior Database Administrator (Junagadh)

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)
- Solid 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 Apply on Kit Job: kitjob.in/job/4m5yy9