MySQL Database Administrator

Your Skills:

• 5-8 years of software industry experience as MySQL DBA. Installed and configured MYSQL on Windows Linux Environments. Performed Installation, new databases design, configuration, backup, recovery, security upgrade, schema changes, tuning and data integrity.
• Performed incremental backup and log file rotation. Increased database performance by utilizing MYSQL configuration changes multiple instances.
• Familiar with hands-on experience on different MySQL cluster setups like Innodb, Galeria, Percona in both active-active and active-passive configurations.
• Setup Disaster recovery instance and enable production DR sync. Handle production DR failover issues.
• Ensured production data being replicated into Data Warehouse without having any data anomalies from the processing databases.
• Worked with the Engineering team to implement new design systems of databases.
• Have dealt with Database hot and cold backup.
• Performance tuning for preventing issues and providing capacity planning using MYSQL Enterprise monitor.
• Have troubleshooted performance issues, analysed the slow execution queries and tuning the queries for better performance. Created and Deleted Users, Groups and setup restrictive permissions.
• Performed MYSQL Replication setup and administration on Master-Slave.
• Assisted with sizing, Query Optimization, Backup and Recovery, installations, upgrades and security including other administrative functions as a part of profiling plan.
• Configured auto switch to failover.
• Giving inputs to various stakeholders different database-related decisions.
• Should have experience in DB Size optimization.
• Highly performance oriented individual, self-motivated and results-focused. Committed to high standards and continuous improvement.
• Ability to take ownership and drive actions to closure.
• Good mentor, team player and contributor with excellent collaboration and interpersonal skills.
• Experience in supporting DB for enterprise-scale applications and
• Experience in Financial Service Industry or Banking applications will be an added advantage.
• GraduatesPost Graduates, preferably in Engineering from reputed institutions.