DBA Engineer (PostgreSQL and MariaDB/MySQL)

Mayflower is a technology company building highload products used by millions of people worldwide. Operating at the scale of one of the world's top-50 websites, we solve complex engineering challenges and create solutions that power real-time entertainment for a global audience.

We are looking for an experienced Database Infrastructure Engineer to join our Infrastructure team. Our goal is to ensure the reliability, scalability, security and performance of high-load relational database systems. The primary focus of this role is the administration and optimization of PostgreSQL and MariaDB clusters, automation via IaC, and the development of reliable HA/DR solutions.

Job Responsibilities

-
Database Cluster Management: Deploy, administer, upgrade, and scale PostgreSQL and MariaDB clusters in high-load production environments;

-
High Availability & Disaster Recovery: Design and maintain HA solutions, replication topologies, failover/switchover, backup/restore , and DR plan;

-
Infrastructure as Code: Fully automate provisioning and configuration management using Terraform and Ansible;

-
Performance Tuning: Analyze query execution plans, optimize indexes and database parameters, investigate locking and replication lag, and tune Linux kernel parameters for specific workload profiles;

-
Observability: Configure monitoring, dashboards, logging, alerting, and SLOs for database services;

-
Troubleshooting: Investigate incidents, analyze logs and metrics, identify performance bottlenecks, and participate in on-call activities;

-
Automation: Develop tools and scripts for routine operations, health checks, failover validation, maintenance, and database lifecycle management.