dba for high-load relational databases

Mayflower is a technology company building high-load products used by millions of people worldwide. Its products operate at the scale of one of the world's top-50 websites and power real-time entertainment for a global audience.

• Deploy, administer, upgrade, and scale PostgreSQL and MariaDB clusters in high-load production environments;
• Design and maintain high-availability solutions, replication topologies, failover and switchover processes, backups and restores, and disaster recovery plans;
• Automate infrastructure provisioning and configuration management using Terraform and Ansible;
• Analyze query execution plans, optimize indexes and database parameters, investigate locking and replication lag, and tune Linux kernel parameters for specific workload profiles;
• Configure monitoring, dashboards, logging, alerting, and SLOs for database services;
• Investigate incidents, analyze logs and metrics, identify performance bottlenecks, and participate in on-call activities;
• Develop tools and scripts for routine operations, health checks, failover validation, maintenance, and database lifecycle management.

• 3+ Years of experience as a DBA, DBRE, DevOps Engineer, or System Administrator, with a strong focus on production relational databases;
• Deep understanding of PostgreSQL and MariaDB architecture and internal database processes;
• Experience building PostgreSQL and MariaDB high-availability architectures, replication, backup, and performance tools;
• Experience with PostgreSQL HA solutions such as Patroni and PgBouncer, and MariaDB solutions such as MaxScale and Galera;
• Experience troubleshooting replication lag, deadlocks, locking issues, and transactional workloads;
• Hands-on experience testing failover scenarios and recovering from backups;
• Strong SQL and query optimization skills, including query analysis and profiling;
• Strong Terraform proficiency, including writing reusable modules and managing state files;
• Experience writing complex Ansible roles and playbooks;
• Deep knowledge of Linux internals, filesystems, CPU, memory, disk I/O, networking, and kernel tuning for database workloads;
• Experience with Prometheus or VictoriaMetrics, Grafana, and the ELK stack;
• Proficiency in Python or Bash for automation and operational tooling;
• Nice to have: configuring CDC pipelines from PostgreSQL or MariaDB using Debezium and Kafka Connect, running stateful database workloads in Kubernetes including database operators, managed database services and cloud infrastructure, knowledge of ClickHouse, MongoDB, Redis, or other distributed data platforms, database access control, TLS, secrets management, auditing and encryption, supporting applications written in Java, Go, Python, or similar languages.

• EU-based employment contract;
• A 3-year Cyprus work visa with full support for relocation and visa processes, including assistance for family members;
• Opportunity to obtain an EU passport after 4 years of residence;
• Relocation package includes flights to Limassol for the employee and family, a company-covered apartment for the first month, and relocation support;
• Provident fund in Cyprus, co-funded by the employee and the company, available after probation;
• Performance reviews twice a year, with bonus opportunities and salary adjustments;
• Private medical insurance for the employee and family;
• Corporate mobile plan with unlimited usage in Cyprus and roaming;
• Mindfulness and well-being support, including psychological assistance with 50% coverage;
• 50% Coverage of school and kindergarten fees for children;
• Fully covered sports benefits, plus access to in-house electric scooters and bike rentals;
• Professional growth support through language courses, conferences, training programs, and coaching;
• Peer recognition program;
• Fully equipped office in Limassol city center;
• Free breakfasts and lunches in the office, an in-house coffee bar, and a health bar stocked with nutritious snacks;
• International teams, corporate events, team building, and hackathons;
• Recruitment process: HR interview (45 minutes), technical interview (1.5 hour), final interview (1 hour), recommendations check, and job offer.