SUMMARY

• More TEMPthan 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 TEMPthan 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 wif data modeling and database logical / physical design.
• Deep understanding and solid skills in MySQL Sharding, and Master-Master / Master-Slave Replication.
• First hand experiences wif Amazon AWS, RDS(SQL Server and MySQL) and S3/EBS storages; Excellent knowledge wif 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 wif monitoring, troubleshooting, and resolving database issues in 24x7 production environment.
• Experience in teh 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 wif 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 wif teh 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 wif intricate row based replication configurations including filters and cross internet communication. Manage and tune multi-terabyte MySQL databases wif 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 wif 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 teh 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 teh production engineering group to support more TEMPthan 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 wif development teams to make best schema design dat balances feature requests wif performance concerns.
• Coordinate wif teh team dat responds to all system problems in order to reduce or eliminate production problems by analyzing production usage information and using dat 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 teh data into a datamart. Wrote Perl scripts to load data into our raw database, to convert raw data into a datamart, archive raw data dat TEMPhas 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 wif 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 autantication wif LDAP and proxying accounts to pre-defined privilege groups.
• Code monitoring, backup, alerting and programs dat automate administrative database tasks in teh Go programming language.

Confidential, Cincinnati, OH

Senior MySQL Database Administrator

Responsibilities:

• Core contributor for supporting MySQL 5.1 databases. Teh 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 teh 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 teh availability and reliability of production databases.
• Cooperated wif 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. Teh script looks for errors and uses teh spatch software to page teh 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 teh 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 wif 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 TEMPthan 50 MySQL databases.
• Designed database system architecture, manage production databases to achieve high availability and scalability.
• Migrated production database servers wif 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 wif 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 teh administration, installation, configuration, troubleshooting and support of MySQL in Linux/AIX and Windows platforms. Provided technical support and training for more TEMPthan 300 users on teh organization.
• Developed Unix shell scripts to be used wif MySQL to enforce standard process used by teh 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.