Swapnil

MySQL Database Administrator
placeholder
Location 
view-icon
Total Views136
availability
Shortlist0
back in time
Member since30+ Days ago
 back in time
Contact Details
phone call {{contact.cdata.phone}}
phone call {{contact.cdata.email}}
Candidate Information
  • User Experience
    Experience 4 Year
  • Cost
    Hourly Rate$15
  • availability
    AvailabilityImmediate
  • work from
    Work FromOffsite
  • check list
    CategoryEngineering & Design
  • back in time
    Last Active OnMay 24, 2022
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.

Copyright : 2022 – OnBenchMark All Right Reserved.