MySQL DBA

TechDigital Group; Austin (TX); On-site; USD 80,000 - 120,000; Full time

Job summary

An established industry player is seeking a seasoned MySQL DBA to manage and optimize their database systems. This role involves ensuring high performance, availability, and security of MySQL databases, both on-premises and in the cloud. You will be responsible for database design, implementation, monitoring, and maintenance while collaborating with cross-functional teams to enhance database integration. If you thrive in a dynamic environment and possess strong analytical and problem-solving skills, this opportunity is perfect for you. Join a forward-thinking company that values innovation and excellence in database management.

Qualifications

• 7+ years of MySQL DBA experience in production environments.
• Expertise in SQL performance tuning and database design.

Responsibilities

• Install, configure, and manage MySQL databases on-premises and in cloud environments.
• Monitor performance, optimize queries, and implement security best practices.

Skills

MySQL DBA experience

SQL performance tuning

Database design

MySQL replication

Backup and recovery tools

Cloud database solutions

Monitoring tools

Linux command-line tools

Analytical skills

Database security best practices

Tools

AWS RDS

Azure Database for MySQL

Google Cloud SQL

Prometheus

Grafana

Percona Monitoring and Management

Nagios

Job description

MySQL DBA profiles with 7+ years of experience, to manage, optimize, and ensure the reliability of MySQL database systems. Responsible for database design, implementation, monitoring, and maintenance, ensuring high performance, availability, and security.

Skills Requirements:

1. Proven experience as a MySQL DBA in production environments.
2. Expertise in SQL performance tuning, query optimization, and code/script optimization and other optimization tools and techniques.
3. Proficient in designing and creating database objects, such as data table structures, stored procedures, views, triggers, reports, database administration, configuration, maintenance, and support.
4. Hands-on experience with MySQL replication (Master-Slave, Master-Master, GTID, etc.).
5. Familiarity with backup and recovery tools (mysqldump, Percona XtraBackup, etc.).
6. Experience with cloud-based database solutions (AWS RDS, Azure Database for MySQL, Google Cloud SQL).
7. Knowledge of monitoring tools such as Prometheus, Grafana, Percona Monitoring and Management (PMM), or Nagios.
8. Familiarity with Linux operating systems and command-line tools.
9. Excellent analytical, problem-solving, and communication skills.
10. Understanding of database security best practices.

Key Responsibilities:

1. Install, configure, and manage MySQL databases on-premises and in cloud environments.
2. Monitor database performance, identify bottlenecks, and optimize queries, indexing, and storage engines.
3. Implement security best practices, manage access controls, and ensure compliance with data protection regulations.
4. Design and implement backup and disaster recovery strategies to ensure data integrity and availability.
5. Configure replication, clustering, and failover mechanisms for high availability and scalability.
6. Diagnose and resolve database-related issues, ensuring minimal downtime.
7. Develop scripts for automation of routine database tasks using SQL, Python, or Shell scripting.
8. Monitor database growth and plan for scalability and future storage needs.
9. Work closely with developers, system administrators, and DevOps teams to optimize database integration and performance.
10. Collaborate with developers to design and implement database structures.
11. Maintain documentation of database configurations, schemas, and procedures.
12. Plan and execute database migrations and upgrades.
13. Ensure maximum uptime according to the SLA.
14. Implement new technologies and design changes.
15. Improve and maintain customer and employee satisfaction.