Manager Project

Linda Zhang

West Windsor, New Jersey *****

609-***-**** Email:

***********@*******.***

SUMMARY

Certified Oracle Database Administrator with extensive experience in

the design, implementation and support of Information Technology

solutions, Core competencies include Oracle RDBMS Database version from

8, 8i, 9i, to 10g and Oracle Applications from 11.03, 11i to 12.

Recognized and selected by management as troubleshooter to address and

satisfy user issues. Effectively communicates with users at all levels

and resolves issues timely. Self-motivated professional who can work

well independently or as a team member.

SKILLS

-Oracle Applications DBA -IT Controls

-RapidInstall -Sql*Loader -Net8

-Oracle Applications System Admin -SOX Compliance -RapidClone

-TOAD -Export/Import

-Oracle E-Business Suite (EBS/ERP) -Discoverer 9i/10g -AD

utilities -RMAN -Unix Sun Solaris

-OAM (Oracle Application Manager) -OEM/Grid Control -SQL*Plus

-PL/SQL -Linux and Windows

EXPERIENCE

The New Jersey Department of Labor, Professional Service Group,

Trenton, NJ Aug. 2009 - present

A member of Computer Committee to design, develop and test a

database driven website www.mercopsg.net

using Mysql, HTML, and PHP in Apache service.

Avtech Institution of Technology, South Plainfield, NJ

Jan. 2010 - present

Oracle E-Business Suite Financial 11i class

Oracle 11g DBA class

Accounting class

Opnext, Inc., Eatontown, New Jersey

April, 2008 - July

2009

Oracle Applications System Administrator

Lead Oracle Applications System Administrator for a globally

implemented, multilingual, Oracle EBS 11i which services a global

electronics manufacturer of optical lasers.

. Oversee all remote DBA services and liaison between developers/users

and the DBAs

. Regularly use OAM/OEM to help streamline system performance to reduce

downtime

. Project manager for globally implemented Oracle 10g database

upgrade

. Monitored all the EBS system administration activities

including Security Setup, New Concurrent

Programs, Printers, Forms, and Menus

. Handled day-to-day provisioning of user accounts and

responsibilities per established SOX policies

. Realigned Oracle EBS change management processes with general

IT control standards

. Initialed and monitored all user requests and Oracle Support

(Metalink)

. Monitored all user activity with access to critical financial

applications and related data

. Troubleshot and migrate PL/SQL codes an objects to production database

. Proactive monitoring of databases and servers performances and

tablespace, storage usages

. Responsible for managing relationships with both internal and external

IT auditors

. Provided timely and user satisfactory support to global Oracle

community

Garmin International Inc., Olathe, Kansas

Sept.2006-

Feb. 2008

Oracle Applications DBA

Supported Oracle's E-Business Suite 11i with over 20 modules

including Financial, Human Resource, Supply Chain Planning, Demand

Planning, Order Management, Internet Expenses, Mobil Supply Chain

Application, Manufacturing,

I-Payment, Work In Process.

. Monitored system, database and application with multi-node

performance

. Upgraded Oracle Application 9i database to 10gR2, Application

11.5.9 to 11.5.10

. Installed and setup RMAN backup catalog; Implement backup

strategies

. Researched and applied various patches for ERP modules and

databases

. Provided Global Support for US, UK and Taiwan Oracle

Application users

. Troubleshoot issues with Web Server, Web Listener, Forms

Server, Concurrent Manager/Request,

Report Server, Notification Mailer and database.

. Performed Custom Migrations for the Implementation and

Development team

. Supported Applimation/LogicalApps users to automate functional

setups

. Performed instances clone using Rapid Clone

. Installed and setup Software Configuration Manager

. Updated files for Vertex Tax Decision Maker Taxability

Reference

. Supported users and developers for Oracle services, daily

requests and questions

. Monitored and troubleshoot backup and recovery

Magma Concept Consultant, Princeton Junction, New Jersey

Jan. 2006- June 2006

Oracle Applications DBA

. Supported Oracle Application database using AD utilities: Adadmin,

Adpatch, Adctrl and Adrelink.

. As a Financial Administrator, performed followings:

. Setup new user and assigned responsibilities

. Setup user profile

. Managed concurrent processing

. As a Core Database Administrator, performed followings:

. Setup Oracle Enterprise Manager (OEM) to monitor Oracle Database

8/8i/9i

. Participated DataGuard/Standby database setup and configuration

. Involved Logical Database model review and Physical Implementation

Ulogon, San Jose, California

March 2004-March.2005

Oracle Applications DBA

. Upgraded Oracle Application 11.5.7 to 11.5.8.

. Setup Database monitoring including SGA, Datafile, Archive Log,

Database Connectivity, Listener,

Tablespace, Background Process, Oracle Server Process, and Log

file checking.

. Assisted Functional Team members with setting up Flexfield,

Calendar, Currency, Chart of Account, Set of

Books, New Responsibility, Set of Books Profile, and Opening

first period in GL module.

. Monitored Application user, Session, Internal Manager & Concurrent

Manager.

. Participated in Disaster Recovery.

Telcordia Technologies, Piscataway, New Jersey

Jan. 2001- Jan.

2002

Oracle Database Administrator

. Monitored and optimized performance of the databases.

. Backing up and restored production databases..

. Installed/Upgraded Oracle software versions 8.0.6 and 8.1.7 and

related patch sets on a number of servers.

. Configured client/server environment through SQL* Net and Net

8.

. Installed various third party tools to monitor databases.

Lehigh University, Bethlehem, Pennsylvania

June 1996-

Aug.1998

Research Associate

Designed and implemented company-wide manufacturing

information system that provided a cost effective solution

to manufacturing information processing.

Trantech Consultant, Devon, Pennsylvania

May 1994- May

1996

Programmer/System Analyst

Solely responsible for upgrading and maintaining an existing

Database, CHEMPLAN, which is used by worldwide chemical companies

for management decision making and planning? Designed and

implemented an associated software package, CHEMPLAN-EDIT, which is

used to insert, change, and delete information from the CHEMPLAN

database.

EDUCATION

Master of Science in Computer Science, Lehigh University, Bethlehem,

Pennsylvania

Bachelor of Science in Applied Mathematics, University of

Washington, Seattle, Washington

Bachelor of Science in Computer Science, Shanghai University,

Shanghai, China

Certification: Oracle Certified Professional DBA

Bookkeeper

Contact this candidate