SUMMARY

• More than 10 years experiences in Information Technology industry as MySQL/MS SQL Server/Oracle database administrator/developer and unix - like platform system administrator such as Linux / IBM AIX / HP-UX / Oracle(Sun) Solaris / BSD.
• More than 8 years hands-on experiences in MySQL/MariaDB database administration, including design, development, implementation, migration, upgrading, maintenance and production support of complex database applications and huge data warehouse system.
• Solid first-hand experiences with data modeling and database logical / physical design.
• Deep understanding and solid skills in MySQL Sharding, and Master-Master / Master-Slave Replication.
• First hand experiences with Amazon AWS, RDS(SQL Server and MySQL) and S3/EBS storages; Excellent knowledge with SAN storage and Storage Capacity Planning.
• Strong MySQL and Oracle skills but also significant general system administration skills on Linux, IBM AIX/Oracle Solaris/HP-UX, and Windows environment. Proficient writing korn/bash shell and Perl scripts as well as knowledge in general system administration tasks.
• Experienced in database optimization and developing stored procedures, triggers, cursors, joins, views, and SQL tuning on MS SQL and MySQL databases.
• Expertise in MySQL database migration from MyISAM format to Innodb storage engine to increase performance and betterment of integrity constraints.
• Strong exepriences with monitoring, troubleshooting, and resolving database issues in 24x7 production environment.
• Experience in the administration of Web based Internet/Intranet Client/Server multi-tire distributed application, major in database technologies in Consulting, Internet, Telecom domains.
• Experienced in designing, modeling, developing and support web based projects with responsibilities including analysis, design, development, implementation and maintenance.
• Solid Experiences in database and system performance tuning, query optimization, client/server connectivity, and database consistency checks using different utilities.
• Expertise in snapshot, import/export, database optimization with the help of explain plan in MySQL database.

TECHNICAL SKILLS

DATABASE: MySQL 4.x/5.x, MariaDB, Oracle 11g/12c, MS SQL Server 2008,2008R2, 2012, 2014, NoSQL concepts(key/value, graph, document)

LANGUAGE: SQL, PHP, Perl, Python, Ruby, HTML, CSS, Javascript, C/C++/C#

PLATFORM: Linux (Redhat/CentOS, Ubuntu, Debian), FreeBSD, IBM AIX, HP-UX, Solaris and Windows

MONITOR SYSTEM: Zabbix, Nagios, Solarwinds, Graphite, New Relic

APPLICATION: Apache/Nginx/Tomcat, SVN/Git, Samba, Fireware, VPN, VMWare and KVM.

TOOLS: SSRS/SSAS/SSIS, Profiler, Performance Monitor, SQLyog, Visual Studio

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Senior MySQL DBA

Responsibilities:

• Senior MySQL database administrator responsible for over sixty MySQL 5.5 databases with intricate row based replication configurations including filters and cross internet communication. Manage and tune multi-terabyte MySQL databases with million plus row tables on solid state drives, as well as conventional disk storage in virtual and non-virtual environments. Investigate and offer solutions to database related issues and counsel colleagues on best practices working with MySQL.
• Installed, Patched, Maintained, and Upgraded MySQL using MySQL utilities and monitoring tools. Setup and Monitored backups, implement and test recovery techniques. Diagnosed and corrected performance problems.
• Participated in the project of data migration from Oracle 11g to MySQL 5.x. Wrote shell scripts and setup cron job to automatically backup MySQL databases in Linux platform.
• Work in the production engineering group to support more than 60 production MySQL database servers, plus servers in Dev and QA environments.
• Maintain a reliable database management plan, including performance tuning, monitoring, backup and recovery, replication strategies, etc.
• Work with development teams to make best schema design that balances feature requests with performance concerns.
• Coordinate with the team that responds to all system problems in order to reduce or eliminate production problems by analyzing production usage information and using that information to design a better architecture.
• Setting up MySQL Nagios Alarms, using a GPLed Database Administration Dashboard, managing multiple MySQL installations, managing terabytes of data and converting the data into a datamart. Wrote Perl scripts to load data into our raw database, to convert raw data into a datamart, archive raw data that has been converted to a datamart. Installed services such as Nagios, Wiki, Mercurial, and other technologies for our department.
• Increase availability and performance of applications by gathering and analyzing server and database metrics with various monitoring tools.
• Advise system administrator on optimal components and configuration for new and replacement database hardware.
• Converted tables to InnoDB storage engine to increase performance, concurrency, durability and facilitate consistent online backups.
• Greatly simplified administration by integrating user authentication with LDAP and proxying accounts to pre-defined privilege groups.
• Code monitoring, backup, alerting and programs that automate administrative database tasks in the Go programming language.

Confidential, Cincinnati, OH

Senior MySQL Database Administrator

Responsibilities:

• Core contributor for supporting MySQL 5.1 databases. The role involved server hardware selection and builds, FreeBSD administration, MySQL administration and architecture, new product development as well as defect identification and bug fixes of existing code in various languages including SQL, PHP, Perl and bash/ksh.
• Worked in the Infrastructure team as a senior MySQL DBA contractor responding to all system problems and participated in 24X7 on-call rotation.
• Developed automation processes, benchmarked, implemented and oversaw database policies and procedures to ensure the availability and reliability of production databases.
• Cooperated with other DBAs and system engineers to investigate problems, implement solutions, achieve efficiency gains, and automate repetitive tasks.
• Setup and maintained MySQL replication in master-master topology; diagnosed replication issues and performed failover when server fails.
• Maintained and validated database backups. Migrated data from server to server to mitigate disk space and performance problems.
• Upgraded 40+ MySQL instance from 5.0 to 5.1 and fixed upgrading issues independently.
• Designed and implemented SPARKS, a PERL script used to monitor production sites, by looking at MySQL logs, replication server logs, and database related resources. The script looks for errors and uses the spatch software to page the DBA on call.
• Installed, configured and migrated development, staging/QA, and production database instances across different environments.
• Tuned and optimized operating system and MySQL server using DBA tools and best practices to achieve maximum performance.
• Evaluated, implemented, and integrated complex administration and monitoring tools such as Nagios and Cacti to monitor all of the websites, servers, and database instances.
• Planed and tested fault tolerance capabilities for backup and recovery, replication, multi-master failover, and disaster recovery.

Confidential, Chicago, IL

MySQL and Microsoft SQL Server DBA

Responsibilities:

• Worked closely with Systems Administrators and Development teams to Administer - install, upgrade, migrate and troubleshoot Prod and non-prod SQL server instances across both physical and virtual machine (VMware) environments.
• Administered over 30 Microsoft SQL servers database and more than 50 MySQL databases.
• Designed database system architecture, manage production databases to achieve high availability and scalability.
• Migrated production database servers with minimal downtime. Monitor production databases for performance, availability and data integrity.
• Supported reporting applications, and other sub systems dependent on SQL server.
• Configure and maintain database replication, log shipping and nightly processes. Scripted several database maintenance tasks reducing manual processes and related overheads.
• Created SSIS packages for data transfers, Import/Export and Migrations. Recreated indexes, optimized queries, memory management to improve performance.
• Created and managed full-text server, linked servers to support production needs.
• Integrated SQL Server with Windows Active directory security for database/table level permissions.
• Monitored Windows/Linux system using Nagios software.

Confidential, Denver, CO

Linux System Administrator

Responsibilities:

• Responsible for the administration, installation, configuration, troubleshooting and support of MySQL in Linux/AIX and Windows platforms. Provided technical support and training for more than 300 users on the organization.
• Developed Unix shell scripts to be used with MySQL to enforce standard process used by the development organization.
• Designed database system architecture, manage production databases to achieve high availability and scalability.
• Linux and Unix infrastructure design and management. Improved service performance and reliability through investigation and root cause analysis.
• Monitoring system logs and root's email for important messages such as errors and warnings or hardware failure errors.
• Implementation of systems and scheduling automated and manual backups/restored to take production data and archive log files backup.
• Cisco router installation and configurations. Troubleshooting of Cisco VPN client related issues.
• Performing User ID creation, modification, deletion and maintain server security.