MariaDB Adminnistrator

Key Responsibilities

1. Database Administration

• Install, configure, upgrade, and maintain MariaDB Server in Linux/Unix environments.

• Manage and support database instances across Production, UAT, and Development environments.

• Monitor database health, availability, and overall performance.

• Perform regular database maintenance, patching, and optimization activities.

2. Performance Optimization

• Analyze and optimize complex and slow SQL queries.

• Tune database configuration parameters to enhance performance and scalability.

• Manage indexing strategies and analyze query execution plans.

• Identify and resolve database performance bottlenecks.

3. Backup & Recovery

• Design, implement, and maintain robust logical and physical backup strategies.

• Perform Point-in-Time Recovery (PITR) when required.

• Regularly test backup restoration procedures to ensure reliability.

• Implement and maintain disaster recovery (DR) solutions.

4. High Availability & Replication

• Configure and manage replication setups (Master-Slave / Master-Master).

• Implement and support clustering solutions, preferably Galera Cluster.

• Troubleshoot replication issues, including lag and synchronization problems.

5. Security & Compliance

• Implement database security best practices and hardening measures.

• Manage database users, roles, and access privileges.

• Apply security patches and updates in a controlled manner.

• Conduct periodic audits to ensure compliance and data protection standards.

6. Automation & DevOps Support

• Develop and maintain automation scripts using Bash, Python, or Ansible.

• Automate routine tasks such as backups, monitoring, and deployments.

• Collaborate with DevOps teams to support CI/CD pipelines involving database changes.

7. Troubleshooting & Support

• Diagnose and resolve database-related incidents and outages.

• Provide support to application teams for database-related issues.

• Participate in on-call support rotation when required.

Requirements

• Bachelor’s degree in Computer Science, Information Technology, or a related field.

• 5+ years of experience as a Database Administrator.

• Strong hands-on experience with MariaDB / MySQL architecture.

• Proven experience in:

  • Replication and clustering (Galera Cluster preferred)

  • Database performance tuning and optimization

  • Backup and recovery strategies and tools

• Strong Linux/Unix system administration skills.

• Experience with database monitoring tools.

• Solid understanding of TCP/IP networking and system performance tuning.

• Experience with cloud platforms (AWS or Azure) is a plus.

• Saudi nationality is required.