Oracle Manager

CHICHI DIKE *******@*****.***

**** **** ***** *****, *******. GA 30302. Cell: 678-***-****

U.S Citizen

OBJECTIVE

I am an Oracle Database administrator, with over seven years experience in

the areas of Capacity Planning, Troubleshooting, Backup and Recovery,

Oracle fine Tuned for peak performance, Implementing Oracle database in a

24x7 environment and High Availability Cluster .

PROFESSIONAL SUMMARY

. Experienced in database patch and upgrade in 8i, 9i, 10g and 11g

. Performed backup planning and implementation through RMAN and Veritas

Net Backup.

. Configuring Data Guard Database and Replications on Distributed

Database environment.

. Experience in Oracle 10G Flashback Queries, Automatic Workload

Repository, Oracle Enterprise Manager, Grid Control, SAN and ASM.

. Creating centralized repository for all database information including

licensing, uptime report and dash board for health check.

. Installation and Configuration of Oracle 10G, 9i, and 11g on

different operating systems for OLTP & Data Warehouse environments for

Very Large Databases (VLDB).

. Excellent knowledge of implementing Real Application Clusters (RAC)

and Data Guard.

. Performed numerous Oracle Database and Tools migration from RDBMS

version 8.x through 10G using Oracle migration workbench and manual

tools.

. Experience within an on-call 24x7 production DBA support,

application/development DBA, system administrator; handled business

service requests.

. Responsible for creating standard database creation scripts,

installation, upgrades, patches, contacting Oracle collaborative

support for critical issues

. Extensive experience in implementing automated jobs using Korn/Bash

shell scripts and Crontab.

SKILLS

. DATABASES: Oracle 7.4/8.0/8i/9i/10g/11g, IBM DB2 9.3, SQL SERVER

2000, 200, 2008

. SOFTWARE: Microsoft Office 2003 and 2007 (Word, Excel, PowerPoint,

Publisher, Visio)

. PROGRAMMING LANGUAGES: SQL,PL/SQL,VB, Shell Scripts - bash, ksh, VB

Scripts, XML, XSLT, SAP SD, Perl Scripts

. DATABASE TOOLS: DB Artisan, Spotlight on Oracle, PLSQL Developer, SQL

Navigator, Erwin, Oracle Enterprise Manager (OEM), Grid Control,

Tivoli Storage Manager, Toad, BMC Patrol, BMC Performance Manager and

BMC SQL-BACKTRACK, SQL Navigator.

. OPERATING SYSTEMS: Sun Solaris 9, 10, Aix 6.1, Red Hat Linux, VMware,

Windows XP/NT/2000, and Vista

PROFESSIONAL EXPERIENCE

MEDai / Elsevier Orlando, FL

APR 2010 - JUNE -2010

PRODUCTION ORACLE DBA - Contract

. Performed database capacity planning for OLTP environments.

. Responsible for using Oracle Grid Control to schedule Jobs and Alert

. Responsible for migrating tablespace from different platforms using

transportable tablespace.

. Ensure all backups are registered with Recovery catalog in Rman.

. Responsible for partitioning larger tables and indexes into various

type of partitioning

. Installed, configured and upgraded Oracle database in UNIX and Linux

Platform.

. Responsible for using oracle Advanced security to Encrypt password

over the network

. Established and maintained sound backup and recovery policies and

procedures

. Performed oracle database upgrade from 10g to 11g in a Linux

environment

. Performed the design of oracle Rac database in a 10g environment.

. Responsible in using Advance security to protect data over the network

. Responsible for making sure that all the Real Application Clusters

(Nodes) are up and running.

. Implemented and maintain database security using privileges, roles and

profiles.

. Performed Database tuning for Application bottle Neck during Peak

hours.

. Maintained database growth and changes by undertaking capacity

planning

. Worked as part of a team that provides 7x24 supports for database

related issues.

. Responsible for monitoring CRS backups in the cluster environment.

. Responsible for monitoring log shipping in Data Guard and making sure

there is no Gap.

GE - GENERAL ELECTRIC Atlanta, GA NOV 2008 - MAR

2010

PRODUCTION DBA SUPPORT - Contract

. Responsible for applying patches and upgrade for different database

versions.

. Monitored and tuned SQL and PL/SQL codes using Explain Plan and AWR

for performance.

. Perform installation and design of Oracle RAC in a Unix and Linux

platform

. Maintain and monitoring Data Guard log shipping from Primary to

standby

. Ability to manage high availability solution centers using Oracle Real

Application Clusters (RAC) .

. Analyzed applications at their database interface points and

troubleshoot performance problems.

. Experienced in using databases features such Data pump, Flash-Back

Recovery, ADDM.

. Designed and implemented logical and physical database architecture

. Cloned databases using RMAN, DBCA and manual copy

. Performed database upgrades and patches

. Performed 80% of production support during On-call duties and split

60% for Production and 50% for development and QA databases during

regular time.

. Managed Production database work order tickets to which assigned in

accordance with the Service Level Agreement (SLA) to ensure all

tickets are processed on time and in track with project schedule.

. Responsible for taking On-call dba duties in 24/7 helping the end

users with oracle support.

. Managed Oracle Real Application Clusters (RAC) using ASM.

. Designed and implemented Oracle Database backup strategy.

. Manage database Refresh using data pump export and import utilities.

. Responsible for converting tablespace from different endian using

Rman convert.

DEPARTMENT OF ENERGY Portland, OR Jan 2008

- Aug 2008

ORACLE DBA- Contract

. Implemented Oracle Data Guard and monitoring log shipping from Primary

to Standby databases.

. Managed databases using Automatic Storage Management (ASM) and SAN.

. Applied software patches to Oracle and SQL SERVER databases.

. Installed, upgraded, patched Oracle 10g on different platforms.

. Performed Backup and Recovery using RMAN and Sql Backtrack for

different backup operations.

. Performs database performance and ensure maximum uptime of the

database.

. Responsible for maintenance, monitoring, tuning, configuring database

object.

. Migrated database from AIX to Linux platform using transportable

tablespace.

. Responsible for managing Change Control Window for Production database

related changes.

. Involved in 24 x 7 supports of Production databases.

PACIFIC SYSTEMS SOLUTION Atlanta, GA MAY 2005

- Dec 2007

ORACLE DBA - full Time

. Managed database security.

. Performed database refreshes.

. Created new Oracle databases.

. Replicated data using materialized views.

. Upgraded Oracle Databases from 8.1.7 to 10.2.0.2.

. Cloned databases from a production instances to development.

. Performed schema objects refreshes.

. Tuned and optimized SQL queries for maximum performance.

. Configured and managed a standby database using Oracle data guard.

. Cloned database from a production instance to development

. Responsible for migration of schemas from QA to production databases

CORE TECH SOLUTION Atlanta, GA MARCH 2003 - APRIL

2005

JUNIOR ORACLE DBA

. Responsible for the Allocation of database space management for future

requirements.

. Created Primary Database Storage Structures and Objects.

. Responsible for creation of Users and setting up environment for User

Application using Power Builder to access the Oracle database.

. Responsible for Backup and Recovery Procedure for the Database.

. Responsible for granting of privileges to users in multiple databases.

. Testing and Moving PL /SQL Codes from Development to Production.

EDUCATION

Bachelor of Arts, University of Nigeria

TECHNICAL EDUCATION

ORACLE Certified Professional for Oracle 8.0, 8i and 9i

ORACLE 10G and 11G - Performance Tuning Course by Oracle University

Contact this candidate