Swapnil

MySQL Database Administrator

Location :

Experience :4Year

Last active on :September 19, 2021

Rate: $15/Hourly

Availability :Immediate

Work From :Offsite

Category :Engineering & Design

 
Active:30+ Days ago
Shortlist :0
Total Views :43
Key Skills
MySQLMariaDBLinuxUnix Shell ScriptingMySQL WorkbenchDBAInstallation Configuration Upgradation.Monitoring troubleshooting
Summary

 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

issues.

 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.