Omotayo O Balogun

New Carrolton, MD *****

Mobile: 240-***-**** Email-id: bumscomakinde.com

QUALIFICATIONS:

About 6+ years of professional experience as an Oracle Database

Administrator having an immense experience in Production and

Development, Installation, Administration, Monitoring, Trouble

Shooting, Data Guard, Migration, Performance Tuning, Patches, Backup

and Recovery, Cloning, space management, database security.

. Extensive knowledge on database administration of Oracle 9i, 10g, 11g

with experience within very large scale database environment and

mission critical large OLTP and OLAP systems.

. Excellent experience in installation, setup and configuration of

Oracle 9i, 10g and 11g on Windows, Linux, Unix platforms.

. Expertise in upgrading the databases from Oracle 9i to Oracle 10g and

Oracle 11g.

. Installation, maintenance and tuning of RAC Applications

. Created development, testing, staging, production, RAC and standby

databases for OLTP systems

. 24*7 production database support with Support to developers & end-

users.

. Have implemented ORACLE STREAMS, and two type of standby databases

supported by DATAGUARD, logical standby and physical standby databases

. Having hands on experience in Hot/Cold Backup, Recovery and Cloning of

databases using RMAN.

. Implemented RMAN backup (Full, incremental and cumulative) and

recovery, Incomplete recovery and disaster recovery using Standby

database or Data Guard.

. Implemented the secure backup of the data using RMAN.

. Experience on working in Exadata Machines.

. Implemented automated backup strategy using the UNIX shell script CRON

UTILITY

. Performance tuning of the database - SQL Tuning, Used Tuning utilities

like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA,

Distribution of disk I/O, Sizing of tables and indexes.

. Performance Tuning i.e. tuning applications, shared pool, I/O

distribution, rollback segments, buffer cache, redo mechanisms

. Data loading using SQL*LOADER, Logical backups using full export and

DATAPUMP.

. Database replication using snapshots, materialized views and advanced

replication methods.

. Experience in applying security patches to the databases.

. Effective troubleshooting of database and Performance problems.

. Good experience in Data Migration using export/import.

. Management of Objects, Schemas, Partitioning the tables and Indexes.

. Worked on Developing PL/SQL packages, stored procedures, functions,

Cursors, triggers.

. Extensive knowledge of Oracle Architecture, SGA, PGA, LISTENER,

TNSNames, V$ and DBA views.

. Experience in implementation of enterprise databases on enterprise

storage solution using Storage Area Network (SAN).

. Knowledge on Oracle Support Process for Technical requests using

Metalink and other support procedures.

. Good Interpersonal communication skills and Documentation Skills.

TECHNICAL HIGHLIGHTS:

PROFESSIONAL EXPERIENCE:

Remarkable Technology Group -Oracle Database Administrator Mar, 2010

-Till Date

. Performs database installations, configuration, upgrades, and maintenance

of data.

. Creates appropriate tables and views for developer and client needs.

. Creates appropriate indexes for queries and suggested changes to

application developer.

. Applies and tests security, application patches.

. Monitoring Tablespaces and Datafiles utilization.

. Managing Undo Tablespaces, Redo Logs, Control files and Archive logs.

. Implemented multiplexing control files and redo log files

. Writes PL/SQL stored procedure, triggers, etc. for application

development and db monitoring. Monitors alert log and trace files using

shell scripts and user activities by auditing, user privileges, and

roles.

. Configuring various RMAN parameters as per the requirement.

. Performing physical backups using RMAN utility.

. Identify and recover the corrupted db blocks using Block recover option

in RMAN utility

. Performing Complete Media Recovery of Database depends on the nature of

failure.

. Configure and implement the use of Oracle Recovery Manager (RMAN) for

cold and hot backup to the databases

. Performed various performance goal oriented database tuning.

. Use explain plan, AWR, ADDM and various Oracle Advisors to tune the

database.

. Created and tuned various materialized views.

. Tuned various slow running query

. Performed instance tuning, memory tuning query tuning and complete

database tuning.

. Creates and implemented various table partitions for large tables

. Resolved various complex issues with the database.

. Apply quarterly CPU patches to different version of databases.

. Upgrade Oracle 10g database to 11g.

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

MFORMATION Technologies Inc., Edison, NJ Jan

'09 - Feb '10

Oracle Database Administrator

. Participated in Oracle RAC 2 node implementation on 10g database with

Linux o/s.

. Best practices and documentation to maintain standards across

environment.

. Evaluate h/w, capacity planning.

. Re-tolled backup and recovery strategy.

. Interpreting AWR, ADDM reports.

. Worked on Oracle 10g OEM for the effective DB administration.

. System monitoring and maintenance to ensure the high availability.

. Setting up Data guard and provide all DBA support from Dev to PROD.

. Applying Database Patches and rolling upgrades.

. Installed Oracle DBs on Vmware ESXi 4.0.

. Migrated Oracle Databases from 8i/9i to 10g.

. Data refreshes through Oracle utilities such as EXP/IMP/SQLLDR.

. Creating and maintaining database roles and privileges.

. Worked with Streams to replicate the data.

. Performed partitioning on oracle large tables.

. Extensively used UNIX Shell (Korn) scripts for automating various

processes.

. Used Flashback utility to restore the erroneously deleted objects.

. Used Datapump utility instead of Export/Import.

. Used backup, recovery and DB refresh based on Dev team needs.

. SQL Server Installation, backups and restore.

. Supported DB2 Databases.

Environment: Oracle 10.2.0.4/11.1.0.7, Oracle EBS 11i, Solaris 10, HP-UX

11.0, Windows 2003, RMAN, J2EE, Weblogic 9.2, Javascript, APEX, SQL Server

2000/2005, MySQL 5.0, DB2.

Kaiser Permanente, Pasadena, CA Jun 07 - Dec'08

Oracle Database Administrator

. Evaluate h/w, capacity planning.

. Re-tolled backup and recovery strategy.

. Oracle Standby/Failover Administration.

. Done database cloning to setup Test & Development Databases.

. Used Flashback utility to restore the erroneously deleted objects.

. Used Datapump utility instead of Export/Import.

. Performance Tuning of the databases.

. Performed partitioning on oracle large tables.

. Design of Data Models using Erwin. Worked on designing of Dimensional

Data Models.

. Helping Dev team to move database objects from Dev environment to

PROD.

. Creating and maintaining database roles and privileges.

. Database Migration across various OS and in between different

databases.

. Used Security features such as FGAC, Roles and privileges.

. Performing Various Backup (HOT&COLD) and Recoveries using RMAN.

. Hands on experience with ETL tool informatica.

. Good understanding of Data warehouse tasks such as data mining, data

integration, data cleansing, data transformation and data governance.

. Having good knowledge with creation of Metadata.

Environment: Oracle 9i/10g, Solaris 8.0, HP-UX, RHE Linux 5.3, J2EE,

Weblogic, SQL/PL-SQL,OWB/ODI Informatica Power Center 5.0.

EDUCATION& TRAINING

Bachelor of Science (Geography), University of Ibadan, Nigeria

2000

Microsoft Certified Professional (MCP)

2009

Oracle Certified Associate 11g (OCA)

Sept 2012

Reference

Available Upon Request

Operating systems Redhat Linux, Windows NT/2000.

Languages SQL, PLSQL, Unix shell Programming.

Databases Oracle 11gR2,11gR1, 10g, 9i, MS SQL server 2000/2005.

Hardware/Machines Intel PC

Tools & Utilities EXP/IMP, OEM, RMAN,TKPROF, STATSPACK, AWR,ADDM, SQL

LOADER, SQL NET, TOAD, SRVCTL, DBMS APIS, ORADEBUG,

RACDIAG, RDA.

Contact this candidate