dba for a trading platform

Capital.com; United States; Remote; USD 140.000 - 210.000; Vollzeit

Benefits dieser Stelle

Annual performance bonus

Medical insurance

Pension plans

Remote work from anywhere

Volunteer days

Referral program rewards

Zusammenfassung

Capital.com ищет инженера DBRE/SRE для эксплуатации PostgreSQL на уровне продакшн, работающего в облаке и across регионы. Ваша задача — обеспечить отказоустойчивость, автоматизацию и безопасную эксплуатацию баз данных, внедрять IaC, CI/CD и улучшать мониторинг.

Ключевые требования: 5+ лет работы с продакшн БД, опыт HA/DR, миграций безDowntime, работа в регулируемой финансовой среде и знание инструментов IaC (Terraform, Ansible). Ушла работа удаленная по всему миру.

Qualifikationen

• Опыт работы в продакшн с PostgreSQL на масштабе, включая MVCC, вакуум и блокировку.
• Понимание инфраструктуры через код, версионирование изменений.
• Наличие CI/CD для изменений в инфраструктуре и базах данных.
• Опыт планирования безотказных миграций и обновлений без Downtime.
• Опыт работы с AWS RDS/Aurora и механизмами DR/HA.
• Навыки скриптов на Python, Bash или Go для автоматизации.
• Знание систем мониторинга, алертинга по SLO и аудита.

Aufgaben

• Проектирование и управление высокодоступной базой данных PostgreSQL across regions.
• Определение инфраструктуры как код, мониторинг, бэкапы и восстановление.
• Обеспечение CI/CD деплойментов, ревью кода и детекция дрейфа.
• Создание self-service провижининга БД для команд продуктов.
• Планирование миграций, апгрейдов и перемещений таблиц с минимальным Downtime.
• Сотрудничество с разработчиками по изменениям схем, пул соединений и отклика.
• Определение SLOs и построение алертов/дашбордов для latency и capacity.
• Проектирование резервного копирования и тесты восстановления, аудит.
• Оптимизация размеров инстансов и хранилища, экономия затрат.
• Безопасность: least privilege, шифрование и аудит доступа.

Kenntnisse

PostgreSQL

DBRE/SRE

AWS RDS/Aurora

CI/CD pipelines

IaC

Version control

Scripting

Kubernetes

Monitoring

Security controls

Tools

Terraform

Ansible

MySQL (production)

Redshift

ClickHouse

DynamoDB

pglogical

AWS DMS

Debezium

Vault

Jobbeschreibung

Описание

The company operates a global trading platform with award-winning products focused on cutting-edge technology and a seamless client experience.

Задачи

• Design and operate highly available PostgreSQL across zones and regions, with automated, tested failover and protection against split-brain
• Define database infrastructure as code, including clusters, parameters, networking, access, monitoring, and backups
• ensure peer review, CI/CD deployment, and drift detection
• Build self-service database provisioning for product teams
• Plan and execute migrations, upgrades, and table moves with zero or near-zero downtime, including cross-version, cross-cluster, and cross-cloud work
• 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 detect latency and capacity problems
• Design backup and recovery processes and validate them through scheduled restore and failover tests measuring RTO and RPO and producing audit evidence
• Optimize instance and storage sizing and select cost-effective options that meet requirements
• Secure data through least-privilege access, secrets management, encryption at rest and in transit, audited access, and PII masking
• Lead and participate in incident response and on-call
• write blameless post-mortems and ensure follow-up actions are completed
• Replace manual runbooks with automation and document remaining procedures

Требования

• Deep production experience with PostgreSQL, including operating it at scale and handling MVCC, vacuum and bloat, locking, physical and logical replication, and query planning based on real incidents
• Use infrastructure as code as the standard way of working
• keep work in version control and review it before application
• Use CI/CD pipelines for infrastructure, database, and schema changes reaching production.
• Candidates whose normal process relies on console clicks, SSH changes, or wiki steps are not a fit
• At least 5 years running production databases as a DBRE, SRE, platform, or database engineer, ideally with substantial AWS RDS or Aurora experience
• Experience designing high availability and disaster recovery, including replication, automated failover, multi-region or multi-cloud redundancy, and RTO, RPO, and cost trade-offs
• Track record of zero-downtime changes, including online migrations, major version upgrades, or moving data between clusters
• Understand application database usage, including connection pools, ORMs such as Hibernate, transaction scope, retries, idempotency, and safe deployment order
• Define observability measures, alert on SLOs, and verify changes with data
• Script in Python, Bash, or Go to automate operational work
• Comfortable working in a regulated financial services environment with strict access control, encryption, and audit trail requirements
• Communicate clearly, take ownership of outcomes, and partner with developers rather than gatekeeping
• Будет плюсом: Terraform and Ansible, production MySQL, Redshift, ClickHouse or DynamoDB, logical replication or CDC tooling (pglogical, AWS DMS, Debezium), Kubernetes and production Java services, Linux performance tuning and troubleshooting on self-managed database hosts, Vault or another secrets manager

Условия

• Competitive salary
• amount not specified
• Annual performance bonus
• Annual leave and two additional paid volunteer days each year
• Medical insurance, pension plans, and location-specific benefits and perks
• Employee referral program with rewards 30
• Extra days to work remotely from anywhere in the world, subject to some restrictions