Oracle DBA

MEITANG HONORINE

Oracle Database Administrator

********************@*****.*** 702-***-****

EXPERIENCE SUMMARY

PROFESSIONAL SUMMARY:

Over 5+ Years of total Oracle Database Administration experience in implementing, Design,

Development, Testing and Production support in all industry verticals exclusively Telecoms,

Financial, Pharmaceutical, Insurance Industries.

Wrote several Purging shell scripts on Linux which have been using as standard script at the

workplace

Provided root cause analysis and permanent fix of production problems

Installation, administration and maintenance of Oracle 11g

Worked extensively on Oracle Installation, Oracle Version Upgrade, Migrations (from 10g to

11g) and patching

Handled operational responsibilities like database refreshes/copy backs, security, documenting

standards and procedures, data migration, data clean up, data archiving, etc

Developed RMAN scripts for database backup and recovery including hot and cold backup

Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.

Team player with excellent interpersonal, analytical and communications skills

Wrote scripts to inform the DBA’s regarding the status, performance and space management of the

database

Participated in planning and implementation of off site Disaster Recovery planning and testing

Worked with development and operations staff in resolving problems quickly and efficiently

Installed, configured and maintained Physical, Logical, Active standby databases supported by

Data guard on Oracle 11g, 10g RAC servers for the purpose of disaster recovery procedures.

Performed backup & recovery of large databases and provided 24X7 production support to high

critical databases

Unix Shell scripts for hot backups, SQL*Loader, export and import of database.

Perform Daily Monitoring of Oracle instances using Oracle Enterprise Manager, ADDM,

TOAD, monitor users, table spaces, memory structures, rollback segments, logs, and alerts.

Expert in systems analysis and architecture, capacity planning, backup/recovery, installation,

configuration, apply patches, troubleshooting, performance monitoring and tuning.

Design, development, and testing of backup and recovery to ensure complete recoverability.

Solid experience in disaster recovery, routine maintenance for Oracle databases.

Security management for database, network, and operating systems.

SQL Net installation/configuration/troubleshooting (Server and Client side).

Storage Management including fragmentation detection, tablespace growth ratio.

Excellent interpersonal and strong analytical, problem solving skills.

TECHNICAL SKILLS

OPERATING Red Hat Linux RHEL 5.x and Windows XP

SYSTEMS:

RDBMS: Oracle 11g/10g

LANGUAGES: SQL, PL/SQL,UNIX Shell Scripting

SOFTWARE/ DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager

(OEM), OEM Grid Control, Oracle Data Guard, Oracle Management

APPLICATIONS/

Service (OMS), Real Application Clusters (RAC), ASM, SQL Navigator,

TOOLS:

TOAD, Data Pump (expdp,impdp),SRVCTL,SQL*Plus

TUNING TOOLS: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and

ADDM

WEB TOOLS: HTML, XML

PROFESSIONAL EXPERIENCE

Celtic Technologies, Rockville MD. June 2012 – Present

Oracle DBA

Responsibilities:

Install client/server Oracle and MS SQL Server Software

•

Wrote scripts to create tables, views, indexes and synonyms required meeting developer

•

needs.

Worked on in house installation of Oracle on different platforms, loaded user data to

•

reproduce the problem, applied new Oracle patch, managed database backup using

RMAN, upgraded Oracle database 10.2.0.4 to 11.2.0.1

Database reorganizations and refresh schema using Export/Import. Creating the

•

database, table spaces, tables, indexes, setting privileges and user logins.

Creating physical databases with multiple tablespaces from logical and physical data

•

model

Monitored and performed database sizing, tablespace management and rollback

•

tablespace management, transaction management and security administration

Data migration between databases using both Oracle 10g and 11g export/import

•

utility and Oracle 11g exp/imp data pump.

Prepared scripts to tune developer SQL codes to maximize result return time

•

Worked on large databases in Oracle 11g with multiple instances using Veritas Cluster.

•

Performed cold and hot backup using Oracle's Data pump.

•

Provided remote technical support using SSH and terminal services

•

Troubleshooting, Restructuring and tuning for optimal performance of existing

•

databases that were poorly designed for heavy hits.

Cloned databases using scripts as well as RMAN. Installation, setup and configuration

•

of Data guard

Involved in design and enforcing of standards in place to ensure that all application

•

design and code is produced with proper integrity, security and performance

Refreshed schema using Export/Import. Created the database, tablespaces, tables,

•

indexes, set privileges and user logins

Design of databases following OFA: Creating Databases schemas, profiles, database

•

links, Snapshots and Synonyms of objects as required to ensure data quality and

security to comply with company's business rules. Oracle scripting in Windows/

Solaris and UNIX platform.

Backup / Recovery methodology specification for mission critical databases

•

Performed hot and cold Backups.

•

Scheduled daily Exports/Imports to serve as temporary backups.

•

Installation and configuration of Oracle 10g and 11g Enterprise Editions, OEM with

•

Oracle Diagnostic and Tuning packs.

Capacity planning and creating databases for development, staging and production.

•

Database and Data Migration using Export/Import, Migration Utility.

•

Performed bulk data loads using SQL Loader.

•

Set up and configured SQL*Net and on servers and client machines.

•

Administration of RAC and DATAGUARD databases in Oracle 11g.

•

Resizing and reorganization of database objects: Tables, Indexes, Rollback segments

•

and Redo log files of existing production and development systems. Resizing

Tablespaces, Tables, indexes, Rollback segments.

Oracle DB System Development Life Cycle (SDLC) planning and Oracle DB 3 Tier

•

architecture.

Designed, tested and documented Oracle RAC database procedures

•

Created, relocated and removed Services as needed in an Oracle RAC configuration

•

Adding and removing nodes to existing Oracle database RAC configurations

•

Resolving RAC specific issues such as node evictions

•

Performed proactive and reactive tuning/managing database space utilization and

•

growth

Implementing Oracle ASM and resolving ASM related issues

•

Detailed analysis of the business and users requirements by doing various information

•

gathering techniques.

Environment:Oracle RMAN, Oracle 11g (11.2.0.2), DBMS STATS, Datapump, SQL TRACE,

TKPROF, EXPLAIN PLAN

Knoxville Utilities Board Mohnton, PA October 2010 –May 2012

Oracle DBA

Responsibilities:

Managed Oracle Databases on Windows and Linux platforms.

•

Performed activities like monitoring the database and provide maximum uptime.

•

Created and granted users the privileges and roles and resizing the datafiles to

•

manage database growth.

Defined and implemented database backup and security strategies, tested the

•

backups periodically for consistency and reliability

Identified long running database queries, refining queries for better performance,

•

and working with end users to implement changes

Created primary database objects (tables, views, indexes) once application developers

•

have designed an application

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.

Monitored the alert logs and troubleshot the errors.

•

Scheduled the backup jobs such as export through crontab in UNIX environment.

•

Rebuilt indexes and analyzed tables to ensure good performance of database.

•

Installed Oracle 10g and 11g on multiple platforms.

•

Performed upgrades from 10g to 11g databases.

•

Performed traditional Cold backup in appropriate environments via OS commands as

•

well as logical exports.

Created the database objects such as Tables, Indexes, Views, Database Triggers,

•

Procedures, Functions, etc.,.

Environment:Oracle 10.2.0.1, Oracle 9i (9.2.0.8),RMAN, Datapump, SQL TRACE, TKPROF,

EXPLAIN PLAN, HP UX 11, Sun Solaris 10.0

AT&T Middletown, NJ November 2009 –October 2010

Role: Oracle Junior DBA

Configure. Implement & Deploy Oracle 10g & Oracle 11g single instances on

•

SunOS 5.9 using files systems for storage & VERITAS Clustering for high availability

using IBM’s HACMP

Create oracle databases (single instance) on configured servers using both the

•

DBCA & Database creation scripts.

Monitor database systems and provide technical support for database system

•

issues and application performance enhancement/improvement using both Oracle 11g

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 10g/11g databases using Oracle RMAN.

•

Tools Used: Oracle 10.2.0.1, Oracle 10g (9.2.0.8),RMAN, Data Pump, SQL TRACE, TKPROF,

EXPLAIN PLAN

EDUCATION

Bachelor’s degree in Law, University of Yaoundé II.

•

Contact this candidate