Назад
Company hidden
4 дня назад

Senior PostgreSQL DBA

Формат работы
remote (только Europe)
Тип работы
fulltime
Грейд
senior
Английский
b2
Страна
Ukraine/Europe
Вакансия из списка Hirify.GlobalВакансия из Hirify Global, списка международных tech-компаний
Для мэтча и отклика нужен Plus

Мэтч & Сопровод

Для мэтча с этой вакансией нужен Plus

Описание вакансии

Текст:
/
TL;DR
Senior PostgreSQL DBA (Amazon Aurora PostgreSQL): Improving the performance, resilience, and operational safety of a production database platform with an accent on failover, observability, workload isolation, and capacity management. Focus on defining safe operating limits, preventing connection and concurrency overload, tuning PostgreSQL workloads, and ensuring predictable recovery.

Location: Fully remote; candidates must be based in Ukraine or have relocated to Europe. Long-term cooperation.

Company

hirify.global provides production platform engineering and database reliability work.

What you will do

  • Improve the performance, resilience, and operational safety of a production platform running on Amazon Aurora PostgreSQL.
  • Define measurable database safe operating limits and protect against excessive connections, concurrency spikes, abnormal workloads, and retry storms.
  • Build observability and alerting that detects degradation before database saturation.
  • Isolate expensive workloads and ensure predictable failover and recovery without secondary overload.
  • Collaborate with Platform Engineering, application development, and operations teams to investigate cross-layer performance and reliability issues.
  • Create database monitoring, alerting, operational runbooks, and resilience controls.

Requirements

  • 5+ years of hands-on PostgreSQL experience in high-load production environments.
  • Strong practical experience with AWS Aurora PostgreSQL, including writer/reader architecture, replication, failover, and capacity management.
  • Deep knowledge of PostgreSQL performance tuning, including execution plans, indexing, query optimization, wait events, locks, transactions, and statistics.
  • Experience with EXPLAIN ANALYZE, pg_stat_statements, PostgreSQL system views, and AWS database-performance monitoring tools.
  • Knowledge of autovacuum, table and index bloat, transaction-ID management, data retention, archival, and high-volume cleanup strategies.
  • Experience configuring database connection layers such as AWS RDS Proxy, PgBouncer, or similar solutions; understanding of connection pooling, concurrency limits, backpressure, and workload throttling.
  • Experience defining capacity thresholds and safe operating limits using workload metrics and load testing; understanding of read scaling, replica lag, and read-after-write consistency.
  • Experience with backups, recovery, failover testing, application retry behavior, monitoring, alerting, and operational runbooks.
  • Upper-Intermediate or higher English is required for technical discussions and documentation.

Nice to have

  • Experience with very large transactional tables and PostgreSQL partitioning.
  • Experience with Terraform or other infrastructure-as-code tools.
  • Familiarity with Kubernetes-based applications and asynchronous workloads.
  • Experience conducting database load, stress, and resilience testing.
  • AWS or PostgreSQL-related certifications.

Culture & Benefits

  • Fully remote, long-term cooperation with flexible working hours; start between 8:00 and 11:00.
  • 16 paid vacation days per year, 16 documented sick-leave days, and 5 undocumented sick-leave days.
  • Leave for significant life events and medical-insurance compensation for employees based in Ukraine.
  • Weekends follow the Ukrainian or local calendar.
  • Career growth opportunities, certifications, and Udemy courses.
  • Friendly, open, and supportive culture with corporate events, team building, gifts, and recognition.

Будьте осторожны

Если работодатель просит войти в их систему, используя iCloud/Google, прислать код/пароль, запустить код/ПО, не делайте этого. Это мошенники. Обязательно жмите «Пожаловаться» или пишите в поддержку. Подробнее в гайде →