We are seeking an experienced MariaDB Database Administrator (DBA) with 5+ years of hands-on experience managing and optimizing MariaDB environments.
The successful candidate will ensure database availability, performance, reliability, and security across both production and non-production environments.
Key Responsibilities:
Database Administration
- Install, configure, and upgrade MariaDB Server in Linux/Unix environments.
- Manage database instances across production, UAT, and development environments.
- Monitor database performance, health, and availability.
- Perform routine database maintenance and optimization tasks.
Performance Optimization
- Analyze and optimize slow SQL queries.
- Tune database parameters to improve performance and throughput.
- Manage indexing strategies and review query execution plans.
Backup & Recovery
- Design and maintain logical and physical backup strategies.
- Perform point-in-time recovery (PITR) when required.
- Regularly test backup and restoration procedures.
- Implement disaster recovery solutions.
High Availability & Replication
- Configure and manage replication (Master-Slave / Master-Master).
- Implement clustering solutions, preferably Galera Cluster.
- Troubleshoot replication lag and synchronization issues.
Security & Compliance
- Implement database security best practices.
- Manage user roles and access privileges.
- Apply security patches and updates.
- Conduct database audits and compliance checks.
Automation & DevOps Support
- Develop automation scripts using Bash, Python, or Ansible.
- Automate monitoring, backups, and deployments.
- Support DevOps and CI/CD workflows.
Troubleshooting & Support
- Diagnose and resolve database-related incidents.
- Support application teams with database issues.
- Participate in on-call support rotation when required.
Requirements
- Bachelor's degree in Computer Science, IT, or related field.
- 5+ years of experience as a Database Administrator.
- Strong hands-on experience with MariaDB / MySQL architecture.
- Experience with:
- Replication & clustering (Galera preferred)
- Database performance tuning
- Backup and recovery tools
- Strong Linux administration skills.
- Experience with monitoring tools.
- Understanding of TCP/IP networking and system performance.
- Experience with AWS or Azure is a plus.
- Saudi nationality is required.