MariaDB Adminnistrator

Prospex Development


Date: 2 weeks ago
City: Riyadh
Contract type: Full time
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.

How to apply

To apply for this job you need to authorize on our website. If you don't have an account yet, please register.

Post a resume

Similar jobs

PMO Expert

stc, Riyadh
9 hours ago
Job PurposeThe role holder is responsible for supporting the execution of Mission-Critical and Business-Critical PMO’s activities by coordinating project timelines, tracking deliverables, consolidating updates, and ensuring adherence to project scope, budget, and quality standards. The role also contributes to the consistent application of project management methodologies and tools and facilitates cross-functional collaboration to ensure efficient implementation of technology initiatives. The...

Senior Manager: Procurement - Regional Links

Parsons, Riyadh
16 hours ago
In a world of possibilities, pursue one with endless opportunities. Imagine Next! At Parsons, you can imagine a career where you thrive, work with exceptional people, and be yourself. Guided by our leadership vision of valuing people, embracing agility, and fostering growth, we cultivate an innovative culture that empowers you to achieve your full potential. Unleash your talent and redefine...

Recovery Director

Mace, Riyadh
1 day ago
Mace combines construction expertise with consultancy to unlock potential in every person or project and redefine the boundaries of ambition. Our values shape the way we consult and define the people we want to join us on our journey. The project: This is an opportunity to work on one of the largest programmes in Saudi Arabia. This unique project consists...