PostgreSQL/Aurora DBA

Job Title: PostgreSQL/Aurora DBA
Location: Remote
Duration: 6 Months

Job Description:

We need someone who can serve as a PostgreSQL/Aurora subject-matter expert and actively improve the production environment. The person should be capable of diagnosing difficult production performance issues, tuning PostgreSQL and Aurora workloads, using AWS telemetry to identify bottlenecks, building proactive monitoring, and developing automation and permanent fixes that reduce recurring operational issues.

Expert PostgreSQL expertise, particularly supporting high-volume, business-critical production environments.
Strong AWS experience, with hands-on expertise supporting Amazon RDS for PostgreSQL or Aurora PostgreSQL.
Ability to troubleshoot complex PostgreSQL performance issues and rapidly determine whether the bottleneck is query, database, infrastructure, or application related.
Advanced SQL/query tuning, including execution-plan analysis using EXPLAIN / EXPLAIN ANALYZE, indexing strategies, join optimization, statistics, and identifying inefficient queries.
Strong understanding of PostgreSQL configuration and parameter tuning, including memory, WAL, checkpoints, autovacuum, connection management, planner settings, and workload-specific optimization.
Hands-on experience with AWS Performance Insights / Database Insights to identify database load, expensive SQL, waits, locking, and other performance bottlenecks.
Strong understanding of Aurora PostgreSQL architecture, including clusters, reader/writer instances, replicas, failover, scaling, parameter groups, maintenance, and backup/recovery.
Ability to develop proactive monitoring and alerting that identifies developing problems before they become production incidents