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.