Mysql Database Administrator

Job description

Role: Database Administrator Required Technical Skill Set: MySQL Database Administration Desired Experience Range: 4-7 years with minimum 4 years of Mysql database administration experience. Note: Will be working from office in shifts across 24\\*7 Required skillset: • MySQL database Administration , Installation and configuration of MYSQL version 8.0.X, MYSQL knowledge • Backup & Recovery • Performance tuning and query optimization • Replication Master-Slave, Master-Master, and GTID-based replication • Database security and Access Management • Database monitoring and troubleshooting • knowledge of MySQL Migration MySQL version 5.0.X to 8.0.X Responsibility of / Expectations from the Role 1. Monitoring and maintenance of My SQL databases, installation of database software patches/upgrades, monitoring & scheduling of database backups, standardization and implementation of databases to improve the management of production and test environments, upgradation of DB versions support users by resolving problems with applications' databases. 2. Create and manage multiple databases and assist in capacity planning. 3. Use tools like MySQL Workbench, generate traces, execution plans, identify performance issues and resolve them. Develop strategies and implement solutions for managing back-ups, restoration and replication. 4. Create and manage constraints and indexes. Support software developers with database operations including the development of complex SQL and the creation of stored procedures. Manage production, staging and development database environments. 5. Strong expertise in MySQL clustering, replication, multi-master and MySQL Galara. Extensive experience with RDBMS concepts, database architecture and SQL.