Senior Database Reliability Engineer (PostgreSQL, Terraform, AWS)
capital.comover 1 year ago
Warsaw, PolandSenior
Responsibilities
- Own provisioning, configuration, maintenance, uptime, and performance of PostgreSQL and MySQL instances across AWS RDS and on-premises environments.
- Design and implement automated failover, load balancing, and DNS management strategies.
- Write and maintain Terraform code for database infrastructure across environments.
- Build and manage Ansible playbooks and roles for deployments, configuration changes, and patching.
- Monitor, alert, and tune database systems using Prometheus and Grafana.
- Plan and execute database upgrades and migrations across PostgreSQL, MySQL, Redshift, ClickHouse, and DynamoDB.
- Manage and regularly test backup, restore, and recovery processes.
- Harden database security through access controls, encryption, and audits.
- Maintain and improve Linux systems hosting databases, including security hardening and performance tuning.
- Document configurations, runbooks, and disaster recovery plans, and participate in an on-call rotation.
Requirements
- 5+ years of experience as a Database Administrator or Database Engineer with production PostgreSQL and MySQL expertise.
- Hands-on experience writing and maintaining Terraform infrastructure-as-code.
- Working knowledge of Ansible for configuration management and deployment automation.
- Strong Linux system administration, performance tuning, and troubleshooting skills.
- Experience designing and operating high-availability solutions involving failover, replication, load balancing, and DNS management.
- Familiarity with Prometheus and Grafana or comparable monitoring tools.
- Bash and/or Python scripting ability for automation and operational tasks.
- Understanding of CI/CD pipelines and database changes within deployment workflows.
- Experience working with access control, encryption, and audit trails in regulated financial services environments.
- Preferred experience with ClickHouse, Redshift, MongoDB, or Microsoft SQL Server.
- Familiarity with Docker and Kubernetes for database workloads is preferred.
- Financial services audit experience or other regulated-environment experience is preferred.
- AWS certification such as Database Specialty or Solutions Architect is preferred.
Benefits
- Competitive salary and comprehensive health and pension benefits, including location-specific benefits and perks.
- Annual leave and two additional paid volunteer days each year.
- Employee referral program.
- Hybrid work arrangement, as indicated by #LI-Hybrid.
- Up to 30 extra days to work remotely from anywhere in the world, subject to restrictions.
Tech Stack
Amazon DynamoDBAmazon RedshiftAnsibleAWSBashClickHouseDockerGrafanaKubernetesLinuxMicrosoft SQL ServerMongoDBMySQLPostgreSQLPrometheusPythonTerraform
Categories
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.