Description :

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

Job Type : Contractual / Project Based

Experience Required : 7+ Years

Work Mode : Remote

Shift Timing : 12 PM - 9 PM IST

Job Overview :

We are looking for an experienced Senior Database Administrator with strong expertise in PostgreSQL and AWS RDS environments. The ideal candidate should have hands-on experience in PostgreSQL version upgrades, database performance tuning, cloud migrations, and ensuring database stability across production systems.

Key Responsibilities :

- Manage, monitor, and optimize PostgreSQL databases across on-prem and AWS RDS environments

- Analyze and optimize complex SQL queries and long-running database operations

- Improve database performance through indexing, configuration tuning, and query optimization

- Handle backup, recovery, replication, failover, and disaster recovery processes

- Lead PostgreSQL version upgrades with minimal downtime

- Perform compatibility checks, upgrade testing, rollback planning, and post-upgrade validations

- Design and manage AWS RDS PostgreSQL instances, backups, snapshots, and security configurations

- Work on on-prem to AWS RDS migration projects and ensure smooth cutovers

- Automate database maintenance and operational tasks using scripting tools

- Collaborate with DevOps and engineering teams for deployments and infrastructure improvements

Required Skills :

- 7+ years of DBA experience with strong PostgreSQL expertise

- Hands-on experience in PostgreSQL version upgrades (mandatory)

- Strong experience with AWS RDS PostgreSQL

- Expertise in query optimization and database performance tuning

- Good understanding of PostgreSQL internals and database architecture

- Experience with backup, recovery, replication, and failover strategies

- Strong Linux/Unix administration knowledge

- Experience with monitoring tools and database diagnostics

- Scripting experience in Python, Bash, or similar technologies

- Strong communication and stakeholder management skills

Good to Have :

- Experience with AWS services such as EC2, S3, IAM, and VPC

- Exposure to DevOps tools and CI/CD pipelines

- Experience with database automation and Infrastructure as Code (IaC)

What Success Looks Like :

- Smooth and zero-downtime PostgreSQL upgrades

- Improved query performance and reduced database latency

- Stable and scalable AWS RDS environments

- Successful migrations with no data loss

- Proactive database monitoring and performance improvements