Data Manager

ESEME MBOH FRITZ

(***) ***- **** *************@*****.***

Oracle Database Administrator

Experienced Oracle Database Administrator with over 7 years of Oracle experience in configuring, integrating, upgrading, migrating, and setting up databases in various environments. Highly skilled in database cloning and refreshing and tuning and assigning indexes. Excels as an IT professional and a database analyst, easily able to work in teams to achieve common goals. Skilled in installing, configuring, upgrading, and migrating databases as needed. Maintains strict database security and integrity standards for databases. I have 2years experience in AWS, EXADATA, POSTGRES SQL and SQL server databases . Areas of expertise include:

Oracle 10g, 11g, 12c

Solaris

UNIX

AIX

Linux

Windows

TOAD

SQL DEVELOPER

Performance tuning

RMAN

RAC

Data guard

Goldengate

Upgrades and patches

Oracle Enterprise Manager (OEM)

Real Application Cluster (RAC)

ASM

Data pump

UNIX scripting

Database security

AWS

Data migration

EXADATA

PL/SQL

SQL*Loader

PROFESSIONAL EXPERIENCE

Fidelity Investment Durham, NC

Oracle Database Administrator AUGUST 2016 - JUNE 2019

Participate in a 24/7 on-call rotation position for all prod, QA, and dev environments

Installed and created 11g,12c databases for testing and development.

Utilized SAN level storage mirroring to perform data refreshes on large production data warehouse environments Conducted analysis and feasibility studies for development of Oracle Exadata solutions.

Experience working with Microsoft SQL Server to create databases, creating and managing users accounts and Migration

Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.

Conducted analysis and feasibility studies for development of Oracle Exadata solutions.

Experience migrating oracle database to Oracle Exadata

Expert in maintaining and administering Oracle Exadata machines

Experience working with AWS

Experience with EC2 and RDS instance in AWS

Hands on experience migrating to AWS

Supported Business Objects for data warehouse analytical reporting

Configure oracle database for data warehouse

Monitoring data warehouse performance and taking preventive and corrective actions as required

Performing upgrade of the database and data warehouse software

Hand on experience in cloning the non-multitenant container database to pluggable database in 12c using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot Cloning feature.

Performed database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, and cloning on the above said versions.

Used Oracle 12c Enterprise manager to monitor and report the Database health for over 300+ databases

Used implemented range, list, hash, and sub partitions to develop partitioning strategies for large tables and create and schedule refreshes for materialized views

Provided high speed parallel bulk and meta data movement of database contents through skillful use of Data pump

Reorganized databases, tables, and schemas to improve performance and aid in capacity planning

Administered and troubleshot 3 node clusters on 10g/11gR2 and configured Grid Infrastructure SCAN listeners

Hands on experience in troubleshooting RAC environment, using srvctl, crs stat and crs profile.

Performed task like administering the RAC using SRVCTL adding nodes, administering storage components

Experience with PL/SQL function and procedure

Experience editing and debugging PL/SQL

Performed cluster-wide resource management, creating resource plans, service configuration, parallel instance groups, and application isolation

Managed all ASM functions including storage, cloning, preparing/adding/and removing disks, tuning I/O, and troubleshooting crashes and memory problems

Expert in logical and physical data modeling and designed logical and physical database structure

Created user accounts, roles, privileges, administrative tasks and schema deployments

Ensured high availability, data protection, and disaster recovery through extensive use of Data guard and physical and logical standby databases

Utilized ADDM and SQL Tuning Advisor in 10g, 11g, and 12c to improve database performance by tuning SQL and instance parameters

Expert on Cluster management, event management, application management, connection management, storage management, load balancing and availability.

Quickly resolved client connectivity issues by using TCP/IP protocol configured SQL*Net files on server and client machines

Expert with setting up physical standby Data guard environment for prod and non-prod databases

Expert in using the data guard broker to manage the data guard environment

Efficiently monitored application and database security along with user accounts and passwords

Extensively used Hints, Indexes, and partitioning to improve performance

Recovered data files from logical and physical block corruptions

Applied all needed security patches including patch set, critical patch updates (CPU), patch set updates (PSU), and one-off patches

Experience in golden gate set up for data replication

Hand on experience trouble shooting golden gate errors

Configured Golden Gate for continuous, real-time capture, routing, transformation and delivery of transactional data across heterogenous platforms.

Hands on experience in collision handling during initial load in golden gate

Met Life Insurance Aurora, IL

Oracle Database Administrator May 2012 – July 2016

Provided prompt 24/7 support for all production and development databases

Utilized RMAN and traditional Data pump export/import to clone and migrate databases

Used RMAN to successfully recover database data during database crashes and media and disk failures as well as create and implement recovery strategies

Extensively used Crontab to schedule and monitor hot and cold physical backups

Created all users, groups, roles, profiles, and privileges for relevant groups

Optimized and tuned SQL queries using AWR, ASH, ADDM, Explain Plan, SQL TUNING ADVISOR.

Applied all needed security patches including patch set, critical patch updates (CPU), patch set updates (PSU), and one-off patches

Skillfully used RMAN and Data pump conventional import/export to implement database, schema, and table level data refreshes

Installed and configured 10.2.0.1 database and upgraded from 11g to non-CDB 12c

Successfully migrated from 11g to 11gR2 and from 12c non-CDB to pluggable databases

Implemented tablespace level TDE security successfully and created Oracle Wallets

Reviewed alert log and trace files to constantly monitor database performance (V$ dynamic performance views at peak load)

Checked database health status including table size growth, extent allocation, free and used space, and fragmentation by creating and running scripts

Managed space maintenance, capacity planning, disaster recovery, and database overall maintenance

Ensured zero downtime during physical standby database creation by using RMAN

performing failover and switchover manually and Data guard Broker

Knowledge in resolving gaps in the data guard environment

Resolved SRS efficiently through use of Oracle Support

Configured Golden Gate for real time replication of data

Knowledge in monitoring golden gate errors using ggserr.log file and the discard file

Experience in troubleshooting golden gate processes like abending replicate and extract

Created standard process documentation for peers to follow and utilize

EDUCATION & CERTIFICATIONS

Bachelor of Science in Management and Economics university of Buea Cameroon

Certified Oracle Database Administration 12c

Certified in SQL Fundamentals

Contact this candidate