MYSQL DBA

You will be joining our dynamic technology team as a highly skilled and experienced MySQL Database Administrator. Your primary responsibility will be to ensure the performance, integrity, security, and availability of our MySQL database systems. This role requires proactive problem-solving skills, a deep understanding of database administration principles, and the ability to work both independently and collaboratively on various aspects of database management. Your key responsibilities will include: - Installing, configuring, administering, and maintaining multiple MySQL database environments across different stages (production, staging, development). - Monitoring database performance, identifying bottlenecks, and implementing solutions to optimize query performance, storage, and system efficiency. - Developing, implementing, and testing robust backup and recovery strategies to ensure data integrity and business continuity. - Implementing and maintaining database security measures, including user access control, auditing, and vulnerability management in compliance with security policies. - Designing, implementing, and managing database schema changes while ensuring data integrity and application compatibility. - Diagnosing and resolving database-related issues efficiently, including performance degradation, connectivity problems, and data inconsistencies. - Implementing and managing MySQL replication topologies and high availability solutions to ensure system uptime. - Developing scripts and automation tools for routine database administration tasks. - Collaborating with development teams, system administrators, and other stakeholders to provide necessary database support. - Planning and executing database upgrades and migrations with minimal downtime. - Keeping updated with the latest MySQL features, best practices, and security updates. To be successful in this role, you should have: - Bachelor's degree in Computer Science, Information Technology, or a related field. - 5-6 years of hands-on experience as a MySQL Database Administrator. - 2-3 years of experience 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, optimization techniques, backup and recovery procedures, and database security principles. - Proficiency in writing and debugging SQL queries and stored procedures. - Experience with MySQL replication technologies, high availability solutions, Linux/Unix operating systems, and scripting languages for automation tasks. - Strong analytical and problem-solving skills with effective communication and collaboration abilities. Preferred skills include experience with cloud-based database services, database monitoring tools, database migration tools, DevOps practices, CI/CD pipelines, and relevant MySQL certifications.,