Zhongchun Yan

**** ** *** ******, ******, Washington 98059 602-***-**** ada1at@r.postjobfree.com

Summary of Qualifications

MySQL/MariaDB DBA

Oracle DBA

Informix DBA

PostgreSQL DBA

GoldenGate

** ***rs

10 years

12 years

6 years

6 years

Unix, Linux

C, Java, Perl, Shell Script

Tivoli Storage Manager

ETL

LDAP

20 years

20 years

8 years

15 years

7 years

Experience

Hewlett Packard Enterprise/Perspecta, Seattle, Washington Technical Consultant IV, 2014 – Present

As subject matter expert in MySQL and PostgreSQL, provide MySQL and PostgreSQL support/consultant services across multiple departments and for multiple clients

Build and support database clusters of MySQL v5.1~8.0 database clusters including master to slave, master to master and innodb cluster replication; Conduct MySQL databases management activities such as user management, space management, replication setup, database patching, performance tuning and disaster recovery exercise.

Build and support database clusters of PostgreSQL v8~11; In additional to complete regular database management routines, play a technical lead role in Oracle 11 to Postgres 11 migration, responsibilities including migration tools evaluation and selection, data migration and objects (tables, views, sequences, triggers, functions and stored procedures) migration; database migration project finishes successfully per project plan

Provide enterprise databases services in MS SQL v2012~2016, Oracle RAC v11~v12 and Teradata v15

Develop and enhance database jobs of Unix shell/perl/python scripts and Windows PowerShell scripts

Successfully migrate enterprise databases to open source databases including DB2 to MySQL, Oracle to MySQL, Oracle to Postgres and from on-premise to AWS cloud First Data Corporation, Chandler, Arizona

Senior Database Administrator, 2011 – 2014

Provide Oracle 9i/10g/11g/11gR2 production database administration services that ensure 100% database availability

Lead the project of database replication and implement GoldenGate replication with success that replaces physical standby database and materialized views

Play a primary role in writing and enhance monitoring shell/perl script tools of RMAN backup, database health monitoring and database replication

Successfully setup and support Oracle Internet Directory (Oracle LDAP) 10 TSYS Acquiring Solutions, Tempe, Arizona

Senior Database Administrator (DBA), 1998 – 2011

Provide primary Informix database administration services. Install and configure Informix IDS 10 and 11 database client and server; Upgrade Informix IDS database from version 10 to 11.50; Make schema change and user management; Conduct database space management; Backup and restore database using onbar; Perform tuning and continuous data replication (CDR)

Single-handedly design and develop a set of Perl/Java/Shell scripts high-performance data integration tools for a 35 Terabytes data warehouse running on Informix XPS and HP-UX. The applications extract, transform and load (ETL) data from OLTP database, fix length files and delimited flat files to data warehouse

Provide enterprise databases services in MS SQL and Oracle

Created shell scripts ETL application to synchronize databases of company core systems

Developed company mission critical applications in C, C++ and Java Education

Master of Science in Petroleum Engineering

University of Kansas, Lawrence, Kansas

Master of Science in Computer Science

Shandong University, Jinan, China

Certificates and Honors

• Oracle Database Administration Associate 10g

• IBM DB2 UDB 8.1 Database Administrator for Linux, UNIX and Windows

• Teradata Master V2R5

• System Administrator for IBM Informix Dynamic Server V10

• American Software Testing Qualifications Board Software Tester

• TSYS Acquiring Solution Electrifying Performance Award and Golden Standard Award

Contact this candidate