Manager Oracle

YINKA I. OLADAPO,

**** ******* *** **. *****, OH 45040

*********@*****.***

Phone: 301-***-****

OBJECTIVE:

Actively seeking a more challenging Oracle DBA opportunities that utilize my broad hands-on technical training and work experience to build infrastructures, add IT support value and deliver costly efficient cutting edge technology solutions.

SUMMARY OF SKILLS:

Provide administrative support for all applications that use oracle database 10g and 11g

Experience with 11g RAC, ASM, DATAGUARD, RMAN and EM Grid Control

Identified, resolve, or provide recommendation to different kinds of performance problems using AWR, STATSPACK, EXPLAIN PLAN, SQL Trace

Perform general DBA duties (install software, create databases, tablespaces, add redo log files, apply patches and upgrades, migrate databases from Windows to Linux, managing storage & work closely with Sr. DBA on capacity planning and performance tuning

Perform daily database backup of development and test environments, use production data to refresh development and test schemas for testing using RMAN duplicate

Excellent troubleshooting skills

Knowledge of managing Oracle on Windows, Linux & UNIX

Prepared documentation for DBA department

Implemented/maintained database security with roles and system privileges

Experience working in a help desk and call center environment.

Demonstrate ability to quickly diffuse heated customer situations.

Excellent troubleshooting and logical problem solving skills.

Creative ability to solve unusual or difficult problems when logical methods have failed.

Demonstrate ability to meet deadlines and set priorities.

Strong communication and interpersonal skills.

Ability and desire to learn new technologies quickly.

OS Platforms: Windows Vista, XP, 2000, 98, 95, SQL*Plus Oracle (Linux/Unix), Mainframe.

Oracle Tools: Oracle Enterprise Manager (11g, 12C OEM) with Diagnostics, Oracle Universal Installer, Database Configuration Assistant, Database Upgrade Assistant, Oracle Net Manager, SQL*Plus, Recovery Manager, Data Pump, TOAD, Netca, STATPACK SQL*Loader, Oracle VM Manager, and Command-line tools, VERITAS Netbackup, Autosys, STAR application.

EDUCATION AND TRAINING:

University of Maryland: Bachelor of Science- Accounting (2007)

DBA University

oOracle 10g, Oracle9i

oMS SQL Server 2005 and 2000,

oEnterprise manager,

oquery Analyzer,

oSQL profiler,

oService manager.

CERTIFICATIONS:

Oracle Certified Administration I.

SQL Fundamentals I Certified.

PROFESSIONAL EXPERIENCE:

Oracle Database Administrator

TATA CONSULTANCY SERVICES- THE BOEING CO. MAY 2013 – Present

Applied PSU and CPU patches to RAC, HP-UX environments with their standby databases

Resolve daily issues and requests through ticketing systems.

Configure, monitor, and manage RMAN backups for all database instances

Worked with developers to generate Explain Plan for specific SQLs identified in Statspack reports.

Responsible of executing weekend database health check.

Deep knowledge on installing, upgrading and patching Oracle systems.

Perform backup and recovery for numerous Oracle 10G, 11G databases using export & import.

Monitor the applications to make sure that they are up and running properly

Making sure that the application servers are in proper communication with the database servers

Monitoring database application schemas to make sure that account are not locked and passwords are not expired.

Knowledge of creating a DataGuard Standby Database

Created and managed oracle accounts, roles, privileges and profiles to maintaining database security in accordance with compliance and Assurance policies (C&A).

Performed data migration between environments using EXPORT AND IMPORT

Manage and monitor DB storage usage by creating tablespaces, adding and resizing datafiles to existing tablespaces.

Perform/use production data to refresh development and test schemas for testing.

Oracle Database Administrator

ARES GROUP INC. - IRS MARCH 2010 – APRIL 2013

Installs the Oracle server and client software applications

Administer database user accounts. Create, modify and deactivate user account; assign appropriate privileges as well as maintaining database security.

Perform backup and recovery for Oracle 9i, 10G, 11G databases using export and import.

Provide performance tuning, maintaining and troubleshoot database problems.

Create different table spaces, tables, schemas and users accounts.

Perform daily database administration on production and test environments.

Responsible for monitoring (alert log, memory, disk I/O, CPU, database network connectivity)

Perform various RMAN cold and hot backup

Ensure daily RMAN and export backups are completed and valid for restore and recovery

Assist with upgrade from 11gR1 to 11gR2 using DBUA

Knowledge of Data Guard

Monitored all database using oracle enterprise manager, automated all backup, and automated scripts to refresh testing and development databases from production.

Perform administration and maintenance of RAC

Write SQL scripts to create tables, indexes synonyms, views and other objects

REFERENCES

Available upon request

Contact this candidate