Akin Alawode

***** ****** *** ***

Fort Myers, Florida 33913

Phone: 281-***-****

E-Mail: acrj0k@r.postjobfree.com

SENIOR DATABASE CONSULTANT

Passionate and adaptable senior database professional with comprehensive background providing and delivering quality software and well-tuned databases that exceeds customer expectations and needs. Experience leading projects in various sectors including; Retail, Banking, Manufacturing, and Software Technology. Focused on Cross-Platform application development, Legacy modernization, and Enterprise wide solutions.

Areas of expertise:

oApplication Integration and Performance Tuning

oData Warehouse

oRoot Cause Analysis and Problem Resolution

oDatabase Management and Capacity Planning

oBusiness Continuity and Disaster Recovery Solutions

oDatabase Design and Optimization

oRDBMS Life Cycle Support

oE COMMERCE or digital commerce like ATG

oRetail applications Like JDA

oDATA MAT and ETL

oFunctional design

oExpert in disaster recovery and database architecture

oManaging Databases, Migration and Replication expert

oProactive monitoring through customized scripts and Oracle Enterprise Manager

oInstalling and Configuring Oracle databases

Professional Experience

Chicos FAS INC

Senior Engineer

September 2012 to Date

ENVIRONMENT; AIX and LINUX

Oracle 11.2.0.3 single instance and RAC

GRID Stand alone and RAC

ASM and ASMLIB

ASM configuration and management

Supply Chain applications

Production Support ORA errors resolution

Oracle patch application and coordination

Support Ecommerce applications

Migration of Application to a new Data Center

Database upgrade

Disaster recovery strategy

RMAN backup and recovery

Data pump

Data migration

Data guard configuration, management and support

Application support for trouble shooting of corrupted data during data feed

Support JDA Allocation

Support JDA Enterprise planning

Support JDA CHANNEL CLUSTERING

Support JDA SIZE SCALING

Support JDA TIBCO CLOUD for SAP BI feed

Support Size Scaling and Cluster Channeling application

Support Manhattan SCI application

Eliminate Severity 1 incidence in allocation application

Stabilize the environment

Performance tuning to reduce response time from 10 minutes to 5 seconds

Migrate 12 databases no new AM disk group so as to change the AU_SIZE to better handle the IO

Upgrade oracle OEM from 10g to 12C in place upgrade

Perform incremental roll forward to sync standby database because of missing logs

Apply oracle patch to both grid home and RDBMS home in both standalone and RAC

Configure and architect RMAN backup to use Veritas netbackup with data domain

Clone oracle Home and oracle database

Upgrade database to 11.2.0.4

Upgrade database and ASM to 12 C

Migrate from ASMLIM to AFD

Satellite Tracking of People LLC (STOP)

Senior Oracle Database administrator

DEC 2011 to September 2012

•Configure and manage 10 databases

•Manage VLDB (24T)

•Production support of 24/7 database

•Application development support

•Partition a 3 Terabyte table using dbms_redefiination package

•Configure Backup and disaster recovery using New oracle 11g feature of Incremental backup for VLDB

•Configure oracle dataguard on 11g using the new 11g feature active database (NO NEED for backup

•Configure active data guard for real time query

•Partition large table using interval partition

•Upgrade 10g database to 11g on oracle unbreakable Linux

•Tune application for better performance improving response time from 4 minutes to 10 seconds

•Tune report job for better performance reducing run time from 40 minutes to 5 minutes

•Migrate 24 Terabyte database to a new server keeping downtown to 1 hr.

•Design and implement procedure to archive historical database to slower disc saving company money on expensive disk

•Apply PSU patches on the oracle Server

•Manage gateway servers running MYSQL in a LINUX server

•Configure oracle client on webserver

•Configure and manage oracle 2GRID control for production and lower environment

Bank of America (Mortgage)

Senior Oracle DBA (Data Analyst) Consultant

November 2010 to December 2011

ENVIRONMENT; AIX

Production Support

ORA errors resolution

Oracle patch application and coordination

•Migration of Application to a new Data Center

•Code deployment in production

•Stream setup and management

•Consultation with oracle for best practice on new project and errors resolution

•Utilize Oracle Enterprise Manager Grid control to manage multiple databases

•Utilize Oracle Enterprise Manager GRID CONTROL for database diagnosis

•Utilize Toad for analysis and day to day performance

•Run jobs to create Materialize view when the auto job fails

•Schema export and import, database refresh using data pump.

•Created and maintained all RMAN backups

•Responsible for PSU or CPU for the entire servers in the group

•Responsible for Agent upgrade for the entire group

•Responsible for Data Guard lagging issues for the entire group

•Responsible for databases upgrade and documentation of the steps

•Write script to put database in backup mode for SRDF replication

Wells Fargo and Company (HOME MORTGAGE)

Senior Oracle Database Administrator

November 2009 to October 2010

ENVIRONMENT: Red Hat LINUX, AIX ASM and OCFS2 LINUX on Virtual Machines

•Perform SQL tuning, SGA tuning

•Apply Oracle database patches

•Support applications developers in tuning application codes

•Configure standby database

•Refresh dev., IST, POC, database with production

•Install and configure 10g, 10gRAC

•Write KORN shell to automate jobs database monitoring jobs

•Review and optimize PLSQL codes to improve performance

•Utilize Oracle Enterprise Manager Grid control to manage multiple databases

•Utilize Oracle Enterprise Manager GRID CONTROL for database diagnosis

•Utilize Toad SQL optimizer for SQL tuning

•Utilize Toad for analysis and day to day performance

•Perform table partition to improve archiving in the data warehouse environment

•Oracle stream for replication

•Materialize view to help database performance and query rewrite

•Schema export and import, database refresh using data pump.

•Created and maintained all RMAN backups

•Fix RMAN Tape failures

Hewlett Packard (IT Manufacturing Company)

Global Database Administrator

April 2009 to October 2009

ENVIRONMENT: HPUX Itanium, Windows

•Install and Perform database upgrades, migration of databases from Windows platform to UNIX platform

•Perform SQL tuning, SGA tuning

•Apply Oracle database patches

•Write KORN shell to automate jobs database monitoring jobs

•Review and optimize PLSQL codes to improve performance

•Database cloning on 10gRAC and 11gRAC

•Install and configure 10g, 10gRAC, 11g and 11gRAC

•VERITAS clustering as the underlying OS clustering for HP service guard

•Create RAC database 2nodes and 4 nodes

•Analyze and review codes with application developers to Optimize and improve query performance

•Manage and work with business analyst in data warehouse environment

•Configure standby database data guard

•Refresh test database with production

•Clone oracle SAP database 6T in size

•Utilize Oracle Enterprise Manager Grid control to manage multiple databases

•Utilize Oracle Enterprise Manager for database diagnosis

AUTHORIA (HRMS Software Company)

Senior Oracle DBA

March 2008 to March 2009

ENVIRONMENT; Oracle 10g RAC Red hat Linux, ASM, Toad, OEM ADDR, RMAN, AWR SCP putty ORDBMS, OLTP,OLDP

•Schema export, database refresh

•Created and maintained all RMAN backups

•Database patch and upgrade, support of Dev., Test and Production environment on10g

•Use of EMC SRDF technology for storage solution

•10.2.0.3 4 node RAC, node RAC and two set of stand-alone development environment, all on LINUX operating system

•Resolved oracle alert messages, open SR with oracle Support, manage space usage, and review the backup strategy and activation of the Flash_recovery_area.

•24/7 support of both ITG and Production environment

Hewlett Packard Company (IT Manufacturing Company) Houston, Texas

Lead Global Oracle DBA

June 2006 to March 2008

ENVIRONMENT: Oracle 10gRAC, HPUX ITANIUM, HPUX PARSC, Windows XP, 2005, OEM, RMAN windows X, Putty SCP SFTP, FTP, Toad and Erwin, ORDBMS, OLTP, OLDP

•Worked with assigned teams to roll out servers while meeting the specification deadlines.

•Designed check processes to check server qualifications and set up maintenance plan on SQL server 2005 for stand-alone and clustered databases.

•Delivered over 400 oracle binary installations for stand alone, 2 nodes, 3 nodes, and 4 nodes RAC clusters every quarter. ● Installed Oracle 10g RAC on HP ITANIUM & HPUX -PARISC

•Write KORN shell to automate jobs database monitoring jobs

•Configure and support oracle e-business suit

•Review and optimize PLSQL codes to improve performance

•VERITAS Clustering as the underlying OS clustering for the ORACLE RAC

•Meet with application team to understand the required environment to plan for the architecture of the database.

•Consulted with the engineering team on a regular basis on data modeling and architecture of the databases

DBA Konsult

Oracle DBA

08/99 to 04/2006

Oracle database migration and installation across platforms

Experience with building highly-available and scalable systems.

Experience of deploying database upgrades to live systems.

Knowledge of database performance and resilience testing.

Resolved oracle alert messages, open SR with oracle Support,

Manage space usage, and review the backup and recovery

Created and maintained all RMAN backups

Proactively work on databases alert

Fix RMAN Tape failures

Education

Bachelors’ Degree, Chemistry

University of Ibadan

Professional Development-Houston, TX

COMPUTE COURSE, DBA Professional Training

Oracle 11G R2 performance training

Contact this candidate