- core mysql and mysql enterprise monitoring.
- installation and configuration and upgradation of mysql database.
- user access management for mysql.
- hands-on experience on linux os and familiar with basic linux commands and shell scripts.
- data migration, backup, restore & recovery, resolving performance issues, blocking and deadlocks.
- implement and monitor mysql cluster to provide high availability for mission critical events,
database mirroring, replication and log shipping.
- implement and maintain security and integrity controls including backup and disaster recovery
strategies for mysql databases.
- design and create database objects such as data table structures, stored procedures, views,
triggers, reports, database administration, configuration, maintenance and support.
- experience in dr drill activities like switchover and failover.
- knowledge of etl tools like pentaho data integration, tableau etc
- extensive work experience on query optimization, script optimization, other related optimization tools
and techniques including performance monitoring.
- develop, implement, and maintain change control of databases. ensure all database systems meet
business and performance requirements, including patch management.