Sql Server System Administrator

ToNy JIng

. CellPhonE : 650-***-****

. EMAIL : ***********@*****.***

EXPERIENCE SUMMARY

HIGHLY MOTIVATED, QUICK LEARNER WITH OVER 10 YEARS

EXPERIENCES WORKING IN THE IT INDUSTRY SPECIALIZING

IN MYSQL, MICROSOFT SQL SERVER AND ORACLE DATABASE

ADMINISTRATION AND DEVELOPMENT. PROVEN ABILITY TO

SOLVE A WIDE VARIETY OF SOFTWARE AND BUSINESS

ISSUES. EXCELLENT ANALYTICAL, ORGANIZATIONAL,

MULTI-TASKING, PLANNING AND PROBLEM SOLVING SKILLS.

OPERATE WELL INDEPENDENTLY OR WITHIN A TEAM. EAGER

TO INCREASE MY KNOWLEDGE AND ADD TO MY TECHNICAL

SKILL SET. DEAL WELL UNDER PRESSURE AND WITH

RIGOROUS DEADLINES. LOOKING FOR A CHALLENGE AND

LOVE CREATIVE SOLUTIONS TO COMPLEX PROBLEMS.

OBJECTIVE

MYSQL DBA AND DEVELOPER

Linux/Unix System Administrator

Microsoft SQL Server DBA and developer

Professional 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 history

September 2012 ~ Present: Dell Corporation,

Atlanta, GA

Position: Senior MySQL DBA - contractor

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.

MAY 2010 ~ AUGUEST 2012: ACCENTURE,

CINCINNATI, OH

Position: Senior MySQL Database Administrator -

contractor

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.

April 2007 ~ May 2010: GE Healthcare,

Chicago, IL

Position: MySQL and Microsoft SQL Server DBA

Experience architecting, enhancing and maintaining

large MS SQL Server and MySQL databases through

coding of triggers, stored procedures, packages and

business logic modules for new and existing

applications. Worked with local and remote team

members to organize and coordinate delivery of

project milestones.

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.

Auguest 2005 ~ March 2007: Comcast,

Denver, CO

Position: Linux System Administrator

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.

Education

Old Dominion University

Norfolk VA

Master Degree in Computer Science

Contact this candidate