Henry LI

acxwjo@r.postjobfree.com

EXECUTIVE SUMMARY

Over 20 years IT experience (including development and system engineer)

with 18 years plus core/Apps DBA experience, capable to design the

reliable, scaleable architecture and build the manageable enterprise

technology for a company in the industry.

Expert level experience in Oracle 9i/10g/11gR2 RAC, Data Guard,

EBS11i/R12, OEM Grid Control, RMAN backup/recovery, and Networker.

Expert level experience in Oracle installation, upgrade, large system

architecture designing, capacity planning, consulting, backup/recovery.

Expert level experience in performance tunings on SQL statements, indexes,

network, OS and DB parameters using various tools such as tkprof,

Statspack, SQL trace, AWR, ASH, ADDM, RACCheck, etc.

Knowledge of the best practice in SQL and PL/SQL coding for the

performance.

Experience as a Principal Consultan for Oracle Corp.

Experience as an Oracle DBA instructor in one of Oracle training schools.

Experience in mentoring other DBAs.

Experience in OBIEE, Hyperion, ASCP, Streams, GoldenGate, AS10g/FM11g,

Linux, Solaris, AIX, HP-UX, Shell Script, NetBackup, MySQL and SQL Server.

Strong ability in identifying problems, developing new ideas, and finding

the best solutions.

Experience on 24 by 7 on call for production database support or

maintenances.

Highly self-motivated and detail-oriented individual with excellent

communication and personal skills.

Broad knowledge in related areas such as Linux, Unix, Solaris, AIX, HP-UX,

Suse Linux, Network, TCP/IP, Storage LUNs, Partitioning, Interconnect, Load

balancer, Python, HTML, PHP, and CSS.

EDUCATION: B.A., Computer Science, Queens College of the City University of

New York, 9/1/1987

TRAINING:

AWS Architecture, EMR Big Data on AWS, Teradata, Data Modeling and Database

Design, Oracle7 SQL and PL/SQL, Oracle8 Database Administration, Oracle7

Performance Tuning, Oracle8 Backup and Recovery, Oracle Parallel Server for

IBM RS6000, Oracle Parallel Server Administration, Oracle7 Symmetric

Replication, Oracle8: New Features for Administrators, Peoplesoft

Configuration and Administration, Unix, C, C++, SQR3, PowerBuilder, ALC,

JCL, Cobol

CERTIFICATIONS

Oracle7/8 Certified Professional DBA, 1998

Systems Enginneer, EDS, 12/31/1990

EXPERIENCE

Sr. Database Administrator, Confidential, 2013 to present, Phoenix, AZ

Created Oracle/PostgreSQL/Cassandra NoSQL databases on AWS RDS/EC2 for

Oracle Access Manager upgrade. Created Chef scripts to automate the Oracle

installation and database creation on EC2 servers.

Performed Oracle 11g RAC and Dataguard installation and configuration for

Informatica repository databases on Linux multiple times including RQA and

production environments. Performed hardening on Oracle databases based on

the PCI compliance requirements.

Uesed the dbms_redefintion tool to redefine column data types on multiple

very large tables in the data warehouse with almost no outage.

Used partition exchange to moved old data from very large tables to

archive tables with almost no downtime.

Performed upgrade from 11.2.0.3 to 11.2.0.4 on multiple cluster

environments.

Provided the DBA supports for the Data Warehouse migration to Teradata

14.10 database. Set up the DEV/QA/Production database environments the

project team. Worked with Teradata consultants and off-shore consultants to

resolve various issues during migration.

Implemented the backup strategy using RMAN and Networker. Scheduled the

backup to tape and monitored the daily backup jobs including incremental

and archivelog backups.

Provided the DBA supports for the Reservation System migration/upgrade.

Worked with the vendor on various issues during and after migration.

Resynchronized the standby database in production using the Rman backup

when the standby was out of sync with the primary due to lost of

archivelogs caused by the server reboot.

After the QA database was corrupted, with RMAN, rebuilt the entire QA RAC

and Data Guard environment with two nodes on the primary site and two nodes

on the standby site.

Applied PSU in rolling fashion in the RAC and Data Guard environments.

Created the document for operation and maintenance. Performed the standby

switchover test.

Configured the Goldengate extracts/datapumps/replcats for oneway

replication.

Installed/Upgraded OEM repository/OMS/agents to 12.1.0.5 and configured OEM

to monitor hundreds of production databases and send alerts to DBA team,

Operation personnels and business owners. Also installed Goldengate plugin

and configured the new OEM to monitor the Goldengate processes using

jagent. Investigated and troubleshot various issues and performed the root

cause analysis and provided solutions to fix various issues. Performed

various tunings for performanance issues.

Provided the database security related reports to the Compliance department

and remediated various security concerns based on the compliance

requirements.

Cloned production database from RAC to single instance on the AIX stage

server, then the single instance was cloned to the QA in RAC configuration.

As a DBA SME, reviewed and approved various database change requests/tasks

including the design details documentations, database modifications, and

database access, etc.

Sr. Oracle Apps DBA/DBA Lead, Murad Inc., El Segundo, CA, April2008 to Feb

2013

Installed and configured the Oracle 11gR2 database in the RAC environment.

Configured kernel parameters, NTP, and hangcheck-timer kernel module;

installed required rpms and ASMlib 2.0 on Redhat Linux 5.3. Configured SSH

and enabled SSH user equivalency. Worked with the System Administrator to

configure the private, public, and virtual IP addresses for RAC. Installed

the Cluster Verify Utility, Oracle Grid Infrastructure (clusterware) 11.2.0

and the Oracle Database 11.2.0. Created LUN partitions and ASM diskgroups

on EMC CX3-40. Also installed the patchset update PSU 11.2.0.1.2 on the top

of 11gR2 Grid Infrastracture (clusterware) and RAC installation on all

nodes. Installed Cluster Health Monitor (IPD/OS).

Deconfigured, deinstalled, cleaned up and rebuilt the clusterware on the

crashed node and added the node back to the cluster.

Designed and implemented the backup/recovery strategy and configured RMAN

with EMC Networker and tested backup/recovery scenarios by restoring or

duplicating from hotbackup without target and catalog connection or

duplicating from active database. Performed logic backup using Data Pump.

Configured the Data Guard and created the standby database using RMAN

duplicate from active instance. Tested switchover and failover procedures

in both SQL*Plus and the Data Guard Broker command line. Reinstated the

failed primary database using the flashback database feature.

Installed, setup, monitored, and troubleshot the GoldenGate for the bi-

directional (active-to-active) replication. From primary to secondary, on

primary, created extract/traillog group, datapump (extact, extsrc),

extrail, rmttrail; on seconday site, create replicat group. From secondary

to primary, on primary, created EXTRACT group, datapump, remote trail; on

primary, created the replicat group. Used Conflict Detect and Resolution

(CDR) to resolved uniqueness conflicts occurred during insert and update

replication, update conflicts and delete conflicts such as no data found.

Also configured the parameter files including getbeforecols, comparecols,

resolvecols, reperror, etc, for conflicts resolution and various errors

hundlings. Troubleshot and resolved various errors.

Installed and configured OEM Grid Control master agent using Oracle 11g

repository and client agents on multiple nodes.

Upgraded the RDBMS from 10.2.0.2 to 11.2.0.1 and applied patchset

11.2.0.1.2 and other required or recommended patches. Migrated and

converted the database characterset from US7ASCII to AL32UTF8.

As required by the PCI compliance, created the wallet and configured the

Transparent Data Encryption (TDE). Also configured Database vault and

enabled the audit option.

Monitored the performance and generated AWR, ADDM and ASH (Top Cluster

events and Top remote instance waits) reports for perfomance tunings.

Reviewd RACCheck report and configured hugepage. Monitored the

interconnection bandwidth utilization such as RX, TX and packets errors,

dropped, overrun, collisions, interrupts and worked with SA to fix various

interconnect issues. Reviewed AWR report for high Global Cache Block Access

Latency and tuned UDP.

Tuned various SQL statements to reduce the high I/O waits by creating

missed indexes or function based indexes; increased initrans on few tables

and indexes to reduce the block contention for ITL (Interested Transaction

List); tuned SGA size to minimize the number of connection timeout

occurance; increased log_simultaneous_copies value to lower redo copy latch

waits.

Provided DBA support on both Oracle Applications 11i/R12 production (multi

TB) and development environments running on Red Hat Linux, including

cloning, patching, backup, tuning, troubleshoot, etc.

Installed/configured Fusion Middleware/Weblogic/OBIEE11g/SOA/IDM, Hyperion,

OBI Apps, DAC server repository, Informatica server/client.

Installed/configured Oracle NoSQL database, MySQL 5.5, MySQL Cluseter 7.2,

MySQL Workbench, MySQL Enterprise Backup/Monitor

Provided support on the whole life cycle of Oracle E-Business R12

implementaion. Installed Oracle Appplications EBS Release 12.1.1. Applied

HRMS HRglobal patches and performed other post installation configuration.

Analyzed the requirements for RUP2 and Oracle Financial Critical Patch

Collections (CPC). Upgraded R12.1.1 to R12.1.2 by applying RUP2 patchset

then to 12.1.3 laterly. Also upgraded the database from 11.1.0.7 to

11.2.0.1. Cloned R12 instances from development to test then to production

and vice verse using RapidClone utility (adpreclone.pl, adcfgclone.pl).

Configured R12 Workflow notification mailer. Defined printer styles, types,

and Pasta definition various profiles. Configured the mobile WMS (Warehouse

Management System) and various printers using the PASTA.

Sr. Oracle DBA/DBA Lead, Raytheon, Fullerton, CA, Mar 2007 to Apr2008,

Contract

Designed the highly available and scalable the architecture with the Oracle

Real Application Cluster, Data Guard, Grid Control, and Streams

technologies included. The architecture will support 24 by 7 availability

with maximum 59 minutes down time per year and one thousand DMLs per second

and 42 TB data on EMC CX-380. Researched, evaluated, and recommened the

hardware, software, and storage technologies, performance, and capacity

required to support the architecture. Also performed the benchmark test on

Emc CX-380 and Sun Storage 6540.

Installed and configured the RAC environment on Sun Solaris. Installed

Oracle 10.2.0.1, the patchset 10.2.0.3, the Cluster Verify Utility, Oracle

Clusterware 10.2.0.1 and the patchset 10.2.0.3. Created the ASM and cluster

database instances using DBCA and created TNS listener using NETCA.

Configured the Transparent Application Failover (TAF) and both client-side

and server-side Connection Load Balance (CLB) in tnsnames.ora. Using the

DBMS-SERVICE package, configured the RAC to use the Load Balancing Advisory

(LBA) to determine how to balance new connections based on information in

the SERVICE_METRIC's event (SME) and other FAN events.

Installed and configured the Oracle Enterprise Manager Grid Control and its

agents on multiple nodes.

Configured the Data Guard in Maximum Availability mode, enabled Flashback

feature on both the production and the target standby databases, enabled

the Data Guard Broker configuration, configured Redo Transport Services in

LGWR SYNC mode, and configured the Fast-start Failover Observer and enabled

the Fast-start Failover.

Configured, tested, monitored, and tuned Streams replication in the

multiple source and multiple target environment. Turned on the supplemental

logging on both db and table levels. Created db links, StreamsAdmin and

granted privileges. Created the queue tables, AnyDataQueue, rules and rule

sets tapply process, capture process, and propagation process. Manually

instantiated objects and started/stopped capture, propagate, and apply

process for testing and troubleshooting. Packages used are dbms_rule_adm,

dbms_streams_adm, dbms_adadm, dbms_capture_adm, dbms_propagation_adm, and

dbms_apply_adm. Troublshot and fixed various issues related to capture,

propagation, apply, network, truncate, DDL, etc. Also configured the

replication from Oracle to SQL Server using Microsoft's Oracle Publisher.

Sr. Oracle DBA, AMC, Orange, CA, OCT 2006 to Mar 2007

Provided the DBA support on the production and QA databases in the Oracle

10g RAC and Data Guard environment.

Tuned the SQL statements and tested various tuning options and improved

performance 300% better for few reports utilizing AWR (Automatic Workload

Repository) snapshots, ASH (Active Session History) report, and ADDM

(Automatic Database Diagnostic Monitor).

Designed and tested backup strategy using the RMAN and Netbackup.

Providing the DBA support for the application teams throughout the

development cycle.

Troubleshoot various issues such as performance related issues,

connectivity issues, space management issues, report job failure issues,

etc.

Refreshed the test and QA databases using data pump utilities.

Sr. Support Engineer, Quest Software, Aliso Viejo, CA, OCT 2005 to Sep2006

Installed Shareplex 5.1.0 and patches on Solaris, HP-UX, and Linux. Set up

and tested various replication configurations and features such as one way,

multiple targets, peer to peer, horizontal and vertical partitioning,

intermediate replication using named queue, multi-thread post, etc.

Worked with clients to resolve various Shareplex issues related to library

errors, slow capture or post performance, log wrap, export or impor idle,

core dump, queue corruption, compare hanging, reconcile hanging, out of

sync between source and target, configuration, network connection error,

and Oracle database related issue such as full table scan, index problem,

privilege problem, slow performance such as inittrans contention, etc.

Sr. Oracle DBA, Toyota Financial Services, Torrance, CA, October 3rd 2004

to Oct 7th 2005, Contract

Providing the database support for five application teams throughout the

development cycle and production databases in Oracle9i and Oracle10g

environment.

Installed, configured Oracle10g software and upgraded databases from

Oracle9i to Oracle10g.

Designed and tested backup strategy using the RMAN and Netbackup.

Designed, created, and maintaining the logic and physical database models

using ErWin 4.0.

Tuning the SQL code and tested various tuning options. Created the bitmap

index and partitions by list and improved performance for few major reports

from few minutes to few seconds in a large data warehouse database.

As a team member, worked with the migration team to migrate the databases

from one data center to the new data center.

Sr. Oracle DBA, New York City Government, New York, Feb 2003 to Apr 2004,

Contract

Provided DBA support on Oracle Applications 11.5.7 (HR, FIN) production

running on Sun Solaris and development support on development and QA

databases.

Installed and configured Oracle 9.2.0.1.0 multiple times on multiple Sun

Solaris machines. Created more than fifteen databases and Auto Undo

Management for rollback segments. Created locally managed tablespaces with

segment space management auto option. Created spfile from pfile. Also

installed the Oracle Patchset 9.2.0.4 on top of each Oracle9i binaries and

upgraded all Oracle9i databases to 9.2.0.4 release.

Migrated multiple Oracle8i databases to Oracle9i release. Converted

database characterset from US7ASCII to WE8MSWIN1252 then to multiple-byte

characterset AT32UTF8. Configured and tested automatical database startup

and stop. Created multiple listeners on the development machine.

Improved performance by tuning session_cashed_cursors, log_buffer,

checkpoint, redo logs. Eliminated Checkpoint Not Complete message.

Minimized I/O contention on redo log activity.

Sr. Oracle Apps DBA, ON Semiconductor, Phoenix, AZ, June 2002 to Sep 2002 -

Contract

Analyzed and documented all requirements and impacts for Oracle Apps 11i

upgrade from 11.5.1 to 11.5.6 (FIN, HR, INV, Order Management, inventory

management, iMarketing, iPayment, iStore; Manufacturing) in a three-tier

(multi-node middle-tier) Solaris environment. Before upgrading the

production, cloned the production and tested the upgrade procedure three

times in the testing environment.

Recreated the digital certificate files adsign.txt using adjkey. Repackaged

Jinitiator using adjbuild.sh.

Regularly purged Concurrent Request and Manager data, Obsolete Workflow

Runtime data and Signon Audit data.

1 Sr. Oracle DBA/Lead, Princeton eCom, Princeton, NJ, Dec. 2000 to Feb.

2002

Managed the DBA team to supported on 24 by 7 mission-critical production

databases (the largest one is around 1 TB), which provided thousands of

internet and IVR users for the online billing services

Performed the capacity planning and designed the file layouts. Designed the

new database architecture that is two-dimensional and modulated by the

vertical industry and horizontal services.

Designed the VLDB data warehouse open architecture and models for one of

client companies. The architecture could be scaled up to 131 TB data

capacity using the Oracle9i Real Application Cluster (RAC) technology in a

four E4500 cluster configuration.

Designed and implemented the backup/recovery strategy using RMAN and

Netbackup tools to improve reliability, manageability, and scalability on

the backup/recovery and ensure the business continuity services.

Sr. Oracle DBA/Lead, Bigfoot Interactive, New York City, NY, Sept. 1999 to

Nov. 2000

Managed a multi-million dollar project which involves migration of all

production databases from Microsoft SQL Server on Windows NT to Oracle

8.1.5 on Sun Solaris 2.6.

Performed research, analysis, evaluation on hardware, software requirements

in order to build a system environment with high reliability, availability,

manageability, and scalability. Evaluated and hired the consulting services

and brought in the advanced technology such as Veritas Clustered Servers

and Quick I/O file system.

Worked with consultants to install and configure Sun Solaris 2.6, disk RAID

0+1, Veritas Clustered Servers, Quick I/O file system, DLT tape library,

Netbackup, SQL Backtrack.

Sr. Database Administrator, HIP Company, New York City, NY, 1998 to August

1999

Provided both Oracle and Peoplesoft support to more than a hundred users in

multiple locations. The support activities including installation of

Oracle7 and Oracle8 Servers on Windows NT platform and Peoplesoft software

on client users' PCs, refreshing development and test databases from

production, monitoring and performance tuning, troubleshooting, backup and

recovery, startup and shutdown of Peoplesoft AppServs and process

schedulers, data conversion from Sybase to Oracle using Crystal Report and

Data Junction and

SQL*Loader.

Principal Consultant, Oracle Corporation, New York City, NY, August 1997 to

October 1998

Provided DBA support for SAP application in both production and development

environments for one of fortune 500 clients.

Designed the enterprise architecture for one of the largest insurance

companies to integrate systems on various platforms (IMS/DB2/Lotus Notes on

IBM mainframe/AIX, Oracle on Solaris, Access on NT) from 23 international

branches. The integrated system can eliminate data redundancy, streamline

the workflow, enhance reporting and analysis capabilities, increase

efficiencies in distributing bonding products internationally to agents and

clients by providing a single input, output, and query data source of

information on account, agent, claim, underwriting, reinsurance, contract,

transaction, job, activity and premium by branch.

Database Administrator, AT&T, Lincroft, New Jersey, 1996 to 1997 - Contract

As a development DBA, provided the DBA support to the development and QA

teams including debug of the stored procedures and packages, application

tuning, data modeling, reverse engineering, logical and physical backup and

recovery, etc. Upgraded Oracle Servers and existing databases to Version

7.2 on HP-UX 9.04 Unix machines and to Version 7.3 on HP-UX 10.20 Unix

machines.

Oracle Database Administrator and Developer, NDB Brokerage, New York City,

NY, 1993 to 1996

Installed and configured Oracle 7.2 Server, SQL*NET 2.2, ODBC, Oracle

client software, and the data modeling tool Designer 2000 in Windows NT.

Designed the logical and physical database model for the Oracle application

using Oracle Designer2000. Created the database, multiple instances,

tablespaces, segments, procedures, tables, indexes, roles, and users on the

Oracle 7.

Systems Engineer, EDS, Bedminster, New Jersey, 1989 to 1993

Developed and maintained the Agency Information System used to process

millions of records in the DB2 database which contains 2 years of

statistical data collected from about 21,000 Western Union Money Transfer

Agencies all over the World.

HARDWARE AND SOFTWARE

HP9000, Sun E4500/6500, SP/2, IBM RS6000, disk arrays, tape library, IBM

mainframe, Bridge, Routers, EMC Symetrix, EMC Clariion CS450, MS Windows,

etc.

Oracle7/8/8i/9i/10g/11g, RAC, Data Guard, OEM Grid Control, OBIEE, Streams

replication, Shareplex, Advanced Replication, Oracle Applications

10.7/11/11i, Oracle Application Server 10g, SQL, PL/SQL, SQL*Loader, RMAN,

exp/imp, MS SQL Server, HP-UX, AIX, Solaris 2.6, Linux, VCS, Veritas

Netbackup, SQL*Net, Korn shell, Apache, etc.

6

Contact this candidate