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. Implement new technologies and design changes. Improve and maintain customer and employee satisfaction. #J-18808-Ljbffr TechDigital Group