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.