Zuowu Yang
Senior database administrator
ad1a3t@r.postjobfree.com Greer, SC 296**-***-*** 8166
Summary:
17+ years of IT industry experience in database administration field. Strong experience to plan, install, upgrade, configure, audit, performance tuning, troubleshooting on database and data warehouse, including MySQL,Sybase,Vertica,Vector. Good program experience with Python and Shell script. Experience on AWS(network, RDS, Aurora, Dynamodb), IaC(Terraform), K8S, CI/CD(Gitlab). Authorized to work in the US for any employer, no visa sponsor needed. Skills:
* OLTP: Sybase(16 years), MySQL(10 years), PostgreSQL(1 year), Oracle(1 year)
* Data Warehouse: Vertica(1 year), Vector(6 years)
* Programs: Python(6 years), Shell scripts(16 years), SQL(16 years)
* VCS: Git(less 1 year)
* Cloud: AWS RDS, Aurora(less 1 year)
* IaC: Terraform(less 1 year)
* CI/CD: Gitlab(less 1 year)
Certifications:
* Terraform Associate
Jul 2023 to Jul 2025
* IBM Data Engineering
May 2022 to Present
Launch the new career in Data Engineering. Master SQL, RDBMS, ETL, Data Warehousing, NoSQL, Big Data and Spark with hands-on job-ready skills.
* Google IT Automation with Python
January 2022 to Present
This program builds on your IT foundations to help you take the career to the next level.
* Vertica Certified Professional Essentials 10
Jun 2021 to Jun 2023
Proven skill and knowledge on the Vertica architecture, managing database users and resources, load and manage data in the database, and understanding the database security environment.
* MySQL 5.0 Professional DBA
Awards:
* 2020 President's Club winner
TD SYNNEX global employee awards, reward who has the outstanding contribution and performance in past few years.
* June of 2021 Monthly performance star
TD SYNNEX global employee awards, represented IT department, for the good performance on projects.
Work Experience:
* Senior DBA, TD SYNNEX, Greenville SC
March 2016 to Present
* Independent ability to plan, install, upgrade, and troubleshoot database, including MySQL, Sybase ASE and Rep server, Vector, Vertica, PostgreSQL… Key projects:
Leading MySQL upgrade to 8.0.
MySQL break down, break down the single huge MySQL servers into hundreds of small databases, better stability and performance.
Follow the best practice, work with other teams to add the primary key for each table. Use the partition to replace delete, better performance, reduce the conflicting. Automate MySQL installation process, follow infrastructure as code. Sybase ASE from Solaris platform to Linux platform migration, 2 times performance improving. Vertica from 9.0 to 11 upgrading, 20 hours downtime saving.
* Database disaster recovery among datacenters.
Design and perform database disaster recovery among different datacenters. Automate all manual operations.
* Strong troubleshooting skills.
Ability to simplify a complicated issue.
Key projects:
Sybase ASE and Rep server down 10 hours, even involving Sybase support engineer can’t solve it. Figured out a corruption page once rep agent started. Sybase ASE reboot failure when switch kernel mode from process to thread. Figure out a parameter which works in process mode, but not in thread mode. MySQL replication lag without a primary key. Change the parameter to fix.
* Assistant DBA Manager, SYNNEX China, Chengdu Sichuan China February 2007 to March 2016
* Maintain databases, including Sybase, MySQL.
* Review and deploy schema designs.
* Plan project and resource, coordinate with other teams.
* Mentor DBA members.
* ERP supervisor, Sichuan Qiyang Group, Chengdu Sichuan China June 2006 to February 2007
* Maintain ERP system.
* Automation with Shell scripts.
* Oracle DBA, Mianyang Whale software INC, Mianyang Sichuan China May 2005 to June 2006
* Maintain Oracle database.
* Web program with C#
Education:
* Bachelor, Information Systems
Southwest University of Science and Technology, Mianyang, Sichuan, China September 2001 to May 2005