MySQL DBA Admin - 4-6 years - Mumbai
Job Description :
• Should be SPOC for all MySQL Database incidents, installations, upgradations, migration, Replication performance tuning activities and patching
• Should be responsible to validate the different backups and restore using different tools
• Should manage creation/alteration of Database, changes to database schema, creation/alteration of user roles and privileges
• Should be responsible for Database tuning, Performance tuning, Database troubleshooting that includes rigorous performance checks/root cause/analysis
of database instances using provided tools.
• Should be responsible for management and maintenance of Database Security, Backup and Recovery policies and procedures
• Should create SOPs for various day to activities/incidents
• Should follow processes for change control, problems, incidents, service calls and manage the incident/tickets at provided tool.
• Should have sound knowledge Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using different Utilities.
• Expertise in database migration from MyISAM format to Innodb storage engine to increase performance and betterment of integrity constraints.
• Should participate in database upgrade, patch upgrade as and when required
• Should interact with respective Database vendors for technical support.
• Patch Management and Version Control