Resume

Sign in

Oracle Manager

Location:
Houston, Texas, United States
Posted:
January 29, 2018

Contact this candidate

GLADSTONE ABIOLA IDOWU

Email: ac38ux@r.postjobfree.com

Tel: +1-832-***-****, +1-469-***-****

Location: Houston, Texas 77056

Relocation: Yes

Applications

Product

Versions

Experience

Applications DBA

10.7, 11, 11i

14Yrs – ad utilities, conc mgr admin, backup, cloning, sys admin

Oracle Financials

10.7, 11, 11i 12i

14 Yrs – Admin, Patching, Install, Setup, Tuning

Oracle 9iAS R2,10iAS

9.0.2.0.1

5yr – Admin, Install, Setup, Tuning

Oracle HRMS/Payroll

11, 11I

7Yrs - Admin, Patching, Install, Setup, Tuning

Oracle Web Apps

11, 11I

7Yrs - Admin, Patching, Install, Setup, Tuning

OBIEE/ODI/ODS

5,6,7

2 Yrs- Install, Setup, Admin

SOA WSDL XML

10g,11g

2 Yrs – Install, Setup, Admin

Data Modelling

DFD,ERD, Erwin

10Yrs – Install, Setup, Admin

BMC Patrol

4 Yrs

OPSF

10.7

1 Yr - Admin, Patching, Install

Peoplesoft

8.8, 8.4

2Yr - Admin, Datamover, Change assistant, Sqr, Upgrade

Oracle Database & Tools

Product

Versions

Experience

Oracle RDBMS

6, 7, 8, 8i,9i,10g,

11g,12c

16 Yrs DBA – Backup Recovery, Install, Upgrade, Patch, Performance Tuning, Administration, Sizing, Designing, Diagnostics

SQLPlus PL/SQL

2, 3, 8

16 Yrs – Reports, Admin Scripting, Programming

SQLNet Net8

1, 2, 8

16 Yrs – Install, Admin, Setup

Import/Export/Data pump

6, 7, 8,9i,10g,11g

16Yrs – Backup Tables, Reorganise Database Objects

SQL Loader

6, 7, 8

16 Yrs – Data Import

Enterprise Manager

1, 2

8Yrs – Database Administration, Registration of Owb scripts

RMAN /RAC/Data guard

9i, 10g, 11g

7Yr – Backup Recovery, HA

OEM Grid Control

10g

4Yrs - Monitoring

Erwin

10 Yrs – Data Modelling, Reverse Engineering, Scripting

Oracle Warehouse Builder

9.0.4

2 yrs – Data Acquisition, Extraction, Transformation, Cleansing and Loading

Toad

12Yrs – Import and Export, Scripting, Dba Admin

Hardware Platforms & Operating Systems7

Product

Versions

Experience

Sun Solaris

2.5, 2.6, 10,11

16 Yrs – System Administration, Shell Scripting, Oracle DBA

HP UX

10.20, 11

16Yrs – System Administration, Shell Scripting, Oracle DBA

Oracle ZFS, Exadata

3-2

2Yr – Administration, Oracle DBA

Windows

NT, 2000, 2003 XP

17Yrs – System Administration, Oracle DBA

MS Windows

3, 95, 98, 2K

10 Yrs – Client Administration, Install, Setup

AIX

6,7, Ent Edit

5Yr – Client Administration, Net 8 Install

Red Hat Linux

7 Yrs – System Adminstration, Oracle DBA

VMS

2 Yrs – Oracle DBA

Compaq

True64

2 Yrs – System Administration, Oracle DBA

Product

Versions

Experience

Sun Solaris

2.5, 2.6, 2.7

16 Yrs – System Administration, Shell Scripting, Oracle DBA

HP UX

10.20, 11

16Yrs – System Administration, Shell Scripting, Oracle DBA

Sequent Dynix

4.4

2 Yrs – System Administration, Oracle DBA

Windows

NT, 2000, 2003 XP

17Yrs – System Administration, Oracle DBA

MS Windows

3, 95, 98, 2K

10 Yrs – Client Administration, Install, Setup

AIX

6,7, Ent Edit

5Yr – Client Administration, Net 8 Install

Red Hat Linux

7 Yrs – System Adminstration, Oracle DBA

VMS

2 Yrs – Oracle DBA

Compaq

True64

2 Yrs – System Administration, Oracle DBA

PROFESSIONAL EXPERIENCE

10/2016 – Present

Globalstar inc

Senior Oracle DBA

Installation and configuration of Dbvisit standby on Primary and standby database Servers

Oracle Database Enterprise Edition downgrade to Standard Edition

Working with third party Vendors with regards to new database deployments ensuring proper standards are adhered to and Database Version Control maintained.

Provisioning databases for the Development team.

Data scrubbing and masking of production data for dev and test environments

05/2013 – 06/2016

Union Bank PLC,

Senior Oracle DBA

Setup Active Data guard Between Head Office Data Centre and Disaster Recovery site.

Implemented Partitioning strategy to improve response time of queries.

Migrated VLDB’s (very large databases) to Exadata and Supercluster Environments from Non-Engineered system environments.

Performed RMAN Backups to Disk and ZFS Storage.

Implemented and configured Oracle GoldenGate for data replication to ensure Zero downtime.

Led a Team of six DBA’s ensuring coverage 24/7.

Upgraded Oracle EBS version 12.2.0 to 12.2.2

Maintained and Cloned Oracle EBS Version 12.2.2

Provided Mentoring to team members.

Implemented data archiving and auditing methods based on Sarbines Oxley (SOX ) act regarding data retention using audit logs, partitioning, Heat Map and other Information Life Cycle (ILM) strategies.

Acted as Subject Matter expert on issues concerning Oracle to other DBA’s, Developers and Exco

Implemented Data masking on sensitive data using 12c Redaction policies on the FCUBS Core Banking database.

Performed Capacity Planning, Space Management, Security Management, Auditing, Shell scripting, Memory utilization and Performance Tuning of FCUBS Core banking database.

04/2009 – 05/2013

MTN Nigeria Plc,

Database Consultant

Supported and improve the database performance of VLDB (very large database) by repartitioning the databases

Provided product support by engaging improvement team to perform upgrades, as needed.

Engaged in Storage capacity planning and space management for production servers.

Installation of Application server for the Gamma Netone environment through Development, Test, Uat to Production.

Implemented and administered a central user repository using Oracle Internet Directory (OID) for the SOA infrastructure preventing the need to add AD lightweight service for each new application deployed on Fusion Middleware.

Advised Management on database management strategies and best practices.

Migrated the Facts database to a new M9000 environment while ensuring that Oracle best practises are adhered to.

Helped TSS developers with issues with PL/SQL coding.

Performed the role of the Oracle go to person for TSS dept.

Liaised with vendors regarding issues with server purchase and advised Management on database management strategies and best practices.

Provided 24/7 on call support for the production databases.

Configured and set up Disaster Recovery Site using Oracle Data Guard.

06/2007 – 01/2009

Shell Oil (SPDC),

Senior planning Engineer/Data Architect

Prepared Project Planning and Scheduling Procedures.

Prepared Project CTR’s Catalogue.

Prepared and maintained Project Schedule with resource allocation and levelling using Primavera 5.0 for Engineering and Construction and Microsoft Project.

Prepared and Updated Project Bar Charts and S-Curves.

Project control and monitoring.

Project reporting with analysis on project performance with emphasis on project target dates.

Prepared Project forecast and recovery Plans when appropriate in line with project delivery dates.

Established Work Breakdown Structure (WBS) to facilitate the creation of Cost Breakdown Structure (CBS).

Prepared and maintained planned and actual man-hours / cost expenditures using S-Curves.

Measured Value of Work Done (VOWD) against Time-Phased Budget on monthly basis.

Ensured that the planning and scheduling documents such as, master schedule, progress reports, “S” curves and Bar Charts etc. are prepared properly and in accordance with contractual time schedules.

Introduced and reengineered strategic business processes using Oracle BPM

06/2005 – 07/2007

HBT Consulting,

ORACLE DBA/ PEOPLESOFT DBA

Working on client site for TotalFinaElf, an oil and gas producing company as lead DBA.

Carried out configuration of oracle database servers for PeopleSoft databases.

Installed and migrated Oracle version 9.2.0.1 to 9.2.0.5 to conform to PeopleSoft HCM 8.8 certification.

Database administration and performance tuning on multiple instances of PeopleSoft databases using Oracle and PeopleSoft native tools.

Managed data conversion and uploading using SQL * LOADER, TOAD, EXCEL.

Cloned databases between various environments using DATAMOVER, DBCA and IMP/EXP

Rebuilt and created tables and indexes using APPLICATION DESIGNER

Installed and migrated PeopleSoft and database patches between environment

Work in conjunction with Basis dba team to analyzing space problem of tables, administration method

and using the SAPDBA/BRTools utility provided by SAP.

01/2004 – 06/2005

Aqualectra Distribution,

APPS DBA

Installation, administration and configuration of Oracle Applications version 10.5.9 on a linux 2.1 ES server

Installation and configuration of Oracle interconnect between two Oracle version 9.2.0.5 databases for a datastream application server.

Database monitoring using Watchdog, Enterprise Manager and Sql scripts.

Administration and configuration of Oracle Collaboration Suite.

Performance tuning of Oracle version 9.2.0.5 databases including using explain plan and tablespace re-organization.

Backup and recovery of the oracle 9.2.0.5 databases using RMAN.

Cloned production databases periodically to refresh the development environment.

Administered and upgraded Oracle 8i version 8.1.7 to version 9.2.0.5.

Linux system administration tasks.

Designed and tested Disaster recovery methods.

10/2003 – 01/2004

South Lanarkshire Council,

APPS DBA

Patching of the Self-service web applications servers

Performance tuning of Oracle Portal (HTTP server) using DAD trace, Tkprof and explain plan

Installation and configuration of Oracle 9iAS on a Linux 2.1 ES server

Clone of the HR and payroll system

Database refresh of the council tax system

Upgrade of the Oracle CRM application from 11.5.7 to 11.5.9

Upgrade of Oracle Financials application from 11.0.3 to 11.5.9

Ensuring that the apps tier and the database tier are properly backed up and maintain the backup procedure

09/2001 – 09/2003

Guinness UDV,

DBA

Daily maintenance of over 130 Oracle databases using various tools including Enterprise manager, Big brother, scripts etc.

Installation and maintenance of Oracle 9i version 9.0.1 on a Linux Red Hat platform

Installation of Oracle 8i version 8.1.7 and upgrade of Oracle 7.3.4 to 8.1.7 on a dg-Unix platform, NT4/2000.

Installation of Oracle8i version 8.1.7 and upgrade of Oracle 7.3.4 to 8.1.7 on an OpenVMS Platform.

Mentoring of a junior DBA and skills transfer.

Maintenance of the Oracle data warehouse using enterprise manager and Oracle warehouse builder.

Creation of Oracle databases for the different departments across the U.K.

Provided support for EMEA and the Americas sub divisions.

SAP Client copy (local, remote, export/import), creation of clients, deleting clientsSap (SAP GUI)

04/2001- 07/2001

NM Rothschild And Sons,

APPS DBA

Installation, upgrades and build of Oracle 8.1.6 databases for the investment and private banking group.

Performance tuning of all Oracle databases.

Daily monitoring of the databases and space issues

Implemented database synchronisation using Export utility, PL/SQL and SQL loader

Review of current backup procedures

Tablespace reorganisation.

Installation of Oracle applications version 11i using Rapid Install.

Operating system UNIX and NT4

Refreshed and cloned 11i production environment with adclone utility.

Extensive documentation of various task performed.

11/2000 - 04/2001

PwC, Zurich,

APPS DBA

Working on client site for YOU BANK, an Internet banking solution for the VONTOBEL private bank.

Installation of Oracle 8i version 8.1.6 on Development, Integration, Acceptance and Production environments on UNIX/NT.

Provide support for the development and infrastructure teams.

Daily monitoring of the databases using scripts, Enterprise manager and third party tools.

Migration of data into the Oracle databases.

Implementation of a backup and recovery strategy using RMAN.

Ensuring smooth running of all databases on a 24 /7 basis.

Installation and maintenance of Oracle applications version 11i

Writing Oracle Module Technical design using Oracle’s Application Implementation Methodology (AIM).

Patch administration and system administration task

06/2000 - 11/2000

Unilever PLC,

DBA

Installation and configuration of Oracle 8i version 8.1.6 and 8.1.5 on HP-UX v11 and windows NT 4.0

Daily monitoring of the SAP Oracle database using scripts, Enterprise manager and SAPGUI.

Database creation, user set-up, configuration of pearl DBI, JDBC thin and oci drivers

Writing of shell scripts and PL/SQL procedures for the monitoring and housekeeping of over 70 databases in the European IMC division.

Implementation of a backup strategy for new databases created and the review of existing backup Strategy.

Unix system administration

Review and implementation of disaster recovery procedures

EDUCATION

ORACLE Training Course (ORACLE v7 with Case) (London, UK)

Associate Chartered Insurance Institute (ACII.) (London,UK)

Bachelor’s Degree in Business and Finance. (Liverpool John Moores University, Liverpool, UK)

Planning And Controlling With P3e/c Enterprise Using Primavera (Houston)

Exadata Database Machine Administration Workshop Ed 2 (Oracle University, Dubai, UAE)

ORACLE Applications System Administration. (London)

ORACLE Certified Database Administrator 10g. (Houston)

ORACLE Certified Database Administrator 12c. (Houston)



Contact this candidate