PostgreSQL DBA

Job Title: PostgreSQL DBA

Job Location: Chandler AZ

Job Type: Full Time

Job Description:

• We are looking for a midlevel Database Administrator DBA with strong handson experience in PostgreSQL administration along with solid AWS exposure and Terraform expertise especially writing reusable Terraform modules
• 4 to 8 years flexible based on depth of PostgreSQL AWS Terraform
• The role will focus on ensuring database reliability performance security automation and supporting cloudbased database environments
• Oracle experience is a plus but not mandatory

Key Responsibilities:

• Install configure administer and maintain PostgreSQL databases in production and nonproduction environments
• Perform backup and recovery planning and execution PITR restore validations DR readiness
• Monitor database health and performance troubleshoot issues related to queries indexing locks replication and storage
• Plan and execute patchingupgrades migrations and version compatibility checks
• Implement and manage replication streaming replicationlogical replication where needed and high availability strategies
• Ensure database security access controls rolesprivileges and audit readiness
• AWS Responsibilities
• Work with AWS services related to database hosting and operations such as
• Amazon RDS for PostgreSQL Aurora PostgreSQL preferred
• EC2based PostgreSQL deployments
• Supporting services IAM VPC Security Groups KMS CloudWatch S3 SNS
• Support cloud best practices for networking encryption monitoring scalability and cost awareness
• Participate in DR strategies using AWS native capabilities
• Terraform Infrastructure as Code IaC
• Design and develop Terraform modules for repeatable infrastructure deployments
• Maintain Terraform codebase apply IaC practices such as
• Remote state workspaces state locking
• Module versioning reusable patterns naming standards
• Secure variable handling Secrets ManagerParameter Store integration
• Partner with DevOpsSRE teams to automate infrastructure provisioning for DB environments
• Operational Collaboration
• Participate in oncall production support if required for incidents and problem management
• Create and maintain runbooks SOPs and technical documentation
• Collaborate with application teams to review schema changes query performance and release readiness

Required Skills Qualifications

• 4 to 8 years of handson DBA experience with PostgreSQL in production
• Strong understanding of
• Backup recovery replication HADR concepts
• Performance tuning indexes vacuumanalyze query plans
• Security roles grants encryption basics
• Working experience in AWS RDSAurora preferred
• Strong expertise in Terraform including writing and maintaining Terraform modules
• Familiarity with Linux administration and scripting ShellPython is a plus
• Strong troubleshooting mindset and ability to handle production issues calmly

Nice to Have Preferred

• Oracle DBA experience basic administration backuprestore concepts troubleshooting
• Experience with CICD integration for Terraform JenkinsGitHub ActionsGitLab
• Monitoring tools CloudWatch Prometheus Grafana Datadog New Relic etc
• Container environments EKSKubernetes for DBadjacent services
• Exposure to securitycompliance requirements SOC2 ISO PCI etc

Skills

Mandatory Skills : AWS Infra Services PostgreSQL PostgreSQL-DB Administration Terraform