SUMMARY:

• Dynamic and self - motivated database professional with over 5+ years strong experience in managing production, test and development databases in complex heterogeneous environment
• Responsible for managing high performing databases including end user and third party provider activities pertaining to the design, development, testing, documentation and implementation of database services
• Proactively monitored databases to establish secure services with minimum downtime as per the SLAs
• Managed MySQL 5.0, and 5.1, 5.5, 5.6
• Managed MySQL and PostgreSQL High Availability
• Performed database backups and performance tuning
• Monitored databases on daily basis to ensure database services issues were promptly identified and resolved within SLAs
• Managed database related alerts and escalations
• Designed and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets
• Performed database installation, upgrades and patches
• Unix scripting for system maintenance, scripts for data interfaces and other database needs

TECHNICAL SKILLS:

• MySQL Workbench, MONyog, EM7 Server
• MySQL 5.0, 5.1, 5.5, 5.6
• MySQL Enterprise Manager
• MySQL backup and recovery, export/import, mysqldump, patches
• MySQL database indexes, constraints, views, stored procedures
• MySQL performance tuning and optimizations
• MySQL High Availability, replication master/slave, master/master
• Customer focus; Change Management process and tools
• Red Hat Enterprise, Linux, Susie Linux, NAS, Storage Area Network (SAN), and VMWare.
• Apache, Linux Shell scripting
• Oracle Enterprise Manager configuration and management
• Information Technology Disaster planning and recovery
• Motivated to learn and perform

PROFESSIONAL EXPERIENCE:

MySQL Administrator

Confidential

Responsibilities:

• Delivered MySQL server training to Oracle and Microsoft SQL server DBAs
• Delivered MySQL server administration on Linux and Windows
• Performed MySQL server installations, configuration and upgrade
• Performed MySQL performance tuning, replication, replication failover
• Troubleshoot and monitored MySQL servers

MySQL Database Administrator

Confidential

Responsibilities:

• Provided expert advice and direction in MySQL which includes database administration, high availability, database design and development for system solutions
• Provided 24/7 monitoring solution for various application services and database
• Managed MySQL instances for LAMP Applications
• Member of the project team, participating in and validating technology decisions
• Provided MySQL multi-master replication administration and configuration
• Managed MySQL and PostgreSQL and instances
• Managed databases using Monyog, and EM7 server monitoring applications

Oracle Database Administrator

Confidential

Responsibilities:

• Managed Oracle 10g and 11g databases on Veritas Cluster
• Creates, modifies, monitors, manages and deletes databases in order to provide support of various systems. Reviews and provides database growth and performance as necessary to project team.
• Proactively monitors databases to establish secure services with minimum downtime as per client SLAs.
• Analyzed information and make recommendations on database monitoring, performance and planning to project team.
• Utilizes advanced database programming techniques to complete complex assignments or to solve difficult problems.
• Creates, executes, and troubleshoot database scripts in Toad and PL/SQL.
• Works with senior level staff to define and implement standards for hardware, software and creation of database administration policies.
• Reviews data base designs and make recommendations for changes, to ensure efficiency and integrity of information.
• Mentors, coaches, supports, and provides leadership to database administrators and other IT staff to improve technical abilities; assist in completion of challenging assignments.

Senior Oracle & MySQL Database Analyst

Confidential

Responsibilities:

• Installed, configured, and managed Oracle 8i, Oracle 9i, Oracle 10g and Oracle 11g
• Installed, built, configured, and managed MySQL 5.0, and 5.1
• Performed MySQL backups and recovery, export/imports
• Managed MySQL replication, security issues
• Managed MySQL database objects - indexes, views, constraints and stored procedures
• Managed database users and security
• Performed MySQL database backups, setup backup directories, backup scripts, export and imports
• Performed MySQL backup recovery
• Performed MySQL replication - master/slave, MySQL performance tuning and optimizations
• Installed MySQL patches
• Monitored databases using MySQL Workbench
• Implemented and maintained development and production database security
• Developed proactive methodologies (policy and procedures) used in the management of Oracle databases and applications, for better performance, on Linux and Storage Area Networks (SAN ) platforms
• Corresponded with third party software vendors on product problems and enhancements;
• Developed and maintained database and software administration documentation, standards, and capacity plan
• Developed programs in UNIX shell scripts, MySQL scripts for various functions;
• Optimized queries for better performance
• Researched and resolved database problems
• Provided 24x7 database support services

Oracle Database Administrator / Programmer

Confidential

Responsibilities:

• Performed Oracle Database Administration duties to support PeopleSoft Applications
• Managed Oracle databases on Storage Area Network
• Defined disk layouts, Oracle database backup requirements, and sizing parameters for new Oracle databases
• Created database backup and recovery scripts to manage Oracle database backup process
• Performed Oracle database performance tuning