Sr MySQL DBA & Developer Resume Los Angeles - Hire IT People

PROFESSIONAL EXPERIENCE

Sr My SQL DBA & Developer

Confidential - Los Angeles

Responsibilities:

Writing Ad-Hoc queries for Business Analytics, Daily reporting for GL, Auditing reports, database performance metrics,
Scripting for automated backups, database encryption(column, table, database)
Performance Tuning & Optimization
Schema Design for BI integration
Scalability for High Availability
MySQL Enterprise Backup Utilities
DevOps Tools - Puppet Enterprise, WatchDog, Docker Containers, Jenkins
Support for HA
Install, Upgrade and document New MySQL version 5.6.40
Work on Migrating MySQL databases into the Cloud(AWS RDS)
Cloud migration and server configuration setup (AWS)
Installation of Mysql InnoDB Clusters Enterprise environments
Working with Oracle MEM for server managements
Working with MySQL and firewall setups with Topology design
Working with MySQL database design and Application, Job server, Tomcat, Apache, Linux
Working with large database design(MySQL) with data warehousing (Cognos, Jasper)
Working with Extensive scripting using PHP SQL for automated processes, reporting.
Expert in SQL scripting for automating processes with Schema database design
Expert in MySQL tools including SQLyog, MonYog, Percona Backups, Oracle MEM, Nagios and Workbench.

MySQL Database Administrator

Confidential

Responsibilities:

Working as a MySQL Database Administrator involving several MySQL instances with Master to Master replication and several slave installations.
Checking configuration settings for optimal results in a InnoDB environment. Creating scripts for general table analysis and Database design.
Working with several tools to administer and profile MySQL instances like Jetprofiler, SQLyog, MONyog, MySQL Workbench and Percona.
In addition, performing general studies of Database Schemas and optimal indexes created.
Also, troubleshooting and resolving MySQL errors in a multiple MySQL server instance environment using CentOS.

Senior Consultant MySQL Database Administrator

Confidential

Responsibilities:

DBA for multiple databases in a MySQL VM environment; job responsibilities include optimization, creation of a high-availability with Microsoft Cluster Services, with VMware Clusters, setup of Master to Master replication, Master to slave replication and Linux Ubuntu setups.
Also, creation of new MySQL instances of MariaDB, Windows, Linux, and conversions of MyISAM to InnoDB for high transaction environments.
In addition, upgrading current environments to MySQL 5.5.23, MySQL Cluster 7.2.5, MySQL Workbench 5.2.39 and MySQL ODBC connectors 5.1.11;
Perform general studies of Database schemas for table optimization and index structures. And create automated scripts using Events and stored procedures for scheduling of backups and database synchronization jobs.