32 Olaniyi Street Abule Egba Lagos, Nigeria

ADELUSI BENARD SUNDAY

32 Olaniyi street abule egba Lagos, Nigeria

Telephone number: +234 8038503784

E-mail:

CERTIFIED DATABASE CONSULTANT PROJECTS MANAGER

ICT BACKGROUND

Benard is a database technologist DBA/consultant for DataSci Ltd. He’s specialized in Oracle Database Management System since 2009, with his main interests in high availability and disaster recovery solutions for mission critical 24x7 systems. He is a proud member of the Oracle Certified Professional community. Benard enjoys giving various high availability training courses and presentations for different clients and usergroups.His current position involves running a team that develop best practices for the Oracle Grid Infrastructure, including products like RAC (Real Application Clusters), Storage (ASM), and DataGuard

Project Delivery

Soft Alliance and Resources Ltd Oct 2015 till date

Achievements in the first four month

Relevant experience in Oracle APPS DBA R12 with mimimum end to end upgrade implementation project.with in depth Oracle Database Administration experience including RAC, ASM, R12 , Upgrade from R12.0.4 to R12.2 on Solaris sparc OS, worked with System/OS Engineer to Set up a Solaris Sparc server,Create database and application software owners,Create a stage area for software install target.

Upgrading Oracle EBS r12.0 to r12.2.4 and database 10.2.0.4 to 11.2.0.4 with the following task,

Disk Space Requirements gathering

initialize parameter file tuning to suite 11gr2 enviroment

investigate against Duplicate Records for product hub with apps user

Gathering of schema statistics

generating a materialize view to refresh database

Update init.ora with upgrade parameters

Set FAILED_LOGIN_ATTEMPTS to UNLIMITED for Oracle E-Business Suite schema

Disable custom triggers, constraints, and indexes

Enable Maintenance Mode

Apply AD 12.2 upgrade driver

Apply all Consolidated Upgrade Patches (CUPs)

Run the American English upgrade patch driver

Reset init.ora parameters

Review Security Practices

Configure Release 12.2 E-Business Suite instance

Upgrade considerations for Add-on Localization products

Using Solaris ZFS snapshot to take backup

First City Monument bank (FCMB) January 2015 till date.

Achievements in the first three month at First City Monument bank (FCMB)

Carried out a comprehensive assessment of the environment and made recommendations.

Identified finacle queries for performance tuning.

Investigated performance and capacity issues in finacle databases and made recommendation.

Implemented recommendation that reorganized the physical structure of the database.

Resized the database memory components, this helped to stabilize the fnacle environment and improved the performance.

Collaborated with application team to fine-tune some performance related queries.

Recommended Increase in the arhivelog filesystem and reduced the frequency of archivelog backups. This helps to reduce contention on controlfile and consequently improved performance

Designed and setup the test database servers for oracle 12c ,d 11g deployments

Installed and deployed oracle 12c on finacle databse test server.

Installed and deployed 11g. Clients on finacle applcation server.

Installed 12c software on CSIS and WAS servers.

Installed, upgraded and patched Oracle software. Setup brand new machines including

Oracle software installation, Oracle side configuration, troubleshooting and backup testing on aix 7.1 power8 server.

Developed some Unix Shell scripts to automate database operation and database monitoring.

Successfully implemented Oracle 12C Cloud Control

Successfully Implemented Oracle Data Guard

Daily Activities

Daily monitoring and analysis of systems to ensure 24x7 stable operations.

Troubleshoot day-to-day database issues to ensure system stability and throughput.

Responsible for Oracle logical and physical databases maintenance on AIX 7.1 power8 server

Performs Oracle database performance analysis, capacity planning, system sizing and ongoing maintenance/tuning to ensure maximum performance.

Performed database tuning using sql developer Toad, client tools, and Enterprise Manager.

Monitoring the database activities using Alert log and trace files for errors to take appropriate actions.

Monitoring space related issues of (data files, table spaces, Disk adding in ASM).

Creating and managing database objects, users, roles, privileges, profiles.

Creation and maintenance of database, space management and configuring database listeners.

Implementing backup and recovery strategies using Hot/Cold backup.

Edo state/world Bank (2014)

Deployment of Oracle12c (OEM) for the Monitoring of all their RAC database.

Preparation of suitable training programme to address the identified gaps which may extend beyond Oracle functional and technical training.

Preparation of training need assessment.

Deployment of Oracle E-business suit on Edo state HP Server for the purpose of the training.

Installation of Oracle 11gr2 and Unix OS on HP Server for the technical Training

Configure the unix OS on HP Server to dynamically access the wireless network.

Trained 30 Edo state technical staff on how to administer Oracle database for their

business needs.

Generate a script to perform day to day Oracle backup.

Migration of datafile from production to Test using DataPump for the purpose of the class training.

Credit Reverence Company (DataGuard) 2014

Technical Responsibility

Configure Enterprise Linux on IBM Server

Installed linux OS and the packages. Setting up OS users and groups

Disk Partitioning Setup Manually with Disk Druid

Configure the kernel parameters. Increased the shell limits.

Configuration of Network Protocols through TCP/IP. Create new file systems.

Register of system and activate the subscription with Oracle to receive automatic updates to the software.

Configure Oracle Automatic Storage Management (ASM). Configure Oracle Cluster File System (OCFS2).

Install Oracle Database 10g Release 2. Configuration of the database and ASM home.

Create standby parameter file (pfile). Set the value of DG_BROKER_START parameter to be TRUE.

Configuring primary database opened in ARCHIVELOG mode.

Creating a Physical Standby Database by Using SQL and RMAN Commands.

Creating a Listener Service for the Primary and Standby Database.

Setup data guard Environment for the Primary and Standby Database.

Starting replication from Primary to Standby and view the shipment from Alert_log.

Perform a Role Transition(UAT)

Switchover Role from Primary to Standby

Nigeria identification management commission (NIMC)

Team Member

Meeting with stakeholder to review current status of all activities

Review AIX environment hardware and infrastructure

Meeting with NIMC Database management team and AIX system Admin team on Design Document

Prepare User Acceptance Test (UAT) for the deployment of RAC,OEM and DataGuard Applicationat the main data center (NIMC HEAD OFFICE)

Technical Responsibility

Creating a Physical Standby Database by Using SQL and RMAN Commands

Verifying That the Physical Standby Database Is Performing Correctly

Creating a Data Guard Broker Configuration

Setting the DG_BROKER_START Initialization Parameter

Creating a Listener Service for the Primary and Standby Database

Creating the Broker Configuration, Enabling the Broker Configuration and Installing the Oracle Management Agent

Configuring Monitoring Credentials for Your Primary and Standby Database

Adding a Physical Standby Database to Your Configuration

Verifying the Broker Configuration and Configuring Data Protection Modes

Setting the Data Protection Mode by Using DGMGRL

Monitoring a DataGuard Broker Configuration Using DGMGRL

Viewing Log File Details

Configuring Network Compression of Redo Data

Configuring Flashback Database on the Primary Database

Configuring Flashback Database on the Standby Database

Performing Switchover by Using DGMGRL, Starting the Observer, Testing Fast-Start Failover

Converting the Physical Standby Database to a Snapshot Standby Database

Backup and Recovery Considerations in an Oracle Data Guard Configuration

Installation and Deployment of Oracle Enterprise Manager (OEM) on production and Development AIX P770 Server.

Add Oracle RAC Agent to OEM

Installation and configuration of Oracle Cluster, RAC Software Installation, Oracle Grid Infrastructure and RAC Database Creation

Managing Backup and Recovery in RAC Environment using RMAN Technology

Tuning of the RAC database for Instance Recovery and Database Availability, Wait Events for RAC and Event Views.

Deployment of Database Vault, Audit Vault and Database Firewall and Oracle Advance security options modules in the Development, Production and Disaster Recovery (DR) site

DATA & SCIENCTIFIC LTD

Datasci sparc server T2000(SPARC 64-Bit):

Design a single client access name (SCAN) address used by all clients connecting to the cluster

Provide three IP addresses in the DNS to use for SCAN name mapping to ensure high availability. Set

the SCAN domain name that is unique within the corporate network.

Using ASM diskgroups for Clusterware OCR and Voting disks and SSH Configuration

Verify the Hardware Requirements for Physical memory, swap space for RAM, Temporary space and a processor type (CPU) that is certified with the version of the Oracle software at a minimum of 1024 x786 display resolutions.

Investigate IP Address Requirements for public, virtual and there single client access name(SCAN) IP address for each node

Create the users that will own the Oracle software, Create OS groups and password for the oracle account.

Configuring Kernel Parameters to values greater than or equal to the recommended values by Oracle

Prepare the shared storage for Oracle RAC

Airtel Nigeria Project (dynamic sim allocation)2013

Technical Responsibility

Verifying that all applicable requirements are met for installing an Linux operating system.

Evaluate and select an installation method that meets the needs of the infrastructure.

Verifying that the factory default settings in the BIOS are set prior to performing the operating system installation.

Configuring Enterprise Linux on Sun Server X3-2

Installed linux OS and the packages. Setting up OS users and groups

Disk Partitioning Setup Manually with Disk Druid.

Configuring the kernel parameters. Increased the shell limits.

Configuration of Network Protocols through TCP/IP

Configuration of Logical volume manager to allocate hard disks to logical volumes via RAID

Increase partition sizes of the filesystem

Register of system and activate the subscription with Oracle to receive automatic updates to the software.

OS Server Hardening

Configuring Physical System Security, Configuring Packages to Minimize Vulnerability.

Disk Partitions to obtain higher data security in case if any disaster happens.

Disabling of unwanted service that are running. Configure Secure Shell to allow Specific Users.

Enabling Security-Enhanced Linux. Configuring system to Restrict Users to Use Old Passwords.

Enabling Iptables (Firewall). Disable Ctrl+Alt+Delete in Inittab.

Configuring the system to Keep /boot as read-only

Kyramix Technologies LTD 2010

General Linux administration for oracle ERP

Define and develop processes and documentations on daily, weekly, monthly, bi-annual checklist and reports on Unix monitoring and administration Requesting of Data Centre infrastructure e.g. Space and patching, Develop and document backup and restore procedure

Oracle E-business Suites Implementation and Support DBA and System administrator

Oracle E-Business Suites Customization, Application Desktop Integrator, applying Patches and other E-Business administrative task

Implementation of Recovery Manager (RMAN) for backup of Database running on Oracle 11.5.10

Application. Provision of Shell Scripts to automate RMAN backup. Creation of standby Application / Database on oracle E-Business suite.

FCMB NIGERIA 2012

Database migration of Oracle 10g from Linux environment to AIX Server, using datapump utility

Operating Systems

General UNIX/Linux Shells

Installation of the Red Hat Linux ES 3.0, AS 4.0 & Enterprise 4.5, 5.4 versions, Sun Solaris 10,

Ubuntu 9, Fedora 7

Managing file systems and disk in the Solaris 10 and general Linux/UNIX operating system environment

Configuration of Logical volume manager to allocate hard disks to logical volumes via RAID and

increase partition sizes in the general UNIX/Linux OS

Configuration of Samba Server to share files between Windows and general UNIX/Linux

Configuration of Network Protocols through TCP/IP

Dynamic Host Configuration Protocol (DHCP)-TCP/IP

Develop automating scripts to monitor UNIX resources, processes, available disk space, disk and network performance and log files Configuration of peripherals sharing on a network (printers etc.) Performing system backups and restores, mounting external file systems FAT32

Shell scripting and crontab utility to automate system maintenance and scheduling of backups Problem determination and handling (Ability to analyze and interprets OS logs and gather system information) Experience in design, repair and manage UNIX systems

Clear understanding of UNIX system architecture (kernel, processes, I/O, file trees and more)

Oracle & Oracle ERP

Installation of Oracle 9i, 10g R1 & R2 and 11g R1 & R2 database on all versions of

Red Hat, Solaris 10, Ubuntu 9, Fedora 7, IBM-AIX, Windows XP

Installation of Oracle E-Business Suite 11i on Red Hat ES 3.0 & Windows Server

Installation and configuration of Oracle SQL developer, Oracle instant client, Oracle
enterprise manager client to query and administer the database remotely.

Perform maintenance and performance tuning of oracle database on

Oracle data pump utility to transfer data between databases Data Migration on oracle database

Implementing data guard for disaster recovery

Oracle Database Backup and recovery (Both user managed and RMAN based)

Cloning of Oracle databases to remote host Configuration and implementation of Transportable table spaces between databases of different environment format.

Upgrade of Oracle databases

Installation and configuration of Oracle ASM instance

Analyzing database performance and tuning for effective database performance

Automation of business transactions with the use of Oracle 11i Application and assigning of different responsibilities to users.

Enrolling of System users to use the Oracle Application and planning their Oracle Network access.

Monitoring Database Performance and recovering from database failures.

Create tablespaces, tables, and users for custom built applications

Implementation of Recovery Manager (RMAN) for backup of Database running on Oracle 11.5.10 application.

Provision of Shell Scripts to automate RMAN backup.

Cloning of Oracle E-Business Suite Application 11.5.10

Proper sizing of SGA and PGA based on running single instance as well as adapting with current database size and planning for growth

Installation, repair, management and administration of UNIX/Linux system

UNIX system security and monitoring of system for performing bottlenecks Installation and configuration of Oracle 10g Database on Linux operating system.

International Certifications

Oracle Database Certified Professional (10g)

Oracle Database Certified Associate (10g)

Oracle Database Certified Professional (11g)

Oracle Database 10g R2: Administering RAC

Oracle 11i E-Business Suite Essentials

Sun Solaris Certified System Administrator

Sun Solaris Certified System Professional

Enterprise Linux System & Implementation Administrator

Enterprise Linux System Specialist

Microsoft Certified Technical Specialist

Microsoft Certified Technical Specialist SQL Server 2005

Microsoft Certified Project 2007

Itil v3 foundation Certified

EDUCATIONAL INSTITUTION BACKGROUND

NIIT Education & training Centre 2005-2007

University of Ado Ekiti, Ekiti State1999-2004 B.Sc. (Hons) Business Administration

Second Class Lower Division

Unity Secondary School Ado Ekiti, Ekiti State1990-1996

Training Carried Out

Course / Company / Date
Unix Essentials/Oracle / CONOIL / July, 2012
Oracle Database Administration 1 / UBA / August, 2011
Oracle 10g: SQL Fundamentals / ASHAKA CEMENT / September, 2009
Unix Essential / Alcatel Nig / September, 2010
Oracle Database Administration 1&11 / Nigeria Custom / November, 2010
System Administration for the Solaris / Chronicle GN Oil & Gas Ltd / April, 2010
MS Project / NIMASA NIG / October, 2010
Unix Essential/Oracle Fundamentals / FIRS/ITAS / September, 2012
Oracle Primavera / Chevron Nig / December 2012

INTERESTS: Enjoys board games like chess and scrabble, and also physical exercises.

REFERENCES: Available upon request.