MySQL DBA
TechHuman · United States
- Hybrid
- Full-time
- $120,000 / year
- United States
Tailored resume — keyword-matched to this role.
Hiring manager — we find who's hiring.
Intro email — drafted to reach them directly.
Job highlights
- Administer and optimize critical MySQL databases.
- Perform seamless version upgrades and migrations.
- Ensure database performance, availability, and recovery.
- Collaborate on SQL optimization and database design.
- Support Linux environments and high availability.
About the role
MySQL Database Administrator
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.
Key skills/competency
- MySQL Database Administration
- Percona Server
- Galera Cluster
- InnoDB Storage Engine
- SQL Optimization
- Backup and Recovery
- Disaster Recovery
- Linux Administration
- Database Performance Tuning
- High Availability Architectures
Skills & topics
- MySQL
- Database Administrator
- DBA
- Percona Server
- Galera Cluster
- InnoDB
- SQL
- Linux
- Database Performance
- High Availability
How to get hired
- Tailor your resume: Highlight your 5+ years of MySQL DBA experience, Percona Server, Galera Cluster, and upgrade expertise.
- Showcase technical skills: Emphasize your deep knowledge of InnoDB, SQL optimization, backup/recovery strategies, and Linux administration.
- Demonstrate problem-solving: Provide examples of troubleshooting performance, locking, and concurrency issues in critical environments.
- Research TechHuman: Understand their focus on modernizing database infrastructure and supporting large-scale applications.
- Prepare for technical questions: Be ready to discuss specific scenarios involving database upgrades, HA, and performance tuning.
Technical preparation
Master InnoDB internals and performance tuning.,Practice performing zero-downtime MySQL upgrades.,Develop strategies for backup and recovery.,Optimize complex SQL queries for performance.
Behavioral questions
Describe a critical database performance issue you solved.,How do you handle pressure during a database outage?,Explain a challenging database migration you managed.,How do you collaborate with development teams effectively?
Frequently asked questions
- What are the key responsibilities for a MySQL Database Administrator at TechHuman?
- As a MySQL Database Administrator at TechHuman, your key responsibilities will include administering and optimizing critical MySQL database environments, planning and executing version upgrades with minimal downtime, monitoring database health and performance, collaborating with development teams on SQL optimization, and implementing robust backup and recovery strategies. You'll also troubleshoot performance issues, support high-availability architectures, and maintain documentation.
- What specific MySQL versions and technologies are most important for this role at TechHuman?
- For this MySQL Database Administrator role at TechHuman, significant experience with MySQL 5.x and/or MySQL 8.x is crucial. Proficiency in managing Percona Server and Galera Cluster is highly valued, as is a deep understanding of the InnoDB storage engine. Experience with modernization initiatives and migrating legacy environments is also a key aspect of this position.
- How does TechHuman approach database upgrades and migrations for their critical systems?
- TechHuman emphasizes performing MySQL version upgrades and migrations with minimal application downtime and operational risk. As a MySQL Database Administrator, you will be instrumental in planning and executing these transitions, ensuring continuity and stability for their large-scale business applications. This involves careful strategy, execution, and rigorous testing.
- What kind of collaboration can I expect as a MySQL DBA at TechHuman?
- As a MySQL Database Administrator at TechHuman, you will collaborate closely with application development teams. This partnership will involve reviewing and optimizing SQL queries, discussing database design improvements, and troubleshooting any performance or design-related issues to ensure the smooth operation of mission-critical business applications.
- Does TechHuman have a strong focus on high availability and disaster recovery for their databases?
- Yes, TechHuman places a strong emphasis on high-availability database architectures and robust disaster recovery procedures. As a MySQL Database Administrator, you will be responsible for implementing and maintaining these systems to ensure minimal service disruption and business continuity for their critical applications.