Oracle Data

Ritter Zhang

***** ********** **

Rancho cucamonga, CA 91730

Tel. No: 407-***-****

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

Authorized to work in US (US Green Card Holder)

Overview

One real Oracle DBA veteran who has over eight years of focused experience in high end Oracle database administrative area in various fields like finance, banking and telecom. Extensive experiences in Oracle database design, analysis, modeling, development, administration, implementation, trouble shooting and quality management. Involved with the architect group in designing the logical and physical model of the enterprise level databases. Have long term and solid experience in Oracle RAC, Grid, ASM, DataGuard, GoldenGate installation, configuration, trouble-shooting, and performance tuning. Have impeccable communication and interpersonal skills and an exceptional team player.

Objectives

Oracle Database Administrator (RAC/DataGuard)

Oracle GoldenGate Administrator

Oracle Exadata DMA (Database Machine Administrator)

Technical Skills

Database

Oracle Database 9i/10g/11g/12c, MySQL, Microsoft SQL Server

Language

SQL and PL/SQL, Perl, Korn/Bash Shell

Hardware

Oracle X2/X3/X4/X5 full rack Exadata, IBM PowerPC, X64 servers, Sparc, HP-UX

Data Replication

Oracle GoldenGate

Monitor Tools

Oracle OEM, AWR

Experience Summary

Over 8 years extensive experiences in Information Technology industry, especially in Oracle Database / Unix-like system administration, software design and implementation area.

Over 8 years in Oracle databases (9i/10g/11g/11gR2) as Oracle Database Administrator in Oracle Exadata machine, IBM AIX, Redhat/CentOS Linux, HP-UX, Solaris and Windows.

Solid hands-on experiences in installation, configuration, trouble-shooting, performance tuning in Oracle High Availability technologies, including 10g/11g RAC, ASM, Physical/Active DataGuard on AIX/Linux(X64) environments.

Proficient with Database Cloning, Migration, Standby Database, Data Guard and Patching of Oracle Databases and Oracle Applications.

Experience with Oracle 11g/12c new features: Flash-Back Recovery, Data Pump, ASM, ASH, AWR, ADDM, ASSM, ASMM, Automatic Undo Management, Grid Monitoring and Recycle Bin.

6+ years experiences and solid hands-on experiences in Installation / Configuration / Performance Tuning / Troubleshooting Oracle GoldenGate data replicate middleware in Oracle to Oracle homogeneous environments and heterogeneous environments (including My SQL Server to Oracle).

Proficient in Oracle database backup & recovery strategies plan and implementation such as user-managed backup, RMAN backup with/without catalog, cold and hot backup, full/incremental backup.

Highly skilled in SQL Tuning by using Oracle statistics management, Explain Plan, TK Prof and necessary SQL code rewrite. Expertise in monitoring and performance tuning of Oracle database through tuning application, memory and disk by using Stats pack/AWR/ADDM/SQL Advisor.

Strong work experience with tools like Toad, PL/SQL Developer, Oracle SQL Developer, OEM Grid Control 11g.

Proficient in developing management / monitoring scripts by using Bash Shell and Perl.

Results-Driven with ability to take initiatives and meet deadlines in a fast paced changing environment; Strong analytical and communication skills with the enthusiasm to learn new technologies.

Professional Experiences

Western Union Orlando, FL

Position: Oracle DBA

02/2017 – Present

Oracle Core DBA work on ODS and EDW implementation using Oracle 11g and 12c. Implementation of Backup, Recover, Disaster Recovery (Using Physical DataGuard) and cloning of 50 TB+ database.

Provided 24x7 on-call supports for more than 30 mission critical OLTP (RAC) production databases on Linux and AIX platforms and several huge data warehouse systems with data sizes of 20~40 TB, including one full rack Exadata. Database versions are ranging from 9i,10g, 11gR2 and the most recent version 12c R1.

Setup and configuration of ASM on multiple RAC instances. Setup TDE for data encryption. Setup of OVD to support single sign-on. Migration of EDW database from 11g running on AIX to Exadata Full Rack X5.

Participated in the full life-cycle development process from definition and design to production delivery.

Participated in implementation of various projects for SEC. Wrote custom PL/SQL script to move data from old systems running on Oracle 9i on AIX to Exadata.

Supported multiple phases of the project for both backup and recovery and other core database responsibilities.

Setting up and administering of 11gR2 RAC and Clusterware and Instances. Resolved RAC issues, OCR related issues, rebooting of faulty nodes, relocating the switched over services. Applied patches on Oracle Cluster ware and RAC databases.

Database Services creation for distributing the applications across multiple nodes, extensively used all command line utilities SRVCTL, CRSCTL, ADR, ASMCMD.

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 Stats pack/AWR reports using OEM 12C from Oracle 11g database and analyzed the reports for Oracle wait events, time consuming SQL queries, tablespace growth, 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.

Setting up High Availability Oracle GoldenGate (OGG) systems on Oracle 11gR2 RAC environments.

Effectively decrease OGG lag by using various technical methods such as database tuning, OGG parameter tuning, application large table re-design, Linux/Unix kernel performance tuning.

Upgrade OGG from 10g to 11g. Implement OGG 11g new features in mission-critical production environments.

Trained other DBA's on the team in Oracle RAC, Back/Recovery, Oracle GoldenGate, Performance Tuning and general Database Administration tasks.

24X7 level L3 DBA support for the production systems.

Verizon Wireless Houston, TX

Position: Oracle Database Administrator

08/2015 – 02/2017

Working as a DBA in the Database Support Team to support (daily On-Call rotation) production and non-production environments.

Working with the Information / Data Architect and Database Designer / Modeler to help implement the physical data model to support the mission critical OLTP and OLAP production databases.

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.

Installed, configured the Oracle 10gR2 RAC/ASM production and non-production databases on Redhat Linux X64 boxes to support different applications.

Implementation and support of 10g and 11g migrations and upgrades from Oracle 10g to Oracle 11g databases, including RAC (Real Application Clusters) databases on IBM AIX and Linux X64 box.

Implemented 11g Data Guard Physical and Logical standby using DG Broker, and experienced with 11gR2 Data Guard new features Active Data Guard and Snapshot Standby.

Setup and trouble-shoot the Oracle physical Data Guard for disaster recovery purpose.

Maintenance of production database and development database which includes table space management, user creation, and privileges, roles. support RMAN backup and recovery including physical backups and logical backups by using data pump(Exp/Imp) tool. Extensively developed and maintained Korn shell and Perl scripts..

Implemented Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11g R2.

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.

Daily development / testing environment baseline backup and restore, develop and maintain administration scripts by using Perl/Korn shell.

Performance Tuning and Troubleshooting of custom and vendor apps running on Oracle databases using AWR/ADDM, traces/tkprof, explain plans, profiles.

24X7 On-call support rotation to the production database.

Nationalwide Financial Jacksonville Beach, Florida

Position: Oracle Database Administrator

10/2013 – 07/2015

Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables.

Implements data models and database designs, data access and table maintenance codes; resolves database performance issues, database capacity issues, backups, replication, and other distributed data issues over a highly volume Terabyte Database.

Created Oracle database objects(tables, partition tables, b-tree and bitmap indexes, constraints, views and materialized views), PL/SQL Procedures/Functions/Packages, SQL and Korn shell/Perl Scripts and develop transaction processes based on created objects to support business needs and report needs. Developed UNIX shell scripts to perform a nightly refresh of the test system from Production databases.

Designed, and developed Oracle PL/SQL ETL processes for loading data from internal systems using SQL Loader and External tables. Designed, developed and maintained oracle database schemas, tables, standard views, materialized views, synonyms, unique indexes, non-unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors and other database objects.

Performance tuning and optimize SQLs using explain tables, TKPROF utility, by setting database parameters, by using optimizer hints and using Analyze to compute statistics on tables.

Designed Test Plan and Test Cases according to Functional Requirements and design specifications of the application and executed them with testers. Implemented Unit Testing Stored Procedures, Functions, Packages and Triggers.

HSBC Birmingham, UK

Position: Customer Support Engineer in Database Team

07/2010 – 05/2013

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.

Education Background

University of Birmingham Birmingham, UK

Master of Science in Information Technology

University of International Business and Economics Beijing, China

Bachelor Degree in International business

2008-2010

2001-2005

REFERENCE Available upon request

Contact this candidate