> Markdown version of [/jobs/ext/2661729-aws-postgresql-dba](https://www.wearedevelopers.com/jobs/ext/2661729-aws-postgresql-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).

---

# AWS PostgreSQL DBA

- **Company:** Propertyvalue Quantum Technologies Llc
- **Location:** United States (Remote available)
- **Experience:** Experienced
- **Contract:** Temporary contract
- **Skills:** Airflow, Amazon Web Services, Amazon Elastic Compute Cloud, Amazon S3, Bioinformatics, Databases, Data Recovery, IBM DB2, Database Security, Disaster Recovery, Failover, Monitoring of Systems, Identity and Access Management, Subnetting, Python (Programming Language), PostgreSQL, Operational Databases, Query Optimization, Aws Command Line Interface (CLI), Prometheus, SQL Databases, Management of Software Versions, Datadog, Scripting, Connectivity Problems, System Availability, Grafana, Database Optimization, Database Performance, Indexer, Amazon Virtual Private Cloud (VPC), Database Migration, Amazon Relational Database Service, Functional Programming, Cloud Optimization, Database Monitoring, Cloudwatch
- **Published:** August 31, 2026
- **Apply:** https://www.dice.com/job-detail/09edef78-2433-4451-8f16-08a92b41fa32

## About the Role

5+ years of experience in database administration with PostgreSQL.
2+ years of hands-on experience with Amazon Aurora PostgreSQL.
Strong understanding of PostgreSQL architecture, administration, and internals.
Strong experience with SQL, PL/pgSQL, indexes, transactions, locking, and query execution plans.
Experience with PostgreSQL backup, recovery, replication, and high-availability strategies. Strong AWS knowledge, particularly:
o Amazon Aurora
o Amazon RDS
o EC2
o IAM
o CloudWatch
o S3
o Airflow
o Lambda
Experience troubleshooting database performance using tools such as EXPLAIN, EXPLAIN ANALYZE, PostgreSQL statistics views, Performance Insights, and CloudWatch.
Experience with database monitoring and alerting.
Strong scripting/automation skills using Python, or similar languages.
Experience working with production-critical databases and incident management processes.
Preferred Qualifications
AWS Certified Database Specialty or comparable AWS certification.
PostgreSQL certification or equivalent professional experience.
Experience migrating databases to Aurora PostgreSQL using AWS Database Migration Service (DMS). Experience with CI/CD pipelines.
Experience with database observability and tools such as Datadog, Grafana or similar platforms.
Experience with PostgreSQL version upgrades and Aurora major-version upgrades.
Technical Skills
Databases: PostgreSQL, Amazon Aurora PostgreSQL, Amazon RDS
AWS: Aurora, RDS, EC2, VPC, IAM, CloudWatch, S3, KMS, DMS, Lambda, Airflow
Performance: EXPLAIN/EXPLAIN ANALYZE, query tuning, indexing, wait events, locks, vacuum/autovacuum, connection management
High Availability & DR: Aurora replication, read replicas, failover, backup/restore, Point-in-Time Recovery, disaster recovery
Automation: Python, AWS CLI, Lambda, Airflow
Monitoring: AWS Performance Insights, CloudWatch, PostgreSQL monitoring, Grafana/Prometheus, Datadog Soft Skills
Strong analytical and problem-solving skills.
Excellent troubleshooting and incident-management abilities.
Ability to work effectively with developers, architects, and infrastructure teams.
Strong communication and documentation skills.
Ability to work independently in a fast-paced production environment.
Strong ownership and attention to reliability, security, and operational excellence .
Equal opportunity Employer : We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.

## Description

Experienced Aurora PostgreSQL Database Administrator (DBA) to design, administer, optimize, and support highly available PostgreSQL databases running on Amazon Aurora PostgreSQL. The DBA will be responsible for database reliability, performance, security, backup/recovery, monitoring, and production support across development, test, and production environments. The ideal candidate has strong hands-on PostgreSQL expertise, extensive AWS/Amazon Aurora experience, and a solid understanding of database performance, high availability, automation, and troubleshooting. Key Responsibilities Administer and support Amazon Aurora PostgreSQL database environments. Install, configure, upgrade, patch, and maintain PostgreSQL/Aurora database systems. Manage Aurora clusters, read replicas, failover, parameter groups, subnet groups, and endpoints. Perform database performance tuning, including: o Query optimization o Execution plan analysis o Index optimization o Connection and memory tuning o Lock and
wait-event analysis o Vacuum and autovacuum optimization Monitor database health, capacity, performance, and availability using AWS and PostgreSQL monitoring tools.
Implement and maintain backup, restore disaster recovery, and business continuity strategies.
Perform point-in-time recovery and support database recovery exercises.
Troubleshoot production database incidents, performance issues, connectivity problems, replication issues, and failures.
Manage database security, including users, roles, permissions, encryption, auditing, and access controls.
Work with application and development teams to review SQL queries, schema designs, indexes, and database-related application issues.
Support database migrations to Aurora PostgreSQL from on-premises DB2 or other database platforms.
Develop automation and operational scripts using tools such as Python, Lambda, or AWS CLI.
Establish and maintain database standards, operational procedures, documentation, and runbooks.
Participate in on-call rotations with customers and provide production support for critical database environments
Assist with capacity planning, cloud cost optimization, and database modernization initiatives. Required Qualifications


## Related Videos

- [Optimizing Discovery: PostgreSQL's Role in Transforming GetYourGuide's Search](https://www.wearedevelopers.com/videos/1647-optimizing-discovery-postgresql-s-role-in-transforming-getyourguide-s-search)
- [5 steps for running a Kubernetes environment at scale](https://www.wearedevelopers.com/videos/88-5-steps-for-running-a-kubernetes-environment-at-scale)
- [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works)
- [All your telemetry data from any source in one place](https://www.wearedevelopers.com/videos/57-all-your-telemetry-data-from-any-source-in-one-place)
- [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt)
- [Postgres in the Age of AI (and Devin)](https://www.wearedevelopers.com/videos/1042-postgres-in-the-age-of-ai-and-devin)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again)
- [Dev Digest 168: Hacking Postgres, Blocking Meta and Fixing CSS](https://www.wearedevelopers.com/magazine/588-dev-digest-168-hacking-postgres-blocking-meta-and-fixing-css)
- [7 Cloud Computing Trends Coming in 2025 for Developers](https://www.wearedevelopers.com/magazine/412-7-cloud-computing-trends-coming-in-2025-for-developers)
- [Effortlessly Scale Prometheus With The Telemetry Data Platform – And Keep your Grafana Dashboards, Too!](https://www.wearedevelopers.com/magazine/3-effortlessly-scale-prometheus-with-the-telemetry-data-platform-and-keep-your-grafana-dashboards-too)