Sydney(Zhonghui) Zhang
9710 Ashby Road, Fairfax, VA 22031
[Send email to request phone number] 85-0124; [Send email using form at bottom]
SUMMARY OF QUALIFICATIONS
Certified senior Oracle/Peoplesoft DBA with twelve years of industry experience.
Extensive experience in providing production support on multiple 24x7
Oracle/Peoplesoft production environments as well as Peoplesoft Apps
7.5/8.0/8.4+, PeopleTools 8.4+/8.8 implementation, integration, configuration and
upgrade.
EXPERIENCE
Oracle/peoplesoft DBA
05/2007 - present
Sunrise Senior Living, McLean VA
• Provide on-call production support for Peoplesoft Financial environments. The
duties include performance monitoring, tuning, trouble-shooting, nightly
environment refreshes etc.
• design and implement Oracle 10G Disaster Recovery strategy using Max
Performance Data Guard application
• Extensive experience with Oracle ASM with or without RAC
• Extensive experience with Oracle 10g RAC implementation and tuning
• Extensive experience with using Oracle 10g Grid control to automate database
monitoring, alerts, scheduled jobs, etc
• Extensive experience with RMAN backup, restore, recovery, cloning etc.
• Provide troubleshooting and optimization support on critical financial month
end close processes
Peoplesoft Administrator/Oracle DBA
06/2005 – 03/2007
Sprint/Nextel, Herndon VA
• Provide on-call production support for Peoplesoft Financial/Supply Chain
(AP,PC,GL) and HCM(Payroll, T&L) production environments. This includes proactive
performance monitoring,
tuning, trouble-shooting on all components of Peoplesoft Internet
architecture(PIA):
database, application server, process scheduler, BEA web logic
web server and proxy servers
• Provide Oracle database level troubleshooting, tuning and optimization support
on critical financial/payroll month end close processes.
• Installed and configured Peoplesoft integration broker to facilitate
PeopleSoft integration with
HCM and the third party applications using application messaging, EAI, IBM
Websphere, MQ-series, etc.
• Perform daily environments maintenance tasks such as code migration, Oracle
database clone, environment refreshes etc.
• Maintain scheduled Peoplesoft jobs through Autosys on daily basis
• Experience with Control M on Unix
• Apply and test Peoplesoft bundles, patches, maintenance packs and tax updates
etc. using Change Assistant as well as manual tools.
• Performed Peopletools upgrade from 8.43 to 8.46 using Upgrade Assistant.
• Implement and administrate STAT 5.05 for Financial and HCM application
including workflow and approval process.
Principal Consultant, Senior Oracle/Peoplesoft DBA
08/2003 – 12/2004
Freddie Mac, McLean, VA
As a consultant from Keane, Inc, work as the Senior Oracle/Peoplesoft DBA
• Provided 24x7 on call production support on mission critical Peoplesoft
Financial and HRMS systems in Oracle 9i/8i/8 Sun Solaris environments.
• Provided sole DBA support for successfully upgrade of Financial 7.5 to 8.4.
• Performed extensive proactive database performance tuning and troubleshooting
on multiple production Peoplesoft environments including application, memory,
I/O, cache and OS level tuning etc.
• Responsible for the backup and recovery procedure of the mission critical
databases using SQL BACKTRACK. Performed database Point-In-Time recovery
whenever needed.
• Upgrade client backup software SQL BACKTRACK and develop scripts to cut the
database refresh time by at least 50 percent.
• Refreshed production database environments to QA and DEV and TEST environments
using hot or cold back up methods on the regular basis.
• Performed database upgrade and migration from Oracle 8i to 9i. Apply patches
and fixes when needed.
Senior Oracle/Peoplesoft administrator
12/2000 – 08/2003
Technology Solutions Company, Chicago, IL
For Client Choice Hotels International, worked as the senior Oracle/Peoplesoft
DBA.
• Provided 24x7 Oracle production support on the Peoplesoft Financial and HRMS
systems in UNIX environment.
• Performed substantial performance tuning and troubleshooting on database as
well as UNIX level.
• Set up and responsible for the backup and recovery procedure of the mission
critical databases using RMAN and Legato. Performed database Point-In-Time
recovery whenever it is needed
• Refreshed production environment to the development, QA environment on the
regular basis.
• Upgraded production databases from Oracle 8 to 8i. Apply patches and fixes
when needed.
• Performed Peoplesoft 8 Financial and HR implementation, configuration,
administration and upgrade. Finished complete cycle of setting up Financial and
HR Peoplesoft 8 environments from database creation to application server,
process scheduler, web logic server and PIA configuration.
For Client Intersil, served as the senior Oracle/Peoplesoft DBA.
• Installed and configured Peoplesoft EPM application.
• Performed Financial and HR production People Tools upgrade
• Provided 24x7 production database support
• Refreshed the production environment to the development environments including
database, file system, application server as well as process scheduler refresh,
trouble shoot PIA, application server and process scheduler issues.
• Troubleshoot Peoplesoft 2,3 tier application, including app server, process
scheduler, web logic server, crystal report, SQR report issues when needed.
For Technology Solutions Company
• Provide 24x7 Oracle production support on Peoplesoft Financial, HRMS and
payroll systems
• Provide daily environment support on the internal solution center. Duties
include setting up and maintaining 24 Peoplesoft development environments
(Modules include Financial, Supply Chain, HR, CRM, Repayment, etc), trouble shoot
any database or Peoplesoft application level errors. Applying patches and updates
when needed.
Oracle/SQL Server DBA Consultant
01/99 – 12/00
Continuum Consulting, LLC, Washington, DC
• Performed data modeling on OfficeSpace Online Reservation System (ORS) backend
database using Erwin3.5 and Oracle 8.0
• Provided database performance tuning, monitoring and auditing; application
tuning – using SQL trace, TKPROF, Explain Plan, HINT, and creating/maintaining
stored procedures; Database/System tuning – CPU, memory, and I/O tuning on Oracle
and Unix system.
• Provided database backup and recovery strategy and setting up DBA utilities to
maintain database integrity
• Had extensive experience with Oracle 8.0/8i databases installation,
configuration and administration.
• On SQL Server side, designed, developed and administrated Project Tracking
(PT) database using SQL Server 7.0. Performed performance tuning and backup on PT
on the regular basis.
Oracle Developer/Administrator
11/97 – 01/99
Nutech Computer System Inc, Rockville, MD
• Served as a key member in full life cycle design and development of the
Student Tracking System;
• Developed and upgraded the form, trigger, and application program under
Developer 2000; and administered the STS database, duties includes, but not
limited to, database security, storage and resource management, backup and
recovery, performance tuning, and daily troubleshooting
Oracle Developer /System Analyst
05/95– 07/97
Central Bank of China, Guangdong, China
• Served as a key member in full life cycle design and development of Commercial
Bank Management System using Oracle 6.5 and 7.0. Administrated the CBMS database.
• Compiled PL/SQL, stored procedures scripts as needed. Conducted performance
tuning on SQL statements, add Index, rollback Segments, and performed backup on
weekly basis.
• Performed data mining by converting and combining various legacy data source
include Oracle, Fox Pro, dBASE, Access, Excel
EDUCATION & CERTIFICATION
Oracle 8 DBA Certificate, Oracle Corporation 01/99
MBA in Information Technology Management, American University, Washington DC
05/99
SKILL SET
• Strong skills in Oracle8/8i/9i database performance tuning and
troubleshooting
• Strong skills in UNIX shell scripting
• Strong skills in SQL Server7/2000 database performance tuning
• Extensive experience with Peoplesoft Tuxedo Application Server, Process
scheduler, PIA, Web logic Server, SQR, Crystal Report, etc.
• Extensive experience with implementation, integration and configuration of
Peoplesoft 8 environments as well as Tools upgrade. Modules include
Financial/Supply Chain, HRMS, CRM etc.
Language Skills
Fluent in Mandarin Chinese
REFERENCE
Available upon request
|
