PostgreSQL database expertise is in high demand as companies migrate critical workloads to the cloud. This role focuses on optimizing PostgreSQL on AWS, a niche that blends deep database knowledge with modern infrastructure skills. Joining a Phoenix‑based team offers a hands‑on opportunity to lead performance tuning and cloud automation.

Job Summary

We are seeking an experienced PostgreSQL DBA to design, administer, and fine‑tune databases on Amazon RDS/Aurora and self‑managed EC2 instances. The candidate will leverage AWS services and Terraform to automate provisioning, ensure high availability, and drive cost‑effective performance improvements. This onsite position requires strong collaboration with engineering teams to support mission‑critical applications.

Top 3 Critical Skills Table

Interview Preparation

1. How do you diagnose and resolve a slow query in Aurora PostgreSQL?
   What the interviewer is looking for: Understanding of EXPLAIN ANALYZE, indexing strategies, and Aurora‑specific tuning parameters.
2. Explain the steps to set up automated backups and point‑in‑time recovery for PostgreSQL on RDS.
   What the interviewer is looking for: Knowledge of RDS backup windows, retention policies, and recovery procedures.
3. Describe how you would use Terraform to provision a multi‑AZ PostgreSQL cluster.
   What the interviewer is looking for: Ability to write reusable modules, manage state, and configure AWS resources like subnet groups and parameter groups.
4. What are the security best practices for PostgreSQL in a cloud environment?
   What the interviewer is looking for: Encryption at rest/transit, IAM integration, role‑based access, and network isolation (VPC, security groups).
5. How do you handle database schema migrations in a zero‑downtime deployment?
   What the interviewer is looking for: Experience with tools like Flyway or Liquibase, blue‑green deployments, and careful versioning.

Resume Optimization

• PostgreSQL
• DBA
• AWS
• Amazon RDS
• Aurora PostgreSQL
• EC2
• Terraform
• Cloud Infrastructure
• Database Optimization
• Onsite

Application Strategy

When emailing the recruiter, start with a brief greeting, attach your updated resume, and clearly reference the PostgreSQL DBA role. Highlight your 10+ years of database experience, especially your 5+ years managing PostgreSQL on AWS with Terraform. Make sure to mention related skills you possess, such as AWS RDS/Aurora, Terraform automation, and performance tuning.

Career Roadmap