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.