- Design and run highly available PostgreSQL across zones and regions, with automated, tested failover and fencing against split-brain.
- Define database infrastructure as code and apply peer-reviewed changes through CI/CD pipelines with drift detection.
- Build self-service database provisioning for product teams.
- Plan and execute migrations, upgrades, and table moves with zero or near-zero downtime.
- Partner with developers on schema changes, queries, connection pooling, transaction scope, retries, and expand-and-contract migrations.
- Define SLOs and build SLO-based alerts and dashboards to identify latency and capacity problems.
- Design backup and recovery, and verify them with scheduled restore and failover tests measuring RTO and RPO.
- Secure data through least-privilege access, secrets management, encryption, audited access, and PII masking.
- Participate in incident response and on-call, write blameless post-mortems, and follow through on actions.
PostgreSQLPythonGrafana+4 more