Manager Oracle

Yemi A. ADEPOJU

***********@***.*** 925-***-****

Oracle DBA

Seeking an Oracle DBA Position in a goal oriented IT environment that will utilize my existing education and hands on skills, and

experience to achieve the organizations objectives.

Dbase II Administrator

House of Bethel Lagos

Assisted database programmers with writing efficient SQL code

Monitored and maintained system security including database alert logs, managed file system disk space, resizing table space and

defragmenting the database as needed, system shut down and restart, unlocking database table locks as well as monitor and

creating additional tablespaces as needed.

Wrote scripts to create tables, views, indexes, synonyms and other database objects as required by developers.

Managed, created new users, roles and assigning users the appropriate roles and profiles to ensure database security and data

integrity.

Coordinated with LINUX administrators for space management on servers and space planning for data growth.

Monitored RMAN backups, data pump dump files, archive redo log files and fast recovering area.

Responsible for scheduled maintenance tasks including exports, backups, and database recovery

Oracle Database Administrator

Boltos Solutions Institute Laurel, MD

Install the Oracle client and server software & configuration settings, applying patches and migrate databases.

Creating databases using DBCA according to physical and logical database design as recommended

Administer multiple instances of Oracle 10g and 11g databases running on the Linux/UNIX Operating systems

Set up and manage database security by creating new users, roles, profiles, and provide required user privileges in development

and production environments for implementation and maintenance of user security.

Perform backups full and incremental using Oracle's RMAN backup utility.

Load and transfer data using Data pump and SQL Loader utilities.

Design and implement Oracle user audit collection in architecting data flows to the management.

Automate database administration routines in backup and recovery using Recovery Manager (RMAN), routine import/export

activities, schema creation and disk usage monitoring.

Implements monitoring procedures to maximize availability of the database.

Using incremental and full backup; Auto backup with Job function. Fixing restore and backup errors.

Experienced in working with DBMS automation scripts, and deploying scripts.

Configured and monitored the TNS Listener using Netca

Monitoring (alert log, memory, disk I/O, CPU, database network connectivity) .

Created different table spaces, tables, schemas, constraints to enforce business rules and users accounts.

Changed password for users, killing sessions, granted privileges, altered roles, and set alerts.

Implements Performance Tuning and Optimization by using monitoring and troubleshooting tools like ADDM

Automate routine DBA tasks by utilizing scripts

Moved data by using SQL*Loader as well as Export Data Pump (Expdp) and Import Data Pump (Impdp) utilities.

ORACLE SKILLS

SQL Loader

SQL and PL/SQL

Linux Shell Scripting

Data Pump (Expdp and Impdp)

Oracle Recovery manager (RMAN)

Performance tuning (AWR and ADDM)

Proficient in Oracle migration from 10g to 11g

Experienced in creating and altering database objects

Experienced in data migration efforts using Oracle SQL Loader

Knowledge with creating materialized views to improve query performance

Experienced in performing backup and recovery using the Oracle RMAN utility

Apply quarterly CPU patches to different version of databases.

Upgraded Oracle 11g databases from 11.2.0.1 to 11.2.0.3 using patch set

Frequently use Oracle Enterprise Manager (OEM) for database monitoring and some administration work

Installing, configuring and upgrading Oracle database software releases and applying related patches on UNIX

CITIZENSHIP

U.S. Citizen

Contact this candidate