ROSINE ESAMBE

ORACLE DATABASE ADMINISTRATOR

acsvij@r.postjobfree.com 240-***-****

Summary

An Oracle DBA with around 4 years of IT experience in Oracle (11gR2, 10gR2) 11gRAC, 10gRAC, installation, upgrade, designing, backup, recovery, migration, performance tuning, streams, data guard etc. in a variety of environments like UNIX (Solaris, HP-UX, AIX), LINUX & Windows NT 4.0/2000/2003 in production, test as well as development databases.

Technical Skills

Databases

Oracle 9i, 10g, 11g

Database Tools

Oracle (Oracle Enterprise Manager, SQL*Plus, SQL Loader, DB Configuration Assistant) Toad, OEM Grid, RMAN, SQL*Loader, Exp/Imp/Data Pump, Log miner, Statspack/AWR, Shareplex Top, DBCA, DBUA, ADDM, Oracle Migration Workbench, ERwin, QDesigner, Remedy

Operating Systems

MS Windows, UNIX (Solaris 8/9/10, AIX, HP-UX), LINUX

Hardware

Sun Fire 15K, Sun 6320 Storage, Sun Enterprise Servers 890/880/420/450, Sun StorEdge 6320, Hitachi, EMC, Dell Servers, Compaq Servers 6000/3000/1600/800, HP/UX-9000, Red Hat Linux 6.2

Remote Tools

Cisco VPN, Checkpoint VPN, Remote Admin, VNC, Remote Desktop

Experience Summary

Involved in each phase of life cycle (SDLC) including requirement gathering, technical design, development, system integration phase, quality Assurance phase, development and production support activities.

In-depth knowledge and understanding of Oracle Database features such as RMAN for backup and recovery, Materialized Views, Export/Import, Data Pump and Data Guard. Working knowledge of Auditing and Database Security.

Experienced in using Oracle's Transportable Tablespace (TTS) to migrate Tablespace across Oracle databases.

Monitor and maintain system security and Auditing. Experienced in executing SOX related auditing controls.

Full responsibility and expertise in database administration (DBA), performance tuning, database backup, database recovery, database security, database optimization, data migration of Oracle instances and SQL-server databases.

Successfully developed and implemented Client/Server applications on multiple platforms. Actively involved in software development, implementation, software maintenance, software support, troubleshooting, documentation, and training.

Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.

Acquainted in designing and implementing PL/SQL stored procedures, functions, packages, triggers and SQL for automating daily administration tasks

Performed FLASHBACK features to handle efficient database recovery.

Qualified at writing SHELL Scripts and using CRONTAB for automatic backups.

Adept at installation of OEM Database Control, OEM grid control and Deploying Agents

Having hands on experience in Hot/Cold Backup, Recovery of databases using RMAN with VERITAS Net Backup.

Hands on experience in Performance Tuning and Memory (SGA) Tuning by identifying top Sqls/Sessions and Tuning.

Gathered database/Objects statistics using DBMS_UTILITY, DBMS_STATS packages and ANALYZE command.

Scheduling and Troubleshooting Database performance issues using Statspack, Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).

Efficient in SQL query Optimization using Explain plan, Auto trace, TKPROF, Gathering statistics, pinning objects.

Excellent knowledge in Flashback Recovery, Hot/Cold Backup and Cloning/Refresh of databases using RMAN. Experience in applying patches/ patch sets to the databases.

Extensively worked on Import/Export and Data Pump Import/Export tools.

Experienced in loading data from flat files using SQL Loader and External Tables.

Knowledge on Oracle Support processes for technical requests through Meta link.

Monitoring & Reorganizing Tablespaces/Tables/Indexes.

Skilled in using tools such as SQL Developer and TOAD.

Replication (snapshots/materialized views)

Bulk loads and data migrations (using SQL*Loader, data pump import/export)

Unix shell scripting (Korn shell) and Windows command prompt (.bat & .cmd)

Expert in RMAN backups including full, incremental and cumulative.

Professional Experience

NATIONWIDE INSURANCE COMPANY, JULY 2015 - PRESENT

Columbus, OH.

Role: ORACLE AES Application Support Engineer/ DBA

. Create and maintain all application owned database schema objects. Provide immediate response to any

Database availability or performance issue.

. Ensure comprehensive backup and recovery strategy that allows database to recover from every

conceivable system, application, or user risk.

. Provide proactive monitoring of database availability and overall health and performance of databases. . . Implement appropriate tuning techniques to resolve and/or prevent performance issues.

. Monitor available storage space and plan for growth as needed.

. Administer the IDs, roles, and all other access to the database to ensure data is secure and accessed by

Proper methods.

. Handle all database aspects of any project, currency effort or new functionality for an application. Provide consultation on new database technologies and features

Tribune Company, Chicago, IL MAY 2012 – JULY 2015

Role: Oracle Database Administrator

Used RMAN Duplicate and HOT/COLD backups to migrate the data from 11.1.0.7 to 11.2.0.3.

Created a stand by database by using RMAN Duplicate in order to reduce the down time for the PROD database during the migration process.

DBA supporting three major projects from Development to Production via Tech-Test environments, involving daily configuration, administration all running on IBM AIX Database sizes range from 4GB to 2TB (in ODS & EDW environments).

Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers and Indexes on the tables.

Used Secure SCP & FTP extensively for the File transfers from machines to remote server.

Application of Oracle software patches when/where necessary.

Data migration between databases using both Oracle 10g and 11g export/import utility and Oracle 11g exp/imp data pump.

Database refreshes using expdp, impdp, RMAN Duplicate and cloning.

Experienced in cloning the databases using HOT and COLD backups.

Backup/Recovery monitoring and reporting using Oracle RMAN

Technical documentation of all configurations, installations, implementations, monitoring and testing projects for future utilization.

Backup Oracle DBA for two major projects involving periodic administration, troubleshooting & tuning of 10 Oracle databases ( 10g & 11g single instances running on both IBM AIX 5.3, SunOS 5.8 & HP-UX B.11.11)

Create oracle databases on configured servers using both the DBCA & Database creation scripts.

Manage, tune and troubleshoot database issues both on UNIX command line, SQL*Plus, OEM client, Oracle 11g database control, oracle 11g Grid Control as well as other third party tools (TOAD, SQLDeveloper, DBArtisan and dbXpert for Oracle).

Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both OEM (client), Oracle 11g database control & SQL*Plus, as well as pre-developed UNIX shell scripts.

Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).

Tested and qualified 11g new features for setting up 11g standards for database creation and configuration. Qualified installed procedures for 11g.

Designed and implemented database backups and Recovery strategies using RMAN, Datapump Export/Import, Cold, Hot backups

Used SQL*Loader to map and load large amount of data into Oracle Data warehouse from legacy systems. Responsible for data scrubbing, cleansing and data integrity.

Perform technical reviews for logical and physical database designs. Used Erwin for creating logical and physical data models.

Frame standards and security guidelines for the database implementations as part of Infrastructure DBA group.

Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).

Create database Objects, Tablespaces, Schemas as needed.

Schema migrations from Development to Production via Tech Test environments.

Database refresh from Production to Tech Test as needed.

Tools Used: Oracle RMAN, Oracle 10.2.0.1, Oracle 11g, DBMS STATS, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

Prudential Scranton, PA APRIL 2011 – APRIL 2012

Role: Oracle Junior DBA

Taking Backups on scheduled time and Monitoring Scheduled Backups.

Creating and dropping of users, granting and revoking rights as and when required.

Checking of Oracle files for abnormal behaviors.

Day to day Performance Monitoring and tuning of database.

Diagnose and Troubleshoot Database Problems and failures

Involved in the Design (Logical & Physical) of Databases

Preparing Backup and Recovery Plan.

Create oracle databases ( single instance ) on configured servers using both the DBCA & Database creation scripts.

Applied patches 10.2.0.2 and 11.2.0.3, 11.2.0.4.

Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.

Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.

Performed Installation and configuration of Oracle 10.2.0.1 database on HP-UX platform.

Successfully performed migrations from Oracle 9i/10g to 10gR2 RAC (Real Application) Database.

Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both Oracle 10g Grid Control & SQL*Plus, as well as UNIX shell scripts.

Worked closely with Application Developers to design/create new Oracle databases/create new schemas/database objects, as well as making database changes from DEV to PROD, via TST following requests/demands from the development team.

Backup/Recovery of Oracle 9i/10g databases using Oracle RMAN.

Tools Used: Oracle 10.2.0.1, Oracle 11g,RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

Academic Details

CAMEROON COLLEGE OF ARTS AND SCIENCES 2007

Advance level GCE Graduate with a GPA of 3.5 (equivalent to high school diploma).

CERTIFICATION

Oracle Certified Associate.

Contact this candidate