DBA - MYSQL - L1

Summary:

MySQL DBA (L1) with 2-4 years of experience maintaining MySQL databases on Linux (Red Hat, CentOS, Ubuntu) and Windows platforms.

- Proficient in installing, upgrading, and configuring large-scale MySQL databases, including mission-critical OLTP and OLAP systems.
- Hands-on experience with replication setups, backups, recovery, and migration of MySQL databases. - Knowledge of user administration, access control, and performance tuning for MySQL environments. - Familiar with backup strategies using MySQL Enterprise Backup, mysqldump, and other tools, including full and incremental backups. - Experienced in performance optimization, query tuning, and database health monitoring. - Basic understanding of high availability solutions such as MySQL Replication, InnoDB Cluster, and Group Replication. - Exposure to clustering and failover mechanisms to ensure database availability. - Assisting in routine database maintenance tasks, patching, and troubleshooting.

MySQL DBA with comprehensive knowledge of database architecture and administration across multiple platforms.

- Strong understanding of MySQL architecture and internals.
- Experience in installing, upgrading, and maintaining MySQL databases on Linux (Ubuntu, RHEL) and Windows environments. - Proficient in applying patches and updates to MySQL, including version upgrades and bug fixes. - Established backup and recovery strategies using tools such as mysqldump, MySQL Enterprise Backup, and other backup utilities. - Performed cloning of databases from production to test environments to facilitate development and testing. - Skilled in query optimization, index tuning, and supporting development teams with stored procedures, triggers, and query analysis. - Configured and maintained replication setups, including asynchronous replication, semi-synchronous replication, and Group Replication for high availability. - Managed physical and logical backups, including the use of mysqldump, Percona XtraBackup, and replication logs. - Automated routine database tasks using shell scripting and automation tools to streamline operations. - Developed scripts for monitoring database health, space utilization, and performance metrics. - Monitored hardware resource utilization, providing recommendations for hardware upgrades to optimize performance. - Conducted testing for performance, stability, failover, and upgrade validation to ensure reliable database environments. - Kept up-to-date with the latest MySQL releases and features, planning migration and upgrade strategies accordingly. - Assisted in developing automation scripts, documentation, and procedures for routine database administration and disaster recovery. - Ensured data security and integrity through proper user management, encryption, and compliance with departmental standards. - Managed backup and recovery processes, including incremental and full backups, and recovery procedures. - Experience with replication setup and troubleshooting, including monitoring replication lag and resolving replication issues. - Prepared and maintained scripts for database monitoring, space alerts, and performance metrics. - Good communication and interpersonal skills for effective collaboration with teams.