> Markdown version of [/jobs/ext/4721762-amazon-aurora-postgresql-database-administrator-dba](https://www.wearedevelopers.com/jobs/ext/4721762-amazon-aurora-postgresql-database-administrator-dba). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Amazon Aurora PostgreSQL Database Administrator (DBA) - **Company:** Ztek Consulting - **Location:** Costa Mesa, CA, United States (Remote available) - **Experience:** Expert - **Salary:** $110,000 - $125,000 - **Contract:** Permanent contract - **Skills:** Amazon Web Services, Bash Shell, Databases, Continuous Integration, Database Encryption, DevOps, Identity and Access Management, Python (Programming Language), PostgreSQL, Performance Tuning, Windows PowerShell, Query Optimization, Ansible, SQL Databases, Software Vulnerability Management, Scripting, Database Optimization, Database Performance, Infrastructure as Code (IaC), Cloudformation, Database Migration, Amazon Relational Database Service, Infrastructure Automation Frameworks, Cloud Migration, Cloudwatch, Terraform, Database Installation - **Published:** November 14, 2026 - **Apply:** https://www.dice.com/job-detail/fd6351d4-8be9-4de1-ae2f-af8ac64292e3 ## About the Role Must Have Technical/Functional Skills Technical Skills * Strong expertise in PostgreSQL architecture, replication, backup and recovery. * Deep knowledge of AWS database services, including: o Amazon Aurora PostgreSQL o Amazon RDS o AWS DMS o AWS SCT o CloudWatch o IAM o KMS * Experience with database performance tuning and troubleshooting. * Proficiency in scripting languages such as Python, Bash, or PowerShell. * Experience with Infrastructure-as-Code tools including Terraform, Ansible or CloudFormation. * Familiarity with CI/CD tools and DevOps practices. Experience * Minimum 5+ years of hands-on database administration experience. * Strong experience administering PostgreSQL databases in AWS environments. * Proven experience with Amazon Aurora PostgreSQL and Amazon RDS services., Bachelor's degree Regards ## Description Amazon Aurora PostgreSQL Database Administrator (DBA), * Provision, configure, monitor and maintain Amazon Aurora PostgreSQL and Amazon RDS databases. * Perform database installation, upgrades, patching and lifecycle management. * Monitor database health, capacity and performance metrics. Performance Optimization * Analyze and optimize SQL queries and database workloads. * Implement indexing strategies and query tuning best practices. * Manage connection pooling and resolve infrastructure bottlenecks. * Troubleshoot and resolve database performance issues. High Availability & Disaster Recovery * Design and implement Multi-AZ deployments and cross-region replication. * Develop, test, and maintain backup and disaster recovery processes. * Ensure database availability and business continuity objectives are met. Cloud Migration & Modernization * Lead or support database migration initiatives to Aurora PostgreSQL. * Utilize AWS Database Migration Service (DMS) and Schema Conversion Tool (SCT) for migration projects. * Perform migration assessments, validations and post-migration optimization. Automation & Infrastructure as Code (IaC) * Develop automation scripts for routine database administration activities. * Manage infrastructure using Terraform, Ansible or AWS CloudFormation. * Support CI/CD pipeline integration for database deployments and schema changes. Security & Compliance * Implement security controls, database encryption and access management. * Apply database patches and vulnerability remediation activities. * Ensure compliance with organizational and regulatory security standards. * Perform periodic security reviews and audit support activities.