Oracle Manager

SHUANG ZHAO

Professional Summary:

. Having *+ years of IT experience in full life cycle business systems with

expertise in Oracle Database Architecture, Administration, Systems

Analysis, Design, Development and Implementation Oracle 9i, 10g and 11g..

. Performance tuning and problem resolution for large data warehouses to

include SQL tuning, OS performance monitoring with Grid, tkprof,

Statspack, AWR, ADDM, SQL Tuning Advisor, vmstat and SQL scripts.

. Have installed and configured Web and Database Servers.

. Have been responsible for Data Integration for Enterprise applications.

. Installed and configured Oracle and Red hat Linux, HP-UX and Sun Solaris

Server operating systems.

. Recommended, implemented, installed and configured Oracle 11G R2

Enterprise database software.

. Expertise in very large Oracle databases of sizes up to 10 TB and

experience in Oracle migration from 10g to 11g.

. Expertise in RMAN and Oracle Backup and Recovery.

. Strong experience in Oracle Data Guard and Golden Gate.

. Audited the activities for data access & security issues for production,

testing and development databases.

. Manage Database Security, password expiration and user account through

Profile.

. Strong knowledge in SQL, PL/SQL programming and debugging and strong

UNIX, Linux Shell scripting experience.

. Diverse background which includes managing DBA's, Network, Windows and

Unix Administrators.

. Strong knowledge of ETL tools, Informatica Powercenter 9.0/8.6/.8.5/.8.1,

Informatica PowerMart, PowerConnect, PowerExchange.

. Strong knowledge in OLTP, OLAP, Data Warehouse, Erwin Modeling, Ralph

Kimball Methodology, Bill Inmon Methodology,Star schema, Snowflake

schema.

. Strong experience in Business Intelligence tools like Business Object

XI/6.5/6.0, and Crystal Reports.

. Client interaction, user training, and hardware

evaluations/recommendations.

. Strong logical and physical data modeling experience.

Education:

Master 's in Electrical Engineering

University of Bridgeport Bridgeport, CT USA

Bachelor 's in Automation & Control System Engineering

Dublin Institute of Technology Dublin, Ireland

Certification:

Oracle Database 11g Certified Associate (OCA) DBA.

Technical Skills:

Elements Details

Primary Skills/ Oracle DBA, Oracle 8i/9i/10g/11gR2, SQL SERVER

RDBMS 2005/2008, DB2

Operating Systems Window 98/95, Red Hat Linux,HP Unix, Sun

Solaris, IBM AIX, CentOS, Vmware Server, Vmware

Workstation

Languages SQL, SQL*PLUS, PL/SQL, Shell scripting, C

Language

Development Tools SQL Developer, Toad, Enterprise Manager

Console, Putty, Secure CRT

ETL Informatica 9.0, Erwin, BI, BO,

Bank of America, Herndon, VA Mar 2012 -

Till date

Sr. Oracle DBA / Consultant

Project Description:

Oracle DBA for multi-TB sized data warehouses supporting the banks mortgage

servicing applications. Responsible for all aspects of support with a

focus on troubleshooting, performance optimization and capacity planning.

Major Activities:

. Installed and Configured Oracle 10g, 11g in Solaris and Linux for Data

Warehouse, and OLTP systems.

. Performed Oracle upgrade from 9i, 10g to 11g.

. Implemented Automatic Storage Management (ASM) and maintained logical

disk groups.

. Performed storage and hardware growth analysis of Oracle servers,

prepared capacity plans and implemented.

. Installed and maintained Oracle 2 nodes Real Application Clusters (RAC)

on Linux systems.

. Configured and maintained RMAN repository catalogs for backup and

recovery.

. Automated RMAN full and incremental backups through Shell scripting.

. Restored and Recovered Oracle production database using RMAN backups.

. Performed tablespace and data file recoveries.

. Configured Oracle Grid Control systems and Enterprise Manager for

database diagnostics and monitoring.

. Configured Oracle Flashback procedures for fast recovery.

. Implemented and maintained large partitioned tables and partitioned

indexes.

. Implemented virtual partitions, interval partitions, system partitions,

and extended composite partitions.

. Reorganized critical applications at the tablespace level and schema

level.

. Implemented datapump Exports/Imports for mission critical schemas.

. Upgraded Oracle servers with Oracle supplied patches.

. Performed Database health check, analyzed and fixed Oracle dictionary

issues and Orphaned objects.

. Managed effectively the SQL Plan management techniques.

. Participated in the complete development cycle including testing,

implementation and production deployment.

. Documented and mentored database administrators and Developers for best

practices.

Environment: Oracle 9i,10g,11g, Sun Sparc 5.10, RHEL 4.5, 5.5, AIX,

DGMGRL, Toad, RMAN, Data Pump, OEM, SAN, Net App, Business Objects 4.0,

Informatica PowerCenter 9.

Fannie Mae, Rseton, VA Nov

2010 - Feb 2012

Sr. Oracle DBA / Consultant

Project Description:

Enterprise Automation is a large decision support system built to support

Enterprise wide project teams for Requirement Management, Defects Tracking,

and Performance Testing for tools like Quality Center, Load runner, and

Business Object Crystal Reports.

Major Activities:

. Installed the Oracle Grid for 11.2.0.2 for RAC databases and maintained

multiple Oracle Databases for Data Warehouse systems.

. Configure Golden Gate on RAC environment to replicate data on non-RAC.

Performance-tuning of Goldengate processes.

. Upgraded 24 development single node as well as RAC databases from

10.2.0.4/10.2.0.5 to 11.2.0.2 with DBUA and manual. Used Cloning for

binary installation to speed up the time.

. Reinstalled components like Oracle XML Database, Oracle Expression

Filter, Oracle Rule Manager, JServer JAVA Virtual Machine, and Oracle

XDK.

. Implemented data encryption (TDE) using Oracle Wallet feature.

. Testing & QA data refresh done with development data on regular basis

with oracle export/import/EXPDP/IMPDP utilities

. Performed & monitored backup strategies & plans using cold-hot, logical

backups, full and incremental backup management using RMAN.

. Worked with developers to optimize SQL queries using Statspack, TKPROF,

Explain Plan & SQL Trace.

. Identified the long-running database queries, refined queries for better

performance, and worked with end-users to implement changes, by reducing

the numbers of calls made through application.

. Employed data modeling concepts to define entity relationships and data

elements in star and snowflakes schema.

. Performed Oracle backup and recovery, and tuning.

. Developed PL/SQL packages, functions, procedures and triggers.

. Tuned applications and Oracle systems.

. Developed database standards for developers.

. Upgraded Oracle Server with Oracle supplied patches.

. Performed database migration from SQL server to Oracle.

. Analyzed, Designed, Created and Maintained Oracle DW and Data Mart

systems.

. Maintained and Managed Quality Center and Clear Quest applications on

Oracle databases.

Environment: Oracle 9i,10g, AIX, Solaris 10, RHEL Linux 3.4, Windows

NT, Crystal Reports/Crystal Enterprise XI R1,R2, HP-Quality Center 9,

Clear Case, Clear Quest.

Horizon Blue Cross Blue Shield, Newark, NJ

Apr 2009 - Oct 2010

Oracle DBA

Project Description:

HBCBS is a leading multi-line healthcare enterprise. The data warehouse

system built to assist decision makers to analyze, share, and distribute

information throughout the enterprise.

Major Activities:

. Created Oracle databases for production, QA and testing purposes on

Optimal Flexible architecture (OFA) manually as well as with DBCA.

. Installed single node & RAC databases supported on ASM with logical unit

number (LUN).

. Applied patches to databases as and when required using OPTACH utility.

. Upgraded Oracle databases from 9.2.0.8 to 10.2.0.1 using DBUA and

installed the Oracle database 11g on various platform.

. Configured Physical Standby Database using DATAGURAD in testing

environment. Used In-house scripts developed for Archive Log Shipping and

synchronizing standby database.

. Monitored, analyzed the database change and memory management trends

using AWR, ADDM, and ASSM.

. Performed & monitored daily hot Backups using NetVeritas in production,

test and development databases. Restored critical data according to

user's request.

. Helped the developers in troubleshooting/resolving the performance

problems by tuning the code.

. Automated various processes by configuring DBMS Jobs and CRON Jobs.

. Maintain/document database administration procedures and errors.

. Involved in the Capacity Planning for databases based the future business

growth requirements.

. Audited the activities for data access & security issues for prodution,

test and development databases.

. Used vendor provided scripts to automate the system administration.

. Provided 24x7 support for production databases.

Environment: Oracle 11g/10g/10gRAC/9i/9iRAC/8i, RMAN, ASM, Data Guard,

Weblogic, WebSphere, Sun Solaris9,IBM AIX Windows 2003, ER win, Net

Veritas, INFOMAN & OVSD

Hewlett Packard, Chicago IL

May 2007-Feb 2009

Oracle DBA,

Major Activities:

. Installation and periodic upgrades of different databases on different

versions UNIX boxes as per Change Management procedures.

. Upgraded the production and testing Oracle databases to 9.2.0.1 from

8.1.7 version using OPTACH & DBUA and installed 10g/11g.

. Configured OEM as well as OMS (Oracle Management Server).

. Configured refresh of development and test/QA databases from production -

planned as well as on-demand using export/import, DATAPUMP utilities,

SQL* Loader and cloning through RMAN.

. Performed & monitored backup strategies and plans - using cold, hot &

logical backups; and full and incremental backup management using RMAN.

. Configured Physical Standby database and periodic transportation of logs

to the Disaster Recovery site with Data Guard through maximum performance

mode.

. Managed user accounts, password management, data security through data

accountability through auditing; and access controls through privileges,

roles and profiles etc

. Monitored memory, CPU utilization, disk utilization (I/O usage),

locks/deadlocks and runtime of queries in Oracle databases.

. Performed database maintenance activities such as De-fragmentation,

rebuilding tables and indexes, adding data files, rollback segments and

respace management.

. Performed tuning for overall database performance, using tools as

Statspack, TKPROF, & Oracle Enterprise Manager (OEM) to properly size the

system global area as well as determine I/O bottlenecks on system.

. Supported the Weblogic /Broad Vision Support Team in the completion of

schedule Run syncs and problem fixes.

. Worked closely with UNIX team for all UNIX related changes in

production/testing environment.

. Manage database security, password expiration and database audit.

. Automate System administration tasks as scripts provided by vendor.

. Designed disaster recovery plans for mission critical systems.

. Participated in design discussions to support project.

. Regularly attended change management & problem management meetings.

. Produced and maintained documentation to controlled standards including

project plans and status reports.

. Maintained the documentation for database administration procedures and

errors.

. Complete 24X7 support for production databases - both master as well as

snapshot sites for online user community.

Environment: Oracle 11gR1/10g/10gRAC/9i/8.1.7.5, RMAN,ASM, Data Guard,SQL

Server2000, Sun Solaris, HP-UNIX, AIX,Windows 2000/2003, WebLogic,

Websphere, ERwin, INFOMAN & OVSD

Kaiser Permanente, Chicago IL June

2005- March 2007

Oracle DBA:

Major Activities:

. Database performance tuning and troubleshooting - latch contention

tuning, hung sessions, research/resolution using ORADEBUG and level 12

traces, troubleshooting dynamic sampling, buffer busy waits, UNDO issues.

. SQL performance tuning and database design recommendations relating to

index usage rules and partition pruning.

. RMAN catalog maintenance and database refreshes using the RMAN

duplicate command.

. Patch installations, upgrades and one-off patch installs.

. Respace creation and maintenance, partition splitting and space usage

monitoring.

. Performed database recovery regarding corrupted affiliates in the UNDO

respace.

. Unix shell scripts to monitor database resource intensive sessions,

respace usage, database growth and Oracle errors. Assisted developers and

Junior DBA's in writing shell scripts for CRON jobs.

. Logon triggers to enable tracing/auditing on specific sessions for

security and monitoring. Also used Log miner to find user commands that

resulted in production downtime.

. Install and configure Oracle Management Server (OMS) for database

monitoring. Set up Oracle Events via OEM for database monitoring.

Environment: Oracle 9i/8i/8.0/ RMAN, HP-UNIX, Windows2000, SQL Server 2000,

Red hat, WebLogic, ER win & OEM

Saber Corp, Salem OR

April 2004- May 2005

Oracle DBA:

Major Activities:

. Enhanced end users' understanding of database systems by conducting pre-

implementation workshops, delivering group and individual training

sessions and creating user-friendly training materials.

. Served as DBA in the completion of 80+ medium- to large-scale

implementations, managing projects from business requirements analysis to

solutions delivery and support.

. Installing, configuring ORACLE Databases.

. Installing and configuring Enterprise Grid Control.

. Applying patches to the databases.

. Configuring High Availability by creating Real Application Cluster (RAC)

by using Oracle Cluster Ready Services (CRS) and Data Guard environments

for disaster recovery.

. Scheduling backups and recover databases on an event of a system crash by

using Recovery Manager (RMAN).

. Implementing and enforcing security for all of the Oracle Databases.

. Performing database re-organizations as required assisting performance

and ensuring maximum uptime of the database.

. Using different views to monitor users and database activities.

Environment: Oracle 9i/8i/8.0/ RMAN, Red Hat Windows2000, SQL Server 2000,

WebLogic, ERwin & OEM

Contact this candidate