DBA Engineer (PostgreSQL and MariaDB/MySQL)
About this job
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. You’ll thrive here if you have • Experience: 3+ years as a DBA, DBRE, DevOps Engineer, or System Administrator with a strong focus on production relational databases; • Deep understanding of PostgreSQL/MariaDB architecture and internal database processes; • Building PostgreSQL/MariaDB high-availability architectures, replication, backup and performance tools; • Experience HA soultions for PostgreSQL (Patroni, PgBouncer), MariaDB (MaxScale, Galera); • Experience troubleshooting replication lag, deadlocks, locking issues, and transactional workloads; • Hands-on experience testing failover scenarios and performing recovery from backups; • Strong SQL and query optimization skills, analyze and profiling queries. IaC & Automation: • Strong proficiency in Terraform, including writing reusable modules and managing state files; • Experience writing complex Ansible roles and playbooks. Linux: • Deep knowledge of Linux internals, filesystems, CPU, memory, disk I/O, networking, and kernel tuning for database workloads. Observability: • Experience with Prometheus/VictoriaMetrics, Grafana, and the ELK stack. Scripting: • Proficiency in Python or Bash for automation and operational tooling. Big Plus: • Kafka & Debezium: Experience configuring CDC pipelines from PostgreSQL or MariaDB using Debezium and Kafka Connect; • Kubernetes & Helm: Experience running stateful database workloads in Kubernetes, including database operators; • Cloud Platforms: Experience with managed database services and cloud infrastructure; • Analytical & NoSQL Databases: Knowledge of ClickHouse, MongoDB, Redis or other distributed data platforms; • Security: Experience with database access control, TLS, secrets management, auditing, and encryption; • Programming: Experience supporting applications written in Java, Go, Python, or similar languages. Conditions We know that great talent deserves great conditions, so here's what you can expect when joining us: • EU-based employment contract and a 3-year Cyprus work visa with full support for your relocation and visa processes, including assistance for your family. • EU passport. Opportunity to obtain an EU passport after 4 years of residence • Full relocation package: flights to Limassol for you and your family, a company-covered apartment for the first month, and full relocation support to make your move smooth and hassle-free. • Provident fund (Cypus): a long-term savings plan co-funded by you and the Company together (available after probation) that grows throughout your time with us in Cyprus. • Transparent performance reviews twice a year, with bonus opportunities and salary adjustments. • Private medical insurance for you and your family • Corporate mobile plan (unlimited in Cyprus with roaming included) • Mindfulness & well-being support, including psychological assistance with 50% coverage. • 50% coverage of school and kindergarten fees for your children. • Fully covered sports benefits, and also access to in-house electric scooters and bike rentals • Professional growth support: language courses, conferences, training programs, and coaching. • Peer recognition program: receive and share kudos for great work. • A fully equipped office in Limassol’s city center, with everything you need for deep work and collaboration. • Free breakfasts and lunches in the office and an in-house coffee bar with high-quality drinks and a health bar stocked with nutritious snacks. • A strong engineering culture: international teams, corporate events, team buildings, and hackathons — because great work happens in great communities. Recruitment process • HR interview (45 minutes); • Technical interview (1.5 hour); • Final interview (1 hour); • Recommendations check; • Job Offer.