JOSEPH OLUWATAYO

Phone: 404-***-****

E-mail: adwqyc@r.postjobfree.com

Location : Atlanta, Ga.

SENIOR ORACLE DATABASE ADMINISTRATOR

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 all the process to the completion of the project.

•Skilled in designing and implementing complete life cycle client servers and database applications with various development tools and languages.

•Has managed internal databases, from planning and testing stages through implementation, support and has involved in end-to-end performance tuning, High Availability and Disaster Recovery solutions.

•In-depth understanding of diagnostics of performance issues, security and backup procedures to ensure database integrity.

Possesses superior skill in communication, presentation, analytical and problem-solving skill. Work well with all levels of business.

Areas of Expertise include:

• Oracle RAC Administration

• SQL Tunning in Oracle Environment

• Oracle ASM Administration

• Automatic Workload Repository (AWR/ASH)

• RMAN

• Azure

• Logical backup (datapump, export/import)

• AWS

• Storage

• GoldenGate

• Linux

• Patching

• Data Guard

• Performance Tunning and capacity Monitoring

• Oracle Virtual Private Database

• Virtual Private database (VPD)

• Exadata

• Advance Data Security, BackUp and Recovery

• Data Warehouse

• Cloning of Database

• Oracle Enterprises Manager (OEM)

• DBCA

• Migration

• Cloning of Databases

Key Competence / Technical Skills

10 years of experience in Oracle Database Administration and Engineering, involved in Installation, Configuration, Upgrades, Patching, Backup and Recovery, Migration, Memory and Space Management, Cloning, Replications, Reporting, Performance Tuning, RMAN, RAC, DataGuard, Active DataGuard, GoldenGate (Classic and Microservice), OEM Grid Control.

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.

Experience in a variety of hardware platforms including UNIX/Linux, Sun Solaris, HP-UX & AIX.

Excellent experience and maintaining database including database security, Capacity monitoring and performance tuning (I/O, Memory & SQL Tuning etc.) Using Statspack, Explain plan, ADDM, AWR Report and so on. Gathering and analyzing AWR report for troubleshooting purposes.

Experienced in Real Application Cluster (RAC), ASM, GRID Infrastructure Implementation and Support.

Implementation of Transparent Data Encryption (TDE) for data at rest using different algorithm.

Create Data Redaction Policy. Setup Oracle Real Application Cluster for High Availability and Scalability

ASO (Advance Security Options) Implementation and administration in a highly robust environment.

Good experience in regular Security patching on oracle products and interim patching for various bug fixes on database products.

Great working experience in writing SQL for creating views, functions, stored procedures, creation of database etc.

Expertise in efficient database performance, implement performance optimized recommendations, fix issues and problems. Configuring and creating databases using DBCA.

Extensive experience implementing backup and recovery strategy for disaster recovery using Hot/Cold Backups and using the Oracle backup utility such as RMAN.

Hands on experience in Oracle 11g/12c/18c/19c 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 and maintaining and upgrading all Oracle software 11g to 12c), (12c to 18 and 19c).

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

Managed and supported a large PostgreSQL database with over 20TB of data, including backups, restores, monitoring, and performance tuning.

Implemented an alerting system using Nagios for critical issues such as disk space depletion or high CPU usage by processes on the server.

Created database security policies that prevented unauthorized access, reducing DBA workload by 80%

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

Consults on Data Definition Language (DDL) and Data Manipulation Language (DML) design and development opportunities

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

Experience in implementing Flash Back Pointing Time Recovery.

Experience in User Management by Granting, Revoking Privileges according to requirement.

Experience in Space Management by Monitoring and Managing Tablespaces.

Keeping the database up to date by applying the latest CPU and PSU using the OPATCH utility.

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

Experience in Administering Oracle Database using Oracle Enterprise Manager, Toad, and PL/SQL Developer.

Monitoring Alert log for any errors and issues.

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

Hands on experience working on High Availability Environments.

24 X 7 Production Database on Call Support.

Knowledge of database normalization theory, Oracle patching methodologies, and data modeling techniques.

Extensive knowledge on database backup/recovery strategy (RMAN, Export/Import & Datapump), Capacity Planning, Replication (Streams) standby databases, Oracle configuration management, Database Cloning, Refresh, and patch management.

Documentation of the work assigned in the environment and stored for future use.

Strong emphasis on organization and documentation. Excellent interpersonal and strong communication skills (including Presentations). Customer-service oriented attitude and self-motivated, dedicated in any work environment.

SKILL SET

RDBMS

Oracle 11g Release 1 & 2; 12c, 18c, 19c and 21c

LANGUAGES

SQL, PL/SQL

SOFTWARES, APPLICATIONS & TOOLS

DBCA, DBUA, Oracle Data Guard, OEM (GC), RMAN, ASM, SQL*PLUS, SQL*LOADER, EXP, IMP, Data Pump (expdp, impdp), TOAD, SQL TRACE, EXPLAIN PLAN, AWR, and ADDM, OEM / Grid Control, Goldengate Replication (Microservices and Classic).

RELEVANT SKILLS & EXPERIENCE

WellStar Corporation: Atlanta, GA April 2021-Present

Role: Snr Oracle DBA

Configuring and maintaining replication Bi-Directional and Uni-Directional using Oracle Golden Gate.

Performing minor and major upgrades with minimal downtime and providing 24x7 schedule responding to critical events, incidents, and situations within the ECOSYSTEM.

Installation and consolation of 12c, 19c multitenant container and pluggable databases and Cloning.

Migration of non-container to container and pluggable database (PDB)

Setting up maintaining High Availability using DataGuard and Active Dataguard for Rac standalone and Rac Cluster.

Converting Physical Standby to Snapshot Standby to support Code testing, releases during application upgrades.

Schedule Exadata Patching with Oracle Platinum team via OASG (Oracle Advanced Support Gateway).

Software and firmware maintenance of the Exadata storage servers in the Database machine including routine health check and upgrades according to the suggestions from Oracle support.

Working on Exadata X7 and X8 machines which included Half Rack and Full Rack

Migrating 100+ databases from X7 machines to Exadata X8 machines

Working on setting up agents on Exadata X8 machines for monitoring.

Created OEDA requirement document for Oracle to setup the new Exadata X8 machines.

Worked with network and Linux teams to configure the network on the Exadata X8 machines so Oracle ACS can install Grid infrastructure 19c and Databases.

Configured and modified Exadata X8 machines as per Confidential requirement and specifications after Oracle handed over the standard Exadata machines.

Installation of OJVM patch on 11gR2 12c databases on Exadata X7 environments before migrating it to Exadata X8 machines to match with Bundle patch version.

Worked with Storage team in configuring Netbackup and CommVault on Exadata X8 machines.

Migrated using Datapump Export/Import for small databases and non-critical databases and used DataGuard and GoldenGate to Migrate huge and critical databases with 99% uptime.

Setup DataGuard between multiple datacenters for over 20 production databases.

Planed and documented all migration steps and coordinated with different teams during the deployments.

Tested Switchover and failover between data centers before migration of production databases using Dataguard

Efficient in using Dataguard Broker for all DataGuard tasks.

Migrated multiple databases upto 80TB of size with minimal to no downtime using DataGuard.

Configured databases with 2 node and 4 node RAC clusters.

Integration of Exadata monitoring into our existing IT monitoring framework. Provide and implement performance and tuning recommendations of all components in the Exadata machines.

Setup and configure RMAN jobs for full backups, incremental backups and archive log backups and are scheduled using Cron.

Setup scripts to monitor dataguard health on all datacenter apart from OEM monitoring.

Reviewing application and end user SQL for performance improvement.

Researching, and training others in the use of data warehousing in the cloud technologies and best practices.

Ensuring delivered solutions are realized in the timeframe committed and works in conjunction with project sponsors to size and manages the scope and risk.

Monitoring for 24x7 Production environment, resolution of severe performance and user access issues and Oncall rotation support.

Worked on building and rolling out new 19c databases for TEST/DEV/QA/PROD environments.

Migrated databases from 11gR2 and 12c to 19c.

Coca cola June 2017 – April 2021

Role: Oracle Database Administrator

Configured and maintained replication using Oracle Golden Gate.

Migration of large data from Exadata to RAC clustered environment.

Installed, configured Oracle 11gr2, 12c and 19c con Linux, Sun Solaris and HP servers.

Migration of standalone databases to RAC and ASM.

Implemented transparent data Encryption (TDE). Used TDE with Encrypted columns and Data Pump.

Creating duplicate databases for RAT Testing and moving databases from EXADATA to RAC environment.

Involved in the complete SDLC, Database design, System analysis, design and development.

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

Installation and Configuration of 11g,12c and 19c Grid Control.

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

Implemented Oracle Database 11g/12c/19c - 2 to 4 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 OEM Grid Control 11g and OEM Cloud Control 12c and 13c 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.

Work with software vendors and Oracle support to ensure all database and application related issues are resolved 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.

Provide Tier III/other support per request from various constituencies. Investigate and troubleshoot issues.

SUNTRUST BANK June 2012 –May 2017

Role:Oracle Database Administrator

Experienced in Troubleshooting Golden Gate extract processes and Replication related errors (table ddl changes, remove/add tables between replication group) during code deployment and data refresh activities.

Cloning production databases to test environment for testing and training purposes.

Experienced in troubleshooting ORA-xxxx errors, adding data files to tablespaces during dataload operation if required.

Supported, maintained, and troubleshooting Oracle Golden Gate for data replication and high availability databases.

Debugging Golden Gate replication issues such as abend.

and performance enhancement.

Enhancing SQL statements performance using Explain Plan and Oracle optimizer hints.

Manage high availability solution centers using Oracle Real Application Clusters (RAC) with several nodes.

Creating a database that meets the constantly changing requirement and need of the company and clients.

Administering and maintaining databases including daily monitoring and performance analysis using Stats pack, ADDM, AWR Report etc. Gathering and analyzing AWR report for troubleshooting purposes.

Working with other IT professionals for database designs and reviews; troubleshooting database issues and deploying timely fixes; maintaining regular and proactive database patches, updates Configuring the Oracle Network environment including Oracle Net Services and Listeners, configuring and managing oracle network.

Developing SQL scripts to carry out routine checks on databases. This include checking if the Listener is running, optimal running of all databases, Unix error messages, disk space availability etc.

Experienced in database backup and recovery using RMAN, Data pump, Import and Export utility.

Modifying database object’s structures as required by developers due to business or application requirements.

Sending daily operational report to the top management regarding the whole operation of the day, including any hitches and unusual situations.

Identified, resolved, and provided recommendations to various instances of performance problems which include Database performance problems, I/O hardware performance problems etc.

Set up and manage database security by creating new users, roles, profiles, and provide required user privileges in development, test, training and production environments.

Experienced and participated in shift rotation and on-call 24/7.

Environment: TOAD, Oracle 11g/12c/19c, PL/SQL, SQL Plus, OEM, RMAN, UNIX

EDUCATION

Lagos State University (Nigeria) 2005 – 2010

B.Sc. Computer Science

CERTIFICATIONS

OCI Certified Architect Associate

OCI Certified Foundations Associate

AWS Certified Solutions Architect

TRAININGS

Oracle Database 11g, 12c, 18c, 19c Administration

Introduction to UNIX Scripting / Red Hat Linux

SQL and PL / SQL Fundamentals

Oracle Golden Gate Replication (BI/UNI Directional) Conflict Detection and Resolution

Oracle Active Data Guard Internals

Performance Tuning and Management

Exadata (Half Rack and Quarter Rack)

Contact this candidate