Mayflower logo

DBA Engineer (PostgreSQL and MariaDB/MySQL)

Mayflower·Salary not specified

Primary stack

PrometheusAnsibleMySQLMariaDBPythonPostgreSQLLinuxGrafanaBashTerraform

Nice to have's

DebeziumKafkaKubernetesHelmClickHouseMongoDBRedisJavaGoPython

Job description

About the Position

DBA Engineer (PostgreSQL and MariaDB/MySQL)

Mayflower is a technology company building high-load 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.

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.

Requirements

  • 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 with HA solutions for PostgreSQL (Patroni, PgBouncer), MariaDB (MaxScale, Galera).
  • Experience troubleshooting replication lag, deadlocks, locking issues, and transactional workloads.
  • 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.

Nice to Have

  • 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.

We Offer

  • 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 (Cyprus): 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.

About the Company

Mayflower is a technology company building high-load 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.

© Made with love for IT. 2025 Mayflower

© Mayflower. This job description was sourced from the employer's public career page. TheJob is not the employer — we index the posting and route candidates to the source. All content rights and hiring decisions belong to the employer.

Mayflower is a technology company that alters the entertainment industry to a new level of perception and engagement.We are building the future of live entertainment. We believe that by providing people with the best and high-quality live streaming experience in entertainment, we can tackle the world’s “problems” better, together!

Popular searches