Senior Database Reliability Engineer (DBRE) ; postgreSQL

We are looking for a highly skilled Database Reliability Engineer (DBRE) with deep expertise in PostgreSQL at scale and solid experience with MySQL. In this role, you will design, operationalize, and optimize the data persistence layer that powers our large-scale, mission-critical systems.

You will work closely with SRE, Platform, and Engineering teams to ensure performance, reliability, automation, and operational excellence across our database environment. This is a hands-on engineering role focused on building resilient data infrastructure, not just administering it.

Responsibilities

• Design, implement, and operate highly available PostgreSQL clusters (physical replication, logical replication, sharding/partitioning, failover automation).
• Optimise query performance, indexing strategies, schema design, and storage engines.
• Perform capacity planning, growth forecasting, and workload modelling.
• Own high-availability strategies including automatic failover, multi-AZ/multi-region setups, and disaster recovery.

Automation & Tooling

• Develop automation for any and all tasks including but not limited to: provisioning, configuration, backups, failovers, vacuum tuning, and schema management using tools such as Terraform, Ansible, Kubernetes Operators, or custom tooling.
• Build monitoring, alerting, and self-healing systems for PostgreSQL and MySQL.

Operations & Incident Response

• Lead response during database incidents,performance regressions, replication lag, deadlocks, bloat issues, storage failures, etc.
• Conduct root-cause analysis and implement permanent fixes.

Cross-Functional Collaboration

• Partner with software engineers to review SQL, optimise schemas, and ensure efficient use of PostgreSQL features.
• Provide guidance on database-related design patterns, migrations, version upgrades, and best practices.

Required Qualifications

• 4 plus years of hands-on PostgreSQL experience in high-volume, distributed, or large-scale production environments.
• Strong knowledge of PostgreSQL internals (WAL, MVCC, bloat/ vacuum tuning, query planner, indexing, logical replication).
• Production experience with MySQL (InnoDB internals, replication, performance tuning).
• Advanced SQL and strong understanding of schema design and query optimisation.
• Experience with Linux systems, networking fundamentals, and systems troubleshooting.
• Experience building automation with Go or Python.
• Production experience with monitoring tools (Prometheus, Grafana, Datadog, PMM, pg_stat_statements, etc.).
• Hands-on experience with cloud environments (AWS or GCP).

Preferred/Bonus Qualifications

• Experience with PgBouncer, HAProxy, or other connection-pooling/load-balancing layers.
• Exposure to event streaming (Kafka, Debezium) and change data capture.
• Experience supporting 24/7 production environments with on-call rotation.
• Contributions to open-source PostgreSQL ecosystem.