Manager Data

EMMANUEL NEBA AMBEBILA

********@*****.*** 240-***-**** 3213 W Walnut Hill Ln, Irving, TX 75038

ORACLE DATABASE ADMINISTRATOR

Key skills:

Oracle 10g, 11g, 12C, 19c Recovery Manager(rman) Oracle GoldenGate Performance Tuning Toad Oracle SQL*PLUS Oracle RAC Data Migration AWS Cloud RAC

Data guard OEM 13C datapump Database Security Software installation Linux

PROFESSIONAL EXPERIENCE & ACHIEVEMENTS

CITI BANK, IRVING, TEXAS January 2019 to Present

ORACLE DATABASE ADMINISTRATOR

• Install, Configure, troubleshoot and support GoldenGate Replication

• Configuration management, performance tuning and administration of mission critical production databases

• Fixing critical database problems emerging in the course of normal and abnormal operations

• Installation Patching Upgrade of the database software on Linux platform,

• RMAN backup and recovery of the Oracle databases

• Database, performance tuning, migration, data guard replication, configuration and security administration

• Carry out database refreshes from production to lower environments using RMAN and Data pump

• Partners with application development manager and System DBA to understand the application and database requirements and ensures appropriate definition, organization, security, integrity and operational efficiency

• Review service-related reports (database backups, maintenance, monitoring) on a daily basis to ensure service related issues are identified and resolved within established SLAs

• Use AWS management console to perform some basic tasks

• Physical Replication using (Data Guard) Data Guard Broker

• Database Replication using GoldenGate and ensuring data integrity using Golden Gate Command line Interface, Unix scripts, Oracle Enterprise Manager and veridata

Incident Response

• Serve as primary contact for incidents for application issues

• Coordinate all database corrective actions using ServiceNow

Object Capacity Planning

•Monitor object growth and sizing

• Reorganize objects as required

Object Design

•Assist development/design team with database design and creation

Object Maintenance

• Perform application database object changes

• Creating and managing schema objects

• collect statistics and analyzing Tables, Indexes to improve performance

Object Recovery

• Perform object level backups as required.

• Recovery individual objects as necessary

Data Management

• Import/Export of Data

• Manage 2 and 3 node RAC for high availability on ASM

AMERICAN HOME PATIENT, NASHVILLE, TN US Nov-2015 to Nov-2018

ORACLE DATABASE ADMINISTRATOR

• DBA supporting major projects from Development to Production involving daily configuration, administration running on Linux platforms

• Experienced in Golden Gate Installation and Configuration for database replication purpose. Troubleshooting Golden Gate extract and replicate issues.

• Implement and manage RAC databases and upgraded from 10g to 11g and 11g to 12c.

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

• Automation of routine DBA tasks using tools like OEM 12C, shell scripts and crontab

• adding and removing ASM disk on diskgroups

• Applied database patches using Opatch utility

• Configure, monitor and maintained DATA GUARD for disaster recovery

• Manage Enterprise DB postgresql advance server databases, creating users, schemas, tune postgresql databases and perform logical replication

• Perform routine maintenance tasks on EDB postgresql advanced server like vacuuming and reindexing

• Implemented Server level security in EDB postgresql advanced server

• Loading data from flat files to tables and vice versa using copy command and EDB*loader

CARDINAL HEALTH, DUBLIN, OH US June-2012 to Sept-2015

Jn ORACLE DATABASE ADMINISTRATOR

• Perform basic database administration tasks

• Cloned/Migrated databases using RMAN Datapump utilities

• Automated monitoring the databases, performance parameters, backup and recovery activities by running Cron jobs and customized various Unix Shell Scripts,

• Performed troubleshooting of database using AWR and ADDM reports.

• Planned, tested and implemented backup strategy using RMAN, Oracle Utilities (Export/Import) EXPDP.

• Implemented Oracle's Transportable Tablespace (TTS) feature using Data pump Export/Import (Oracle 11g, 10g)

• Implementing data refreshes (at database, schema & table level) using RMAN utility and Data pump, conventional Export/Import of Oracle 11g, 10g.

EDUCATION & TRAINING

Bachelor Degree in Biochemistry,

Major: Biochemistry,

University of Yaoundé 1 2002-2005

Certifications

Exam Title

Exam Number

Test Date

AWS certified cloud practitioner

CXXT2JT2FEFQQ752

13-Feb-2020

Oracle Database 12c: SQL Fundamentals

1Z0-061

14-MAY-18

Oracle Database 12c Administration (OCA 12C)

1Z0-062

24-Jan-2019

Oracle Database 12C Advanced Administration (OCP 12C)

1Z0-063

01-May-2019

Contact this candidate