Senior Postgres Database Administrator

Responsibilities: Administer PostgreSQL databases across development, test, and production environments. Manage AWS RDS for PostgreSQL, including provisioning, configuration, patching, upgrades, scaling, monitoring, and maintenance. Design and support high-availability and disaster recovery solutions, including Multi-AZ deployments, replication, failover, and read replicas. Manage backup, restore, point-in-time recovery, retention, and recovery validation processes. Support database migrations, upgrades, consolidation, and cross-environment refreshes. Develop and maintain change data capture (CDC) solutions using AWS DMS, Debezium, logical replication, or equivalent technologies. Tune database performance through query analysis, indexing, vacuuming, statistics management, connection optimization, and configuration changes. Monitor database health, capacity, availability, replication lag, storage, connections, and performance. Troubleshoot incidents involving outages, replication, locking, deadlocks, backup failures, and performance degradation. Implement security controls for access, roles, privileges, encryption, auditing, and credential rotation. Automate DBA activities using shell scripting, Python, AWS services, and CI/CD tools. Maintain operational documentation, runbooks, recovery procedures, and database standards. Collaborate with application, infrastructure, DevOps, security, and data engineering teams. Participate in on-call support, incident management, root-cause analysis, and continuous improvement.