Victor Amungwa

Work History

Oracle Database Consultant

PNC Bank

10.2019 - Current

Assist in development of systems and procedures affecting database management, design and maintenance
24X7 support for over 3500 databases in production QA and UAT
Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups
Provide status reports to senior management
Use Unix/Linux Shell scripting (KSH, BASH) and also experience with job scheduling systems like crontab
Hands on knowledge of AIX HACMP, Oracle Dataguard, UNIX environments including AIX and RHEL
Responsible for monitoring and implementing database changes in production environments
Restore the health of databases and ensure no performance issues arise after periodic Linux patching
Perform database upgrades from 12.1 to 12.2 and from 12.2 to 18.6
Monitoring and troubleshooting gaps between source and target databases configured with golden gate
Control system resource usage and perform capacity planning, perform troubleshooting and diagnostic activities
Use of ITIL framework in aligning IT services with the strategic demands of business
Designed, tested and debugged external and DB2 native stored procedures
Worked with remote stored procedure calls
Extensive experience in utilities and tools used for database monitoring (DB2 traces, online performance monitors, reports, EXPLAIN, DB2 catalog queries), data movement and organization (LOAD, UNLOAD, REORG), data consistency utilities and catalog manipulation utilities (RUNSTATS, MODIFY, STOSPACE), etc
Competent and experienced in using IBM utilities, Omegamon and other third party tools like CA/DB2 tools (platinum products), TMON, Omegamon and BMC tools
Experience in data guard configuration, implementation, and maintenance of standby databases
Supports Database versions including 11c, 12c, 18c using Real application Clusters (RAC) and standalone Oracle Instances
Hands on experience on performance tuning and troubleshooting skills for Oracle 12c/19c and Exadata
Migration of On-prem Oracle database onto RDS in AWS
Experience in Installation, Configuration, troubleshooting and Maintenance of Oracle Goldengate in production environment
Experience in Using Goldengate 21.6 to maintain Live Standby Database and propagate replication of data from source to target
Used OCI to Cache objects in memory on the client machine and to Create, update, and delete objects in the cache
Worked with OCI to provides navigational access to API objects
Experience in Using Goldengate for Active-Active Synchronization (Bi-Directional Replication)
Provide support on all the stages of database implementation and/or database related deployments
Run diagnostic tools to identify database performance bottlenecks and take appropriate corrective actions to improve database performance
Work with development teams to tune SQL queries
Dataguard administrations, DG Broker configuration & administrations & Good experience in DR activations
Developed various backend application programs such as Views, Functions, Triggers, Procedures and Packages combining SQL and PL/SQL
Created procedures and functions using PL/SQL
Create, modify and test various SQL queries, stored procedures and views for obtaining data from diverse source systems and platforms
Efficiently managed multiple, competing, high-priority projects with varying SLA
Upgrade and migration of Oracle database within and across other platforms
Performing regular activities like monitoring the alert logs, redo log status, listener
Log and checking the space for normal segments, rollback segments and tablespaces
Document the logical and physical components of operational databases and their functionality
Support application teams with performance tuning and production performance issues and the recovery of databases using RMAN and flashback technology
Use of tools like SQL Tuning Advisor, TKPro, ADDM and AWR reports to check and improve on database Performance

Oracle Database Consultant

Wells Fargo

07.2018 - 07.2019

Upgrade, enhance and migrate Oracle server-based application that meets user requirements
Follow database development standards for enterprise and application databases
Design database Backup and Restoration Strategy for 11g and 12c
Deploy database change scripts provided by third party vendors
Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables
Loaded Data into Oracle Tables using SQL Loader
Identifying, recommending, and implementing emerging Modeling and IT trends, developments, tools and improvements/solutions
Create, manage, and modify logical and physical data models using a variety of data modeling philosophies and techniques including Inmon or Kimball
Work with the development team to implement data strategies, build data flows and develop data models
Partitioned large Tables using range partition technique
Document the logical and physical components of operational databases and their functionality
Understand table indexing and query strategies, database objects maintenance and performance issues
Database upgrades from 11g to 12c, database enhancement and migration
Analyse problems as assigned and provide solutions to address business needs
Performed Unit Data Testing
Experience in Configuring Oracle Goldengate in Heterogeneous environment (operating systems and databases)
Experience of Using Logdump Utility to check Trail files and troubleshoot
Experience of developing solutions for handling high TPS transaction load using Goldengate
Developed automated continuous integration system with tools developed in Python and Bash
Configured Goldengate for High Availability using Oracle DBFS and active Dataguard
Installed and configure Golden Gate Agent to work with OEM Goldengate plugin
Managing Day-to-day Basic Database Administration work deployments in Development, Test and Production databases

Oracle Database Consultant

ALLY Financial Bank

08.2015 - 03.2018

Installation of oracle 11g and 12c databases in production, development and test environments depending on project requirements
24/7 production support of processes such as incident change and problem management, with responsibility of supporting critical applications, performing dedicated maintenance activities, live database performance tuning, cause analysis and recommendations
Experience as member of AWS Build Team, Setup/ managed EBS Volumes and EIP to EC2 Instances
Designed AMI images of EC2 Instances by employing AWS CLI and GUI, created and Managed User Accounts, Log Management, Shared Folders, Reporting, Group Policy Restrictions
Applying upgrade patch, maintenance and interim patches on all the databases
Refreshing Dev and Test instances with data from Production on a regular basis
Defragmentation of tables and indexes for improved performance and effective space management
Responsible for database maintenance, backups, recovery, patching, upgrades and performance tuning, user access control
Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration in RAC environment
Monitored and trouble shoot database issues with OEM grid control
Built physical standby using RMAN Active duplication method as well for Disaster recovery site
Used ASM for creating disk groups, additional storage (DISKS) and troubleshooting ASM issues
Setup the unidirectional replication on oracle 11g and 12c databases using Goldengate
Managed Database Maintenance Activities to achieve optimum database uptime
Provided technical assistance for development and maintenance of version control procedures
Successfully installed Oracle Real Application Cluster (RAC) including Grid infrastructure (Cluster ware and ASM) and Oracle RDBMS software on a 2 nodes RAC architecture in development and UAT running oracle
Configured 12c Oracle grid infrastructures & Oracle database software to meet the current needs and upgraded as required to meet the expansion needs of the company
Performed logical backups using Export/Import and Data Pump
Perform database security by creating and configuring Data base wallet for TDE Transparent Data Encryption options
Doing the regular activities like monitoring the alert logs, redo log status, listener
Log and checking the space for normal segments, rollback segments and tablespaces
Planned and implemented database backups (operating system, full/partial backups, and export/import) using various types of backups
Performed other Oracle DBA responsibilities performance tuning, monitoring tablespaces, monitoring users, etc
As well as much problem solving

Barclays

04.2012 - 08.2015

Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN
Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs
Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups
Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries
Maintained the data integrity and security using integrity constraints and database triggers
Provided 24X7 support for all the production and development databases
Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using 'runInstaller' and opatch utility
Experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import, allowing users to quickly move a user Tablespace across Oracle database
Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 10g, 11g and 12c
Performed Installation and configuration of Oracle 10.2.0.1 database on HP-UX platform
Successfully upgraded the databases from 11g to non CDB 12c
Created Oracle Wallets and implemented Tablespace level TDE security
Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files
Use scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc
Performed space management, capacity planning, disaster recovery and overall maintenance of the databases
Created Physical Standby databases using RMAN with zero downtime, performed Failover and Switchover using Data Guard Broker and manually when required
Worked extensively with Physical Standby database, troubleshooting, switchover and switchback with Physical standby setup

Summary

Overview

Work History

Oracle Database Consultant

Oracle Database Consultant

Oracle Database Consultant

Education

Bachelor’s Degree - Biology

Skills

Certification

Timeline

Similar Profiles

Tammy BentonTammy Benton

Erica HendryErica Hendry

Abel Maldonado JrAbel Maldonado Jr

Courtney KutscherCourtney Kutscher

Todd BraggTodd Bragg