Senior Database Reliability Engineer (PostgreSQL, IaC)
capital.com9 hours ago
Limassol, Cyprus or Warsaw, PolandSenior
Responsibilities
- Design and operate highly available PostgreSQL databases across zones and regions with automated, tested failover and split-brain fencing.
- Define database infrastructure, networking, access, monitoring, backups, and parameters as code, with peer review, CI/CD application, and drift detection.
- Build self-service database provisioning for product teams and replace manual runbooks with automation.
- Plan and execute zero- or near-zero-downtime migrations, upgrades, and table moves across versions, clusters, and clouds.
- Partner with developers on schema changes, queries, connection pooling, transaction scope, retries, idempotency, and expand-and-contract migrations.
- Define SLOs and build alerts and dashboards to identify latency and capacity issues.
- Design backup and recovery processes and conduct scheduled restore and failover tests measuring RTO and RPO.
- Optimize database instance and storage costs while maintaining requirements.
- Implement least-privilege access, secrets management, encryption, auditability, and PII masking.
- Lead and participate in incident response and on-call, write blameless post-mortems, and track corrective actions.
Requirements
- 5+ years running production databases as a DBRE, SRE, platform engineer, or database engineer.
- Deep production PostgreSQL experience, including MVCC, vacuum and bloat, locking, physical and logical replication, and query planning.
- Hands-on infrastructure as code experience with version-controlled, peer-reviewed changes.
- Daily experience delivering infrastructure and database changes, including schema migrations, through CI/CD pipelines.
- Experience designing high availability and disaster recovery with replication, automated failover, multi-region or multi-cloud redundancy, and RTO/RPO trade-offs.
- Experience with zero-downtime changes such as online migrations, major-version upgrades, or moving data between clusters.
- Understanding of application-database interactions, including connection pools, ORMs such as Hibernate, transaction scope, retries, idempotency, and deployment order.
- Observability experience defining measurements, alerting on SLOs, and validating changes with data.
- Scripting experience in Python, Bash, or Go for operational automation.
- Comfort working in a regulated financial services environment with strict access control, encryption, and audit requirements.
- Clear communication and collaborative partnership with developers.
- Preferred experience with AWS, particularly RDS or Aurora; Terraform and Ansible; MySQL; Redshift, ClickHouse, or DynamoDB; pglogical, AWS DMS, or Debezium; Kubernetes; Java services; Linux performance tuning; and Vault or another secrets manager.
Tech Stack
Amazon DynamoDBAmazon RedshiftAnsibleAWSBashClickHouseGoGrafanaJavaKubernetesLinuxMySQLPostgreSQLPrometheusPythonTerraformVault
Categories
DevOpsSite Reliability
About capital.com
Capital.com is a retail trading platform that lets individuals trade CFDs on shares, indices, forex, commodities, and crypto via web and mobile. Founded in 2016 and privately held, it is headquartered in Limassol, Cyprus, with regulated entities in the UK and EU; it earns revenue from spreads, overnight financing, and other brokerage fees. The platform also offers education resources and real-time market insights.