Senior MySQL DBA Resume CA - Hire IT People

SUMMARY

7 years experience managing MySQL, medium to large scale database, in a complex multi - tier enterprise environment.
Strong administration skill in MySQL 5.0-5.5, and Percona 5.1-5.6, on Linux, and CentOS environments.

TECHNICAL SKILLS

RDBMS: MySQL 5.0-5.5, Percona 5.1-5.6, XtraDB, XtraBackup, Percona Toolkit, Sybase ASE 10-15, and Sybase Repserver 11.5-12.5.

MONITORING/ALERTING: Cacti, Procallator, Ganglia, MonYog, Confio, Nagios, and Icinga.

PLATFORMS: RedHat Linux 5.0-6.5, Centos 5-6, Solaris, SGI IRIX, HP-UX, Windows 95,98,2000,XP,7.

LANGUAGES: Shell, TSQL, C and C++.

UNIX TOOLS: sar, iostat, vmstat, mpstat, pstat, lsof, Netscaler, and F5.

STORAGE: SAN, file system, raw partition, 3Par, SSD and NetApp filer

SOURCE CONTROL: CVS and SVN

PROFESSIONAL EXPERIENCE

Senior MySQL DBA

Confidential, San Jose, CA

Responsibilities:

Set up, manage, and monitor Percona MySQL 5.6 instances on RHEL 6.5, to support online classroom applications for University of Phoenix.
Provide HA solution and perform failover process.
Set up infrastructure using custom scripts, Percona Toolkit, Nagios, and Cacti, to monitor db availability, locking issues, slave latency, and performance.
Performance tuning and disk optimization.
Use Percona XtraBackup for backup and recovery, slave resync, and cloning.
Monitor db growth for capacity planning, as well as for future project plan.
Set up SVN repository for db objects, MySQL user account privileges, custom scripts, and cron jobs.
Create run books and documentations for mentoring offshore DBAs.

Senior MySQL DBA

Confidential, San Jose, CA

Responsibilities:

Set up, configured, cloud base MySQL 5.5 in AWS, and Rackspace, which powers Total Media Networks platform running on CentOS 5.
Set up database monitoring using MonYog, Nagios, and Cacti.
Set up master-to-master replication to provide high availability.
Set up nightly database backup process for production, staging, UAT, and development environments.
Set up nightly data pruning process to maintain data growth.
Used Percona Toolkit for day-to-day operations, such as maintaining data integrity, online schema change, and monitor slow queries.
Worked with engineers to tune slow queries to improve applications performance.
Provided 24x7x365 operations support to NOC and DevOps, performed database deployments, and helped troubleshooting database related issues.
, \\Principal DBA/Architect at CBS Interactive, San Francisco, CA
Installed, set up, configured and managed 650 MySQL instances, and 25 Sybase ASEs with database size in terabytes, to support multi-business units in a 24x7 environment.
Set up master-to-master replication for production MySQL instances to provide high availability for automatic database fail-over to support various corporate mission critical sites.
Set up multi-query slaves for each MySQL tiers.
Wrote custom backup and recovery scripts, and alerting process for MySQL, and Sybase databases.
Monitored database performance metrics using MonYog, Cacti, Procallator, Ganglia, Confio, and use alerting tools such as Nagios and Icinga.
Set up automated daily optimize and pruning processes to ensure optimal operations performance.
Implemented standards for installation, upgrade, backup, and deployment procedures.
Monitored error log, slow query log, deadlock and blocking issues to identify performance bottleneck, and to provide solutions for performance improvement to operations team and developers.
Performed query plan evaluation and optimization for performance tuning.
Maintained SLA for all databases that support enterprise applications with 99.9% uptime.
Created SOX reporting tool to maintain compliance.
Used MySQL replication to perform frequent colo migrations to minimize site outage.
Used Maatkit tool for data checksum, set up replication and parse slow query logs.
Provide high availability using Veritas cluster on 3Par SAN for MySQL production instances.
Architected, planned, documented and executed various projects with timely completion while juggled through with daily database deployments and operational issues.
Participated in 24x7 on-call rotation to support production databases.
Worked with DevOps to deploy applications and database schema changes to support new applications and features.
Mentored and provided guidance in day-to-day operations to team members including offshore DBAs.

Database Administrator

Confidential, Mountain View, CA

Responsibilities:

Managed 50+ Sybase data servers version 4, ASE 10-11.5 and RepServer 11.5 running on SGI IRIX platform.
Supported SGI manufacturing and customer service systems databases.
Improved nightly backup process and shortened refresh process for corporate reporting servers.
Created in-house monitoring and alerting scripts.
Set up nightly database consistency check process to optimize and maintain database health and performance.
Provided technical support for in-house developers and business community.

We provide IT Staff Augmentation Services!

Senior Mysql Dba Resume

CA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship