Busayo (BJ) Adeyemo

adkzvn@r.postjobfree.com

240-***-****

Professional Summary

An Oracle DBA (SME) with over 14 years’ experience on Oracle Database Administration and on various operating systems such as Linux, UNIX (HP UNIX and Solaris), ODA (Oracle Database Appliance), EXADATA, VMware, ORACLE VM VirtualBox, Oracle Cloud platform, Windows NT, Windows 2000/2003 and SQL Server on Windows 2008 and 2012 Server

Experience in Development, Test and Production Environments

Experience in Data Center migration Production Environments

Expert in Managing Oracle Databases on Windows, Solaris, Linux, Aix and HP

Expert in Performance Tuning, Sql Tuning and Core Oracle Database Administration

Expert in Data Guard, Streams, RAC and Grid Control

Install and configure 12C multiple Physical standby databases and data broker

Configure Transparent Data Encryption (TDE) in oracle 12c (Data level encryption)

Configure Enterprise User Security (EUS) – Password Authentication User level login Encryption using LDAP directory

Expert in Oracle Backup and Recovery

Experience in a 24/7 High Availability and Mission Critical Environments

Expert in Database Upgrade, Migration and Patches

Experience on DOD System and supported on 24X7 operations

Design and develop logical and physical database designs from customer requirements.

Expertise in security, monitoring activity, installation, backup and restores, recovery, tuning and SQL & PL/SQL

Experience in working as SQL Server DBA as well as Sql Server Integration Package

Experience in SqlServer Backup/Recovery, Database Administration and Performance Tuning

Successfully implemented Oracle11g(R2) RAC: ASM storage devices, RHEL4/3

Install, Configure, and Create RAC CRS and Database Instances by using Response files (silent installation) and SRVCTL commands

Install, Configure, and create Oracle Database Instances on Oracle Database Appliance ODA X7-2 bare metal

Setup Data Guard for production RAC Database in Physical Standby Architect

Hands on experience in Oracle advanced technologies such as 10g, 11g RAC, OEM, Grid Control, Data Guard (both logical and physical), partitioning, RMAN

Implemented a standby database operation using Oracle 10g, 11g Data Guard for data loss and also provides graceful switchover and switchback between sites for a planned OS and hardware maintenance

High-volume production database support, Oracle Fail Safe implementation (Data Guard), backup plans and implementation, Performance monitoring and tuning (Statspack)

Experience in implementing and using of Oracle 11g new features like Data Pump, ASM, Flash Back Technology, Transportable Tablespaces and Automatic Workload Repository

Planning and scheduling Physical Backups using RMAN and Manual methods and Logical Backups (Full, User, Table)

Oracle Installation, upgrade and migration (Oracle 9i, 10g and 11g )

Shell scripting for automating, monitoring and performing routine database jobs

PostgreSQL configuration and troubleshooting

Well Knowledge on EXADATA and migration of database from LINUX Servers to EXADATA server

Experience in SQLCMD and power shell shelling on Windows using Toad, Sql developer .

Vibrant team player with belief in taking positive appoach towards issue resolution

Solid knowledge of Cloud Computing and concepts and AWS services: EC2, VPC, Auto-scaling, Elastic Load Balancing (ELB), S3, EBS, Glacier, RDS, CloudFront, Route53, CloudWatch, CloudTrail, CloudFormation, IAM, SNS and so on

Technical Summary

Platforms:

UNIX, Linux (Red Hat, Centos, Fedora, Ubuntu), AIX, HP-UP, Windows (NT/2000/2003/2008)

Databases:

Oracle 9i and 10g, 11g, ODA (ORACLE DATABASE APPLIANCE), PostgreSQL, MS SQL Server 2000,2003,2008

Languages:

C++, Java Script, Java, HTML, SQL, PL/SQL, UNIX shell scripting

Tools:

Microsoft Office Suite (Word, Excel, Outlook), Oracle Enterprise Manager (OEM), SQL-Navigator, Oracle SQL Developer, Toad, Erwin, putty, Grid control, Winscp, RACCheck, OSWatcher and Swing bench

AWS: EC2, VPC, LAMP (Apache), Beanstalk, IAM, Route53, Autoscaling, Load Balancer, Cloud formation, RDS, AMIs, S3, Workspace. Automation tools: Ansible, Git, Terraform, Puppet

Applications

Hardware

PeopleSoft Enterprise Portal 9.0, PeopleTools 8.49, PeopleTools SQR, Tree Manager, Data Mover, Application Designer, Crystal reports, SeeBeyond 5.0, Weblogic, Tuxedo, and Microsoft Dynamics GP (Great Plains) 9.0, Oracle Application server 10gR2, Oracle Identity Management Provisioning Console, Oracle collaboration suite 10gR1, JIRA (Bug & Issue Tracking System), Bugzilla, Frontline ticket system, Kbox Systems Management Appliance, Deltek, Ultimate Software.

IBM Regatta p690+, Colfax CX7200 Blade, Blade Center JS22 Express Blade, ODA (Oracle Database Appliance), EXADATA X2-2

Professional Experience

NeoSystems Datacenter Tysons Corner, VA 10/2018-Present

Oracle DBA Migration SME

Clients: CACI, BLUEORIGIN, MAXIMUS, DELTEK, NetSuite, Abila, Saviom, IBM, Integrify, Ultimate Software

.

Install and Configure Oracle Database Appliance ODA X7-2 bare metal for Two Node RAC Env in our Data Center.

Migrate Oracle Database servers from in house server Env to ODA X7-2 (Oracle Database Appliance) for all Clients.

Install different version of Oracle database products from 11G to 19C on the ODA X7-2 (Oracle Database Appliance).

Install and configure Active Oracle Data Guard with Data Broker for management on the ODA X7-2 (Oracle Database Appliance).

Apply quarterly patch bundle on the ODA X7-2 (Oracle Database Appliance).

Maintain and proactively monitor the Oracle Database Appliance using the ODACLI commands.

Install and configure RedHat Oracle Linux 6.5 and 7 for our single instance database servers.

Install and Configure Oracle 12c, 13c and 19c on Windows servers for All Database life Cycle.

Apply and Patch Critical Patches on both Linux and Windows Database servers.

Create customize Shell and Bash scripts to monitor, schedule and maintain database activities and jobs.

Configure and Maintain ZFS storage attachment on the ODA for all Production database backups and retentions policy.

Write SOPs for all work performed and implemented on the ENV.

Attend different meetings will all our client to discuss application status, growth, expectations and future plans,

Write backup scripts, perform daily RMAN backup and test restore procedure for each database customers base on clients SLA agreement.

Analyzed and studied Database growth using capacity planning techniques.

Performed a daily Data pump export and import for all Critical application schema as a second measure of backups strategy.

Gathered OS Logs for each OS Platform to troubleshoot storage (ACFS/ASM/DNFS/DBFS) issues.

Support all version of Oracle databases and application on Oracle Cloud platform.

Install and configure Oracle OEM 13C on Oracle Enterprise Linux 6 and push all agents to all application and database servers.

Install and configure AWS Plugins on Oracle OEM 13c to connect AWS services.

Install and Configure ZFS.

CACI Fulton, Md 07/2017-10/2018

Oracle /DevOps

Installed Oracle 12.2.0.1 on Production environment.

Upgraded Oracle container and pluggable databases from 12.1.0.2 to 12.2.0.1.

Created scripts to monitor all the pluggable databases.

Shell Unix scripting for automating, monitoring and perform Oracle password changes and Oracle Wallet.

Experience in SQLCMD command line and power shell command line Windows server for job scheduling and automation.

Created shell Unix script to monitor jobs, alerts and more.

Installed Oracle Wallet for AWS instances on EC2.

Applied Oracle quarterly PSU patch 12c to both GRID HOME and Oracle RDBMS Home.

Worked on multifactor Database login using LDAP for security.

Managed 4 node RAC Instances on RedHat 7.

Created, tested and implemented backup and recovery policies for both existing database and AWS databases.

Implemented 12C active Data guard.

Created new EC2instances, Subnets, Routing tables, ACLs, IGW, and NET Gateways ELB.

Provided technical and functional hands-on expertise to plan, analyze, designed Oracle infrastructure.

Designed solutions, performed demo for the Gaps solution from standard Oracle Database solution sets as well customized solutions.

Managed the development of infrastructure for the ERP Program.

Participated in the design and development of the infrastructure components of the architecture strategy.

Implemented Oracle 12c database on Oracle Cloud platform using fedora 28.

Worked with Developers for any issues with Code reviews, performance, and tuning.

Worked on SOP documentation updates and releases.

Reviewed daily Oracle backup jobs, logs, traces file, tickets and any outstanding tasks.

SYNAPSE BUSINESS SYSTEMS Fairfax, VA 01/2015-07/2017

Oracle /AWS Admin

Installed Oracle 12C on Test and development environment.

Created container and pluggable databases.

Created scripts to monitor all the pluggable databases.

Shell Unix scripting for automating, monitoring and performing routine database jobs

Created shell Unix script to monitor jobs and alerts.

Implemented weekly refreshes from Prod to Test using Standby Database.

Cloned Prod database to Test for Developer purposes.

Managed capacity planning for Prod database.

Implemented data pump using rep map schema, tablespaces.

Implemented transportable tablespace to migrate database from 11g to 12c.

Implemented and migrated Oracle database in we8mswin1252 to AL32UTF8 character set using DMU on Dev, TEST and PROD

Plugged Non-CDB into an existing CDB database using DBMS_PDB_Package.

Troubleshot SQL Server related CPU, memory, I/O, disk space and other resource on both Prod and Dev ENV

Performed backups, restores, recovery and cloning on Oracle database Server using RMAN.

Researched and documented space usage on both ASM and OS level for capacity planning.

Experience in SQLCMD command line and power shell command line Windows server for job scheduling, using Toad and Sql developer for SQL command line utility.

Migrated all DEV and Test databases from our Texas West coast Data center to Virginia East coast data center

Applied Oracle PSU patch 12c on GRID HOME and Oracle RDBMS Home.

Performed daily Oracle refresh from PROD to DEV ENV.

Troubleshot Oracle Clusterware for ASM errors and CRS errors.

Installed and configured 12C three Physical standby databases and data broker.

Managed Amazon EC2 Oracle 11G instance running Redhat Linux with 11.2.0.3 binaries installed and a running 11g database.

Installed 12C CDB and PDB Oracle RAC databases with encryption Tablespaces along with TLS1.2 setup and EUS advanced security.

Installed OS watcher on out RAC database 12C Environment to troubleshoot node evictions due to bad Motherboard and NIC.

Troubleshot and Fix patch issues with restricted mode and missing patches errors on PDB and CDB.

Worked on AWS Amazon Cloud, installed Oracle software on AWS, created VPC, created and managed EC2 instances.

Used Cloud Watch to manager and monitor all Oracle instances, CPU utilization, resources and all Application running on AWS.

Managed 12C Database instance on Exadata Database Machine.

Migrated Oracle 12C database from LINUX Servers to Exadata Database Machine using the “RMAN 11g Duplicate standby from Active database” command.

Configured Security groups for both private and public cloud for controlling the inflows and outflows of traffic.

Created a secure VPC for both private and public cloud.

Designed complex solutions which integrate AWS cloud, On premise physical and Virtual server, EC2, S3 storage, networking and security.

Managed and monitored AWS infrastructure, Linux, and Windows components.

Ensured proper security measures has been taken before onboarding any application on Public Cloud.

Installed AWS Puppet Master on the master server and puppet Agent to all servers manages on AWS.

Used Ansible as an automation tool for deploying of Instances on AWS environment, creating and deploying of VPC on AWS, and or creating S3 buckets, subnets, security groups, route tables and ACL’s for VPC creation.

CSC (Computer Science Company) Baltimore, MD 01/2014-01/2015

Oracle DBA

Administered databases throughout the development and production lifecycles.

Designed and developed logical and physical database designs from customer requirements.

Completed all database fixes as required

Provided technical support for all ad-hoc database extracts and reports

Maintained the Data Dictionary for CMS (Center for Medicare & Medicaid Services) ASET II databases on Linux Platform.

Implemented Oracle data conversion plan strategy for our legacy database to the new CMS Enterprise database.

Maintained the databases in Development and Prod environment

Updated the database in Development as needed for each Release

Provided final copy of Database deliverables to PM for delivery to CMS/ OESS

Developed the conversion process as needed for Database changes; executed in development, validated and refined process.

Administered tasks for Oracle databases on both Windows and Linux platforms.

Modified the database design during system testing.

Documented Version Control Procedure.

Executed the final conversion in DEV as part of the PROD deployment; copy the tables to PROD and validate the results.

Established and practiced a consistent database backup and recovery practice that complies with the backup and retention policies and business continuity practices.

Installed and configured Oracle Restart 11gR2 on Linux Redhat.

Refined and managed baseline configurations for the enterprise database environment.

Provided 24x7 operational supports for all databases on a rotating schedule, after hours on-call support and apply production packages during non-peak hours.

Provided the implementation of replication, virtualization backup tasks.

Acted as subject matter expert for all database systems.

Maintained, scheduled and troubleshot all RDBMS related software Oracle Enterprise Manager (OEM) Cloud Control 12C on Linux Environment.

Laureate Education, Inc. Baltimore, MD 08/2012-01/2014

Oracle / SQL SERVER DBA

Refreshed Prod database to Development database on Linux and Windows platform.

Performed ongoing tuning for Oracle and SQL Server database instances.

Installed and configured PostgreSQL on Linux and Windows environment.

Troubleshot PostgreSQL on both Linux and Windows environment.

Reviewed RMAN backups and error logs, ASM disk usage, OS Disk utilization

Planned and implemented daily backups and recovery for Oracle 10G and 11G databases.

Applied PSU Oracle Database Patch to all RDBMS home on both Dev and Production environment.

Installed and configured SQL server 2012 database on Dell Servers.

Applied patches and service packs to keep the database at current patch level.

Developed SQL scripts for maintaining administration tasks.

Upgraded Microsoft SQL server 2008 to 20012 using SQL Advisor and Installation Wizard.

Performed different types of backup strategies and demonstrate how to implement each of these types of backups using Enterprise Manager, the graphical user interface (GUI), and Transact SQL (T-SQL) in Microsoft SQL Server 2008 and above.

Cloned and refreshed Prod database to Development database on Linux platform.

Performed ongoing tuning of four node cluster database instances running on both 10g and 11g.

Installed new versions of the 11G2 (11.2.0.3) Oracle RDBMS and its tools and any other tools that access the Oracle database on Redhat 5.

Planned and implemented daily backups and recovery for Oracle RAC environments.

Performed Oracle backup and recovery scenarios exercise for both single instance and RAC environments

Implemented and enforced security for all of the Oracle Databases in all the environments.

Assisted with impact analysis of any changes made to the database objects from Developers.

Troubleshot node eviction in 2 node RAC on Production environment.

Reviewed RMAN backups and error logs, ASM disk usage, OS Disk utilization.

Troubleshot Row lock contention using Oracle Grid control 12C.

Diagnosed Locking Problems using ASH, AWR and SNAPSHOT.

Using Automatic Database Diagnostic Monitor (ADDM), analyzed data in the Automatic Workload Repository (AWR) in order to identify potential performance bottlenecks.

Installed and configured Oracle Enterprise Manager Cloud Control 12C on OEL 6.1.

Installed and configured Oracle Grid Control Agent 12C using the Push method on all Production and Development servers.

GSA (General Services Administration) Washington, DC 09/2011-08/2012

Oracle RAC DBA

Installed OS Watcher and RACDDT to address and troubleshooting issues on a RAC Database.

Installed and troubleshot RAC database using raccheck utility.

Installed and configured Oracle Spatial 11g on Enterprise Linux and RedHat.

Monitored, patched, backed up and upgraded Oracle Spatial 11g repository database.

Applied PSU 11.2.0.2 Oracle Database Patch to all RDBMS home on both Dev and Production environment.

Applied PSU patch 11.2.0.2.3 to all Grid infrastructure and Oracle homes on all nodes on the clusterware on both Dev and production environment.

Upgraded Oracle database 11.1.0.7 to 11.2.0.2 residing on Sun Solaris sparc 10 on Test, Dev and Staging environment.

Installed and configured Two node Rac 11gR2 (11.2.0.3) on Oracle Database Appliance (ODA) Release 2.2 for Linux x86-64.

Installed and configured Oracle 11g RAC/ASM two node cluster on Solaris SPARC 64 bits With SAN Storage.

Added and Deleted Nodes from Oracle RAC 11R2 on both DEV and PROD environment.

Installed and configured Weblogic cluster 10.3 on Sun Solaris SPARC 64 bits.

Installed and configured Oracle Enterprise Manager Grid control 11g and added an additional Management Service on Sun Solaris SPARC 64 bits.

Setup Streams replication using Schema and database bi-directional replication between two nodes cluster database on production

Added raw disk to ASM disk group, create and maintain ASM database instances.

24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues

Installed 10g and 11g databases on SOLARIS and HP-UX

Upgraded databases from 10g to 11g and applying patches.

Installed and configured Oracle 10g/11g RAC high availability.

Installed Oracle clusterware, configured public and private network and VIP.

Experienced with SRVCTL, CRSCTL, OCR and Voting Disk of 10g/11g RAC.

Implemented and maintained Physical DATAGUARD (Standby) for high availability/disaster recovery purpose using Rman Duplicate on Solaris SPARC 64 bits.

Cloned database from Production to both Test and Development environments.

Configured and maintained huge OLTP databases.

Created database maintenance plans, rebuild indexes and integrity checks

Implemented RMAN Backups, Creation of catalog database.

Recovered database (recovering from Media Failure, recovering tables dropped accidentally, recovering data files, recovering from Block Corruption).

Performed full and incremental backups using RMAN.

Wrote UNIX shell scripts for backup and recovery, Import and export procedures.

Installed and configured Oracle Identity Management 11g R1 PS2 (11.1.1.3) for Oracle Identity Management (OIM) and Oracle Access Manager (OAM).

Started and stopped Weblogic Server, Oracle Identity Manager, SOA Server.

Troubleshot and verified Oracle Internet Directory Identify stores can perform look ups.

Transferred Oracle Identity Manager Configurations between environments.

Troubleshot Identity Manager Server by checking all the log and trace files.

DoD (Joint Improvised Explosive Device Defeat Org (JIEDDO))

Crystal City, VA 2/2010-09/2011

Oracle DBA Lead & Systems Administrator

Performed and maintained 24X7 daily database administration on production and development environments system at the DoD office location.

Installed, configured and tuned Oracle products for both client-side deployments and in-house testing and production, including, but not limited to: Oracle Databases, Oracle Clients, Oracle RAC 11g plus ASM, Oracle Grid Control 11g on RHEL 4, Data Guard (implement both physical and logical standby), Weblogic 11g, Oracle Collaboration Suite on Unix servers (HP, Linux) and Windows servers (Win 2008).

Responsible for refreshing and cloning of databases per customer requirements using RMAN, Data Pump, and hot backup scripts.

Consolidated several production, test, and development multi-terabyte databases by migrating from UNIX environments to AIX Virtual Partitions (vPars).

Performed preventative maintenance, applying Oracle database security patches (CPU), patch sets (PSU) for 10g and 11g versions, database upgrades, database migrations and repair any system and operating environment problems.

Performed daily backup and recovery for numerous Oracle 10g and 11g Databases using Physical back (RMAN) and logical backup (export, import and Datapump).

Used SQL for implementation such as generate data, queue data, modified, alter, update the database and schedule daily performance techniques.

Maintained Oracle Collaboration Suite Rel 10G (Web Conference, Files, Calendar, and Email) on Linux Environment.

Maintained Oracle Application server 10gR1, start, and shutdown and backup all the application containers and patch all the JAVA JDKs and JREs.

Supported top officials.

National Geographic Society Washington, DC 07/2008-02/2010

Oracle DBA

Installed and configured Oracle software and related products such as Oracle 10g and Oracle 11g on both Linux and AIX platform.

Developed and executed plan to apply Oracle upgrades, maintenance, and security patches.

Maintained optimum production environments.

Performed daily database administration on production and development environments.

Reviewed and implemented Oracle Baseline security settings for Oracle environments.

Established and maintained sound backup and recovery policies and procedures.

Performed backup and recovery for numerous Oracle 9i, 10g and 11g databases using RMAN and export and import.

Installed and configured Oracle Enterprise Manager and Oracle Grid Control Server.

Performed database tuning, performance monitoring using OEM tuning pack, STATSPACK and Automatic Database Diagnostic Monitor (ADDM), and capacity planning.

Performed database migrations to newer software versions and to Oracle.

Developed and implemented automated scripts for performance data collection and database monitoring.

Performed analytical research of database architecture seeking areas of performance improvement.

Performed analysis and troubleshooting of queries and provided recommendation for performance improvement.

Supported user administration, appropriate privileges as well as maintaining database security and data migrations.

Implemented database changes and updates for application releases.

Setup and maintained database documentation and standards.

Worked in a team environment and provide 7x24 supports as required.

Responded to problems quickly, determine root cause, and document and recommend

Corrective action.

Performed backup and recovery for SQL Server production databases.

Managed SQL Server database objects, ran scripts for developer and perform action plan for any deployment or implementations.

Created database with management studio, copied database with Database Wizard as well as restored from a backup.

Managed and monitored databases with Management Studio.

Created SQL Server Authentication Login IDs with Management Studio.

U.S Patent and Trademark Office Alexandria, VA 5/2003-7/2008

Oracle DBA

Performed daily database administration on production and development environments.

Installed Oracle 9i, Oracle 10g and Oracle 11g databases including migrating and upgrading databases.

Applied patches on oracle server to upgrade it from 10.2.0.1 to 10.2.0.3.

Applied critical CPU patches including 2007 CPU and CPU 2008.

Performed database cloning and Oracle home cloning.

Created tablespaces, tables, schemas and users accounts.

Wrote scripts to monitor database growth and gather statistics.

Provided performance tuning, maintaining and troubleshoot database problems.

Performed backup and recovery for numerous Oracle 9i and Oracle 10g Databases using RMAN, export and import.

Used SQL to generate data, queue data and report data using crystal report.

Collaborated with in-house database engineering team on key migration initiatives and providing technical assistance as necessary.

Created user accounts and appropriate privileges as well as maintaining database security.

Conducted storage management activities to maintain data integrity, while maintaining functionality servers.

Performed backup and recovery for numerous Oracle 9i, and 10G databases using export and import.

Wrote scripts for validating raw data files to load data into Oracle databases.

Created database objects for custom applications.

Performed SQL Tuning using stats pack.

Education / Training

B. S. University of Maryland (Eastern Shore Campus) - Princess Anne, MD (2002)

Major: Computer Science

M. S. University of Maryland (Global Campus) - Hyattsville, MD in progress

Major: Program Management Professional

DBA Workshops: Oracle Database 10g Administration (2004), Advanced Oracle DBA (2007), Intro to Oracle (2004)

RMAN Backup and Recovery (2004)

Oracle Database Administrator 11g: Workshop I (2007)

PeopleSoft Server Administrator and Installation Rel (2008)

AWS Training and Workshop (2017)

Oracle Database Appliance (ODA X8-2 HA ) Installation and Configuration Workshop training (2020)

Professional Certifications

12C Oracle Certified Professional (OCP) from Oracle Corporation

10G RAC Oracle Certified Expert (OCE) from Oracle Corporation

11G Tuning Oracle Certified Expert (OCE) from Oracle Corporation

10G & 11G Oracle Certified Professional (OCP) from Oracle Corporation

Security Plus (SY201) from CompTIA

ITILv3F

Contact this candidate