Postgres SQL DB Admin with AWS (1123984)

Location: Chandler, AZ

Salary: $110,000.00 USD Annually - $120,000.00 USD Annually

Description

Job Title: PostgreSQL Database Administrator – AWS

Experience: 7 Years

Location: Chandler, AZ 85224

Employment Type: Full-Time

Job Summary

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.

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
  
  

Key Responsibilities

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
  
  

Preferred Qualifications

• 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
  
  

By providing your phone number, you consent to: (1) receive automated text messages and calls from the Judge Group, Inc. and its affiliates (collectively "Judge") to such phone number regarding job opportunities, your job application, and for other related purposes. Message & data rates apply and message frequency may vary. Consistent with Judge's Privacy Policy, information obtained from your consent will not be shared with third parties for marketing/promotional purposes. Reply STOP to opt out of receiving telephone calls and text messages from Judge and HELP for help.

Contact: ssharma17@judge.com

This job and many more are available through The Judge Group. Find us on the web at www.judge.com