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.
Create and manage multiple databases and assist in capacity planning.
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.
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.
Solid expertise in MySQL clustering, replication, multi-master and MySQL Galara.
Extensive experience with RDBMS concepts, database architecture and SQL.