Oracle Database Administrator

William Klavuhn

*******.*******@*****.***

951-***-****

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

Overview

One real Oracle DBA veteran who has over fifteen years of focused experience in high end Oracle database administrative area in the Insurance industry. Extensive experiences in Oracle database analysis, 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, configuration, trouble-shooting, and performance tuning. Have impeccable communication and interpersonal skills and an exceptional team player.

Objectives

Oracle Database Administrator (RAC/DataGuard)

Technical Skills

Database

Oracle Database 8i/9i/10g/11g/12c

Language

SQL and PL/SQL, Bash Shell

Hardware

Dell, HP

Data Replication

Oracle DataGuard, Sharepelex

Monitor Tools

Oracle OEM, AWR, Foglight

Experience Summary

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

Over 15 years in Oracle databases (8i/9i/10g/11g/11gR2/12c) as Oracle Database Administrator in IBM AIX, Redhat/CentOS Linux, 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 Linux(X64) environments.

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

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 data replicate middleware in Oracle to Oracle homogeneous environments and heterogeneous environments.

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, Oracle Developer, OEM Grid Control 11g.

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

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

Ebix Inc. Pasadena, CA

Position: Sr. Oracle DBA

01/1996 – 06/2017

Oracle Core DBA using Oracle 11g and 12c. Implementation of Backup, Recovery, Disaster Recovery (Using Physical DataGuard), RMAN, cloning of databases.

Setting up and administering of 10gR2 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, 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.

Linux/Unix kernel performance tuning.

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

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

Provided 24x7 on-call supports for more than 30 mission critical OLTP (RAC) production databases on Linux platforms.

Education Background

DeVry University Pomona, CA

Bachelors of Science in Information Technology

Oracle University Classes recently completed:

Oracle Database 12c R2: Clusterware & RAC Admin Accelerated Ed 2

Oracle Database 12c R2: ASM Administration Ed 2

1994-1995

Contact this candidate