MySQL DBA

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

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