Senior PostgreSQL DBA — AWS RDS, HA, DR, Automation

Intellibee; United States; Remote; USD 110,000 - 170,000; Full time

Benefits offered by this job

Long-Term Stability

Comprehensive Health Coverage

401(k) program

Job summary

IntelliBee seeks an experienced PostgreSQL Database Administrator to oversee PostgreSQL environments across development, test, and production. You will manage AWS RDS deployments, design resilient HA/DR solutions, and ensure data integrity through backups and PITR.

The role focuses on performance tuning, security, incident response, and automation using shell, Python, and CI/CD tools. Collaboration with DevOps, security, and data teams is essential.

Qualifications

• 5–7 years of hands-on PostgreSQL database administration experience.
• Strong expertise in PostgreSQL installation, configuration, administration, monitoring, and troubleshooting.
• Practical experience managing PostgreSQL on AWS RDS.
• Experience with high availability and replication.
• Backup, restore, point-in-time recovery, and disaster recovery testing.
• CDC and logical replication.
• Database migrations and version upgrades.
• Performance tuning and query optimization.
• Database security and access controls.
• Experience responding to production incidents and managing problems.
• Experience using GitHub or GitLab for source control and collaboration.

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.

Skills

PostgreSQL DBA

AWS RDS

High availability

Backups & recovery

CDC/logical replication

Performance tuning

Security controls

Incident response

GitHub/GitLab

Tools

GitHub

GitLab

Job description

IntelliBee seeks an experienced PostgreSQL Database Administrator to oversee PostgreSQL environments across development, test, and production. You will manage AWS RDS deployments, design resilient HA/DR solutions, and ensure data integrity through backups and PITR.

The role focuses on performance tuning, security, incident response, and automation using shell, Python, and CI/CD tools. Collaboration with DevOps, security, and data teams is essential.