Database Administrator Oracle

TERRENCE IKOME

ORACLE DATABASE ADMINISTRATOR

Edison, New Jersey 623-***-**** *************@*****.*** LinkedIn Professional Summary

• 7+ years of experience in the field of Database Technology Oracle with experience in designing, developing, and implementing Databases.

• Expertise in Oracle Database Administration for Oracle 19c, 12c, 11g with experience in very large-scale database environments (VLDB) and mission-critical large OLTP and OLAP systems.

• Experience in Real Application Cluster (RAC) administration with Auto Storage Management (ASM) on Oracle 11g&12c RAC Grid infrastructure and standalone 12c new features.

• Extensive experience with Oracle Goldengate (OGG), query optimization, Oracle Enterprise Manager (OEM), Toad, SQL development, and various other database utilities

• Hands-on experience with managing ORACLE rdbms on various flavors of UNIX such as Oracle Enterprise Linux 6. x, 5.5, IBM AIX 5.3 & 6.1, and REDHAT LINUX 5.7, 6, 6.5, 7.

• Administer over 100 databases across Development, QA, UAT, and PROD environments via the use of the command line and Oracle Enterprise Manager Cloud 12c.

• Manage the Space and Storage of the Databases through various Shell Scripts scheduled in the cron job periodically in regular intervals. Write Complex Shell Scripts that automate the Import of Reports to PostgreSQL and MySQL Databases.

• Configured DATA GUARD to provide high availability by implementing a physical standby database and worked with various Oracle 11g features, 11g Grid Control, and Automatic Storage Management (ASM).

• Extensive experience designing and implementing backup and recovery strategies using Recovery Manager

(RMAN), traditional Export/ Import, Data pump as well as conventional Hot/Cold Backups.

• Working with Oracle Support to fix the production issues and also to get the merge patches.

• Work on on-call support schedules and 24/7-hour availability.

• Experience with ETL tools to gather data from various sources and load it into distinctive targets.

• Experience in Installation of 12C Grid Control on OEL 6.3 and experienced in monitoring and managing Oracle instances using Enterprise Manager Grid Control (OEM grid) 10g /11g/12c/19c.

• Successfully implemented Physical Standby Database using Oracle DATAGUARD feature for High availability and DR configuration.

• Exadata designing, installing, upgrading, patching, tuning, monitoring, and troubleshooting databases with large amounts of data (Terabytes) and high transaction data migration, AWS integration, or infrastructure improvement.

SKILLS

Experience

Dell Technologies, Texas Jan 2022 – present

Sr. Oracle Database Administrator

• Cloning/duplicating of the database with RMAN and user-managed (hot/cold) backups.

• Oracle Installation, Configuration and Migration of databases to 19C from Oracle 12c.

• Plan and implement backup and recovery strategy and write scripts to do nightly RMAN backup.

• Installed, patched, and managed Oracle Database version 11g on Red Hat Linux.

• Experience working on AWS EC2 instances

• Supported multiple databases including an RAC production database, a Data warehouse database, and some Language/Scripting Python, SQL, Shell Scripting, XML Databases Oracle Exadata, Oracle (10g, 11g, 12c, 19c), MYSQL, SQL Server Cloud AWS (EC2), Azure

Oracle Tools SQL*Loader, TKPROF, Toad, OEM, EXPLAIN PLAN, AWR, ADDM, ASH, Grid Control, RMAN, Data Pump, SQL TRACE, Golden Gate, Data Guard, Backup and Recovery (Cold/Hot backups, Import/Export)

Office Tools MS Excel, MS Word, MS Visio, MS Project Operating System Windows 2008/2010 server, Unix, RedHat Linux Development and Test databases.

• Disaster recovery planning or Emergency Recoveries and Ensuring Recoverability of Databases.

• Ensure night cron jobs for backups, re-indexing & vacuuming & and materialized views are executed properly on 24/7 high-availability Postgres production and development databases

• Good understanding of Golden Gate components like Integrated Extract, Replicat, Trail Files, and GGSCI commands.

• Configured Oracle 11g Physical Standby Database for DR purposes using ORACLE Dataguard.

• Provided Production & and test environment support while coordinating with the Unix Team and storage team to configure the OS infrastructure for Oracle Databases.

• Worked on setting up/installation and configuration of release 11g R2 RAC with ASM.

• Installed and configured 3-node Oracle 11gR2 RAC.

• Installed 12c Databases and was responsible for upgrading Oracle 10g RAC to 11g RAC.

• Involved in Oracle Golden Gate installation, configuration, and troubleshooting Golden Gate EXTRACT and REPLICATE issues.

• Wrote Python scripts to parse XML documents and load the data into the database

• Used Perforce version control system and Python Tools for Visual Studio (PTVSS) IDE.

• Implemented Data Pump, Export, and Import on a day-to-day basis as per development and test servers.

• Experience with ETL tools to gather data from various sources and load it into distinctive targets.

• Responsible for Performance Monitoring and analysis of 11gRAC (Real Application Clusters) with AWR (Automatic Workload Repository) reports and ASH (Active Session History).

• Experience with ETL tools to gather data from various sources and load it into distinctive targets.

• Monitoring database performance and database operation to prevent downtime and slowness of the services.

• Worked closely with the system operations team on database deployment processes and database capacity planning.

• Implemented backup and recovery procedures (Cold/Hot backups, RMAN Incremental backups, and import/Export).

• Strong experience in Space and User Management, Capacity planning, standby setup, Backup & and recovery

(Import/Export, Datapump, RMAN)

• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, AWR, ADDM, SQL TRACE and SQLT

• Handled Physical and Logical Corrections and recovery using RMAN (Recovery Manager).

• Applied database patches using Opatch utility & building Clone instances for Development and Test teams.

• Production support for Oracle database 10g/11g/12c/.

• Creating and Managing Primary Objects like Custom tables, Procedures, Packages, Triggers, Alerts, and functions. Views, Indexes, user accounts, roles, grants, and performing day-to-day operations.

• Expert in monitoring databases using Oracle Enterprise Manager (OEM) and Toad Epsilon, Texas Jan 2019 – Dec 2021

Oracle Database Administrator

• DBA supporting three major projects from Development to Production via Tech-Test environments, involving daily configuration, and administration all running on Linux and Unix servers. Database sizes range from 4GB to 9 TB.

• Performed Installation and configuration of Oracle 12c database on Unix and Linux platforms.

• Performed schema management, database sizing, maintaining privileges of users and user profiles, and implemented Oracle Advance Security.

• Installed Oracle 10g and 11gR1,11gR2 database on Redhat Linux 6,

• Applied Bug fixes patches and Quarterly Security Patches for the stand-alone databases and 2-node RAC databases within the maintenance window.

• Installation of Oracle Enterprise Manager 12c, oracle management repository, and deployed agents.

• Performed SQL and PL/SQL tuning, oracle contention, and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM), and Active Session History (ASH).

• Setting up physical Standby Data Guard for disaster recovery.

• Created Various Disk groups for OCR, Voting Disk, and archived logs with normal redundancy for High Availability.

• Performed Cloning RAC database using RMAN to refresh the data from the Production database to the Lower environment on demand.

• Experience in troubleshooting RAC node eviction problems by reviewing cluster logs and system log messages.

• Installed and configured Golden Gate for replication.

• Responsible for Database Backup and Recovery, daily monitoring of database & network issues

• Deployed Grid Control to monitor and manage all the databases on clients.

• Used Shell Scripts to automate database operation and schedule jobs using CRONTAB.

• Design and Maintain capacity planning.

Caterpillar – Peoria Apr 2016 – Dec 2018

Oracle Database Administrator/MS SQL Server

• Creating various Disk groups for OCR, voting Disk, and archived logs with normal redundancy for high availability

• Performed cloning Rac database using Rman to refresh the data from the production database to the Lower Environment on demand.

• Responsible for database backup and Recovery, daily monitoring of database & Network issues

• Installed Oracle 10g and 11R1,11R2 database on Redhat Linux 6,

• DBA supports three major projects from Development to Production via Tech – Test environments, and administration all running on Linux and Unix servers. Database sizes range from 4GB to 9Tb

• Installed and configured Golden Gate for replication

• Deployed Grid Control to monitor and manage all the databases on clients

• Used Shell Scripts to automate database operation and schedule jobs using CRONTAB

• Experience in troubleshooting RAC node eviction problems by reviewing cluster logs and system log messages Education

BSc Computer Science 2013

University of Bamenda

Certificates

OCA Oracle Certified Associate

Sql Fundamentals

Azure 900

Contact this candidate