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.