Allianz - Database Administrator - MySQL

Job Description :

We are looking for an experienced MySQL Database Administrator (DBA) to join our technology team.

The ideal candidate will have strong hands-on experience managing production MySQL environments, ensuring high availability, performance, and reliability of database systems.

Key Responsibilities :

- Manage and support production MySQL databases (MySQL / Percona / MariaDB)

- Perform database installation, configuration, upgrades, and migrations

- Handle backup & recovery, including PITR, replication, clustering, and HA setups

- Perform query optimization, indexing, and performance tuning

- Monitor database health using tools like Prometheus, Grafana, PMM, or Datadog

- Automate regular DBA and maintenance activities using Ansible or Puppet

- Troubleshoot database and infrastructure-related issues

- Work closely with application, infrastructure, and DevOps teams

- Prepare and maintain technical documentation and runbooks

- Mentor junior DBAs and contribute to continuous process improvement

Required Skills & Experience :

- Strong hands-on experience as a MySQL DBA in production environments.

- Expertise in MySQL / Percona / MariaDB administration.

- Experience with replication, clustering, and HA architectures.

- Solid understanding of backup, recovery, and disaster recovery planning.

- Proficiency in performance tuning and query optimization.

- Experience with monitoring and observability tools.

- Working knowledge of Linux systems.

- Experience with automation tools such as Ansible or Puppet.

- Strong troubleshooting and problem-solving skills.

- Good communication and documentation abilities.

Good to Have :

- Exposure to cloud platforms (AWS, Azure, or GCP).

- Experience working in DevOps or SRE environments.

- Knowledge of containerized or Kubernetes-based database deployments.