Plan, coordinate and implement security measures to safeguard database files; identify and troubleshoot database-performance issues. Learn new technologies quickly, set priorities, meet deadlines and maintain collaborative approach to deliver results. Engage hands-on technical training, work experience, and support IT infrastructures.
Install, upgrade, optimize, troubleshoot, perform root cause analysis on, and maintain MySQL servers versions from between 5.0 to 5.5, distributions from Red Hat, Centos, and Ubuntu MySQL releases, Percona Server with XtraDB.
ï Setup, troubleshoot, and fix backups and restore data using tools such as Mydumper, My loader, and Percona Xtrabackup
ï Implementation of MySQL Stored Procedures, triggers and views
ï Provided technical Support to around 140 instances of MySQL 5.0, 5.1, 5.4 and 5.5 running on 50 Production/QA/Dev. Linux servers with Centos 4.x and 5.x and around 16 TB of data on direct Storage. Some tables with more than 500 million rows. This includes master-master and master-slave configurations, as well as, testing MySQL Cluster and the administration of the PCI database environment using PCI General appliance.
ï Two years Plus of Managing MySQL databases (over 50 databases in a replication environment)
ï MySQL tuning/optimization for InnoDB, MyISAM..
ï configured and set up AWS management console and configured all connection to endpoints through MySQL workbench making sure all back up processes were correctly set up.
ï General Linux system administration tasks including configuration
ï General setup of multi-master cluster replication using MariaDB Galera cluster