JAMES OYEBODE adxsjq@r.postjobfree.com M: 1-248-***-****

Senior Database Administrator

Certified Oracle Database Administrator and Application Server Administrator with technical experience in high availability solutions, along with creating, installing, and managing databases and Real Application Clusters (RAC).

Enforced IT processes to ensure consistent, well-integrated application structures in full compliance with Sarbanes Oxley (SOX) and Payment Card Industry – Data Security Standards (PCI DSS) regulations.

Participated in system certification and accreditation, as well as Federal Information Security Management Act processes.

Assessed disaster recovery plans and business continuity plans.

Audited project controls including project governance / organization, and project work streams.

Participated in business process redesign, technology needs assessment, and IT governance projects.

Managed system information security architecture, design, installation, operational planning, and risk remediation activities.

Proven success resolving problems at server and network levels, designing security mechanisms, backup/restore strategies, and developing stored procedures, database views, and utility scripts.

Strengths include designing database schema objects for applications, developing disaster recovery procedures, testing and implementing crash recovery scenarios and database administration, monitoring, maintenance, tuning, and troubleshooting.

Skilled using query optimization diagnostic tools such as Explain Plan, AWR snapshots, ADDM, and SQL Trace.

Outstanding customer service, problem-solving, and analysis skills, valuable team contributor, and strong database administration abilities.

Expertise

Managing Oracle

Real Application

Clusters

Exadata/ODA

Installing and

Configuring

Oracle DataGuard

GoldenGate

Database Security

Big Data

Technologies

Performance

Maintenance

Data Backup,

Recovery &

Flashback

Linux

Database

Corruption

Issues

ITIL

James Oyebode adxsjq@r.postjobfree.com M: 248-***-****

EDUCATION

Bachelor of Arts, Philosophy Ogun State University, Nigeria Jun 1987

Associate Degree, Computer Science ICS Learning Center, Scranton, USA

Diploma, Computer Programming NRI Schools, Washington, DC, USA

CERTIFICATIONS/TRAINING

Oracle Certified Professional Database Administrator 8, 8i, 9i, 10g, and 11g

Brainbench Oracle 8i Certified Professional

Oracle 9i Certified Associate - Oracle Application Server Release 2

Oracle Database 12c

Oracle Real Application Clusters 12c courses

Oracle Cloud Infrastructure Foundations Online Course

Oracle DataGuard Course

PL/SQL Course

ITIL course

Microsoft SQL Server 2008/Microsoft SQL Server 2012 courses

MySQL course

NoSQL Database Administration Course

Big Data, Hadoop, and NoSQL and DBasS Online Courses

AWS Cloud Practitioner Online Course

Security+ Online Course

Ethical Hacking Online Course

Network+ Online Course

Security+ Online Course

PROFESSIONAL EXPERIENCE

LA-Z-BOY, INC., Monroe, MI March 2020-

Senior Oracle Database Administrator

Responsible for the development, installation, and configuration of environmental footprint for Oracle Database Appliance Application (ODA) and Oracle Environment. Support of agile environment using Oracle WebCenter, Oracle Identity Management, Oracle OVR, and support of various Oracle Applications.

Support of production, test, and development for very large databases and provide logical and physical database administration while working as the sole Oracle Database Administrator in a 24x7 environment. Tune, install, maintain, troubleshoot, and resolve server and network problems. Databases housed with Oracle 12c RAC and Oracle 18c RAC, using ASM on Red Hat Linux for Oracle Database Appliances (ODAs). The environments are configured with DataGuard.

James Oyebode adxsjq@r.postjobfree.com M: 248-***-****

Use of Oracle Enterprise Manager/Grid Control, ODA Console, and command line interfaces, including, but not limited to the following:

Researched, architected, installed, and configured Oracle Database Appliance Environment and Oracle Database Appliances.

Performed Enterprise Architect Role by advising Management on Oracle framework necessary to allow LA-Z-BOY to meet its business goals with high availability and disaster recovery abilities.

Supervised and executed ODA Migration Project from conception to completion:

oODA Migration Project involved the migration of Oracle RAC Databases with Oracle RAC versions 11.2.0.3 on Red Hat Linux to upgraded versions of Oracle 12c, 18c and 19c RAC on newly procured Oracle Database Appliances (ODA) HA hardware situated on Red Hat Linux.

Administration of ODAs using the ODA Admin consoles.

Support of agile environment using Oracle WebCenter, Oracle Identity Management, Oracle OVR, and supported various Oracle Applications.

Created multiple Oracle databases using the ODA tools.

Created multiple DataGuard Oracle databases along with their applicable standby databases.

Troubleshot and resolved numerous complex issues with existing Oracle Containers and associated Pluggable databases.

Identified and resolved numerous performance issues.

Migrated approximately 15 applications including Development, System Test, and Production for each application.

Created and implemented various shell scripts to automate routine maintenance activities.

Refreshed Development/Test environments from Production, using Oracle export/import tools.

Configured Oracle databases and RMAN backup configurations using RMAN Recovery Catalog.

Implemented best practice security database hardening / STIG compliance regulations.

Tune, install, maintain, troubleshoot, and resolve server and network problems when requested.

Performance tuning/work with Developers on PL/SQL scripts and shell scripts.

Engage Oracle on Priority Service Requests.

Monitor/Implement Environmental Requests for changes to database infrastructures using ticketing system.

Attend department meetings.

James Oyebode adxsjq@r.postjobfree.com M: 248-***-****

GLOBAL INFORMATION TECHNOLOGY, Lathrup Village, MI June 2004–Present

Certified Oracle Database Administrator Instructor (Part-Time)

Creation of MS PowerPoints and scripts, along with Instruction Criteria.

Oracle Real Application Clusters Instruction.

Oracle DataGuard Instruction.

Advanced Security Instruction.

ITIL Instruction.

Linux Administration Instruction.

PL/SQL Instruction.

Big Data Technologies Instruction.

Oracle Database Administration Instruction.

Instruction and mentoring of Oracle Database Administration to students from various industries with various backgrounds.

oOracle modules include:

Structured Query Language

Oracle Database Administration Workshop I

Oracle Database Administration Workshop II

These modules have an emphasis in:

Design and Configuration.

Managing Oracle Instance, Managing Data/Data Storage.

Database Security; Manage Schema Objects.

Proactive Maintenance; Performance Maintenance.

Data Backup; Recovery and Flashback.

Import and Export Data.

Database Corruption Issues.

Monitoring and Managing Memory.

Data Retrieval and Display.

INSTANTSERVE, LLC (State of Michigan), Lansing, MI June 2019–December 2019

Oracle Database Administrator

(Assignment with InstantServe, LLC at the State of Michigan – Michigan Department of Transportation)

Support production, test, and development databases and provide logical and physical database administration while working as a member of the database administration team for the Michigan Department of Transportation. Databases housed with Oracle 12c and Oracle 11g, using Solaris 11.4. The environment is configured with DataGuard.

Use of Oracle Cloud Control 13c and command line interfaces, including, but not limited to the following:

Maintain/Monitor Oracle 12c databases (primaries and standbys) through Cloud Control 13c and command line.

James Oyebode adxsjq@r.postjobfree.com M: 248-***-****

Monitor RMAN backup jobs, through Cloud Control 13c and command line with cron, using RMAN Catalog.

Monitor backups and resolve issues regarding RMAN backups and/or RMAN Catalog.

Analysis regarding Cloud Control 13c Incident Manager and Incident Rules.

Analysis regarding Cloud Control 13c Metric Extensions.

Documentation of database/server environment.

Analysis regarding auditing/security practices.

Analysis regarding storage/create objects.

Tune, install, maintain, troubleshoot, and resolve server and network problems when requested.

Performance tuning/work with Developers on PL/SQL scripts and shell scripts.

Engage Oracle on Priority Service Requests.

Attend weekly Database Team information technology meetings.

Monitor/Implement Environmental Requests for changes to database infrastructures using ticketing system.

Apply Quarterly RU database patches.

Assist with Solaris Upgrades performed by Server Team.

Attend department meetings.

TATA CONSULTANCY SERVICES (The Boeing Company), Troy, MI November 2018-July 2019

Senior Oracle Database Administrator/Subject Matter Expert Within Data Hub Department

Support production, test, and development for very large databases and provide logical and physical database administration while working as a member of the database administration team as a part of the Data Hub Department in a 24x7 environment. Tune, install, maintain, troubleshoot, and resolve server and network problems. Databases housed with Oracle 10g, Oracle 11g, and Oracle 12c RAC using ASM on Red Hat Linux, Solaris, HP-UX, IBM-IBX environments. The environments are configured with DataGuard and GoldenGate.

Use of Oracle Enterprise Manager/Grid Control and command line interfaces, including, but not limited to the following:

Maintain/Monitor Oracle 10g, Oracle 11g, and Oracle 12c RAC databases on multiple platforms.

Daily monitor of backups and resolve issues using backup logs in RMAN and Data Pump backups.

Tune, install, maintain, troubleshoot, and resolve server and network problems when requested.

Oracle recovery using RMAN.

Analysis regarding auditing/security practices.

Analysis regarding storage/create objects.

Patching ORACLE_HOME, databases, and Grid Infrastructure through command line and through OEM.

James Oyebode adxsjq@r.postjobfree.com M: 248-***-****

Upgrading databases from Oracle 11g to Oracle 12c.

Relinking Binaries after OS Upgrades.

Migration of Oracle databases to new servers.

Performance tuning/work on PL/SQL scripts and shell scripts.

Engage with Oracle on Priority Service Requests.

Monitor/implement Environmental Requests for changes to

database infrastructures (using ServiceDesk).

Attend weekly information technology meetings and department meetings.

AUTO CLUB GROUP, Dearborn, MI January 2002-October 2012

Oracle Database Administrator/PeopleSoft Database Administrator/Application Server Administrator

(Common Membership and Payment Processing Initiatives)

Support production, test, and development and provide logical and physical database administration while working as a member of the database administration team in a 24x7 environment. Tune, install, maintain, troubleshoot, and resolve server and network problems. Databases housed with Oracle 8i, 9i, 10g, Oracle 11g, and Oracle 10g RAC, Oracle 11g R2 RAC, using ASM on Red Hat Linux, Solaris, HP-UX, IBM-IBX environments. The environments are configured with DataGuard.

Use of Oracle Enterprise Manager/Grid Control and command line interfaces, including, but not limited to the following:

Installed/Maintained/Monitored Oracle 8i, 9i, 10g, and 11g databases and/or RAC on multiple platforms

multiple platforms.

Daily monitor of backups and resolve issues using backup logs in RMAN and Data Pump backups.

Installed and maintained Oracle 9i Application Server.

Installed Clear Commerce Credit Authentication Engine.

Installed RAC 10g and 11g R2 RAC.

Configured Oracle Data Guard for data protection.

Developed disaster recovery procedures.

Implemented fail over in the production databases using Service Guard, as necessary.

Oracle recovery using RMAN.

Tune, install, maintain, troubleshoot, and resolve server and network problems when requested.

Performance Tuning using ADDM, AWR, Statspack, TKProf, and Explain Plan.

Analysis regarding auditing/security practices.

Analysis regarding storage/create objects.

Refreshed development and training databases using Cloning/Exports, RMAN duplicate, and Imports.

James Oyebode adxsjq@r.postjobfree.com M: 248-***-****

Engaged with Oracle on Priority Service Requests.

Attended weekly information technology meetings and department meetings.

WAYNE STATE UNIVERSITY, Detroit, MI January 2001–December 2001

Oracle Database Administrator (Medical School Information Systems)

Support production, test, and development and provide logical and physical database administration. Tune, install, maintain, troubleshoot, and resolve server and network problems. Databases housed with Oracle 8i on multiple platforms (Windows 2000 and Unix [Sun Solaris 8]).

Maintained/Monitored Oracle 8i databases on multiple platforms.

Daily monitor of backups and resolve issues using backup logs in RMAN and Data Pump backups.

Tuned, installed, maintained, troubleshoot, and resolved server and network problems when

requested.

Designed security mechanisms.

Backup/restore strategies load/refresh programming forward and reverse engineering and generation of

physical schema.

Designed and developed of stored procedures, database views, and utility scripts.

Tuned of physical databases and tuned individual queries.

Designed and developed database installation and maintained Oracle software and utilities.

Tested and implemented crash recovery scenarios and recovery plans incorporating tools such as RMAN.

Provided technical support and training on Oracle8i to corporate clients of Apache Web Server and

Jserv modules.

Administration of Enterprise wide databases.

Installation and administration of the Oracle 9i Application Server, involving the installation and configuration of databases using Oracle Enterprise Manager.

Contact this candidate