Oracle Manager

BRUCE L. DANG

Anaheim, California *****

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

3962.

www.linkedin.com/in/b

rucedang1

ORACLE APPLICATIONS DATABASE ADMINISTRATOR/CORE ORACLE DBA

* Hands-on Oracle Applications (EBS) solution design, implementation, and

management experience

* Installed, upgraded and configured Oracle eBusiness Suite R11 and R12

* Support and Manage Oracle eBusiness Suite R11 & R12

* Installed and Configured Oracle Grid Control (OEM) system for monitoring

and management

* Installed and Configured Oracle Discoverer 10g

* Support & Manage MS SQL Server Databases

PROFESSIONAL EXPERIENCE:

AMK Consulting Inc., Anaheim, CA

Sr. Oracle DBA 2013 to

Present

* Installed, configured and managed VMWare and Oracle RAC.

* Established UNIX shell scripts for automated cloning, backup,

monitoring, and disaster recovering.

* Installed, and configured Oracle OEM10g Grid Control for databases

monitoring and management.

* Manage and maintain all production and non-production databases,

including performing backups, recovery and validation, as well as

instance management, cloning and patching.

Powerwave Technologies, Santa Ana, CA

2005 to 2013

Sr. Oracle Apps DBA

* Upgraded Oracle databases from version 8i, 9i, 10g to 11GR2.

* Installed and configured shared APPL_TOP for load balancing.

* Installed and configured iSupplier and iCustomer through DMZ to

support external suppliers and customers.

* Installed, and configured Oracle OEM10g Grid Control for databases

monitoring and management.

* Upgraded Discoverer 4.1 to Discoverer 10g.

* Implemented Oracle Applications Brazil and India Localization

* Responsible for all Oracle EBS interfaces.

* Responsible and manage data conversion when merging other company

legacy system.

* Installed and configured Noetix Reporting System on MS SQL Server.

* Installed and configured Quest Foglight and Spotlight for system

monitoring and management.

* Installed, configured, and managed databases for Agile 5.X to 9.X.

* Installed, configured, and managed databases for PeopleSoft.

* Installed, configured and managed VMWare and Oracle RAC.

* Established UNIX shell scripts for automated cloning, backup,

monitoring, and disaster recovering.

* Designed and configured various backup and disaster recovering using

HP and EMC snapshot/snapclone

* Manage and maintain all production and non-production databases,

including performing backups, recovery and validation, as well as

instance management, cloning and patch management.

* Ensure optimal database performance and tuning including with metrics

and statistics reporting.

* Monitor database systems and promptly resolves communication problems

ensuring high database reliability and availability.

* Ensure compliance with all financial and legal obligations in

accordance with Governance and SOX requirements.

* Manage and maintain IT SOX controls and act as point of contact for

audits.

* Work with internal departments and external organizations to make

effective and timely decision in alignment with departmental

direction.

* Work closely with business customers to implement projects including

the development of plans, management of resources and deliverables in

the EBS applications portfolio.

* Oversight of consultants and contractors assigned to projects or

maintenance activities.

* Serve as the primary technical lead responsibility for production

support on 24 x 7 basis for all company databases and Oracle ERP

related systems and responsible for the day to day system support and

project planning and management of technical activities.

* Responsible for database strategy, including standards, design,

maintenance, replication, archiving, access and security, to support

departmental and company needs.

* Perform project management duties in support of database and related

application initiatives including requirements and resource planning,

scheduling and task identification.

* Determine long-range requirements for database sizing, forecasting,

planning and design in conjunction with application team, end users

and senior management..

* Lead IT Change Management meetings and facilitates and coordinates

organizational change activities.

* Routinely audit database systems to ensure compliance with SOX,

established systems policies, standards, configuration guidelines and

security rules as required by the company.

* Ensure proper security procedures and measures are in place and

maintain to prevent unauthorized access to database systems and

related applications Upgraded Oracle Applications 11.5.9, 11.5.10.2 to

R12.1.3.

Emulex Corp., Costa Mesa, CA 01/2001-

03/2005

Sr. Oracle Apps DBA

* Successfully upgraded Oracle Applications 11.5.5 to 11.5.9 with

Autoconfig enabled, RapidClone, Java Workflow Notification Mailer, and

9i database.

* Setup and configured Oracle Internet Procurement, Web Expense, and

Workflow.

* Coordinated and performed Oracle Applications 11i Performance/Stress

Testing on both database and middle tier to determine server resource

allocation.

* Installed and configured Oracle Recovery Manager (RMAN), Oracle

Management Server, Data Gatherer, Oracle Enterprise Manager with

Diagnostic Pack and Tuning Pack.

* Performed Oracle Applications performance tuning for clients,

databases, and concurrent managers using Oracle Enterprise Manager,

Precise Performance Tools, and custom scripts.

* Installed, setup and configured Precise Enterprise Management Tools

(Indepth, Insight, Interpoint, and Pulse modules) for real time and

historical monitoring databases and servers.

* Installed and configured Legato with Oracle RMAN for all backups.

* Created custom request set, concurrent programs, menu,

responsibilities, and Oracle Alerts.

* Established refresh/cloning scripts for Oracle Application Test and

Development environments from Production environment.

* Established UNIX shell scripts for backup, external interfaces and

utilities scripts.

* Installed and configured Oracle databases for Human Resource Personnel

Data System (PDS) application.

* Installed, setup and configured Oracle databases for Agile

application to integrate Engineer Change Order (ECO), Engineer Change

Notice (ECN) and Bill of Material (BOM) with Oracle Applications.

Sr. Oracle Apps DBA Consultant

1998-2001

* Installed and configured Oracle Applications environments with

Financials, Multi-Org, and Web Expense on SUN Solaris and HP-UX

platform.

* Established and performed refresh/cloning Oracle Application Test and

Development environments from Production environment.

* Setup system and user profiles for Oracle Applications, administer

concurrent managers and reports.

* Developed suite of utilities for maintenance of multiple Oracle

Applications environments: environment configuration, initialize

environment, automated databases, Webserver, Form servers and

concurrent managers startup/shutdown process.

* Installed and configured Oracle Recovery Manager (RMAN), Oracle

Management Server, Data Gatherer, Oracle Enterprise Manager with

Diagnostic Pack and Tuning Pack.

* Performed databases performance tuning and monitoring using shell

scripts, Oracle Enterprise Manager Tuning Pack, and Diagnostic Pack.

* Created and tested shell scripts for automated cold and hot backup.

Installed and configured Veritas NetBackup with Oracle RMAN for all

backups.

* Recovered/restored multiple databases from physical disk failure.

These failures include lost of datafiles/system tablespace/control

files/on-line redo logs.

* Administered Discoverer Business Area, End-User-Layer (EUL) and

designed business critical reports using Oracle Discoverer and Oracle

Reports

Clients:

LMKI Inc. Irvine, CA, TheBigStore.com, Newport Beach, CA, Mercury

Technology Group, Irvine, CA

Lantronix, Irvine, CA Yokaha Tire, Fullerton, CA Cal State

Long Beach and Cal State Fullerton

City of Anaheim, CA

EDUCATION AND PROFESSIONAL TRAINING

. Master of Science in Electrical Engineering - California State Long Beach

. Bachelor of Science in Electrical and Computer Engineering (Cum Laude

Graduate) - California Poly Pomona

. Certified Oracle Financials Technical and Functional Foundation

. Certified Oracle 10g RAC

. Certified Oracle System Administration and Application Development

Contact this candidate