GABRIEL OLUWALAYOMI
Cell [Send email to request phone number] 90 9970 Home (678) 545 1985
E-mail : [Send email using form at bottom]
OBJECTIVES: Senior Oracle DBA, Oracle RAC DBA, Oracle Application DBA, Oracle
Consultant, Remote or Local Fulltime or Contract Employment.
My Technical skills :
§ Oracle 7, 8, 8i, 9i, 10g (on Linux, Solaris, AIX, WinS) Database
Administration.
§ Oracle EBS R11, 11i Application DBA and System Administration.
§ IBM Informix7.2/7.3/9.x (on Solaris) Administration.
§ MS SQL Server 7, 2000 Administration.
§ MySQL 5 (on Linux/Solaris) Administration
§ Business Application of Database Technologies and Enterprise Database
Architecture.
§ High-Transactional Database and Distributed Database Management
§ Oracle Real Application Cluster Configuration and Implementation ( on AIX,
Linux).
§ Experienced with Very Large Databases and Large number of Databases Support.
§ Backup and Recovery Planning and Implementation
§ Database Replication and Disaster Recovery for High Availability
§ Performance Tuning and Database Monitoring Systems
§ Data Analysis and Modelling (ER, Relational and Dimensional Data Models).
§ Data-warehouse and Operation Data Store Architecture
§ Outsource Service SLA Management
§ Quality Management and Change Management
§ SDLC Management.and Application Development and Implementation
§ Project Management Skills
§ Storage Architecture Knowledge IDE, SCSI, RAID, SAN, NAS.
§ Computer Networking (LAN, VLAN, WAN,Internet/Web,WAN,Wireless )
§ Problem Determination and Resolution skills
§ Internal Security and IT Auditing
§ Financial/Accounting Knowledge
My Work History
Arbys Restaurant Group
Location : Atlanta, Georgia
Position Title : Senior Oracle Applications DBA
Start : August 13, 2007 June 13, 2008
Systems Used/Supported:
12 RHEL Servers, RHEL ES/AS Rel 4, 6 X Oracle 10.2.0 (Oracle RAC) Servers.
Oracle E-Business Suite 11i (11.5.10.2) 6 EBS Instances Production, Test,
QA, Development.
Oracle 9iAS, Application Server 10g, Oracle Database 10.2.0, 10.1.0 (RAC),
Oracle Forms Server 6i, Report Server 6i, Oracle BIDiscoverer Server 10g,
Oracle Discoverer Admin, Plus/Viewer.
Oracle Internet Directory, Single Sign-on, Portal
Oracle Enterprise Grid Control, Oracle Data Guard Manager,
RMAN, Veritas NetBackup 6.0,
Oracle Enterprise Grid Control,
MS Project, MS Visio.
Duties :
Management of outsource service provider and vendors
Technology Projects Management
Hardware/Software Evaluations and Capacity Management.
Installation, configuration of Oracle Applications, Oracle Databases, Oracle
Application Servers.
Oracle Application 11i Patching and Cloning Management.
Oracle Database Administration and Oracle Applications Configuration and
Support.
Oracle Applications operational / technical management Concurrent Managers,
Workflow,etc.
RedHat Linux System Administration and Management.
Oracle Discoverer Administration and Support
Support for Database Developers and Datawarehouse Consultants.
Application Code and Database configuration Change Implementation Management
Controls
Mentoring DBAs and Developers.
Achievement:
Streamline Oracle Application 11i patching and cloning strategies.
Implementation of Oracle XML Publisher (BI Publisher).
Implementation of Oracle RMAN Backup/recovery with Recovery Catalog/NetBackup
Implementation of Enterprise Oracle Environment Monitoring with Oracle EM Grid
Control.
IT Internal Security SOX Compliance on Oracle Apps, Databases, Linux Systems
Architecting disaster recovery plan and implementation
Design of External facing extranet configuration for Oracle iStore/Oracle
Portal.
Intelliverse (Voicecom Telecommunications )
Location : Alpharetta, Georgia
Position Title : Senior DBA Developer
Start, : Nov. 2006 August 2007
Systems Used/Supported:
Sun Solaris 6, 8, 9, Red Hat Linux AS 4 , SuSE Linux 9
Oracle 10.2.0, 10.1.0 , Oracle 9.2.0,
Oracle Internet Directory, Streams Advanced Queues Processing,
Oracle Advanced Replication, Streams Replication, Data Guard Manager, dgmgrl
Oracle Enterprise Manager 9i, OEM DB Console, dbca, dbua, netca, emca, oidadmin,
oemctl, agentctl, RMAN, Shell scripting, MicroStrategy 7.1 , MS Project, MS
Visio.
Duties :
Daily operational production database support
Change Management, Research and Testing for new Oracle technologies.
Application development in PL*SQL, Application Codes Change supervision.
Oracle Datawarehouse Projects, Data Modeling, multidimensional OLAP, ROLAP
Mentoring 2 DBAs.
Achievements:
Implemented measures to enhance database availability and performance.
VOIP Data-warehouse Project Management
Migration and Implementation of Production databases.
Integration of Oracle Data Warehouse with Microstrategy 7.
Oracle Database Upgrades and Patch application.
Oracle Data Guard for Production and QA databases. for high availability
Application Stored Procedures PL/SQL development and enhancements.
Planning and Implementation of RMAN for production/QA/test databases.
Setup of multi-master Replication for Production databases.
Oracle Database Upgrades and Patch application.
Production Performance Tuning and reconfiguration of Replication.
Planning and Implementation of RMAN for production/QA/test databases.
MS SQL Server database support.
Emdeon Corporation (WebMD)
Location : Nashville, Tennessee
Position Title : Lead Oracle DBA
Start : Oct. 2005 Nov. 2006
Systems Used/Supported:
Over 150 Oracle/MySQL databases support, IBM AIX 5L, Sun Solaris 8, 9, RedHat
Linux
Oracle 10.2.0, 10.1.0 , Oracle 9.2.0, Oracle 8.1.7 databases, Oracle client
8,9, Instant Oracle 10g.
Oracle Enterprise Manager, OEM DB Console, dbca, dbua, netca, vipca, oemctl,
crsctl,srvct;l
TOAD, RMAN, Veritas NetBackup, Korn shell scripting, ODBC, JDBC,etc
Achievements:
Oracle 10g RAC setups and support. ( 3-node clusters) with ASM instances
Migration of non-RAC Oracle instances to Oracle RAC instances.
Migration non-ASM-enabled instances to ASM enabled.
Oracle Databases Migration from Sun Solaris to AIX.
OEM DB Console setup for Oracle DB instances.
Supporting MMR (multi-master replication database instances).
Database support and Performance Tuning using Statspack, OEM, OEM DB Console.
RMAN/Veritas Netbackup configuration and backup/recovery implementation.
Performing Oracle patches and Database Upgrades.
Installed, configured Oracle 10.x.0 server/client, Oracle 9.x on AIX5L,
Solaris.
MySQL installations and configuration and support.
After hours/Weekend Database Maintenance and Change/Production Support.
Independent Consultant
Location : Sydney, Australia
Start : May 2005
End : Oct. 2005
Systems Used/Supported:
Oracle 9.2.0, 8.1.0 Server for RHE Linux
Oracle 8.1.0/9.2.0 clients on Windows.
dbca, netca, sqlplus, isqlplus, exp/imp, expdp/impdp, sqlload, tkprof, explain
plan, trace.
Oracle 10g, RMAN, Oracle 10g DataGauard, PLSQL
Oracle Enterprise Manager DB Control, isqlplus
Windows 2000 Server, MS SQL Server 2000 Enterprise.
SQL Enterprise Manager, Performance Monitor, MS BCP, BULK INSERT, MS DTS.
Achievements:
Installation and configuration of RedHat Enterprise Linux and Oracle 8.1.0
Migration and Upgrade to 9.2.0
Data Migration from COBOL data files to Oracle Database data sets.
Performing DB Health Checks and Performance Tuning.
Developed routines for data cleaning and padding in PLSQL.
Implementation of Oracle Physical Standby DB.
Installed and configured Oracle 10.1.0 and Testing the functionalities ASM,
AMM, ADDM,
Installation and configuration of Windows 2000 Server and MS SQL Server
Enterprise.
MS SQL Server instances access through ODBC and OLEDB.
Performance monitoring and tuning.
Tourism Technology Pty Ltd.
Location : North Sydney, NSW, Australia
Position Title : Senior Lead DBA
Start : Aug. 2001
Left date : May 2005
Systems Used/Supported:
SUN MicroSystems SunFire Sparc Servers, Solaris 7, 8
IBM Informix IDS 9.40, IDS 9.30UC7,
IDS 9.21UC7, IDS 7.3, Informix ACE, set explain on,
Informix HDR, Informix ER, TSM, Tivoli TDP for Informix.
Veritas Netbackup , Veritas Volume Manager, TSM, Tivoli TDP for Informix.
Achievements:
Daily responsible for Informix database administration, supporting 35 UNIX
servers running Solaris 8 and all together 46 databases ( production / test /
development ) databases. ( databases with average size of 90 gigabytes, the
largest database size of 350 gigabytes).
Conducted installation, configuration and support of Informix IDS 9.30UC7,
IDS 9.21UC7, 9.21.UC6 in production operational client sites.
Responsible for ongoing support and administration of the production, testing,
training and archive databases.
Involved in system administration - installation and maintenance, and support
of Solaris 7, 8.
Tuning Solaris kernel parameters for the Informix database operations.
Conducted Solaris network configuration for distributed databases on 3 database
servers and 1 application server. Configuring multi-residency Informix database
instances.
Performed database schema redesign checks, change management and control.
Liaised with the application development teams on issue of database incarnations
and database re-factoring.
Developed a suite of database health checks scripts and performed regular DB
health checks.
Conducted capacity planning for all databases and growth planning.
Allocate system storage and plan for future storage requirements for the
database system
Coded stored procedures, triggers and functions in Informix SPL and developing
ACE reports for management reports.
Developed a suite of database health checks scripts and performed regular DB
health checks.
Performed quarterly database performance monitoring review and DB tuning and
reorganisation.
Implemented weekly database maintenance activities and automated schedules.
Configured and Implemented backups and restores/imported restores using Informix
Onbar/Veritas Netbackup.
Involved in troubleshooting problems with Informix/Veritas network-based backups
Developed automated scripts and design the schedules for executing backups and
recovery (database refresh on other test database servers) for various clients.
Installed and configured Informix HDR (High-Availability Data Replication)
databases for application fail-over for some clients.
Developed scripts to monitor the HDR and reports problems.
Provide database connectivity support (ODBC/JDBC) for Java applets and
applications.
Designed, configured, implemented and supports Informix ER (Enterprise
Replication) data replication with a hierarchical replication topology (a primary
server and 2 target servers) replicating scores of application tables for load
balancing purpose.
Trained other DBAs on the ER implementation.
Developed suite of functions to ease the task of configuring, maintaining and
monitoring the ER environment.
Developed data unloading and loading scripts to automate test/training database
refresh.
Performed Informix software upgrades and Calypso application software release
upgrades.
Developed Informix 4GL modules for performing data entry and reports
generation.
Documented and optimization of database environment to meet Service Level
Agreements (SLA).
Provide technical resolution to Informix database related problems and vendor
management.
Supporting 100 UNIX Korn-shell scripts for automating application module access,
security, ftp-ing tasks, etc.
Providing supervisory support roles to 2 other DBAs in the company.
Configured and Implemented Tivoli DP for Informix for database instance backups
and restores.
Education :
B.S. Computer Science, University of Nigeria
Hobbies/Interests:
Reading, Singing, Computing, History, Astronomy
Chess, Traveling and Recreational Architecture
Strengths
Vast IT Infrastructure and Software Knowledge, Self-starter, Quick learner
Organisational and Interpersonal skills.
My Certifications :
Oracle 10g Certified Professional DBA OCA, OCP
Oracle 10g Real Application Clusters Training (Oracle University)
IBM Certified Solution Expert Informix Dynamic Server 9 Administrator
More detail resume upon request.
References :
Available upon request. |