Title: Senior Aurora PostgreSQL DBA
Location: Remote
Position: Contract
JD:
Aurora PostgreSQL Database Administrator (DBA)
Required Qualifications
· 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