Database administrator for trading platforms

Devexperts; United States; Híbrido; USD 140.000 - 180.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Hybrid/remote work

Flexible working hours

24 paid vacation days

Wellness days

Medical insurance - VIP

Office with PlayStation

Teambuilding activities

Conferences & fairs

Personal branding support

Parental bonus

Referral bonus

English courses

Mentorship program

Self-learning access

Descripción de la vacante

Devexperts ищет старшего инженера баз данных для администрирования инфраструктуры баз данных на локальных серверах и в облаке. В вашей задаче — обеспечивать доступность, восстановление и масштабируемость, проектировать кластеры и репликацию, реализовывать резервное копирование и бизнес‑п Continuity, а также оптимизировать производительность и стоимость, взаимодействуя с командами разработки и поддержки.

Требуется 5+ лет практического опыта с PostgreSQL, знание Patroni, RDS/Aurora, PITR и

Formación

• 5+ лет hands-on опыта администрирования PostgreSQL в production окружениях.
• Профильный опыт проектирования HA-архитектур PostgreSQL с Patroni.
• Опыт работы с Amazon RDS для PostgreSQL и Amazon Aurora PostgreSQL.
• Надежные стратегии резервного копирования и PITR (pgBackRest, Barman).
• Глубокое понимание MVCC, vacuum, планирования запросов и репликации.
• Опыт мониторинга производительности, тюнинга запросов и устранения узких мест.
• Автоматизация развёртывания PostgreSQL с Ansible.
• Опыт partitioning (native и TimescaleDB) для временных рядов.

Responsabilidades

• Обеспечивать доступность, recoverability и масштабируемость баз данных.
• Проектировать и управлять подсистемами БД: кластеризация, репликация.
• Разрабатывать планы резервного копирования и DR/BCP.
• Обеспечивать соответствие требованиям регуляторов и индустриальным стандартам.
• Разрабатывать мониторинг, планирование емкости и операционные метрики.
• Анализировать инциденты, проводить RCA и внедрять коррективы.
• Сотрудничать с разработчиками, QA и поддержкой по запросам, связанным с БД.
• Участвовать в дежурствах и выступать точкой эскалации для критических инцидентов.
• Оптимизировать стоимость облачных БД на основе загрузки и ресурсов.
• Вести миграции данных и проводить риск-анализ.

Conocimientos

PostgreSQL

Patroni

Amazon RDS

Aurora PostgreSQL

PITR

pgBackRest

Barman

MVCC

Query optimization

Partitioning

TimescaleDB

Linux

Zabbix

ClickHouse

Ansible

Herramientas

Ansible

Descripción del empleo

Описание

Devexperts works with respected financial institutions, delivering products and tailor‑made solutions for retail and brokerage houses, exchanges, and buy‑side firms. The company focuses on trading platforms and brokerage automation, complex software development projects, market data products, and IT consulting services.

We are looking for a Senior Database Engineer who will be responsible for on‑premises and Cloud database infrastructure administration.

Задачи

• Ensure database services meet agreed service levels for availability, recoverability, performance, and scalability.
• Design and manage database subsystems, including clustering, replication, etc.
• Define and execute backup, disaster recovery, and business continuity procedures.
• Handle database compliance with industry standards, regulations, and best practices.
• Establish monitoring standards, capacity planning practices, and operational metrics to proactively identify risks and trends before they impact the business.
• Investigate production incidents, coordinate resolution efforts, perform root cause analysis, and drive remediation initiatives to prevent recurrence.
• Work closely with Developers, Quality Assurance and Support departments on a regular basis assisting with Database‑related requests.
• Participate in an on‑call rotation and serve as an escalation point for complex production issues affecting critical systems.
• Apply cost reduction practices for Cloud database Infrastructure based on the resources usage and databases load profile
• Conduct deep analysis of database performance issues, implementing solutions.
• Oversee data migration projects and perform risk analysis.
• Drive innovation in database technologies within the project or business unit.

Требования

• 5+ years of hands‑on experience administering PostgreSQL in production environments within mission‑critical systems, Proven experience designing, implementing, and operating high‑availability PostgreSQL architectures using Patroni
• Hands‑on experience managing Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL
• Strong expertise in backup and recovery strategies, including planning and executing Point‑in‑Time Recovery (PITR) using tools such as pgBackRest and Barman
• Solid understanding of PostgreSQL internals (MVCC, vacuuming, query planning, replication concepts, etc)
• Extensive experience with performance monitoring, SQL workload analysis, and database tuning, with the ability to identify bottlenecks and optimize database performance
• Experience automating database deployment, configuration management, and operational processes using Ansible
• Practical experience implementing and maintaining PostgreSQL partitioning strategies, including both native partitioning and TimescaleDB for time‑series workloads
• Strong working knowledge of Linux operating systems, including system performance analysis, process management, networking fundamentals, and storage concepts relevant to database operation
• Familiarity with database monitoring and observability tools such as Zabbix, including metrics collection, alerting, and log analysis
• Будет плюсом: Exposure to column‑oriented database technologies such as ClickHouse, with an understanding of their core concepts, architecture, and performance characteristics, would be a plus

Условия

Care for the employees is one of Devexperts' core values. For the suggested position, we offer a benefits package that will guarantee the comfort of our new teammate. Possibility of hybrid/remote work mode Flexible working hours 24 working days of paid vacation, Fully paid additional wellness days (3 days per year), FitPass (sport and related activities) access, Medical insurance - VIP package. Modern office with new equipment, PlayStation and table football in the office, Meals in the office. Teambuilding activities, Corporate parties, Football club, Billiard club, Speakers' club, Free admission to corporate external events, Possibility of joining conferences and professional fairs, Personal branding development support. English language courses, Georgian language courses for foreign employees, Unlimited access to self-learning platforms, Certification opportunities, Mentorship Program. Parental bonus, Referral bonus,