PostgreSQL Database Administrator

We are seeking a highly skilled and hands-on PostgreSQL Database Administrator with strong AWS cloud expertise to own and manage PostgreSQL database operations in a production environment. The role involves end-to-end database lifecycle management including provisioning, performance tuning, high availability, disaster recovery, automation, monitoring, and cost optimization., PostgreSQL Database Operations

• Administer, manage, and optimize PostgreSQL databases across:

• Amazon RDS for PostgreSQL

• Amazon Aurora PostgreSQL

• EC2 / self-managed PostgreSQL (where applicable)

Perform advanced performance tuning, including:

• Query plan analysis
• Index optimization
• VACUUM / ANALYZE and autovacuum tuning
• Connection pooling (PgBouncer)
• Partitioning strategies
• Statistics and parameter tuning

High Availability & Disaster Recovery

• Design, implement, and maintain High Availability (HA) solutions:

• Multi-AZ deployments

• Aurora PostgreSQL clusters

• Patroni or equivalent HA frameworks

Own backup and recovery strategies:

• Automated backups
• Point-in-Time Recovery (PITR)
• Logical and physical replication (streaming replication, logical decoding)

Implement and test cross-region disaster recovery (DR) strategies

Create and maintain DR runbooks and conduct regular failover testing Database Lifecycle Management

• Plan and execute:

• PostgreSQL version upgrades

• Patch management

• Extension management (PostGIS, pg_partman, pg_stat_statements, etc.)

Manage schema changes using tools such as:

• Liquibase
• Flyway

Capacity Planning & Optimization

• Perform proactive capacity planning for:

• Storage

• IOPS

• Throughput

Identify and mitigate:

• Table and index bloat
• Performance hot spots

Optimize database cost and performance in AWS environments Cloud, Automation & Containers

• Provision and manage database infrastructure using Terraform
• Support PostgreSQL workloads running in OpenShift / containerized environments
• Integrate monitoring and alerting solutions for database health and performance

Production Support & Incident Management

• Provide strong production support with rapid incident response
• Perform root cause analysis (RCA) and implement preventive measures
• Drive continuous improvement in database reliability, performance, and security

The ideal candidate brings deep PostgreSQL administration experience, strong AWS platform knowledge, Infrastructure as Code (IaC) expertise, and a proactive mindset toward incident management and continuous improvement.

Must-Have Technical Skills

Primary Skills

• PostgreSQL Database Administration
• AWS (Amazon Web Services)

Secondary Skills

• Terraform (Infrastructure as Code)
• OpenShift / Containerized Environments

Experience Requirements

• Minimum 7+ years of overall IT experience
• 5+ years of hands-on AWS experience
• 5+ years of PostgreSQL administration in cloud environments
• Strong experience with Terraform and cloud automation, * Experience with AWS monitoring tools (CloudWatch, Performance Insights)
• Knowledge of security best practices for PostgreSQL and AWS
• Strong scripting skills (Bash, Python, or similar)
• Excellent communication and documentation skills