Manager Oracle

FOMBU DIVINE

***** ****** *’lvd Silver spring,MD 20904 Tel:240-***-**** Email:********@*****.***

Professional Summary

A goal-oriented Oracle Database administrator with over 5 years of experience in the information

technology industry. Possesses extensive experience in Oracle database administration and design on

both; Unix/Linux and Windows platforms. Has worked in both production and development environments

and in Oracle distributed networks. A proactive goal-driven Oracle dba,who is a reliable team player, and

at the same time, someone who would eloquently take upon any given task, personally.

Verigent staffing solution, Hagerstown MD March 2013 – Present

Oracle Database Administrator

• Installed and maintained 10g/11g databases for testing, development and Production

* Managed database sizes, ranging from 200GB – 800GB in a System development life cycle

environment

.Upgraded from oracle 10.2.0 to 10.2.4, and then to 11.2.0

• Regular maintenance activities like cloning, patching and custom code migration provide by developer

and working with their issues.

• Monitoring CPU, Memory and Disk usage

*Created users and managed their security

• Analyzing database schemas, tables and indexes for improving database performance.

• Successfully implemented Backup & Recovery using RMAN which includes hot backups and Cold

backups.

• Database Monitoring and administration of database using Enterprise Manager Grid control (OEM)

• Implemented and managed optimum physical database design (tablespaces, data files, extents, redo logs,

archive logs) and assessed database capacity by monitoring online storage, growth and file system space.

• Generated performance reports and Daily health check of the database using utilities like AWR,

Statspack and ADDM to gather performance statistics

*Helped analyzed the underlying concepts in Normalization, Entity relationship and Functional

dependency to my team.

• Preparing Shell scripts and automating them through CRON and DBMS scheduler for scheduled

database monitoring tasks.

• Daily Space monitoring in production server as well as development and UAT environments.

• Weekly table partition management

• Creating Materialized view

• Monitoring Day-Day Backups, Logs & recovering them as per the requirement.

• Analyzing database schemas, tables and indexes for improving database performance.

• Identified and tuned poor SQL statements using EXPLAIN PLAN, SQL TRACE and TKPROF,

Analyzed tables, indexes for improving the performance of the Query.

January 2010-February 2013

MG-TechSolutions Greenbelt, MD

Oracle Database Administrator

• Performed Oracle database Upgrade and Migration from Oracle to 10g to 11g

• Installation and management of Oracle database using Grid and database control

• Implemented the use of Oracle Recovery Manager (RMAN) to backup the databases

• Performed import and export as needed and scheduled nightly export on each database

• Administer database user accounts. Create, modify and deactivate user accounts;

• Assign and monitor user access rights

• Performed Cold backup, hot backup using conventional backups and RMAN, recovered various and

critical Production databases.

• Recovery of database (recovering from Media Failure, Recovering tables dropped accidentally, datafiles

and block corruption).

• Applied security related CPU and one-off patches using Opatch utility, Applied RDBMS patch set

utility(PSU)

• Maintain 20 Oracle database instances using OEM 11g Grid Control

Teklogic inc. Bowie MD Feb 2009-Jan 2010

Junior Oracle Database Administrator

• Perform regular maintenance and performance tuning on Oracle 10g /11g databases.

• Perform Schema refreshes in Dev/Test from Prod for data integrity upon developers

request Cloned Oracle database both in test, and production environment and

rename Oracle database in production.

• Make sure all users/schemas have proper privs/roles in such that job processes

could run successfully as scheduled.

• After-hours Database and Oracle Web Application issue support via cell phone

• Knowledge of PLSQL scripts such as creating functions, procedures, packages, and sequences.

• Involved in taking logical backup using Data pump and Exports/Imports Utility

• Created user accounts, role ad granting required access permissions and privileges to the database based

on the application they are accessing

• Configured and tuned RMAN for better performance and backup strategies

• Use the DDL statements CREATE and ALTER within a dynamic SLQ script to create schemas,

Synonyms and Roles.

Database Tools

Oracle Enterprise Manager, SQL Plus, SQL Loader, DB Configuration Assistant) Operating Systems: AIX

5.3,Unix RHEL, Linux Enterprise Server 9, 10.Toad, OEM Grid, RMAN, Exp/Imp/Data

Pump,winSP,Textpad, Statspack/AWR, DBUA, ADDM.

Education Background

Everest college Mclean,Virginia: Homeland security administration (2007)

Professional Certification: Oracle 11g Certified Associate Database Administrator

Oracle University 2010

Contact this candidate