MySQL Database Administrator
Last active on :September 19, 2021
Work From :Offsite
Category :Engineering & Design
Professional and motivated, having over 3.8 years of DBA and Development work experience in the software
industry with recent versions of MySQL(5.x, 8.x) & MariaDB(5.x, 10.x).
Providing 24/7 production support for critical production systems to resolve database performance issues, job
failures, sessions & diagnose root causes.
Strong proficiency in database monitoring & management.
Experience in handling Production and Non-Production databases - Monitoring, troubleshooting production
Good understanding of MySQL architecture concepts.
Performed MySQL Installation, Configuration, Upgradation.
Experience in MySQL Database Administration, physical & logical design, development, maintenance and
production support of relational databases, business applications, new server setup.
Understanding of MySQL’s underlying storage engines, such as InnoDB and MyISAM.
Expertise in DB Instance Creation in both clustered and non-clustered configurations.
Proficient in writing shell scripts to automate the backup/restoration of databases & other routine tasks.
Experienced in Performance Tuning, Database Optimization.
Expertise in query tuning/optimization with the help of explain plan.
Worked on Database Security Policy & user management: Maintaining the user privileges using DDL, DCL &
DML Commands, Granting and revoking privileges, changing password.
Worked on best DB Standards & Practices: Ensuring performance, security, and availability of databases.
Worked on Multiple server setups.
Monitoring MySQL logs.
Worked on MariaDB Audit_Plugin Installation & monitoring.
Performed backup & restoration using mysqldump utility.
Performed point in time recovery using mysqlbinlog utility.
Performed data-fragmentation & maintenance activity.
Worked on different MySQL Replication configuration (Master-Slave, Chain & GTID Replication).
Worked on troubleshooting of replication issues.
Performed DR(Disaster Recovery) activity.
Good understanding of HA options: Galera Cluster & InnoDB Cluster.
Pro-active MySQL health checkup.
Hands on experience in Troubleshooting: General Problems and their resolution, Connection problems, and
understanding the error logs.
Worked on incidents like User creation/deletion incidents, Backup failed incidents, DB failover/down incidents,
and also some other incidents related errors or problems from DB end.
Collaborated with team members, other team members and stakeholders.