Data Oracle

FRU N. NDE

IRS MBI CLEARANCE – ORACLE DBA

202-***-**** *******@*****.***

.

Expertise Overview

Experience

At IRS (Internal Revenue Service) I was part of a team that created a proposal on how to best configure RMAN to perform a variety of automated backup and recovery functions. Our proposal was accepted, and it was implemented with few modifications.

Worked as primary database administrator to perform Data Migration from DB2 to Oracle at the IRS. The task for Data Migration included creating roles, tablespaces, schemas & tables, data from DB2 database extracts are migrated to Oracle 11g using custom shell script code utilizing Oracle SQLLOADER utility. Performed data integrity & quality checks of migrated data, created constraints, indexes, synonyms & triggers, gathered stats to improve performance, coordinated testing efforts by various teams perform similar checks on migrated data. In /DEV/DSIT/SAT/PTE environment, perform similar activities mentioned above across the several lower environments, moved data between environments using data pump export, import.

I have worked in a large scale environments like Jelani consulting with databases ranging from 500gb to 5tb with about 300 databases, in development test and production, with about 10.000 concurrent users, work with oracle 11g version 11.2.0.4 on Linux Redhat enterprise version 6.0 platform.

An accomplished and seasoned professional Oracle Database Administrator with over 8 years’ experience in database security and user management, backup and recovery, Data guard, disaster recovery and management, and database performance tuning in heterogeneous system environments including Oracle SQL DEVELOPER, TOAD, UNIX and LINUX amongst others

Skills

Ability to Monitor different databases and application servers using Oracle Enterprise Manager (OEM) 11g and 12c Grid Control

Ability to Perform performance tuning tasks like generating the AWR ASH report; analysis of ADDM snapshots; and the explain plan to query database issues

Thorough understanding and strong experience in performing physical backup and recovery, cloning of databases using RMAN, Ability to perform logical backups using full/ partial export/import and Data Pump tools.

Ability to learn new technology (Tech Refresh), methodology, and work routines, adapted to produce best result under pressure and detailed oriented solution provider.

Work with Oracle Data Guard in 11g to ensures high availability, data protection, and disaster recovery for enterprise data.

Work on data Guard 11g comprehensive set of services that create, maintain, manage, and monitor one or more standby databases to enable production Oracle databases to survive disasters and data corruptions.

Used Data guard 11g with traditional backup, restoration, and cluster techniques to provide a high level of data protection and data availability.

Work with Oracle Golden Gate 12c provides real-time capture, transformation, routing, and delivery of database transactions across heterogeneous system.

Certifications

Certified Oracle DBA

Education

BSC Environmental sciences 1998, University of Yaoundé, Cameroon,

Diploma Health Information Technology, 2005 Computer career institute at John Hopkins University, Maryland.

Relevant Experience

PURISOLVE, INC September 2016 – Present

DEPARTMENT OF TREASURY.

Internal Revenue Service

Oracle Database Administrator,

Support and Monitor different databases and application servers using Oracle Enterprise Manager (OEM) 11g and 12c Grid Control

Carried out general database administration tasks like creation of users and roles, table spaces; changing and extension of passwords, ensuring database functionality

Worked as part of a team that performed Data guard from switching the production Database from the Secondary site to the Primary site.

I was part of the team that carried out Data Migration from DB2 to Oracle.

In -PRODUCTION, I Created roles, tablespaces, schemas & tables, migrated data from DB2 database extracts to Oracle 11g database via shell script code utilizing Oracle SQLLOADER utility into multiple schemas. Performed data integrity & quality checks of migrated data, created constraints, indexes, synonyms & triggers, gathered stats to improve performance, coordinated testing efforts by various teams performed sanity checks on migrated data. In /DEV/DSIT/SAT/PTE, Performance of similar activities mentioned above for production across the several lower environments, moved data between environments using data pump export, import

Performed physical backup and recovery and clone databases using RMAN.

Carried out logical backups using full/ partial export/import and Data Pump.

Working with App team to execute scripts in various data bases from development, test and production.

Carried out performance tuning tasks like generating the AWR, ASH report; analysis of ADDM snapshots; and the explain plan to query database issues.

Work with Oracle Data Guard in 11g to ensures high availability, data protection, and disaster recovery for enterprise data.

Work on data Guard 11g comprehensive set of services that create, maintain, manage, and monitor one or more standby databases to enable production Oracle databases to survive disasters and data corruptions.

Used Data guard 11g with traditional backup, restoration, and cluster techniques to provide a high level of data protection and data availability.

Work with Oracle Golden Gate 12c provides real-time capture, transformation, routing, and delivery of database transactions across heterogeneous system.

Jelani Consulting, INC. OCT 2012 – SEPT 2016

Oracle database Administrator:

Implemented Oracle 11g ‘s Transparent Database Encryption; created and used the Oracle Wallet using the Oracle Wallet Manager

Enforced database password complexity measures using the Oracle provided script named utlpwdmg.sql (from $oracle_home/rdbms/admin directory) to create password verification function called verify_function_11g.

Performed physical backup and recovery using RMAN; also used RMAN to clone databases.

Carried out logical backups using full/ partial export/import and Data Pump.

Instituted disaster recovery measures to ensure continuity of operations; used Data Guard to create standby databases

Worked on 24 /7 environments, responsible for monitoring, upgrading, configuring, managing and troubling shooting over 300 oracle 10g and 11g databases with sizes from 300g to 5TB.

Performed performance tuning tasks like generating the AWR report; analysis of ADDM snapshots; and the explain plan to query database issues

Two years of experience with extra data @jelani consulting Inc.

Installation and configuration of Oracle RAC (Real Application Server) on different nodes with ASM (automatic storage management)

General database administration tasks like installation of Oracle 11g and 12c; creation of users and roles, table spaces; ensuring database functionality.

Work on data Guard 11g comprehensive set of services that create, maintain, manage, and monitor one or more standby databases to enable production Oracle databases to survive disasters and data corruptions.

Work with Oracle Data Guard in 11g to ensures high availability, data protection, and disaster recovery for enterprise data.

TRENITECH CONSULTING, INC. FEB2009 – OCT 2012

Oracle Database Administrator,

Performed monthly and annual performance reports for trend analysis and capacity planning.

Successfully installed and configured Oracle 11.1.0.7

Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.

Assist in SQL tuning and providing consultation such as creating materialized views, adding indices, dropping unnecessary indices, using hints wherever possible, amongst others.

Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.

Extensively used AWR, ADDM and explain plan for periodic performance tuning.

Implementing Data pump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.

Database monitoring/maintenance, replication process and performance tuning using OEM

Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.

Involved in the installation, configuration and extended support to Oracle 11g, 10g two Node RAC with ASM file system on Sun Solaris platform.

Involved in converting a single instance database to Oracle 11g, 10g RAC databases.

Tender Health care, INC. May 2006 – Feb 2009

Information systems/Medical coding

Extensive knowledge of medical terminology across broad range of medical practice.

Mastered multi-tasking abilities.

Excellent data entry skills.

Strong understanding of ICD -9 –CM, CPT, HCOCS level II guidelines.

Outstanding interpersonal skills and the ability to function as a team member.

Experience with fast-paced medical care environments.

Contact this candidate