Josette Mbanwei

202-***-**** adppog@r.postjobfree.com

Oracle & PostgreSQL Database Administrator (DBA)

Professional Summary

Highly motivated and result oriented oracle OCI, OCA 12C, CompTIA Security+ and AWS certified database administrator (DBA) with a strong hand on 5 years’ experience on both projects and system development life cycle stages (SDLC) in RAC, RMAN, Data Guard, Goldengate, data migration, refresh, Datapump, Data Security, Data Virtualization, performance tuning and data replication. I’m a US citizen with a TOP SECRET CLEARANCE and a member of an Army National Guard and I enjoys working in a team of goal-driven experts where I find tremendous pleasure in completing projects without exceeding the project deadline and without violating the project Service Level Agreement (SLA) and data privacy laws and compliance regulations. Worked diligently to build a system that prevented our databases from planned and unplanned outages or failures.

Project & Production Support

Oracle 19c, 18c,12c, and 11g Versions

Installation & Configuration

Upgrades & Patches

Migration of Systems

Backup & Recovery&Recovery Catalog

PgAdmin, Pg_dump

Dataguard & Broker

Data Refresh, Cloning

RAC, SCAN, Clusterware

Database Provision, Decom

GoldenGate unidirectional

RMAN

TDE, Wallet, Audit Vault

Switchover, Failover

ADDM & AWR Report

SQT T, SQLTXTRACT

Linux/Solaris/Window/AIX

Flashback, PITR

Standby & Primary Databases

Log Miner, Log gap

PgBadger, Pgpool

OEM Database & Grid Control

ASM, OCFS, NAT, Filesystem

Development/Testing/QAT

Career Summary

DDC-ITS Inc. – Montgomery AL

Database Administrator Feb 2020 - Present

Installed, configured, maintained, and supported Oracle 11gR2, 12CR2, physical and logical standby database for testing, developing, and production of various applications.

Excellent in Dataguard configuration, management and resolution of gaps. Enable failover using Dataguard broker and other DG customize tools.

Performing maintenance tasks like Weekly HDD Updates, Monthly Roll Out.

Cloned both full or partial structure of database from PROD to lower SDLC environment

Experience in taking performing database logical Schemas, tables, and Tablespace Datapump export/import backup for refreshing the other lower database environment.

Expertise with database full, and incremental RMAN backup of the database and setting up of the Rman schema catalog for retaining backup information alongside block change tracking

Oversaw 24/7 on-call support for databases using Oracle 12c Cloud Control for alert monitoring and notification.

Experience with large databases (15 Tb) for OLTP and OLAP applications

Upgraded databases from 11.2.0.4 to 12.1 using customize scripts and minimally with dbua.

Initiated and scheduled jobs on Autosys and Crontab to perform bulk related tasks as Database dictionary statistic collection, Health check, and Performance diagnosis.

Excellent in implement and managing all level of Data movement from PROD to other lower environments in SDLC and coordination of database release from QAT to PROD

Extensively investigated and followed-up with application teams and proposed solutions to resolve slowness and performance issues

Experience with oracle STIG

Halliburton Inc. – Houston, TX

Database administrator July 2017 – Dec 2020

Installed, configured, maintained, and supported Oracle 11gR2, 12CR2, physical and logical standby database for testing, developing, and production of various applications.

Excellent in Dataguard configuration, management and resolution of gaps. Enable failover using Dataguard broker and other DG customize tools.

Refreshed and managed large multi terabytes of database from the Delphix engines

Cloned both full or partial structure of database from PROD to lower SDLC environment

Experience in taking performing database logical Schemas, tables, and Tablespace Datapump export/import backup for refreshing the other lower database environment.

Expertise with database full, and incremental RMAN backup of the database and setting up of the Rman schema catalog for retaining backup information alongside block change tracking

Oversaw 24/7 on-call support for databases using Oracle 12c Cloud Control for alert monitoring and notification.

Experience with large databases (10 Tb) for OLTP and OLAP applications

Upgraded databases from 11.2.0.4 to 12.1 using customize scripts and minimally with dbua.

Initiated and scheduled jobs on Autosys and Crontab to perform bulk related tasks as Database dictionary statistic collection, Health check, and Performance diagnosis.

Excellent in implement and managing all level of Data movement from PROD to other lower environments in SDLC and coordination of database release from QAT to PROD

Extensively investigated and followed-up with application teams and proposed solutions to resolve slowness and performance issues

During production hours, resolved lock/latch and resource contention issues for database performance resolution and optimization.

Administered seamless switchovers between datacenters through skillful configuration of Dataguard into active physical and logical standby databases for Dev and QAT read consistency

Upgraded Grid Infrastructure (GI) and databases from 11g to 12c cluster while preserving the content and structure of data.

Applied periodic bundle and security patches release to address database security and bug fixes

Cloned and migrated small databases Datapump import/export and Rman for 11g/12c databases

Monitored and troubleshot GoldenGate replication issues

Provided cost-saving efforts through performance of LOB compression, Secure File, and Deduplication

Configuring PostgreSQL Streaming Replication and Pgpool for load balancing

Experience working on POC of 12c new features like Redaction policy, adaptive query optimization, multiple indexes on single column, Restore table through RMAN etc

Experience with migrating database to AWS cloud services and oracle cloud architecture

Resolved issues involving RAC, OCR, faulty node rebooting and switched over service relocation

Managed the monitoring and troubleshooting of database replication issues

Responsible for all backup, recovery, and upgrading of all of the PostgreSQL databases

Collaborated with application development teams to support and resolve any issues encountered

Manage the Space and Storage of the Databases through various Shell Scripts scheduled in the corncob periodically in regular intervals.

Used OEM, TOAD, SQL DEVELOPER, DB Tools and other customize tools to perform database monitoring, maintenance, replication processes, and performance tuning

Responsible for monitoring environments using monitoring tool viz. Nagios, Check_Postgres.pl, pgOn, custom scripts and other supporting tools like pgBadger and tailmail.

Successfully install and provision databases and software in various database versions including 18C and 19C and have finally upgraded oracle 12cR2 databases to 18c and 19c successfully.

IQVIA Holdings– Durham NC

Oracle DBA Aug 2015 – Jul 2017

DBA supporting three major projects from Development to Production via Tech-Test environments, involving daily configuration, administration all running on IBM AIX 5.3 & 6.1. Database sizes range from 2GB to 3TB (in ODS & EDW environments).

Upgraded Oracle GRID, ASM and Database from 10g and 11g to 12c. Implement Oracle 12c new features in mission-critical production environments.

Administering and setting up of 11g/12c RAC and clusterware and instances.

Resolved RAC issues, OCR related issues, rebooting of faulty nodes, relocating the switched over services.

Database Services creation for distributing the applications across multiple nodes, extensively used all command line utilities SRVCTL, CRSCTL, ADR, ASMCMD.

Implemented Disaster Recovery database 10g/11g Data Guard on physical standby database in maximum performance mode using LGWR ASYNC mode.

Troubleshoot installation errors both independently and with Oracle support (via My Oracle Support)

Create oracle databases on configured servers using both the DBCA, Database creation scripts and with db response file

Administration and supporting of Oracle RAC 11g/12c Databases.

Installation, upgrading, configuration and troubleshooting Golden Gate 11G/12C software.

Refreshing development/test database from production using Export/Import & RMAN backups.

Managed and monitor data replication with golden gate (GG) through ggsci interface.

Perform recovery of critical and non-critical data using Rman and also great with TSPIR

Extensively monitored grid control database, error notification configuration, listener installation, and addition to grid control

Created and implemented recovery strategies, and successfully recovered databases using RMAN

Utilized RMAN utility to schedule and monitor physical backups in the CRON tab

Created users, groups, roles, profiles, and granted privileges according to job needs

Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecks using EXPLAINPLAN, SQLTRACE, TKPROF, AWR, and ADDM.

Used integrity constraints and database triggers to maintain data integrity and security

Applied security patches such as Patch set, Critical Patch Updates, and Patch Set Updates

Used Oracle’s Transportable Tablespace (TTS) to quickly move a user’s Tablespace across Oracle databases

Created Oracle Wallets and implemented Tablespace level TDE security to data at rest security enhancement.

Managed Database Maintenance Activities to achieve optimum database uptime.

Configuration of Listener and Tnsnames

Implemented data refreshes using RMAN, Datapump, and conventional export/import for Oracle 11g and 10g

Installed and configured Oracle 11.2.0.1 database on HP-UX platform

Qualification

Bachelor Decree in gender studies and sociology

Oracle Certified Associate 12C (OCA)

Certified Oracle Cloud Infrastructure (OCI)

Certified AWS Solution Architecture

CompTIA Security+

Contact this candidate