MySQL Database Administrator

Job Summary:

We are seeking a highly skilled and experienced MySQL Database Administrator to join our dynamic technology team. The ideal candidate will be responsible for the performance, integrity, security, and availability of our MySQL database systems. This role requires a proactive individual with a strong understanding of database administration principles, excellent problem-solving skills, and the ability to work independently and collaboratively. You will be involved in all aspects of database management, from design and implementation to maintenance and optimization.

Responsibilities:

• Database Administration:

  Install, configure, administer, and maintain multiple MySQL database environments (production, staging, development).

• Performance Tuning and Optimization:

  Monitor database performance, identify bottlenecks, and implement effective solutions to optimize query performance, storage, and overall system efficiency.

• Backup and Recovery:

  Develop, implement, and test robust backup and recovery strategies to ensure data integrity and business continuity.

• Security Management:

  Implement and maintain database security measures, including user access control, auditing, and vulnerability management, in compliance with security policies.

• Schema Management:

  Design, implement, and manage database schema changes, including table creation, modification, and indexing, while ensuring data integrity and application compatibility.

• Troubleshooting and Issue Resolution:

  Diagnose and resolve database-related issues in a timely and efficient manner, including performance degradation, connectivity problems, and data inconsistencies.

• Replication and High Availability:

  Implement and manage MySQL replication topologies (e.g., master-slave, group replication) and other high availability solutions to ensure system uptime.

• Automation:

  Develop and implement scripts and automation tools for routine database administration tasks, such as backups, monitoring, and deployments.

• Collaboration:

  Work closely with development teams, system administrators, and other stakeholders to understand application requirements and provide database support.

• Upgrades and Migrations:

  Plan and execute database upgrades and migrations with minimal downtime.

• Staying Current:

  Keep abreast of the latest MySQL features, best practices, and security updates.

Required Skills and Experience:

• Bachelor's degree in Computer Science, Information Technology, or a related field
• Minimum of 3-8 years of hands-on experience as a MySQL Database Administrator
• Should have a minimum of 2-3 years of experience in managing MySQL databases in Cloud (AWS - RDS/Aurora) & on-premise environments
• Strong understanding of MySQL architecture, internals, and storage engines (e.g., InnoDB, MyISAM)
• Proven experience in performance tuning and optimization techniques, including query analysis, index optimization, Parameters and server configuration
• Solid experience with database backup and recovery procedures, including point-in-time recovery.
• In-depth knowledge of database security principles and best practices.
• Proficiency in writing and debugging SQL queries and stored procedures.
• Experience with MySQL replication technologies and high availability solutions.
• Familiarity with Linux/Unix operating systems.
• Experience with scripting languages such as Bash or Python for automation tasks.
• Excellent analytical and problem-solving skills with strong communication and collaboration skills.
• Ability to work independently and manage multiple tasks effectively.