WEIYI CHENG (US Citizen)

**** ****** ******, *** ****, Houston, TX 77074

Phone: 347-***-****

Email: acer1q@r.postjobfree.com

SUMMARY:

Experienced in providing solutions for Database Administration and

architecture. Certified Oracle database and E-Business Suite Application

DBA with over 18 years experience with Oracle, Oracle E-Business Suite,

DB2, Informix, SQL-Server, database design and development of extremely

large Database Systems. Areas of expertise include: Database logical and

physical design, capacity planning and performance tuning, upgrade and

patching, hardware selection, software evaluation, implementation, database

and system programming, network connectivity issues, and full system life

cycle development.

TECHNICAL:

Oracle 12c/11g/10g/9i/8i/8/7, Oracle E-Business Suite (Oracle

Applications/Oracle Financials) R12/11i, Oracle RAC databases on OCFS2,

DNFS and ASM, Oracle Dataguard, OBIEE, Goldengate, Oracle Enterprise

Manager 10g/11g/12c Grid/ Cloud Control, Oracle ADI, Weblogic, SOA Suite,

SQL Server, DB2, Informix, MYSQL, SQL, PL/SQL, TSQL, Developer/2000,

Designer/2000, Oracle Parallel Server, Oracle WebDB, Microsoft Web Server,

Oracle Utilities, RMAN, SQL*Plus, Pro*C, C/C++, Java, ESQL/C, 4GL, ERwin,

Solaris, HP-UX, AIX, Linux, Dynix/ptx, Unix Shell Scripts, Motif, X-

Windows, HTML, Windows NT, VMS, Power Builder, JAM, IBM OS-390/TSO, JCL,

Cobol, PL/1, Perl, CGI, Oracle VM Server, VMware vSphere, VMware

Workstation, VMware Server.

PROFESSIONAL CERTIFICATIONS:

Oracle E-Business Suite R12 Applications Database Administrator Certified

Professional

Oracle E-Business Suite R12 System Administrator Certified Export

Oracle Certified Expert, Oracle Real Application Clusters 11g and Grid

Infrastructure Administrator

Oracle Database 11g Performance Tuning Certified Export

Oracle Database 11g Administrator Certified Professional

Oracle Database 10g Administrator Certified Professional

Oracle9i Certified Professional Database Administrator

Oracle 8i Certified Database Administrator, Oracle Certified Professional

Oracle 8 Certified Database Administrator, Oracle Certified Professional

Oracle 7.3 Certified Database Administrator, Oracle Certified Professional

ITIL Foundation Certificate in IT Service Management

EXPERIENCE:

CBS 12/2005 - 5/2014

Senior/Lead Database Administrator

Responsible for database design, re-engineering, installation, upgrade and

troubleshooting of all Oracle databases. Major accomplishments to date

include:

Installed, configured Oracle 12c/11g/10g/9i Servers, networks and

utilities.

Installed, configured, cloned, and upgraded E-Business Suite (Oracle

Applications) R12/11i.

Installed, configured, cloned Oracle OBIEE for data warehouse database.

Installed, configured Oracle Enterprise Manager 10g/11g/12c Grid/Cloud

Control.

Database architecture design and development.

Database server performance tuning with good knowledge of Oracle internals.

Designed/implemented 24x7 availability of Oracle 10g/11g/12c RAC databases

on OCFS2, DNFS and ASM with heavy transactions under Unix/Linux cluster

servers. Currently using OLTP applications for Web Sites backend databases

Applied Oracle Data guard with Fast-Start Fail Over Configuration between

RAC primary and RAC standby databases.

Designed/implemented High Availability E-Business Suite (Oracle

Applications) R12 Production Instance with 10 nodes configuration, which

includes 4 RAC Database Nodes, 3 Web/Forms Server Nodes, 2 Concurrent

Manager Nodes and 1 Discoverer Server Node for CBS Oracle Insight system

Designed/implemented High Availability Production RAC Databases for CBS

PILAT IBMS system with 4 RAC databases configuration, which includes Fast-

Start Fail Over Data Guard configuration between NY RAC primary and NY RAC

standby databases and Regular data guard configuration for 2 LA RAC

databases.

Upgraded E-Business Suite (Oracle Applications/Oracle Financials) from

version 12.0.4 to 12.1.3

Migrated E-Business Suite (Oracle Applications/Oracle Financials) from

version 11.5.10.2 to 12.0.4

Upgraded E-Business Suite (Oracle Applications/Oracle Financials) from

version 11.5.8 to 11.5.10.2

Upgraded Oracle databases to Oracle10g/11g/12c.

Upgraded/Migrated Oracle RAC Database System from Oracle 10.2 to 11.2/12c

with data guard fast start failover configuration.

Upgraded OEM from Oracle grid control 10g (10.2) to Oracle cloud control

12c (12.1)

E-Business Suite (Oracle applications/Oracle Financials) R12/11i

maintenance (backup and recovery, monitoring, diagnosing and trouble

shooting, patching, modeling, SQL and PL/SQL tuning, deployment, security,

performance tuning)

Designed and implemented database replications.

Capacity planning of databases.

Responsible for database security policies, structures, working plans and

procedures.

Database monitoring and procedures.

Responsible for testing new releases of database.

Implemented database and E-Business Suite on Virtual Machines (Oracle VM

Server, VMware vSphere, VMware Workstation, VMware Server)

Served as troubleshooter for all database related situations.

Supported/Created Production/QA/Development Database environments.

REGISTER.COM 8/2001 - 12/2005

Senior Database Administrator

Responsible for database design, re-engineering, installation and

troubleshooting of all Oracle and SQL-Server databases. Major

accomplishments to date include:

Installed and configured Oracle 10g/9i/8i/8 and SQL-Servers, networks and

utilities.

Installed, configured and cloned E-Business Suite (Oracle Applications)

11i.

Database architecture design and development.

Data modeling using ERWIN. Versed in data modeling for large table and

index. Partitioned table and index.

Worked on stored procedure / trigger programming (PL/SQL and TSQL), code

tuning and code reviewing.

Database server Performance Tuning with good knowledge of Oracle internals.

Worked on 24x7 availability of Oracle 10g/9i/8i/8 terabyte databases with

heavy transactions under Solaris 2.6/8 cluster servers and SQL-Server

databases under NT cluster servers. Currently using OLTP applications

for Web Sites backend databases.

Configured/performed Database Failover from primary database to standby

database for disaster failure.

Database failover from one node to the other node in cluster servers for

primary computer failure.

Designed and implemented Oracle 9i/Oracle10g data warehouse terabyte

database under Solaris 8/64 bits.

Worked on data distribution and consistency across databases.

Upgraded Oracle production databases to Oracle 9i/Oracle10g.

Upgraded E-Business Suite (Oracle Applications).

Oracle applications 11i maintenance (backup and recovery, monitoring,

diagnosing and trouble shooting, patching, modeling, SQL and PL/SQL tuning,

deployment, security, performance tuning)

Designed and implemented database replications.

Created Oracle database backup and recovery plans, and procedures (base on

VXFS and EMC).

Created SQL-Server database backup and recovery plans, and procedures.

Designed and implemented Standby (DR) databases (Oracle and SQL-Server).

Capacity planning of Oracle and SQL-Server databases.

Responsible for database security policies, structures, working plans and

procedures.

Database monitoring and procedures.

Responsible for testing new releases of database.

Served as troubleshooter for all database related situations.

Provided solution of data share between Oracle and SQL-Server.

Supported/Created Production/QA/Development Database environments.

Supported MYSQL database applications.

Programmed with perl and CGI for database monitoring and control.

Managed a group of database administrators.

THEGLOBE.COM 8/98 - 8/2001

Senior Database Administrator

Responsible for database design, re-engineering, installation and

troubleshooting of all Oracle and SQL-Server databases. Major

accomplishments to date include:

Installed and configured Oracle 8i/8/7 and SQL-Servers, networks and

utilities.

Database server Performance Tuning.

Designed and implemented 24x7 availability of Oracle 8i/8/7 databases with

heavy transactions under Solaris 2.6/7/NT and SQL-Server under NT for Web

Sites backend databases.

Database architecture design and development.

Data modeling using ERWIN. Versed in data modeling for large table and

index. Partitioned table and index.

Worked on stored procedure / trigger programming (PL/SQL and TSQL), code

tuning and code reviewing.

Configured/performed Database Failover from primary database to standby

database for disaster failure.

Designed and implemented database replications and standby/read only (DR)

databases.

Worked on data distribution and consistency across databases.

Applications were developed by using C, Unix Shell, SQL*Plus, Oracle

Utilities, PL/SQL, TSQL, Java and HTML.

Capacity planning of databases.

Responsible for database security policies, structures, working plans and

procedures.

Database monitoring and procedures.

Created database backup and recovery plans, and procedures (Veritas VXFS

and RMAN).

Responsible for testing new releases of database.

Upgraded database to current version

Served as troubleshooter for all database related situations.

Migrated SQL-Server database to Oracle database.

Provided solution of data share between Oracle and SQL-Server.

Supported/Created Production/QA/Development Database environments.

Managed a group of database administrators.

AJILON INC. 3/98 - 8/98

Senior/Lead Database Administrator (Consultant at IRS, DC)

Responsible for Year 2000 project of Oracle 8/7 databases.

Installed and configured Oracle databases.

SQL, SQL*Plus, PL/SQL, Data modeling using Designer 2000 and Unix coding.

Reorganized Oracle databases for de-fragmentation.

Responsible for backup and recovery, performance tuning, monitoring and

upgrading.

Worked on oracle parallel servers.

Migrated databases from Informix to Oracle

Managed a group of database administrators.

SOFTWORKS INC. 7/94 - 2/98

Database Administrator

Responsible for database design, re-engineering, installation and

troubleshooting of all Oracle and SQL-Server databases. Major

accomplishments to date include:

Installed and configured Oracle and DB2 servers, utilities and networks.

Database architecture design and development.

Data modeling using ERWIN.

Developed Oracle DBA tools using Pro*C, C++, SQL*Plus,PL/SQL, Oracle

utilities, Developer/2000, Discoverer 2000 and Power Builder under UNIX and

Windows NT environments.

Developed DB2 DBA tools and DB2 applications by using SAS C, JAM, SQL,

MVS/JCL and MVS/TSO/ISPF.

Sizing and database storage management.

Capacity planning of Oracle and DB2 Database systems.

Logical and physical database design.

Tuning developer's SQL statements to speed up processing time.

Created database backup and recovery plans, and procedures.

Developed data warehousing, data conversion and data loading between Oracle

and DB2.

Database/warehouse tool installation and setup.

Served as troubleshooter for all system related situations.

Stored procedure / trigger programming and tuning.

Migrated databases from Informix to Oracle

EDUCATION:

CITY UNIVERSTY OF NEW YORK - LEHMAN COLLEGE

Masters of Science, Computer Science January, 1995

QINGHUA UNIVERSITY

Bachelors of Science, Electrical Engineering February, 1983

REFERENCES FURNISHED UPON REQUEST

Contact this candidate