Remote PostgreSQL DBA for Cloud, HA & DR

Bet On Talent; Hinoba-an; Hybrid; PHP 5,643,000 - 8,150,000; Full time

Job summary

Bet On Talent is seeking a senior PostgreSQL Database Engineer to administer and optimize production PostgreSQL databases across AWS RDS and Aurora. You will work with Knex/TypeORM migrations, implement blue/green deployments, and ensure 24/7 reliability in a remote-first setup.

You will monitor performance with Performance Insights and pg_stat_statements, design scalable schemas, manage backups, DR, and cross-region replication, and collaborate with backend and DevOps teams.

Qualifications

• Deep experience administering PostgreSQL 14+ in production, including MVCC, vacuum tuning, WAL, replication and lock behaviour.
• Strong hands-on knowledge of Amazon RDS and Aurora PostgreSQL, including parameter groups, Performance Insights, Enhanced Monitoring and blue/green deployments.
• Proven backup and recovery experience, including real restore exercises and cross-region recovery.
• Proficiency in Terraform and Git-based workflows for managing database infrastructure.
• Solid scripting skills in Python, Bash or SQL for automation, health checks and reporting.
• Strong understanding of schema design, query optimisation and indexing strategies for high-transaction workloads.
• Working knowledge of Redis/ElastiCache and MongoDB administration.
• Understanding of database security and compliance requirements (PCI DSS, GDPR) for customer and payment data.
• Comfortable operating in a multi-account AWS environment with SSO and CI/CD-driven deployments.
• Ability to write clear runbooks, post-mortems and change plans that other engineers can follow.

Responsibilities

• Administer and maintain production PostgreSQL databases on AWS RDS and Aurora.
• Monitor and tune database performance using Performance Insights, pg_stat_statements and EXPLAIN ANALYZE.
• Plan and execute major-version upgrades with blue/green deployments.
• Own backup, restore and disaster recovery, including cross-region snapshots and RTO/RPO drills.
• Review schema migrations and enforce zero-downtime change patterns.
• Manage database infrastructure as code using Terraform and Terragrunt via GitHub Actions pipelines.
• Implement database security controls including least-privilege roles, encryption, and audit logging.
• Manage connection pooling, high availability and failover using RDS Proxy or PgBouncer and Multi-AZ.
• Support data/BI teams with read replicas, replication and secure connectivity to Redshift and ELT tooling.
• Define alerting/runbooks and participate in on-call rotation for 24/7 reliability.
• Track and optimise database spend across instances, storage and IOPS.
• Collaborate with backend (Node.js/NestJS), DevOps and data teams to deliver reliable data services.

Skills

PostgreSQL administration

AWS RDS/Aurora PostgreSQL

Database performance tuning

Scripting (Python, Bash, SQL)

Terraform & IaC

GitHub Actions/CI/CD

Query optimization and indexing

Multi-account AWS with SSO

Backup and disaster recovery

Runbooks and on-call

Tools

Terraform

GitHub Actions

pgAudit

Knex

TypeORM

pgPartman

pg_repack

AWS Secrets Manager

RDS Proxy

PgBouncer

Airbyte

AWS Glue

Grafana

OpenTelemetry

CloudWatch

Job description

Bet On Talent is seeking a senior PostgreSQL Database Engineer to administer and optimize production PostgreSQL databases across AWS RDS and Aurora. You will work with Knex/TypeORM migrations, implement blue/green deployments, and ensure 24/7 reliability in a remote-first setup.

You will monitor performance with Performance Insights and pg_stat_statements, design scalable schemas, manage backups, DR, and cross-region replication, and collaborate with backend and DevOps teams.