Candidates About

 

Raymond Imabekhai

Skills Summary

Oracle DBA (8 years)                                                                                                            Patching (8 years)

Data Guard (2 years)                                                                                                 RAC (4 years)

ASM (4 years)                                                                                                                        AWR (8 years)

RMAN (8 years)                                                                                                         Shell Scripting (8 years)

Exadata (1 year)                                                                                                        AIX (4 years)

Data Warehouse (8 years)                                                                                        Solaris (4 years)

Linux (8 years)                                                                                                           Windows (8 years)

PLSQL (2 years)

Golden Gate (1 year)

 

 

Professional Summary

 

Reliable, Result Oriented, Dedicated to Problem Solving, Responsible, Trusted & Proactive Oracle Database Administrator with expertise in crisis management, performance tuning, and high availability to increase reliability, maximize productivity and ensure system efficiencies. Adept at all stages of project lifecycle, from business requirements and technical definitions to testing, documentation, production support, training and completion.

 

TECHNICAL SUMMARY

Operating Systems: Win. 95, 98 NT 4.0, 2000, 2003 Servers and XP and 7, Red Linux 3.x, 4.x, 5.x, IBM AIX Unix 5.x, 6.x 7.x and Oracle Solaris Unix 2.x; 8.x , 9.x, 10.x; HP.Unix 10.2 and 11.x

Databases: Oracle 9i, 10g Release 1 & 2; 11g Release 1 & 2; 12c Release 1 &;

Applications: MS Word, Excel, Power point, Cyclone, Vertex, Master Tax, Extensity, EMC Documentum, Content Management and Filenet.

Tools: OEM, Sqlplus, Server Manager, Toad, Quest Central for Oracle & SQL Loader, Datapump,      RMAN, AWR, ADDM, Scheduler

Backup & amp; Recovery and High Availability Solutions: Automated shell scripts, Oracle DataGuard & RMAN, Veritas Clustering Services HA Solution.

 

 

Technical Skills

 

 

·         Over 8 years of Oracle DBA experience in Production, Development and Test environments in various industries. 

·         Involved in Installation, Configuration, Upgrades, Patching, Backup and Recovery, Migration, Memory and Space Management, Cloning, Replication, Reporting, Performance Tuning, RMAN, RAC, Data Guard, OEM Grid Control.

·         Hands on experience in configuration of VM machines for multi-tenant databases.

·         Experience in creation/configuration and maintenance of Container Databases (CDBs) and Pluggable Databases (PDBs).

·         Experience in a variety of hardware platforms including; MS-Windows 2008, 2012, Linux, Sun Solaris, HP-UX & AIX.

·         Worked as a team member to provide 24x7 on-call production database support. 

·         Extensive knowledge on database administration for Oracle E-BusinessR12, Databases 10g, 11g and 12c, with experience with large scale database environment and mission critical large OLTP systems.

·         Extensive knowledge on database backup/recovery strategy (RMAN), Import/Export & Data pump, Capacity Planning, Replication (Streams) standby databases, Oracle configuration management, Data guard, database cloning, refresh and patch management.

·         Good understanding knowledge in RAC and Oracle Streams. 

·         Proficient in all DBA responsibilities such as user management (synonyms/privileges, roles, quotas, table partitioning, index, sequence), space management like Tablespaces, monitoring (alert log, memory, disk I/O, CPU, network activity).

·         Disaster Recovery & Security Management and Documentation. 

·         Experience working with data warehousing (OLAP) applications, transactional database (OLTP) development, installing, configuring, administering, managing oracle databases, implementing solutions like High Availability (HA), Disaster Recovery, Cloning, and Database Security. 

·         Hands on experience in creating application contest packages for Virtual Private Database (VPD) configuration.

·         Hands on experience in Oracle 10g/11g and 12c RAC implementation & administration (Oracle Cluster-ware setup and configuration, RAC Installation using ASM, Grid Installation.), Patching, RAC Backup, adding a node to existing cluster database for High Availability and Recovery. 

·         Experience in Implementing, configuring, trouble shooting, switchover, failover of Physical Standby Data Guard on 10g, 11g and 12c.

·         Configured and maintained replication using Oracle Golden Gate.

·          Experience in Cumulative and Differential Incremental backups using RMAN. 

·         Having good knowledge on EXADATA and Involved in moving databases from EXADATA to RAC environment.

·         Used ADDM (Automatic Database Diagnostic Monitor), AWR (Automatic Workload Repository), and ASH (Active Session History) for analyzing the database performance and tuning.

·         Experience in Database Upgrades in 10g, 11g and 12c.

·         Experience in Data Migration using Data pump utility, Non RAC to RAC and Non ASM to ASM.

·         Database Refresh from Production to Development and from Development to Test environments.

·         Replication of tables to cross platform and Creating Materialized Views

·         Managing Table/Index segments, Rollback Segments, Undo Segments, and Constraints. 

·         Planning and scheduling Physical Backups (offline/online) and Logical Backups.

·         Experience in implementing Flash Back Pointing Time Recovery.

·         Experience in Space Management by Monitoring and Managing Tablespaces.

·         Configured network components like TNSNAMES, Names Server, Connection Manager, etc. For easy and effective management of Oracle networking. Configured Listener for external procedure calls.

·         Performance Tuning of SQL statements and Database using tools like Explain plan, TKPROF, SQL Analyze, STATSPACK and Dynamic Performance Views.

·         Monitoring Alert log for any errors and issues.

·         Communicated and interfaced with Oracle support via Metal-link to troubleshoot day-to-day database issues. 

·         Experience in UNIX shell programming. 

·         Expertise in Oracle 11g, ASM, RAC, OEM, Data Guard, RMAN and Shell Script

·         Knowledge of data flow diagrams, data dictionary techniques, CASE tools, Entity-relation modeling and design techniques.

 Professional Profile

 

 

Oracle Database Administrator

DXC Technology                                                                                                      April 2017 to Present
El Paso TX

 

 

RESPONSIBILITIES:

·         Responsible for logical and physical database design, implementation, transforming logical data models into physical databases, and defining strategies for database implementation, high performance, streams & failover. 

·         Maintenance and troubleshooting of oracle network files like listener.ora, tnsnames.ora and sqlnet.ora.

·         Created tablespaces, tables, users for custom applications. 

·         Created and managed database objects such as tables, indexes, partition tables and views.

·         Creation of Materialized views and partitioned the oracle tables to improve reporting performance.   

·         Creation and configuration of VM machines for multi-tenant databases

·         Creation and configuration of CDBs and PDBs

·         Worked on recovering of database in case of Media Failure, Block Corruption, missing data files and accidental tables dropped.

·         Creating and dropping of Users, granting and revoking permissions to users/roles as and when required.  

·         Implemented backup/recover strategies using HOT backup, COLD backups RMAN and Export/Import utilities. Configured and maintained replication using Oracle Golden Gate.

·         Migration of large data from Exadata to RAC clustered environment.

·          Migration of standalone databases to RAC and ASM.

·          Hands on experience in creating application contest packages for VPD configuration

·          Created login triggers to monitor users access in the database using VPD technology

·          Created synonyms, objects and grants on security packages to users

·          Created and applied security policies to VPD tables

·          Creating duplicate databases for RAT Testing, and moving databases from EXADATA to RAC  

 environment.

·         Successfully implemented physical standby database using Oracle Data Guard feature for High availability configuration. 

·         Installed OEM Grid Agents on UNIX, LINUX and Windows for monitoring of production databases.

·         Implemented Oracle Database 11g, 2 node Real Application Cluster (RAC) using Oracle Cluster ware for achieving high Availability on ASM. 

·         Setup and maintain RMAN backup and recovery strategy for RAC and Single instance Databases.

·         Worked on Oracle 9i to 10g/11g migration projects with low maintenance window and applied patches to various databases.

·         Worked on OEM Grid Control 11g, scheduling and troubleshooting OEM jobs and deploying OEM agents. Scheduling Backup Jobs and troubleshooting failed jobs through OEM GC. 

·         Disaster recovery implementation using physical standby databases for high availability. 

·         Worked for Incident & Problem Management and Change Release Management to meet business SLAs (Service Level Agreement). 

·         Monitored the Performance of the migrated databases using grid Control and features AWR, ADDM, ASH and generated the reports for metric collection and health check of the databases. 

Oracle Database Administrator

Hewlett Packard Enterprise                                                                        February 2017 to April 2017
El Paso TX

 

 

RESPONSIBILITIES:

·         Performed capacity planning, design, and installation, configuration and deployment of Oracle 11g database within the computing environment.

·         Installation and management of RAC multi-node cluster.

·         On-Call 24x7 DBA support for production databases. 

·         Perform database upgrades, migrations and installation CPU and on-off patches as needed.

·         Perform reorganization of database structures as needed as well as redistribution of datafiles to improve I/O performance.

·         Work with software vendors and Oracle support to ensure all database and application related issues are resolve timely and efficiently.

·         Performance tuning and optimization of Oracle applications and databases (Database Buffer cache, Library catch, Dictionary catch) AWR reports, SQL Trace, explain Plan. Identify problems and implement solutions; ensure the database is running at optimum speed and efficiency.

·         Engineer System Administration-related solutions for various project and operational needs.

·         Install new / rebuild existing servers and configure hardware, peripherals, services, settings, directories, storage, etc. in accordance with standards and project/operational requirements.

·         Develop and maintain installation and configuration procedures.

·         Apply OS patches and upgrades on a regular basis, and upgrade administrative tools and utilities. Configure / add new services as necessary.

·         Perform ongoing performance tuning, hardware upgrades and resource optimization as required and configure CPU, memory, and disk partitions as required.

·         Perform daily system monitoring, verifying the integrity and availability of all hardware, server resources, systems and key processes, reviewing system and application logs, and verifying completion of scheduled jobs such as backups.

·         Perform daily backup operations, ensuring all required file systems and system data are successfully backed up to the appropriate media, recovery tapes or disks are created, and media is recycled and sent off site as necessary.

 

 

Oracle Database Administrator                                                                         September 2014 to Feb 2017
Technology Group Associate - Atlanta, GA

 

·         Installation and management of 2-node RAC cluster on Linux.

·         Implementation of physical database  and database changes per logical design

·         Performed upgrades and migrated several oracle 9i  databases to 10G

·         Created procedures, functions, packages, triggers, views, tables, indexes, table partitions, Partitioned indexes; synonyms and db links.

·         Interface with vendors, project implementation groups & end users for efficient service delivery.

·         Performed data loading using SQL Loader, Export/Import, Data Pump.

·         Managed database security - created users, roles, grating and revoking of privileges as required.

·         Managing database storage  and database space utilizations

·         Interface with vendors, project implementation groups & end users.

·         Attend DBA group in weekly change management meeting, where all planned production changes is approved prior to deployment.

·         Installing new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database. Plans and implements backup and recovery of the Oracle database. Assists with impact analysis of any changes made to the database objects. Troubleshoots with problems regarding the databases, applications and development tools.

·         Setup and maintain RMAN backup and recovery strategy for RAC and Single instance Databases.

·         Worked on Oracle 9i to 10g migration projects with low maintenance window and applied patches to various databases. 

·         Design, deployment, and management of enterprise Backup and Recovery strategies, using RMAN, Import/Export, Data Pump.

·         Proactively monitoring and tuning of database performance using AWR and ADDM.  Tune the various components of the database – Memory, CPU, I/O, and SQL statements.

·         Creation and management of database objects – tables, Indexes, views, synonyms, snapshots, materialized views, stored procedures, triggers, table partitions and partitioned indexes.

·         Develop and implement an Incident Reporting and Response System to address security incidents (breaches), respond to alleged policy violations, or complaints from external parties.

 

 

Information Security Analyst                                                                                      April 2010 to June 2014
Mczoll Resources Ltd, Abuja - Nigeria

 

·         Ensures operation of equipment by completing preventive maintenance requirements; following manufacturer's instructions;

·         Troubleshooting malfunctions; calling for repairs; evaluating new equipment and techniques.

·         Completes reports by recording observations, information, occurrences, and surveillance activities; interviewing witnesses; obtaining signatures.

·         Develop and implement an Incident Reporting and Response System to address security incidents (breaches), respond to alleged policy violations, or complaints from external parties.

·         Installing new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database. Plans and implements backup and recovery of the Oracle database. Assists with impact analysis of any changes made to the database objects. Troubleshoots with problems regarding the databases, applications and development tools.

·         Setup and maintain RMAN backup and recovery strategy for RAC and Single instance Databases.
Worked on Oracle 9i to 10g migration projects with low maintenance window and applied patches to various databases.

·         Design, deployment, and management of enterprise Backup and Recovery strategies, using RMAN, Import/Export, Data Pump.

·         Proactively monitoring and tuning of database performance using AWR and ADDM. Tune the various components of the database – Memory, CPU, I/O, and SQL statements.

·         Creation and management of database objects – tables, Indexes, views, synonyms, snapshots, materialized views, stored procedures, triggers, table partitions and partitioned indexes.

·         Develop and implement an Incident Reporting and Response System to address security incidents (breaches), respond to alleged policy violations, or complaints from external parties.

 

 

 

EDUCATION

BS – Computer Science - Auchi Polytechnic, Auchi – Nigeria.

MSc., - Strayer University (In Progress)