MySQL DBA

MySQL DBA

Posted 2 days ago by TechHuman

Apply
Negotiable
Undetermined
Remote
Remote
Apply
Application Development Balancing (Ledger/Billing) Business Continuity And Disaster Recovery Database Administration Database Design Database Tuning Disaster Recovery File Servers Galera InnoDB Linux Linux Administration Load Balancing Management Mobile Application Development MyISAM MySQL Operational Risk Oracle Linux Scalability Software Development SQL (Programming Language)

Summary: We are seeking a MySQL Database Administrator to support and modernize critical database environments that power large-scale business applications. The role focuses on administration, performance, availability, upgrades, and operational support of MySQL infrastructure, including migrations from legacy versions to modern architectures with minimal downtime.

Key Responsibilities:

  • Administer, maintain, and optimize enterprise MySQL database environments supporting mission-critical business applications.
  • Plan and execute MySQL version upgrades while minimizing application downtime and operational risk.
  • Monitor database health, performance, availability, and capacity across production environments.
  • Collaborate with application development teams to review, optimize, and troubleshoot SQL queries and database design issues.
  • Implement and maintain backup, recovery, and disaster recovery procedures with minimal service disruption.
  • Troubleshoot database performance, locking, replication, and concurrency-related issues.
  • Support high-availability database architectures and infrastructure modernization initiatives.
  • Participate in database tuning efforts to improve scalability, reliability, and performance.
  • Maintain documentation related to database configurations, procedures, and operational standards.
  • Support Linux-based database environments and related administrative tasks.

Key Skills:

  • 5+ years of professional MySQL database administration experience, supporting MySQL 5.x and/or MySQL 8.x environments, managing Percona Server and Galera Cluster.
  • Deep knowledge of InnoDB storage engine, including locking mechanisms, transaction management, and performance optimization.
  • Strong understanding of database concurrency, consistency models, and ACID compliance principles.
  • Working knowledge of MySQL transaction isolation levels and their impact on application behavior.
  • Experience performing MySQL upgrades with limited or no downtime.
  • Experience designing and executing backup and recovery strategies with minimal service interruption.
  • Strong SQL skills, including query review, optimization, troubleshooting, and developer support.
  • Basic Linux administration experience.

Salary (Rate): undetermined

City: undetermined

Country: undetermined

Working Arrangements: remote

IR35 Status: undetermined

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

We are seeking a MySQL Database Administrator to support and modernize critical database environments that power large-scale business applications. This role will focus on administration, performance, availability, upgrades, and operational support of MySQL infrastructure, including migrations from legacy versions to modern architectures with minimal downtime.


Responsibilities

  • Administer, maintain, and optimize enterprise MySQL database environments supporting mission-critical business applications.
  • Plan and execute MySQL version upgrades while minimizing application downtime and operational risk.
  • Monitor database health, performance, availability, and capacity across production environments.
  • Collaborate with application development teams to review, optimize, and troubleshoot SQL queries and database design issues.
  • Implement and maintain backup, recovery, and disaster recovery procedures with minimal service disruption.
  • Troubleshoot database performance, locking, replication, and concurrency-related issues.
  • Support high-availability database architectures and infrastructure modernization initiatives.
  • Participate in database tuning efforts to improve scalability, reliability, and performance.
  • Maintain documentation related to database configurations, procedures, and operational standards.
  • Support Linux-based database environments and related administrative tasks.

Must-Haves

  • 5+ years of professional MySQL database administration experience, supporting MySQL 5.x and/or MySQL 8.x environments, managing Percona Server and Galera Cluster.
  • Deep knowledge of InnoDB storage engine, including locking mechanisms, transaction management, and performance optimization.
  • Strong understanding of database concurrency, consistency models, and ACID compliance principles.
  • Working knowledge of MySQL transaction isolation levels and their impact on application behavior.
  • Experience performing MySQL upgrades with limited or no downtime.
  • Experience designing and executing backup and recovery strategies with minimal service interruption.
  • Strong SQL skills, including query review, optimization, troubleshooting, and developer support.
  • Basic Linux administration experience.

Nice-to-Haves

  • Experience with Percona Server for MySQL.
  • Experience with Galera Cluster for MySQL high availability.
  • Understanding of load balancing concepts for database environments.
  • Experience with ProxySQL.
  • Experience supporting legacy MySQL environments and modernization initiatives.
  • Knowledge of the MyISAM storage engine and migration considerations.
  • Familiarity with application architectures supporting large-scale B2B platforms.
Apply
Similar Jobs
Loading data...