Resume 1

More than six years of Oracle database administration experiences for various kinds of applications such as Peoplesoft in UNIX and NT environments. Over ten years of IT working experiences with a proven background of technical problem solving. A self-motivated, responsible, and reliable team player with a set of very strong technical skills.

• Provided administrative supports for PEOPLESOFT 7.5 and 8 with Oracle running on HP.
• Upgraded the application from 7.5 to 8.0. Provided migrations of SQL and SQR patches.
• Setup SQL trace, PeopleCode trace, and Application Engine trace. Monitored and tuned AppSever performance.
• Identified, resolved, or provided recommendations to other different kinds of the performance problems ranging from Database performance problems to I/O hardware performance problems.
• The tools used mainly are Savant, TKPROF, Explain Plan, and some my own scripts. The tool called SQL Expert from Leccotech for SQL statement tuning was also used.
• Upgraded PeopleTools for Dev, Test, and Production environments.
• Created domains, configured AppServer, setup Process Scheduler, brought up Web Server, updated report repository and changed passwords through Application Design, etc. for PEOPLESOFT 7.5 and 8.
• Provided Oracle database administrative supports for other different applications, NUCLEUS, CONTERPARTY, CONTRACT, and DOCUMENT MANAGEMENT SYSTEM.
• Created new databases and users, setup RMAN backups, Export, and other monitoring scripts.
• Provided 24x7 on call production support.
• Trained a new DBA in our environment.

• Provided Oracle database administrative support to Enron.
• Responsible for Oracle7/8/8i logical and physical databases design, implementation and maintenance on UNIX and NT.
• Installed, upgraded and patched Oracle software. Setup brand new machines including Oracle software installation, Oracle side configuration, third party backup software Legato troubleshoot and backup testing.
• Managed and resolved design issues during development.
• Moved database Schema changes to stage or production.
• Migrated and upgraded databases from version 7 to 8i.
• Developed some Unix Shell scripts to automate database operation and database monitoring.
• Developed or modified some Oracle backup and recovery scripts. Used Oracle backup utility RMAN/EBU to implement Oracle backup and performed a number of times of disaster recovery.
• Implemented database refresh with the hot backup using DUPLICATE or full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
• Performed database tuning using Explain Plan, hints, utlbstat/utlestat, Toad, PowerExplain, and Enterprise Manager.
• Provided on-call production database support.
• Provided primary database support for application database systems such as Siebel CMS, Documentumn, MapInfo MapXtreme Spatial Application, PowerCurve System, Performance Monitoring Control System, etc.
• Tested and documented some Oracle8I new features, such as duplicate database using RMAN from both disk and tape, setup name server.
• Created materialized views.
• Helped developer to install Oracle Client, troubleshoot and establish the connection to Oracle database through ODBC, JDBC.
• Trained a new DBA in our environment.

• Provided administrative support for Peoplesoft as a backup in Unix environment.
• Provided primary administrative support for Oracle7/8/8i databases in UNIX and NT environments.
• Migrated SQL and SQR patches, refreshed development and test databases. Created domains, configured AppServer, setup Process Scheduler, recompiled and relinked COBOL source code, setup 2-tier and 3-tier environments.
• Participated in the design, analysis and implementation for a space shuttle engineering database system.
• Installed, upgraded and patched Oracle software and associated applications.
• Managed and resolved design issues during development stage. Worked closely with developers.
• Moved database Schema changes to stage or production.
• Developed Oracle backup and recovery strategy and scripts.
• Implemented database refresh using full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
• Performed database tuning using Oracle Enterprise Manager, Explain Plan and utlbstat/utlestat.
• Created Unix Shell scripts to automate database operation.

• Created and maintained Oracle7 databases on Unix to store the structural analysis data of different projects for International Space Station.
• Generated reports from the database using PL/SQL and SQL.
• Developed various computer programs to automate the postprocessing of finite element structural analysis using C++.
• Created different Unix Shell scripts to help stress analysis tasks.
• Added more new features to existing analysis software tools.
• Developed MS Excel Macros for different applications.

• Developed a Finite Element code using FORTRAN 77 from the scratch.
• The main function of the code is to predict the structural response during an earthquake.

Oracle Training - Oracle7/8/8i DBA training courses, 1996-2001
Peoplesoft Training PeopleTools I&II, Server Administration,Data Management 2000-2002
Unix Administration Training -Lockheed Martin 1996

Ph.D, Civil Engineering, Lamar University, Beaumont, Texas 1995
MS, Civil Engineering - Lamar University , Beaumont, Texas 1991
BS, Mechanical Engineering - Hohai University, China 1983

PeopleSoft 7.5/8, Oracle8i/8/7, OEM, EBU, RMAN, TOAD, SQL Expert, ERWIN, DBTuner, Savant Diagnosis, Multi Threaded Server, C, C++, UNIX Shell, SQL, PL/SQL, FORTRAN 77, TCP/IP, SQL*Net, Net8, UNIX, Solaris, SunOS, HP-UX 11.0, IBM AIX, EMC, Tivoli ADSM, Windows-NT, 2000.

REFERENCE
Available upon request