What are the responsibilities and job description for the Postgres SQL DB Admin with AWS position at Judge Group, Inc.?
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
Secondary Skills
Experience Requirements
Key Responsibilities
PostgreSQL Database Operations
High Availability & Disaster Recovery
Database Lifecycle Management
Capacity Planning & Optimization
Cloud, Automation & Containers
Production Support & Incident Management
Preferred Qualifications
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:
This job and many more are available through The Judge Group. Please apply with us today!
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:
This job and many more are available through The Judge Group. Please apply with us today!
Salary : $110,000 - $120,000