Career Objective

An Oracle Application Database Administrator seeking position within a progressive company where I can utilize my skills and experience in a dynamic working environment

Profile

• Oracle DBA and Oracle Application DBA, with over 7 years experience in Oracle e-business suite 11i installations and upgrade, System administration, Oracle Workflow and Oracle Discoverer installation and administration, Database installations, monitoring, capacity planning, performance tuning, backup and recovery, user data security, writing SQL codes, Disaster Recovery planning.
• Experienced in eBusiness Suite Release 12 upgrade
• Experienced in SQL server administration with advance Knowledge in Store Procedure
• Expertise in using Oracle application utilities such as adpatch, adclone, adctrl, adadmin etc.
• Advance in PL/SQL, Shell Programming and software development
• Implemented Single Sign on (SSO) on Application server 10g with E-business suite (HR module).
• Strong analytical skills with experience in problem-solving and implementing solutions.
• Team player who is equally effective in a team environment or working independently.
• Strong Data modeling skills
• Self-motivated, goal-oriented and results-driven, with the professional attitude, enthusiasm, commitment and capacity to succeed in a demanding and high-pressure work environment;
• Punctual and confident with friendly disposition and strong interpersonal skills;
• Excellent communication and people skills, as well as being articulate, presentable and perceptive;
• Adaptive and flexible, adapting quickly to new environments and situations and able to readily learn new skills;

ERP Application
Oracle e-business suite, Oracle Application server 10g, Oracle Discoverer- BI
Operating Systems :
Solaris, HP - UX, Linux, AIX, UNIX etc
Tools:
PL/SQL Developer, Oracle Spotlight, Benthic, Toad, HP Data Protector OEM and Grid Control, ADI, Workflow Builder

Work Experience

Confidential, Nigeria August 2007 - date

Oando Plc, Africa's leading integrated energy solutions provider, comprises a group of companies operating within Nigeria and the African energy sector. Oando Plc implementation environment consist of Oracle RAC 10G database, Application Server 10g, Oracle Application E-Business Suite 11i (11.5.10.2) and R12 (12.0.4), Oracle Financial, Human Resources (Self Service), Human Resources, Purchasing, Asset management, Oracle Process Management, Oracle Projects Module, CRM, Enterprise Assets Management , Daily Business Intelligence etc

Database Manager

• Team leader of five members that comprises of Oracle DBA and Technical
• Ensure prompt payment of Oracle Support license
• Work closely with development team and provide both technical and functional support
• Ensure Database security and control Users access
• Perform regular maintenance, performance tuning, backup and recovery, Disaster Recovery on two nodes RAC environment and Application server 10g
• Ensure both the Application and RDBMS patches are up to date on all instances.
• Maintain Disaster Recovery Site.
• Regular clone of the Production instances to Test, User Acceptance and Development instances
• Plan and perform weekend maintenance for hardware and software.
• Provide standby service by mobile phones, blackberry to support the users off office hours and weekends
• Shell Programming/Unix Scripting
• Maintain Oracle Workflow, Portal 10g and Discoverer 10g

Accomplishments

• Configured, implemented, installed and administered two 10GR2 RAC on 2-nodes HP Itanium Clusters (CFS)
• Installed and Maintained six Oracle databases 10gR2 and eBusiness Suite Applications Release 10.5.10.2 on HP-UX
• Installed and configured Application server 10g for Oracle Discoverer 10g and Oracle Portal 10g.
• Designed and Implemented Disaster Recovery (Maximum Availability Architecture - MAA)
• Maintained and administered several oracle databases ( Production 2-nodes RAC, Test 2-nodes RAC, UAT, Application server 10g etc)
• Performed several database upgrades from Oracle 9i database to Oracle 10gR2. (10.2.0.4)
• Upgraded Oracle Applications eBusiness Suite from 11.5.10.2 to Release 12
• Provided technical support to functional consultants and developers on bug fixes and deployment of solution from development through UAT to Production.
• Proactively measure performance of systems and fine-tune to ensure optimization of performance by extracting traces on long running queries and running oracle utilities (such as tkprof, ADDM, AWR etc) to explain execution paths.
• Performed several clones from RAC to RAC and RAC to single nodes.
• Using Shell programming and Unix Scripting to automate some DBA and Application processes

Confidential, Nigeria October 2006 - July 2007

Confidential, is one of the leading Banks in Nigeria with over 300 branches. The Oracle environment consists of Oracle 10G database, Oracle Application E-Business suite 11i (11.5.10.2) and Customer Relationship Management Module

Senior Oracle Applications DBA

• Installations, upgrades, cloning, Shell Scripting and patches,
• Configured, implemented, administer 10GR21 RAC on 2-nodes on HP UX Pa-risc Raw Devices
• Developed custom scripts, performed regular performance tuning and monitoring, Database backup and recovery and archiving
• Data modeling
• Performing regular maintenance, performance tuning, backup and recovery on two nodes RAC environment
• Implemented Single Sign on (SSO) on Oracle Application Server 10g and e-business suite for the client across the network, and across all the applications e.g. HR module.
• Provided technical support and maintained two nodes RAC of Oracle e-business suite (11.5.10.2), and Customer Relationship Management - CRM module.

Confidential, Toronto, Canada May 2004 - September 2006

Oracle Application DBA (CONSULTANT)

• Team member with Oracle Corporation Egypt to Implement ERP-project (Oracle E-Business suite - i.e. Oracle financials11i) forCentral Bank of Nigeria
• Implemented and supported General Ledger, Human Resources, Account Payables, Purchasing, Balance Score card and Enterprise Budgeting and Planning and many more.
• Day to day management and administration of the Oracle Applications, and the database. Backup and Recovery, Performance Tuning
• Performed Applications Maintenance, Patching, Cloning and Upgrade
• Installed and upgraded Oracle database from 9.2.0.4 to 9.2.0.5 and 9.2.0.6 to 10.1.0.4 and Oracle Applications 11i (11.5.9 to 11.5.10 and 11.5.10.2)
• Installed Application server 10g and Implemented single sign on (SSO) and Discoverer 10g

Confidential, October 1998 - April 2004

• Developed and Maintained Peers HR/Payroll systems running on Oracle9i database
• Responsible for data processing, professional supported HR and Administrative departments including maintenance and enhancements to Peachtree Accounting software and other internally developed applications.
• Project Planning and organization, day to day team direction, user management liaison, high level and detailed systems design and requirement definition
• Hardware maintenance and Networking (LAN).
• Software procurement and analysis
• Staff's Educational Trainings

Confidential, Nigeria January 1997 - September 1998

• Responsible for Technical Support and Help desk support
• Configurations and Installations of new software and
• General system administration and support.

• B.Eng., Electrical/ Electronics Engineering
• Oracle 10g Database Administrations
• Oracle Discoverer 10g - Reports and Views
• Obtained Oracle9i Database Administrator
• Certificate in Information Technology
• Enhanced Language Trainings Program for Professionals in Energy Sector, CCIS, Calgary ( On going)

Workshop and Seminars Attended

• Career Bridge Workshop, CCIS, Calgary (October 2009)
• Oracle Open World, San Francisco, California, USA (September 2008)
• Enhancing Effectiveness of IT Specialists in the Business World, Digital Jewels, Nigeria (July 2008)
• HP Nigeria Technology Refresh Session Q2, HP, Nigeria (April 2008)
• Oracle Financials for Professionals, Data & Scientific Systems Limited, Toronto, Canada (October 2005)