Oracle Support

Frank Wang

Email: *********@*****.***

732-***-**** (Cell)

EXPERIENCE SUMMARY:

Have over 16 years of focused experiences in IT industry in various fields

like financial, telecom, and manufacturing. Extensive experience in Oracle

database design, analysis, modeling, development, administration,

implementation, trouble shooting and quality management. Comprehensive

experience as Oracle DBA, especially in Exadata and Oracle Goldengate;

proficient in Oracle 9i/10g/11g/12c software installations, migrations,

database capacity planning, automated backup implementation, performance

tuning on Linux/Unix and Windows platform. Involved with the architect

group in designing the logical and physical model of the enterprise level

databases. Have solid experiences in Linux/Unix administration, Korn shell

/ Perl scripting. Have impeccable communication and interpersonal skills

and an exceptional team player.

CERTIFICATION

. Oracle 10g OCP (Oracle Certified Professionals),

June, 2010

SKILLS PROFILE:

Hardware / Oracle X2/X3/X4 full rack Exadata machine, IBM PowerPC,

Server X64 box

Operating Oracle / Redhat Linux, IBM AIX, HP-UX, Solaris, Windows

System

Languages SQL, PL/SQL, Unix Shell Scripting(Bash/Korn) and Perl,

C/C++, Java, C#

RDBMS Oracle 9i to 12c(RAC/ASM), MS SQL Server 2008, 2008R2,

2012 and 2014.

MySQL and PostgreSQL

Data Oracle GoldenGate 11gR2, 12c

Replication

Tools / Informatica PowerCenter, Quest Toad/Spotlight, ERWin,

Utilities Tivoli, RMAN, Logminer, TKPROF, AWR/ADDM, OEM 12c

Oracle Exadata Experience (3+ years)

. Deep understanding about Exadata specified features such as

Smart Scan, HCC (Hybrid Columnar Compression), Flash Cache, etc.

. First hands-on experiences in software and firmware maintenance

of both the Database and Storage servers in the Exadata database

machine including upgrades and patching.

. Provide and implement performance tuning recommendations of all

components in Exadata database machine.

. Advise, provide guidance and develop Disaster Recovery

strategies for the Exadata Database machine.

. Solid skills to configure Exadata to meet company internal

security requirement.

. Analyze and determine the feasibility of leverage the Oracle

Enterprise Manager solution to report on performance, provide

metrics, and become the centralized proactive maintenance

solution for Exadata distributions.

. Develop and record certified processes/procedures for all

potential IT downstream support groups to maintain and upgrade

the Exadata database machine.

. Integration of Exadata monitoring and escalation into existing

IT monitoring and actionable events solutions.

Oracle GoldenGate Experience (6+ years)

. More than six years experiences and solid hands-on experiences

in Installation / Configuration / Performance Tuning / Trouble

shooting Oracle Goldengate (OGG) in both homogeneous and

heterogeneous environments (including Oracle to Oracle and MS

SQL Server to Oracle).

. Extensive skills to configure and build one-way, tow-way, active-

to-active Oracle Goldengate Extract/Replicat for multiple

databases.

. Strong experiences in configuration and building heartbeat

monitoring in Oracle Goldengate. Develop flexible home-cooked

Korn scripts to monitor the Goldengate lags.

. Configure error handling for Oracle Goldengate restart, logging,

production support and status reporting.

. Hands-on experiences in trouble shooting and performance tuning

Oracle Goldengate replications. Working with Oracle on SRs for

critical issues.

. Primary technical resources to upgrade Oracle Goldengate from

11g to 12c in Exadata machine environment; design Goldengate HA

solutions by using Oracle 11.2.0.4 Clusterware functionality.

Oracle RAC DBA Experience (8+ years)

1. More than 8 years experiences in support large-scale (up to 8

nodes), mission critical production RAC environment from 9i

version to 11gR2 version RAC on deferent platform(including IBM

AIX, Redhat Linux, Sun SPARC Solaris, HP-UX)

2. Deep knowledge of Oracle 11g Grid Infrastructure, Clusterware,

ASM, RAC internal, Active Data Guard in RAC environment.

3. Architecting, planning, designing, developing, deploying and

supporting Oracle 11gR2 RAC/ASM environment.

4. Extensive hands-on experiences in installation & configuration

Oracle Grid Infrastructure & Database Software (Troubleshooting

using cluvfy & handling common issues that arise during

integration of the whole - bugs, network issues, configuration

files issues, OCR issue, deinstallation & cleanup of

clusterware)

5. Testing and benchmarked the application prior to going into

production to determine its effects on GES and GCS with special

focus on load testing for interconnect traffic.

6. Worked with customer for different RAC related issue such as

hang check, split brain, RAC recovery, ASM, OCR corruptions,

Voting disk loss, etc.

7. Backup and Recovery issues related (loss of OCR, Voting Disk and

Oracle clusterware) & also issues with corruption of individual

disk data blocks, loss of OS configuration files, loss of net

configuration files. Also used the Merge backup for backing

terabyte databases. Issues with block change tracking & also

flash recovery area.

8. Solid skills in upgrading 10g R2 RAC to 11g R2 RAC and 11g R2

RAC to 12c R1 RAC.

PROFESSIONAL EXPERIENCE

Client: U.S. Cellular (telecom), Bensenville, IL

May, 2012 ~ Present

US Cellular(USCC) is the fifth-largest wireless telecommunication carrier

in United States with more than 5 million customers. I worked as the

primary DBA in the DB production support team of USCC Data Center in

Bensenville, IL for more than two years.

Role & Responsibility: Sr. Exadata DBA / Oracle Goldengate Specialist

(Consultant)

. Participated in analysis and designing of Oracle Exadata Server for

infrastructure and related projects. Assisted in integration of Exadata

applications into current IT actionable events and solutions.

. Setting up High Availability Oracle GoldenGate (OGG) systems on Oracle

11gR2 RAC environments (Front-end: IBM p770/AIX 6.1, Back-end: Oracle

Exadata X4 Full Rack).

. Upgrade Oracle GoldenGate from 11gR2 to 12c. Implement OGG 12c new

features in mission-critical production environments.

. Troubleshooting typical OGG technical problems such as unique key

violation / long transaction abending by using GGSCI / Logdump / discard

file analysis etc.

. Performance Tuning OGG in extremely high data volume environments.

Installing and configuring OGG heterogeneous environments (from MS SQL

Server to Oracle Exadata).

. Monitor and fully analyze performance issues in production Oracle

databases by using AWR/ADDM/OEM 12c

. Daily development / testing environment baseline backup and restore,

develop and maintain administration scripts by using Perl/Korn shell.

. Installed, configured and maintained Oracle 11g Real Application Cluster

(RAC) / ASM on Redhat Enterprise Linux 6.x boxes.

. Application DBA leader for a large number of tuning projects. Working

with third party developers on SQL code review and quality control.

Performance load testing and tuning application, SQL code, and database

instance by using a wide range of technologies including ADDM, AWR, ASH,

OEM Performance Manager and home-cooked scripts by using Korn

shell/Perl.

. Duplicate all the non-production databases on Exadata server according

the Data Warehouse development project's requirement. Help to compress

large volume partition table by using Oracle HCC (Hybrid Columnar

Compression) techniques.

. Primary technical resources in SQL tuning in Exadata Production and

Performance Testing environments by using statistics, hints, SQL tuning

set etc.

. Software and firmware maintenance of the Exadata storage servers in the

Database machine including routine health check, patching and upgrades

according to the suggestions from Oracle support department.

. Integration of Exadata monitoring into our existing IT monitoring

framework. Provide and implement performance and tuning recommendations

of all components in the Exadata machines.

. Develop and record certified processes/procedures for all potential IT

downstream support group to maintain and upgrade the Exadata servers.

Client: Charles Schwab(financial), Denver, CO

July 2009 ~ April 2012

Charles Schwab is a leading provider of investment services including

online investing, financial advice and banking solutions, and which today

is one of the world's largest discount brokers. I worked here as the Sr.

Oracle DBA consultant to support the development and QA teams.

Role & Responsibility: Sr. Oracle DBA / Consultant

. Supporting more than 20 Oracle 10g/11g development/testing environments

on Solaris/SPARC and Linux/X64 boxes. Help the developers and QAs to do

trouble shooting about database issues.

. Monitor and fully analyze performance issues in production Oracle

databases by using AWR/ADDM, statspack/tkprof tools

. Daily development / testing environment baseline backup and restore,

develop and maintain administration scripts by using Perl/Korn shell.

. Installed, configured and maintained Oracle 11g Real Application Cluster

(RAC) / ASM on Redhat Enterprise Linux 5.x boxes.

. Implemented 11g DataGuard Physical using DG Broker, and experienced with

11gR2 Data Guard new features Active Data Guard and Snapshot Standby.

. Implemented Oracle TDE to provide transparent encryption of stored data

to support submission efforts with release of Oracle 11g R2.

. Partitioned tables Maintenance, adding new partitions, exchanging one

year old partitions then archiving of the exchanged partitions, dropping

or truncating of old portions.

. Analyze data model in the existing databases and validate compatibility

with Oracle GoldenGate (OGG) replicated environment, use OGG to setup

the replicated implementation from MS SQL Server to Oracle 11g.

. Modified database structures including tablespace, tables, views,

triggers, stored procedures as well as configuration and storage

allocation to support application enhancement.

. Oracle database performance testing, monitoring and analysis by using

LoadRunner.

. Developing the main application control utility: spksctl, by using perl,

integrate apache web server into the application, get rid of the old

iPlanet web server.

. General DBA daily jobs such as disk usage monitoring, table/index

rebuild and reorganization as needed.

Management Science Associates, Inc, Pittsburgh, PA

October 2007 ~ July 2009

MSA (Management Science Associates) is one IT service company headquartered

in Pittsburgh, PA with more than 50 years history. Its main business is to

analyze information, develop systems, manufacture data and create IT

infrastructure for customers such as USA Tobacco, Red Bull, Pepsi, to help

inform decision-making, forecast outcomes, and automate workflow and

process. I worked as the Oracle DBA in the IMS department to support the

production databases.

Role & Responsibility: Oracle DBA

. Part of the Data Architecture team which supports development, test and

production databases.

. Worked on RMAN duplication, Cross-platform Transportable Tablespace.

. Implementation and support of 9i and 10g migrations and upgraded from

Oracle 9i to Oracle 10g databases, including RAC (Real Application

Clusters) databases on IBM AIX and Linux.

. Performed oracle Software's Installations, Creation of new standalone

and clustered databases.

. Administering and setting up of 10g RAC and clusterware and instances.

. Resolved RAC issues, OCR related issues, rebooting of faulty nodes,

relocating the switched over services.

. Database Services creation for distributing the applications across

multiple nodes, extensively used all command line utilities SRVCTL,

CRSCTL, ADR, ASMCMD.

. Redefinition of tables using DBMS_REDEFINITION, partitioning the tables

in the production, re-defining the columns data types, and moving the

LOBS to different tablespaces

. Partitioned tables Maintenance, adding new partitions, exchanging one

year old partitions then archiving of the exchanged partitions, dropping

or truncating of old portions.

. Developed RMAN Backup strategies for cloning the test databases with the

production environment and worked on RMAN active-active duplication.

. Scheduled RMAN backups purge jobs, Maintenance Jobs using DBMS_JOBS,

DBMS_SCHEDULER and crontab.

. Handled Chained Rows and Row migration, and solved the database

performance issues.

. Experienced with ASM, adding, deleting disks to the disk group.

. Supported development teams for all the database related issues and

handled the critical issues like network failures and ASM DISK group

errors and node failures in the RAC cluster.

. Generated Statspack/AWR reports using OEM from Oracle 10g database and

analyzed the reports for Oracle wait events, time consuming SQL queries,

tablespace and database growth.

. Used Explain Plan, Oracle hints and creation of new indexes to improve

the performance of SQL statements. Involved in SQL Query tuning and

provided tuning recommendations to Application jobs, time/CPU consuming

queries

. Supported development teams for moving changes to different development,

test levels and prepared documentations to move changes to the live

production environment.

. 24/7 on-call support for the production environment.

Oracle Shanghai Office, Shanghai, P.R. China

Feb., 2003 ~ Dec., 2006

Oracle Shanghai Office is the East China branch of the Oracle China

company. It's main responsibility is to explore the business in East China

region.

Role & Responsibility: Senior Technical Consultant

. Provide POC(proof of concept) and finial technical solutions based on

Oracle's flagship database servers according to customer's

requirements.

. Analyze technical fit of Oracle's products and professional services

against prospects requirements.

. Installed, configured Oracle database production in different complex

customer's environments. Provide initial technical assistance to

customers and prospects, and coordinate customer technical staff and

Oracle's resources.

. Training customers about Oracle's products and in charge of POC(Proof

of Concepts) based on customer's requirements.

. Onsite hands-on performance tuning and trouble-shooting with Oracle

database team and application vendors for Oracle's important

customers.

. Provide technical presentation about application server technology

during Oracle's marketing road show campaign.

China Beijing Mobile Company, Beijing, P.R. China

August, 2000 ~ Dec., 2002

China Mobile Limited is the leading mobile service provider in Mainland

China. the Group boasts the world's largest mobile network and the world's

largest mobile customer base. Beijing Mobile is the TOP 5 wireless

telecommunication carrier in China Mobile Limited Group. I worked here as

the PL/SQL developer at first, then I worked as the Oracle DBA to provide

24X7 technical support of our company's mission-critical Oracle databases.

Position: Oracle DBA

Working as a BOSS System Oracle DBA and handling all the duties and work

assigned to this position efficiently, these duties are as follows: (The OS

platform are most IBM AIX)

. Working with the developing engineers from third-party vendors to setup,

performance tuning and deliver application.

. Set up and maintained oracle disaster recovery site using Data Guard.

. Established database backup/recovery strategy for different databases.

Utilized RMAN for backup and recovery strategy. Completed export and

import of different databases using Oracle Export / Import utilities and

SQL*Loader. Applied different recovery procedures for complete and

incomplete recoveries depending on the type of failure.

. Trouble shooting and resolving any database and/or application issues or

errors that occurred.

. Created an automated, enterprise wide monitoring infrastructure using

several key technologies including Korn shell scripts, Perl. This

allowed our operational DBA team to efficiently gather database

metadata, exceptions, and performance statistics for remote clients

running Oracle using a consolidated Intranet approach.

. Modified database structures including tablespaces, tables, views,

triggers, stored procedures as well as configuration and storage

allocation to support application enhancement.

. Provided on-call support regarding production-related database problems.

Worked with IT managers and application developers to ensure the

database integrity, high availability and security. Provided all kinds

of DBA support to development teams as well as production support to

various applications.

China Beijing Mobile Company, Beijing, P.R. China

Sept., 1998 ~ August 2000

Position: Oracle PL/SQL and C++ Developer of the BOSS Billing System

Working as a PL/SQL and C/C++ programmer and handling all the duties and

work assigned to this position efficiently, these duties are as follows:

. Studied and analyzed the business requirements, designed entity

relationship diagram using Erwin.

. Review the data model and designed database tables as per technical

specifications

. In writing PL/SQL code and debugging for triggers, functions, and

procedures and packages in the Oracle 8i/9i Database on HP-UX platform.

. Developing the C/C++ module on the Tuxedo server side. Involved in

review the code, preparation of Unit Test Plans (required test

scenarios).

. Trouble shooting for the end users requirement and Optimizing the Oracle

database.

. Tuning application using tools like Explain plan, SQL*Trace and TKPROF

for high efficiency.

. Loading data using SQL*Loader (both conventional and direct path

loading) and stored procedures.

. Coordinating and scheduling changes to database based on requirements.

. Responsible for all version control of code and technical documentation.

. Providing support to team member on daily basis.

EDUCATION:

. Master Degree in Computer Science,

09/1995 ~ 07/1998

Tsinghua University, Beijing, P.R. China

. Bachelor Degree in Computer Science,

09/1991 ~ 07/1995

Dalian University of Technology, Dalian, P.R. China

Contact this candidate