Yan Zhang

* ******* ******, *** **********, NJ **974

Email: ad01y0@r.postjobfree.com

Phone: 908-***-****(C)

TECHNICAL SKILLS & EXPERTISE

Databases: Oracle 7.3/8.x/9.x/10g/11g/12c/19c

Operating Systems: Unix (Sun Solaris, IBM AIX), Linux, Windows

Languages: SQL, PL/SQL, Shell Script

Utilities/Tools: Oracle Enterprise Manager, RMAN, Data Pump, Export/Import, SQL*Loader, GoldenGate, Multitenant Database, Quest Software (TOAD, Foglight, I/Watch, SQL Expert, Space Manager)

EXPERIENCE SUMMARY

●Over 18 years of industrial experience as an Oracle Database Administrator.

●Oracle Certified Professional DBA since 1999.

●Solid background in database installation, upgradation, migration and cloning.

●Strong expertise in implementing backup & recovery and disaster recovery.

●Significant expertise in database and application tuning.

●Excellent analytical and troubleshooting skills.

●Excellent technical, communication and interpersonal skills.

EMPLOYMENT & EXPERIENCE

Maple Bridge LLC New Providence, NJ

Administrator 05/2018-11/2023

●Self-employed to pursue personal interests for family business.

●Volunteer work for local community and schools.

●Recently extensive re-training for Oracle DBA, RAC and GoldenGate and ready for the Oracle DBA job again.

Citigroup Warren, NJ

Senior Oracle DBA 11/2005-05/2018

●Served as one of the DBAs for Citigroup mission critical Citidirect application used by tens of thousands of clients in more than 100 countries. Managed and maintained the servers to guarantee smooth daily processing with billions of dollars in transaction value.

●Received the highest CTI STAR TEAM reward for excellent support to the Citidirect application.

●Involved in Citidirect database upgrade and migration project. Migrated the 3 nodes RAC Citidirect 15TB databases from 9i to 10G, the first Oracle database to utilize golden gate as the fallback plan in CTI.

●Worked as the primary DBA for Citidirect online and a few other critical Global Transaction Service applications.

●Supported critical foreign exchange financial application, the first 9i RAC database in the Citigroup global market group.

●Installed, configured and maintained the foreign exchange 9i RAC database, provided guidelines for future RAC database implementation within the group.

●Implemented the first Oracle quality control checklist for the whole Citigroup global database management group; The checklist has since been used as a standard by the quality control group.

●Served as the critical member of the first Oracle VTM team which handled oracle VTM patching for thousands of databases in whole CTI.

●Worked as a primary DBA for over 10 critical financial applications in CTO supporting 80+ Oracle databases.

●Received numerous rewards from the application teams for excellent client support.

●Troubleshot a data corruption issue and recovered the data in a timely manner for data warehouse application which helped to avoid the downtime for thousands of users.

●Implemented the first production cross platform database upgrade and migration from AIX to Linux using the transportable tablespace technology for a 10TB business data warehouse production database.

●Upgraded and migrated a few critical financial applications for AIX to Linux using the export and import.

●Restored a historical database for allocation settlement application using the partial database restoration technique under a missing backup files situation, that helped to provide evidence to audit department for a 10 million dollars audit requirement.

●Implemented the most challenging migration within the group by moving a 12TB allocation settlement Oracle database from AIX to OraaS platform using advanced compression and customized scripts.

Ann Taylor Inc New York, NY

Senior Oracle DBA 4/2000 – 11/2005

●Provided all 24/7 DBA support for 70+ Oracle production and development databases.

●Worked as a primary DBA for over 20 critical Oracle production databases.

●Planned and recovered one important table back to one year ago in timely manner for board of directors without a valid on-site database backup.

●Defined a fine plan to secure the dotcom website production database which experiencing data block corruption errors without a good database backup.

●Recovered Oracle databases under various failure situations.

●Troubleshot one CPU spiking problem, reduced the CPU usage of one critical server from close to 100% down to 40%.

●Tuned databases, applications using Statspack, OEM and Quest tools for performance gain.

●Monitored and tuned I/O, memory allocation and contention for better performance.

●Configured and administered Oracle Enterprise Manager for database monitoring and capacity planning.

●Described specific techniques for isolating a problem and defining resolution approach.

●Strong experience of Oracle server installation in Unix and Windows platforms.

●Upgraded/Migrated Oracle databases from v7 to v8i and v8i to v9i and v8 to v10g.

●Implemented disaster recovery systems using Oracle Data Guard/Standby database.

●Implemented high availability solutions for Oracle databases and application server under VERITAS cluster.

●Participated in implementing disaster recovery solution using EMC’s SRDF technology.

●Designed and implemented hot and cold backup and recovery procedures using RMAN.

●Ensured compliance with database license agreement & keep up to date on database products.

●Established security policies and implemented audit to ensure compliance with Sarbanes-Oxley requirements.

●Experience with resolving integration or communications problems in multi-vendor environment.

●Implemented partitioning tables and indexes to improve performance.

●Granted and monitored database accesses and privileges of developers and end-users.

●Provided Oracle DBA support for Oracle financial application version 11 and 11i.

●Applied patches for Oracle financial application version 11 and 11i.

●Installed, configured, and supported Oracle application server, Form server and Report server.

●Resolved major problems including vendor escalation when appropriate, fluently applied escalation and notification procedures for incidents.

●Handled major & high-profile deployments & upgrades.

●Monitored performance of major elements on an on-going and historical basis.

●Working on a POC project for RAC implementation.

●Contributed significantly to the team knowledge bases and originates best practice.

●Worked independently and/or within a team to accomplish job objectives.

●Demonstrated effective and active listening.

●Self-Starter and quick learner with high desire to learn.

●Experience working under pressure and tight schedule.

●Established and maintained effective working relationships.

Hamamatsu Corporation Bridgewater, NJ

Oracle DBA 9/1999 – 4/2000

●Worked as a primary DBA for several production servers, responsibilities include system. configuration, capacity planning, procedures establishment, monitoring and management reporting.

●Installed and configured Oracle server and software on Sun Solaris and Windows NT platforms; configured Client-Server and Server-Server computing environments.

●Created databases and primary objects and allocated system storage, managed users, roles,

resources and database security.

●Migrated both production and development databases from Oracle 7.3.4 to Oracle 8.0.5 using the Migration Utility and Export/Import.

●Built and maintained a data warehouse database from sales data; performed regular data loading and summary tables refreshed; helped the marketing and management staff to obtain real time market information.

●Managed (hot and cold) backups with shell scripts; created shell scripts to automate export

and import.

●Performed complete media recovery and time-based incomplete recovery; refreshed testing/development databases from production databases.

●Managed SQL*Net, connection manager, database links and snapshots (data replication).

●Tuned the Oracle Server based on the Report.txt generated by Utlbstat/Utlestat; tuned the application using Explain Plan, SQL Trace and TKPROF.

●Developed customized SQL scripts (50+) for server monitoring; created Unix shell scripts to automate frequent and routine management tasks.

●Re-designed database physical layout to balance the disk I/O for performance purpose; reorganized tables and indexes to decrease the fragmentation problem.

●Handled locking problem and redistributed hot objects to cold spots to improve performance; wrote PL/SQL code to handle data block corruption problem.

●Created database triggers to performed value-based auditing and managed the audit trail.

●Created Cron job to compress the archive log files and monitor the growth of the archive log directory.

●Performed data conversion from other system to the Oracle database using SQL*Loader.

New Jersey Institute of Technology Newark, NJ

Teaching assistant 1/1999 – 5/1999

●Designed and implemented a Reviewer Selection database application for the IJCAI

(International Joint Conference on Artificial Intelligence) committee; Java was the

implementation language and JDBC was used to connect to an Oracle database.

●Teaching assistant of software engineering course for graduate students.

PROFESSIONAL CERTIFICATIONS & TRAININGS:

Oracle Certified Professional program for DBA -1999

Oracle new feature for administrator 8/8i/9i -2001-2003

Oracle 8i SQL tuning -2002

Oracle Data Warehousing -2003

Unix (Solaris 8) system administrator certification package -2001

Autosys implementation and deployment - 2006

Oracle 10G database administration -2008

Oracle 10G database performance tuning -2010

Oracle 11G database administration -2013

Oracle 12C database administration -2017

Oracle 19C database administration -2023

Oracle 19C RAC database administration -2023

Oracle 19C GoldenGate administration -2023

EDUCATION

M.S., Computer Science, May 1999

New Jersey Institute of Technology, New Jersey

B.E, Engineering, July 1996

Southwest Jiaotong University, Chengdu, China

STATUS:

Citizen of USA

REFERENCES: Upon request

Contact this candidate