Database Administrator Managing Director

Phone: 704-***-**** Email: ***********@*****.***

PROFESSIONAL SUMMARY

** ***** **** ** ********** in Oracle database administration in heterogeneous environments including Solaris, Linux, UNIX, Windows, supporting a variety of mission critical applications on Oracle 10g, 11g, 12c, 18c and 19c

Experience as On-Call 24x7 production DBA support, application DBA, system administrator

Experience in DB Platforms - Oracle, DB2/UDB, AWS, SQL Server and Postgres

Experience in Data Modelling and Shell scripting

Experience in bulk patching via use of ansible

knowledge of infrastructure management systems with outstanding leadership ability and creative problem-solving skills in both strategic and tactical areas.

Excellent communication /documentation skills and strong aptitude to analyse and resolve problems.

Migrate to Multitenant Architecture using CDB and PDBs

Troubleshoot and resolve performance issues with extensive investigation and follow-up with respective application teams and proposed solutions.

Supported application deployments through Jenkins

Experience with RMAN backups and improvement to backups by adding block change tracking in 11gR2

Experience with scheduling Cold/Hot Backups, and backups of Archive logs.

Upgraded from Oracle 10g through 11g to 12c, 12c 2-node RAC and 18c

Created and installed Oracle wallet for Transparent data encryption (TDE)

Installation and configured RAC on different nodes with ASM

I have work for some time as an OFSAA Oracle Admin where I did, installations, upgrades, and performance tuning on financial applications

Data migration across platform

Supported Server migrations, Application upgrades/Migrations and Data centre movements

Configured Offline and Online Disaster recovery sites to maximize database availability

Applied Oracle Patches (CPU/PSUs and One-off patches)

Experience on Data transferring with export/import utilities and Data pump.

Worked with development and operations staff in resolving problems quickly and efficiently

Resolve bottlenecks in database environments using GRID, Multitenant Architecture, OEM, Data Pump, SRVCTL, RMAN, SQL*Loader, Exp/Imp, PL/SQL, SQL*Plus, SVRMGR, Listener.

PROFESSIONAL EXPERIENCE:

PNC Bank– Pittsburg, PA October 2019 – Present

Oracle Database Consultant

•Assist in development of systems and procedures affecting database management, design and maintenance

•24X7support 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 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

Wells Fargo – Charlotte, NC July 2018 – July 2019

Oracle Database Consultant

•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 transection 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.

ALLY Financial Bank Charlotte NC August 2015 – March 2018

Oracle Database Consultant

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 11gand 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 - Dallas, TX April 2012 – August 2015

mplemented 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 24X7support 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.

OTHER EXPERIENCES:

Government High School Akum (Bamenda – Cameroon)

Sept 2009 to April 2012

• Taught Biology to all the grade levels of senior secondary and high school

• Taught computer science for beginners to students of the 6th and 7th grades

• schools sport coordinator and staff in charge of FENASCO games

• coordinated the schools science club.

Government High School (G.H S Bombe Bakundu) Kumba – Cameroon)

Sept 2004 to August 2009

• Taught Biology to all the grade levels of senior secondary and high school

• Taught introductory Chemistry to students of the 5th to 7th grades

• assisted as school secretary in the principal ‘s office.

• coordinated the schools science and Health clubs.

Education:

Bachelor’s Degree in Science (Biology) University of Yaoundé 1- Cameroon

Certification:

Oracle certified database administrator

AWS Developers- Associate

Scrum Master Accredited Certification

Technical Skills:

Operating Systems: UNIX (Solaris 8/9/10, AIX, HP-UX), LINUX (redhat/Ubuntu/OEL 5.8), MS Windows 10,

Languages: PL/SQL, Bash/Korn Shell scripting, HTML, Python

Database: Oracle 10g/11g/12c/18c, SQL Server, DB2/UDB,

Tools: Oracle SQL*Loader, SecureCRT, MobaXterm, SQL*Plus, TOAD, SQL Navigator, Grid Control, Goldengatev11.1/11.2, RMAN, Export/ Import, Data pump, RM (Replication Manager), Oracle Enterprise Manager, Microsoft Office 365, Log miner, Stats pack/AWR, DBUA, ADDM, Oracle Migration Workbench, Pac2000, Service now.

Victor Amungwa

Oracle Database Administrator

Certified Scrum Master

Contact this candidate