Cherechi Chukwu

adcjix@r.postjobfree.com * * * 404-***-****

Authorized to work in the US for any employer

https://www.linkedin.com/in/hardy-chukwu-4b027521/

OBJECTIVE: To offer my years of experiences in the field of Information Technology in a creative and collaborative environment where my analytical and technical skills will contribute to the overall goal of the organization.

SUMMARY OF QUALIFICATIONS

Oracle 8i/9i/10g/11g/12c/18c/19c Oracle Database Administration (18 years)

Performance Tuning & Capacity Monitoring (15 years)

Data Security, Backup & Recovery (17 years)

Configured and maintained replication using Oracle Goldengate (8 years)

Exadata (6 years)

Data Center Migration (15 years)

Data Guard (12 years)

VLDB (10 years)

Data Warehouse (12 years)

Solaris (10 years)

Linux (17 years)

Windows (17 years)

Storage (17 years)

Data Profiling, querying and reporting on multiple RDBMS (17 years)

Oracle RAC (Real Application Cluster) setup and tuning. (14 years)

Using shell scripting and RMAN (17 years)

Import/Export (18 years)

Installation and configuration in AWS Cloud (4 years)

Oracle database partitioning, patching, and cloning (14 years)

Hadoop (2 years)

AWS (4 years)

Apache Cassandra (4)

Couchbase (2)

Google Cloud (4)

Microsoft Azure Cloud (5)

Team Lead (14 years)

SalesForce Admin/dev (6years)

Technical Skills

18+ years of experience in Oracle DBA and have been involved in Installation, Configuration, Upgrades, Patching, Backup and Recovery, Migration, Memory and Space Management, Cloning, Replication, Reporting, Performance Tuning, RMAN, RAC, Data Guard, OEM Grid Control.

Expertise in Oracle 11g, ASM, RAC, OEM, Data Guard, RMAN and Shell Script

Configured and maintained replication using Oracle Golden Gate.

Experience in Backup & Recovery techniques of databases running in ARCHIVELOG MODE using RMAN.

Having good knowledge on EXADATA and Involved in moving databases in EXADATA to RAC environment.

Experience in Data Migration using Data pump utility, Non RAC to RAC and Non ASM to ASM.

Implemented Oracle Transparent Data Encryption to encrypt tables and tablespaces that contains PII,PCI and SOX data.

Implemented Oracle Audit Vault 11G

Managed Oracle security (using virtual private databases and role-based security).

Implemented virtual private database/application context code.

Database Refresh from Production to Development and from Development to Test environments.

Worked with various application teams in developing, testing and deploying codes across all life cycles of the application phase.

Experience in Space Management by Monitoring and Managing Tablespaces.

Experience in Implementing, configuring, trouble shooting, switchover, failover of Physical Standby Data Guard on 10g and 11g.

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

Provided hands-on support and implementation of Installation / Configuration / Performance Tuning / Trouble shooting Oracle Golden Gate (OGG) in Oracle to Oracle homogeneous environments.

Monitoring Alert log for any errors and issues.

Resolved Replication related errors Such as ORA -1403, 0001, and several other errors regarding golden gate replication during and after code deployment activity.

Good understanding of no-SQL database, Cassandra and Hadoop.

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

Worked with various application teams in developing, testing and deploying codes across all life cycles of the application phase.

Hands on experience in Oracle 10g/11g 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.

Hands on experience working on High Availability Environments.

24 X 7 Production Database on Call Support.

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.

Mentored other DBA in various Oracle and non-Oracle related tasks.

WORK HISTORY

PWC (MGM Resorts) Las Vegas, NV April.2019– Present

Snr. Oracle Golden Gate / Database admin.

Environment: Oracle, MS SQL Server, IBM DB2 RAC, Data Guard, Grid Control, Golden Gate, EMC, HP-3Par, Linux Advanced Server, RHEL, Windows, ASM.

Responsibilities:

Architected a big data application replication solution with a factory approach using Mongo API,KafkaSpark and Scala.

Designed the use of Azure EventHubs, CosmoDB, ADLS, Hadood, Azure DataLake as targets for the data sourced from Golden Gate passed through Kafka, Mongo DB API, Hadoop API.

Installation, Configuration and Migrated multi- Terabyte Database from existing to a new Data Center.

Managed Oracle security (using virtual private databases and role-based security).

Implemented virtual private database/application context code.

Monitoring and Performance tuning of Goldengate sessions at Database level and GGSCI level and investigate replication failures using, report files and LogDump utility.

Installed, Configured, optimized and maintained Couchbase clusters, Sync-gateways and underlying operating systems.

Experience with NoSQL databases such as Couchbase, MongoDB and ElasticSearch.

Experience designing and supporting development, testing. and production databases.

Experience setting up replication, sharding and other high availability solutions.

Analyzed data access patterns and identify hotspots and bottlenecks.

Designed and review data models, and help developers plan high performing queries.

Defined and establish best practices with Cassandra, including configuration, monitoring health and backups of the cluster.

Managed storage capacity of the cluster and help plan for growth based on future project goals.

Diagnosed and troubleshoot production issues as needed.

Experience with Apache Cassandra, including installing, configuring and monitoring a Cassandra cluster.

Experience with Cassandra data modeling and CQL scripting.

General Motors Atlanta, GA Oct.2015– April.2019

Snr. Oracle Database admin.

Environment: Oracle 11g/12C, TOAD, Oracle Enterprise Manager 13c (OEM), RMAN, RAC, Data Guard, Grid Control, Golden Gate, EMC, HP-3Par, Linux Advanced Server, RHEL, Windows, ASM.

Responsibilities:

Installation, Configuration and Migrated multi- Terabyte Database from existing to a new Data Center.

Experience with Apache Cassandra, including installing, configuring and monitoring a Cassandra cluster.

Experience with Cassandra data modeling and CQL scripting.

Installed, Configured, optimized and maintained Couchbase clusters, Sync-gateways and underlying operating systems.

Installation, upgradation, configuration and troubleshooting Oracle Goldengate 11G/12C software.

Implemented Oracle Transparent Data Encryption to encrypt tables and tablespaces that contains PII,PCI and SOX data.

Managed Oracle security (using virtual private databases and role-based security).

Implemented virtual private database/application context code.

Monitoring and Performance tuning of Goldengate sessions at Database level and GGSCI level and investigate replication failures using, report files and LogDump utility.

Performed Zero Downtime migrations from Non Exadata machines to Exadata machines using Oracle Golden Gate and Dataguard/Rman Duplicate.

Installed configuring Real Application Clusters (RAC) on Oracle11g /12c Automatic Storage Management (ASM).

Setup and maintenance of DATA GUARD on 11g,12C for Disaster Recovery and reporting purpose with various modes.

Performed Data Center Migration involving multi-Terabytes Oracle databases.

Implemented Oracle Transparent Data Encryption to encrypt tables and tablespaces that contains PII,PCI and SOX data.

Managed Oracle security (using virtual private databases and role-based security).

Implemented virtual private database/application context code.

Monitoring and Performance tuning of Goldengate sessions at Database level and GGSCI level and investigate replication failures using, report files and LogDump utility.

Performed Zero Downtime migrations from Non Exadata machines to Exadata machines using Oracle Golden Gate and Dataguard/Rman Duplicate.

Involved in the project of implementing and configuring Real Application Clusters (RAC) on Oracle11g Automatic Storage Management (ASM).

Setup and maintenance of DATA GUARD on 11g,12C for Disaster Recovery and reporting purpose with various modes.

Database Cloning for Logical and Physical Standby server.

Maintained and monitored RMAN backup, restore, and recover as needed.

Created database links to retrieve data from multiple Databases source to ODS.

Monitored Schema level performance issues and performed the tasks like analyzing tables, rebuilding

Snr. Database Administrator

Teksystems – Onstar Project (General Motors), Detroit, MI 03/13- 09/15

Environment: Oracle 10g/11g,12c TOAD, SQL Plus, Oracle Enterprise Manager (OEM), RMAN, Oracle and Linux.

Responsibilities:

Creating and maintaining databases, creating table spaces, tables, indexes, data files etc.

Installed configured Oracle Enterprise Manager (OEM) / Grid Control for monitoring and administrative tasks purposes.

Installed, Setup and configure Goldengate Bi-directional, Broadcast, and Unidirectional replication.

Implemented Oracle Transparent Data Encryption to encrypt tables and tablespaces that contains PII,PCI and SOX data.

Managed Oracle security (using virtual private databases and role-based security).

Implemented virtual private database/application context code.

Created and implemented replication between 2 databases running on Unix RAC for multiple schemas and validated replication for insert, updates functionality between both source and destination databases.

Handled several Onstar Global and minor releases from 4.3 – 6.2 Database and Goldengate replication design changes from ODS and application perspective.

Installed, configured, loaded and implemented of Oracle Spatial Database changes using various ESRI files from different vendors (i.e. NavTeq,TomTom,Nokia, etc).

Installation and configuration of Oracle 10g / 11gR2/12c Real Application Clusters (RAC)

Great Understanding of how the complex Banner environment works together.

Backup plan designing and implementation using cold/hot backups, Flash copy, Volume copy and RMAN backup technology.

Perform capacity planning required to create and maintain database environments.

Helping the development team and data warehousing team.

Monitored table space size, resizing table space, relocating data files for better disk I/O.

Creating users, allocation to appropriate table space quotas with necessary privileges and roles for all databases.

Configuring TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.

Monitoring table space size, resizing table space, relocating data files for better disk I/O.

Designed Backup Strategies and Disaster recovery plans depending upon the criticality of the Databases.

Performed large data loads through SQL*Loader

Managing archive logs, DB-links, partitions.

Create Indexes by analyzing and rebuilding of Indexes for better performance.

Managed database users and security for the SQL Server database.

Fine-tuned and maintained large production SQL Server databases, as well as monitored overall database activities using Profiler

Monitoring of SQL Server databases, working to maximize availability and tune data performance as needed.

Experience in Implementing, configuring, trouble shooting, switchover, failover of Physical Standby Data Guard on 10g and 11g.

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

Provided hands-on support and implementation of Installation / Configuration / Performance Tuning / Trouble shooting Oracle Golden Gate (OGG) in Oracle to Oracle homogeneous environments.

Monitoring Alert log for any errors and issues.

Resolved Replication related errors Such as ORA -1403, 0001, and several other errors regarding golden gate replication during and after code deployment activity.

Worked with various application teams in developing, testing and deploying codes across all life cycles of the application phase.

Lead Oracle DBA

Accenture (Ally Financial, State of Vermont, First Data, Canada FRO), Atlanta, GA 11/12 – 01/13

Environment: Oracle 10g/11g, Oracle Enterprise Manager (OEM), OEM 10g/11g Grid Control, RMAN, Veritas NetBackup, RAC, ASM, DataGuard, AIX 5.x/6.1, Linux RHE, TOAD, Shell Scripting, PL/SQL,

Responsibilities:

Managed and led DBA team in the complete SDLC, Database design, System analysis, design and development to production phase.

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

Setup and configure RMAN Backup using Varitas – NetBackup for all Backups.

Provided daily database administration support such as monitoring space utilization, backup, and export /import of schema objects.

Installed, configured and implemented Oracle Enterprise manager Grid Control.

Engaged in database and Disaster Recovery capacity planning and implemented Disaster recovery exercise.

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

Debugging Goldengate replication issues such as abend of replicat,extract, and pump processes.

Implemented Oracle Transparent Data Encryption to encrypt tables and tablespaces that contains PII,PCI and SOX data.

Managed Oracle security (using virtual private databases and role-based security).

Implemented virtual private database/application context code.

Performed performance tuning using SQLT tool to migrate SQL profile between databases to impact and reduce query runtime.

Installed and configured Multiple Oracle 11g databases.

Responsibilities included applying CPU/PSU patches, maintaining and troubleshooting database issues.

Installed and configured Oracle Audit Vault server / database for a two (2) node RAC with a standalone audit vault server.

Installed and configured Audit Vault Agent on a two (2) node RAC.

Configured and integrated DB and OS collectors with the Audit Vault server/database

Performed Trouble shooting of ora errors and performance tunning of oracle instances and databases.

Snr. Oracle DBA

IBM (Pfizer, Virgin USA, Hertz, SOM, Budget ), Dubuque, IA 10/09 – 12/11

Environment: Oracle 9i/10g/11g, Oracle Enterprise Manager (OEM), OEM 10g/11g Grid Control, RMAN, SQL BACKTRACK, Veritas NetBackup RAC, ASM, DataGuard, AIX 5.x/6.1, Linux RHE, TOAD, Shell Scripting, PL/SQL,

Responsibilities:

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

Cloned databases using RMAN and manual copy.

Performed disaster recovery using Oracle Recovery Manager.

Setup and configure RMAN Backup using Varitas – NetBackup for all Backups.

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

Performed backup and recovery using BMC SQL BACKTRACK.

Engaged in database capacity planning for a new application deployment.

Installation and configuration of Oracle 9i/10g/11g Real Application Clusters (RAC).

Performed backups and tested crash recoveries using conventional cold, hot and RMAN backups.

Experience in Supporting Bi-directional Goldengate replication between databases.

Setup and configure goldengate Manager Processes, Extract Processes, and Replicat Processes for a Unidirectional replication.

Responsibilities included installing, upgrading, migrating and applying patches to Oracle databases.

Managed 4 node Oracle 10g Real Application Clusters (RAC) databases with ASM Storage.

Responsible for creating standard database creation scripts, installation, upgrades, patches, contacting Oracle collaborative support for critical issues.

Performed numerous Oracle database migration from RDBMS 10g through 11g using various Oracle migration methods such as EXPDP/IMPDP, Transportable Tablespace .

Performed cross-Platform Migration of oracle databases.

Supported Quest SharePlex for data replication and for high availability stand-by databases.

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

Proactive monitoring, identifying areas that need to be improved in the application and database using Statspack, AWR, ADDM, and 10g OEM Grid Monitoring.

Performed daily service management activities related to change, incident and problem management, as well as coordinate and/or participate in team and customer meetings.

Analyzed and tuned Oracle database / instances using EXPLAIN PLAN, AWR Reports, Advanced Database Diagnostic Monitor (ADDM), StatsPak, SQL*TRACE and TKPROF.

Oracle DBA

Echho Communications Norcross, GA 09/07 – 10/09

Environment: Oracle 9i/10g/11g, Oracle Enterprise Manager (OEM), OEM 10g/11g Grid Control, RMAN, SQL BACKTRACK, RAC, ASM, DataGuard, AIX 5.x/6.1, Linux RHE, TOAD, Shell Scripting, PL/SQL,

Responsibilities:

Resolved chronic archive log backup processing problem, saving excess money in consultant costs

Performed data migration of large databases from Solaris to Linux and collaborated with system administrators to ensure smooth, continual operation

Experience working with MySQL 5.0 as it relates to replication, proxies, master/slave configuration etc.

Effectively interfaced with developers, system administrators, and staff throughout all departmental levels

Performed monthly table update campaigns: extraction, transformation and loading of data into a production table for application online transaction processing (OLTP) support

Reorganized two production tablespaces which resulted in substantially improved performance and space gain.

Developed a guide and trained team members on how to properly setup RMAN backup and recovery utility.

Installing Banner Upgrades

Upgrade the Banner system version 8.x for all the student,general.finance,HR, position control etc modules and manage them. Review the dependencies for the upgrades.

Conversion of the database to the UTf-8 Characterset as per Banner8 requirement.

Install ICU for the banner8 Pro*C requirement.

Install and configure the FM need Analysis for FA 8.10.

Install and Configure AQ processes.

Install DBEU to prepare for banner9

Manage Banner

Perform day-to-day maintenance

Manage Banner Security

Manage the jobsub, dataload etc

Perform the Fiscal Year End

Apply the Banner patches as per the functional requirement

Installing and Configuring Oracle 11g Fusion Middleware and 10g Internet Application Server.

Migrating Oracle application servers for Internet Native Banner (INB) and Self service Banner, currently running 10.1.3.x

Configure Oracle Developer Suite forms and reports server to deploy the forms on the web.

Install and Configure Banner Degreeworks:

Install and configure Banner Degreeworks 4.1.3.1

Converted existing database tables into index-organized tables, providing faster access time and resulting in a substantial increase in sales per day for clients.

Oracle DBA

FST Financial Mortgage Norcross, GA 09/03 – 10/07

Environment: Oracle 8i/9i/10g

Responsibilities:

Assisted in database migration from Oracle 9i to 10g.

Monitored space usage, and adjust database as needed.

Monitored backup operations, and schedules manual backups as needed.

Worked with system administrators to configure the system for optimal performance.

Provided Oracle database knowledge and support for Oracle 9i/10g application development.

Reviewed and enforced standards, procedures and guidelines for developers' usage.

Involved in installation and configuration of SQL server 2000 on Dell Servers. Applied patches and service packs to keep the database at current patch level.

Responsible for configuration of Microsoft Server/Client Products and implementation.

Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.

Responsible for General Database Administration and Performance tuning.

Experienced in resolving deadlock and blocking issues for concurrent users

Worked with DTS packages to load the massaged data into Data warehousing system.

Data Migration from legacy to master tables using DTS-Import and Export wizard.

Used MS Visual Source Safe 6.0 as a Version Control System.

Provided consultation and resolutions for all application development as it pertains to database related problems.

Assisted in creating logical and physical design of database schemas for new applications.

Reviewed and aided in the design of Oracle databases to meet the business requirements.

Converted some of the views to materialized views for optimum performance.

Approved and made all application-related database changes requested by the development team.

Managed multiple environments for multiple applications: development, integration testing, system testing, staging (QA), and production. This includes synchronization with database change control tools.

Created and maintained data definition language scripts for all database changes.

Assists in providing documentation detailing the design and architecture of the databases, as well as the administration, backup procedures and data recovery steps.

Assisted in promotion of database related changes from development to production.

Worked with operational DBA's in the recovery of corrupted databases, timely troubleshooting of all database-related problems and emergency response to all development, testing, and production downtime events.

Monitored application and database performance, and adjusted database parameters, and schemas as needed.

EDUCATION & Trainings

University of Lagos, Lagos - Nigeria

Bsc (Computer science). Spring, 1998.

SalesForce Admin and Dev Training April, 2017

Oracle RAC and GDS Training12c Dec., 2018

Oracle University

AWS Solutions Architect – Training April, 2017

Google Cloude solutions Architect – Training Nov, 2016

Microsoft Azure Solutions Architect – Training Aug, 2016

Hadoop Training Sept., 2013

Oracle Golden Gate 11g Training Nov., 2011

Oracle University

Oracle RAC and Grid Infrastructure Training11gR2 Dec., 2011

Oracle University

Oracle RAC 10g Dec., 2009

Oracle University

Oracle Database Administrator Training Oct., 1999

Global Career Tutors, Decatur, GA

Microsoft Server / Database Administrator Training July., 1999

Global Career Tutors, Decatur, GA

Reference:

Available upon Request

Contact this candidate