Denny Han

* ****** ****, **********, ** *****

abh2fd@r.postjobfree.com Cell: 973-***-****

SUMMARY

Oracle DBA with experience in client/server and web environment on

Unix/Linux platforms. Capable of applying new methodologies, and

strategies with proven results. Ability to lead projects and work

efficiently with other team members. Strong communication skills with

solid technical and academic background.

TECHNICAL SKILLS

Operating Systems: Linux 32bits/64bits Red Hat 4.0, UNIX (IBM AIX

5.3/6.1, HP 9000-UX, Solaris 10/11 SPARC), HP3000 MPE,

Windows, S/36, AS/400

Database & Networking: Oracle 11g/10g/9i/8i/7x, PeopleSoft

9.1/8.4/7.5/6.0/5.0, Siebel 8.0/7.0, Window NT,

Netware 3.x & 4.x

Programming: PeopleSoft's PeopleTool, Oracle (SQL*Plus,

SQL*Loader, PL/SQL),

SQL, C, Unix/Shell, PowerBuilder, RPG II, RPG/400, OCL, CL

Experience in RAC

Installed, configured and upgraded three-nodes Oracle RAC 11gR2 databases

on Unix/Linux.

RAC with Oracle Grid Infrastructure (Oracle Clusterware+ASM+Virtual IP

(VIP)+ACFS +SCAN listeners).

Configure ASM disks by asmca and SQL commands for hosting RAC

databases.

Applied upgrade patchset to RAC databases, ASM, Clusterware.

Maintained separate RAC database for testing and cloned production

databases.

Experience in High Availability: Data Guard

Implemented a disaster recovery solution for mission critical production

databases. Proficient in setting up physical standby databases with redo

log apply.

Setup Active Data Guard and Snapshot Standby database with Flashback

Recovery function and use Data

Guard Broker to perform swithiver/failover/reinstate/flashback

capabilities

Configured physical standby database for Maximum Availability

protection.

Duplicated database using RMAN cloning from production to UAT servers.

Experience in Data Replication: Stream

Setup Capture, Propagation and Apply processes by using

DBMS_STREAMS_ADM.MAINTAIN_TABLES

Customize Stream by defining rules not to replicate LOB columns or only

replicating the matched subset

criteria, adding Global Rules to exclude certain DDLs like Truncate

Table etc. to be replicated.

Monitor message latency, Keep data in sync by fixing the Logical Change

Record (LCR) and instantiate tables

Using Heartbeat table to ensure Stream function well.

EXPERIENCE

Verizon Wireless, Warrant NJ

09/12- Present

Oracle Database Administrator Consultant

Responsibilities:

POS (Point of Service) system spreads to 4 areas: East,West,South,Mwest

using Shareplex to replicate core

data between 4 areas. Each region has 3 nodes RAC+ ASM with standalone

local /remote DR with ASM.

Configure OEM 12cR2 to deploy agent software, define the rules,

templates, groups, setup alert notification.

Setup Oracle Database Gateway for connecting to MS SQL Server

Install patchset for grid and database to upgrade from 11.2.0.2 to

11.2.0.3

Tuning SQLs by running SQL Tuning Advisor to enable SQL Profile and

using SQL Plan Baselines

Environment: HPUX Itanium 64bit, SPARC Enterprise M5000 Server,

SuperCluster SPARC T5,

Oracle Enterprise Manager Cloud Control 12c, Quest SharePlex Replication

MetLife Insurance Company, Somerset, NJ

08/11- 09/12

Oracle Database Administrator Consultant with PeopleSoft

Production and development support, including install and upgrade

databases, apply patches, load data,

architectural design, shell and PL/SQL programming, create Materialized

Views, create Standby Database with DataGuard, databases

tuning/tkprof/ASH/AWR/ADDM and cloning databases.

Setup RMAN with IBM's TDP 's TSM (Tivoli Storage Manager) to

backup/restore/clone database.

Setup Oracle Internet Directory (OID) and Oracle Name Server with DNS

(Domain Name System) for the

client's database connection. Involving in Disaster Recovery Planning

using Standby database.

Cloning database using EMC's BCV(Business Continuance Volumes), using

Quest's SharePlex to replicate

data, Setup Oracle Stream to replicate tables.

Environment: Oracle 11g/10g, IBM P595 AIX6.1, Quest SharePlex, Tivoli

System's Maestro Workload Scheduler, Tivoli Data Protection (TDP 5.2/2.2

for Oracle ), PeopleTool 8.51/7, SQR, PeopleSoft's Tuxedo Application

Server, PeopleSoft ERP Financial 9.1/8.4/7.5 and HR 9.1/8.16 Application,

BMC's Patrol Monitor Tool, Oracle Enterprise Manager Oracle 11g Grid, EMC

TimeFinder BCV/Snap, EMC Symmetrix SAN Storage.

CBS Broadcasting Inc. (CBS) NYC, NY

08/10- 08/11

Oracle Database Administrator with Oracle E-Business Suite Application

Apply application patches using adadmin and adpatch, clone app tier and

db tier using Rapid Clone I

(adpreclone and adcfgclone)

Bounce app tier and DB tier and Concurrent Manager and Apache Server

Environment: Oracle E-Business Suite R11/R12 (Financial, HR), NetApp

FlexClone, Stratavia's Data Palette for Automation Clone

FISA (Financial Information Service Agent) NYC, NY

11/09- 08/10

Oracle Database Administrator

Support City wide Financial Applications, budget, accounting (On-line

and Report)

support DB2 UDB for z/OS; database native tool (such as SPUFI on DB2

UDB for z/OS),

UPS, Mahwah, NJ 10/07-

11/09

Oracle Database Administrator

Support Customer Relation Management (CRM) SIEBEL for worldwide

locations including: SQL tuning,

setup high availability by using HP ServiceGuard cluster and Oracle Data

Guard, replicate tables by using

Oracle Stream, checking AWR/ADDM/ASH(Active Session History) reports.

MetLife Insurance Company, Somerset/Jersey City, NJ

03/02- 10/07

Oracle DBA consultant with Peoplesoft

Support PeopleSoft Application upgrade on Oracle with Disaster Recovery

Janssen Pharmaceutical (subsidiary of Johnson & Johnson) Titusville, NJ

05/01- 03/02

Oracle Database Administrator

Setup LongView's Khalix Financial Application and Documentum's 4i

Document Management

American International Group (AIG) Data Center, Inc. Livingston, NJ

11/00 - 05/01

Oracle Database Administrator

Setup Ariba Buyer database and Oracle Standby database

DoubleClick.com New York, NY

2/00 - 11/00

Oracle Database Administrator

Support QA and Development environments, including clone databases,

setup RMAN procedures,

backup & recovery, structure changes and tuning.

U.S. Clearing (Fleet Security, Inc) New York, NY

2/99 - 2/00

Oracle Database Administrator

Team member of Data Warehouse to implement data loading, job scheduling

and table partitions.

Build Standby & Clone database. Setup backup/recovery procedure of EBU &

RMAN with Legato Networker.

EDUCATION

Master of Science in Computer Science, New Jersey Institute of Technology,

NJ

Bachelor of Science in Computer Science, Chung Yuan University, Taiwan.

CERTIFICATE

Oracle new feature for Administrator Oracle7 DBA Master Program

Course

BEA's Tuxedo Application Administrator Siebel Server

Administration Ardent DataStage Intro

PeopleSoft's PeopleTool, PeopleCode and Management Tool

PowerBuilder 4.0 CPD and Novell CNE Arbor's Essbase OLAP Application

Contact this candidate