SUMMARY

• 6 years MySQL DBA experience
• 5+ years Linux Systems Administrator experience

TECHNICAL SKILLS

Database Servers: MySQL (5.1, 5.5, 5.6), Percona Server(5.5), MariaDB(10)

MySQL Client Tools: MySQL, mysqldump, myisamcheck, mysqladmin

MySQL GUI Tools: MySQL Adminsitrator, MySQL Workbench, PhP MyAdmin

MySQL Toolkits: Percona Toolkit, MySQL Utilities

MySQL Engines: MyIsam, InnoDB

MySQL Replication Managers: MySQL Utilities, MySQL High Availability

MySQL High Availability Solutions: Replication (Master/slave, Master/Master)

Clustering Solution: Galera Cluster, Percona Galera Cluster, MySQL Cluster, DRBD

Languages: SQL, Shell Scripting

Linux Systems Administration: Red Hat, Centos, Ansible

PROFESSIONAL EXPERIENCE

Confidential, TX

MySQL Database Administrator

Responsibilities:

• Maintain, monitor, tune, and support existing MySQL 5.1/5.5/5.6 database environments for production, staging, QA and development
• Automate various DBA tasks using shell scripts
• Install and configure MySQL databases using binaries, source and RPM
• Install and configure PostgreSQL databases
• Optimization of database performance
• Serve as an escalation point for any defined database issues regarding performance, security, and ongoing maintenance
• Work with the OS and development team to optimize queries and performance functionalities.
• Analyze problems and incidents, identify root cause for critical incidents and identify, resolve or provide workarounds to address issues resulting from new MySQL installations and upgrades
• Troubleshoot any problems that may come up with the database environments
• Set up infrastructure using custom scripts, Percona Toolkit, Nagios and AppDynamics to monitor database availability, locking issues, slave latency, and performance.
• Use Percona XtraBackup for backup and recovery, slave set up and cloning.
• Assist in formalizing and updating database policies, procedures, and technical standards
• Perform application patches, upgrades, service packs and other maintenance
• Manage database security, disaster recovery, and capacity planning;
• Estimate database capacities and develop system for monitoring;
• Perform Physical to physical and Physical to Virtual MySQL server migrations using mysqldump, RSYNC and Xtrabackup
• Setup and manage cron jobs using skybot
• Perform ongoing OS performance tuning, hardware upgrades, and resource optimization as required.
• Configure OS disk partitions as required.

Confidential - Embanet, IL

MySQL Database Administrator

Responsibilities:

• Administered and managed the entire development, QA and production environment.
• Installed and configured MySQL in Linux environments using binaries and source code.
• Managed MySQL 5.1,5.5 and 5.6 in production and development environments
• Increased database performance by utilizing MySQL configuration changes, clustering and by upgrading hardware.
• Assisted with sizing, query optimization, backup and recovery, installations, upgrades and security including other administration functions.
• Worked with the engineering team to implement new design systems of databases used by the company.
• Effectively configured MySQL Replication.
• Installed and configured Tungsten Replicator
• Designed databases for referential integrity and involved in logical design plan.
• Performance Tuning and capacity planning using MySQL Enterprise Monitor.
• Developed stored procedures, triggers in MySQL for lowering traffic between servers and clients.
• Created and deleted users, groups and set up restrictive permissions, configuration of the sudo files etc.
• Performed MySQL Replication setup and administration on Master-Slave and Master-Master.
• Documented all servers and databases.
• Supported management with different database related decisions.
• Setup and configured Ansible for remote server management
• Handled release management and user acceptance.

Confidential, MD

MySQL Database Administrator

Responsibilities:

• Installed and configured MySQL on Linux and Windows environments.
• Troubleshooting MySQL 5.1 and 5.5 in production and development environments
• Performed installation from binaries and rpm to companies customization needs.
• Managed query optimization, buffer tuning, backup and recovery, installations, upgrades and security.
• Ensured production data being replicated into data warehouse without any data anomalies from the processing databases.
• Worked with the engineering team to implement new design systems of databases used by the company.
• Effectively configured MySQL Replication as part of HA solution.
• Performance Tuning on a daily basis for preventing issues and providing capacity planning
• Generated procedures, triggers in MySQL for lowering traffic between servers & clients.
• Managed database clustering.
• Created and deleted users, groups and set up restrictive permissions, configuration of the sudo files.
• Performed MySQL Replication setup and administration on Master-Slave and Master-Master.
• Managed production and development database clusters
• Performed query and schema analysis for efficient SQL processing
• Automated database deployments, upgrades, and monitoring
• Troubleshoot database-related application performance issues and recommend solutions
• Collaborate with cross-functional teams to troubleshoot live issues, internally or externally-reported
• Installation, configuration, operation, and maintenance of systems hardware and software and related infrastructure.
• Install and maintain security patches on the operational and development system.
• Perform daily system monitoring, verifying the integrity and availability of all hardware, server resources, systems and key processes, reviewing system and application logs, and verifying completion of scheduled jobs such as backups.
• Perform regular file archival and purge as necessary.

Confidential, MD

MySQL Database/Linux Systems Administrator

Responsibilities:

• Optimize MySQL database structures and performance
• Monitor database performance including capacity and usage
• Manage backup and recovery for database system
• Perform on-site, day-to-day production MySQL database administration tasks in a Linux environment, including maintenance, troubleshooting, tuning, optimization, installation, upgrades, backup/recovery, and data migration across multiple data centers and multiple database server architectures/systems.
• Responsible for effective provisioning, installation/configuration, operation, and maintenance of systems hardware and software and related infrastructure.
• This individual will be part of a team accountable for the following systems: Linux, SAN Storages, Security, and Inventory systems that support the primary infrastructure;
• Install new / rebuild existing servers and configure hardware, peripherals, services, settings, directories, storage, cabling, etc. in accordance with standards and project/operational requirements.
• Install and configure systems such as supports infrastructure and applications.
• Develop and maintain installation and configuration procedures.
• Perform daily system monitoring, verifying the integrity and availability of all hardware, server resources, systems and key processes, reviewing system and application logs, and verifying completion of scheduled jobs such as backups.
• Create, change, and delete user accounts per request.
• Apply OS patches and upgrades on a regular basis, and upgrade administrative tools and utilities. Configure / add new services as necessary.
• Providing both Remote and On-Site System Administration support for Red Hat Linux Servers
• Setup and configuration of Kernel Based Virtual Machines on Red hat Enterprise Linux Servers
• Datacenter Virtualization and Cloud Computing on a VMWare ESXi environment
• Perform System Monitoring with Nagios, Manage user accounts with command line and GUI
• Monitoring connections and load of Apache server using mod status.
• Configuration of DNS and local YUM repository for software package management.
• Hardening systems with Security Enhanced Linux and File System Special permissions
• File transfer with NFS, Autofs, FTP, SAMBA, SSH etc.
• Installation and configuration of Apache Webserver in a LAMP stack.
• Experience with Role Based Access Control and Systems Security Administration
• Provide support to high end Red Hat and Windows servers hosting MySQL database
• Experience with Bash Shell Scripting
• Server builds and deployment
• P2P and P2V migrations using Cygwin and WINSCP
• Handled managed file transfer using GoAnywhere
• Provide support for migrated applications
• Install and support Oracle 11gR2

Confidential, MN

Linux Systems Administrator

Responsibilities:

• Performance tuning, hardware upgrades, and resource optimization as required.
• Configured CPU, memory, and disk partitions as required.
• Performed network installation, configuration and provided monitoring for network devices such as routers, switches and firewalls
• Troubleshooting internet connectivity in LAN and wireless Networks
• Used Active Directory to create user accounts and email accounts.
• Monitored and responded to network alerts, outages and other critical events
• Re-imaged client computers and loaded them with new images and software.
• Maintained current Information Technology Inventory as required by Service Level Agreements
• Maintained records of daily business transactions, problems and remedial actions
• Used Web based ticketing System to transmit client request to senior technical team.
• Planned and implemented Patch Management programs for LAN/WAN infrastructure
• Provide off hours support as needed as part of monthly maintenance windows
• Linux server build and provisioning
• Performed Physical to physical and Physical to Virtual migrations using RSYNC, Filezila and WINSCP
• Performed MYSQL installations.
• Managed/Troubleshoot MySQL 5.0/5.1 in production and development environments on both Linux and windows environment.
• Automate database deployments, upgrades, and monitoring
• Troubleshoot and resolve production database
• Installed and maintained security patches on the operational and development system.
• Performed daily system monitoring, verifying the integrity and availability of all hardware, server resources, systems and key processes, reviewing system and application logs, and verifying completion of scheduled jobs such as backups.

Confidential

Dental Clinic Manager

Responsibilities:

• Served as a Non-Commissioned Officer-in-Charge for the United States Confidential - managed activities of the regional dental clinic and processed troops for deployment in support of Operations Iraqi freedom
• Acted as a direct liaison between cross functional commands and other units
• Executed assigned missions, provided communication in all units and ensured rules compliance
• Developed training programs, information technology support resources and leadership direction