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.