Summary
Overview
Work History
Education
Skills
Certification
Technical Areas
Timeline
Generic

John Ngepung

Nashville

Summary

Dynamic Sr. Oracle Database Administrator with 13+ years of IT experience and 12 years in Oracle Database Administration across UNIX, Red Hat Linux, Solaris, Windows, and AIX platforms. Proven expertise in Oracle architecture, schema and transaction management, Data Guard, RAC, Goldengate, RMAN, OEM 12c/13c, and upgrades from 10g to 19c. Hands-on experience administering Oracle databases on LINUX/UNIX. I am skilled in implementing backup, recovery, and DR solutions using RMAN, Data Guard, and Flashback technologies. Adept at performance tuning using AWR, ASH, ADDM, SQL Trace, TKPROF, OEM, SQL Tuning Sets etc. Experienced in automation using Bash, Shell, and Python scripting. Certified Oracle DBA (OCA/OCP) with strong problem-solving abilities, excellent collaboration with Dev teams, and a consistent track record in handling critical incidents in production support environments.

Overview

14
14
years of professional experience
1
1
Certification

Work History

Sr. Oracle Database Administrator

UBS
01.2019 - Current
  • Sr. Oracle database Production support DBA.
  • First point of contact in resolving performance issues, tuning SQL queries to improve database response time and application performance.
  • First point of contact on critical incidents on Prod, troubleshoot potential severity 1 incidents and resolving in timely manner.
  • Work on PROD and non-PROD support / Managed database replication, performing database refreshes, scheduling, checking, and resolving backup failures and performing recovery as needed on Oracle Databases running on Engineered Systems (Exadata, ODA, ACFS, SUN Solaris, ETC).
  • Manage technical users with technical mappings connecting through certificate-based authentication LOA 2 & 4, 11gr2, 12,18 & 19c.
  • Troubleshooting OID & Ldap users related logins issues.
  • Perform database migrations, Upgrades, Performance Tuning, Patching for business as required.
  • Setup database Monitoring and Tuning of engineer systems using OEM Grid Control & database diagnostic pack such as AWR, ASH ADDM.
  • Perform database RAC installation, configuration, and migration on ASM, ODA, ACFS, VCS & EXADATA machines for load balancing and scalability for business.
  • Supported automation in Bash, shell, and python scripting.
  • Grant roles, privileges, revoke and drop users on change request as required by business needs.
  • Monitoring and administration of Oracle Linux OS and its components (disks, mount points, packages, users etc.).
  • Work with Dev team in developing back-end interfaces using PL/SQL packages, procedures, functions, Object types and Triggers to meet business needs.
  • Work together with Dev teams, perform database performance tuning by creating SQL Tuning sets, Sql Profile and Sql baselines to improve query performance.
  • Plan and implement application BCP/BCM testing by converting PHYSICAL STANDBY to SNAPSHOTS /LOGICAL standby, ACTIVE/PASSIVE DATAGUARD) and create SOPs for future test steps and application validation steps.
  • Perform database migration using RMAN refresh, Goldengate and Data guard, Schema migration using DATAPUMP and user managed backups.
  • Work with automation team in automating data guard sync motoring agents, Goldengate process and creation of restore points.
  • Implement Transparent Data encryption TDE.
  • Automated activities like gathering schema statistics, reports generation on tablespace & recovery usage in OEM.
  • Create database as required for business needs, decommissioned on user request.
  • Database refreshes from 11g,12c 18 and 19c, respectively using RMAN.
  • Flashback transaction, Flashback Database, Flashback Table, flashback drop.
  • Schema refreshes or migrate from production to test or lower environment as specified in change request for application users testing and release.
  • Applying patches like Critical Patch Updates (CPU), Patch Set Updates (PSU) as required.
  • Perform database encryption, TDE security implementation. Wallet and LDAP issue.
  • Performing switchover, Failover, and database Primary/Standby rebuilt post incident.
  • Configuration and administration of ASM Disk Groups, rebalance operation by using Exadata Storage Server.
  • Experience with migrating Oracle database/application servers from AIX/VMware to Exadata.
  • Writing, maintaining, and developing Shell, Bash and Python scripts.
  • Work with automation team to automate processes.

Oracle Database Administrator

Whitehall Holdings Inc
Cincinnati
04.2015 - 12.2018
  • Oracle DBA supporting multiple projects in Prod through Tech-Test environments, daily configuration and administration of critical databases running on Linux red-hat and Unix platforms ranging from 1TB to 50TB.
  • Perform schema refreshes, creating users and granting privileges.
  • Worked resolving hang check timer, split brain, RAC recovery, ASM, OCR corruptions, Voting disk loss.
  • Configured golden gate bidirectional data movement and setup conflict detection and resolution.
  • Provided on-call production support on rotational basis with offshore DBA’s.
  • Install configure and resolves Golden Gate EXTRACT and REPLICATE issues abending errors.
  • Worked closely with the system operations team on database deployment processes.
  • Implemented backup and recovery procedures (Cold/Hot backups using Rman).
  • Cloning RAC to RAC and RAC to NON-RAC using Rman active duplicate.
  • Handled Physical and Logical Corruptions recoveries using RMAN (Recovery Manager).
  • Scheduled database maintenance tasks such as tables/indexes analysis, index rebuild, materialized views refresh and DB exports.
  • Converted physical stand-by database to snapshot-standby for application testing.
  • Worked closely with Dev teams in identifying SQL queries that are consuming high resources and fine-tuned these queries for optimum performance to reduce user I/O.
  • Sync standby databases which have diverged and out of sync with production.
  • Deployed agent Oracle Enterprise manager OEM 12C for monitoring of production database targets.
  • Managed ASM storage, IBM Power Systems. ASM cloning. Prepare/Add/remove ASMdisks. Tuning of I/O on ASM based databases. Troubleshoot ASM crashes & memory problem.

Oracle Database Administrator

Mayo Clinic
Waukon
01.2012 - 03.2015
  • Cloned and Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 10gR2.
  • Implemented recovery strategies whenever required and recovered databases crashed, media/disk failures using RMAN.
  • Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.
  • Applied security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch).
  • Performed data refreshes (Database, schema) using RMAN utility and Data pump, conventional Export/Import.
  • Successfully performed migrations from Oracle 9i/10g/11g RAC (Real Application) Database.
  • Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.
  • Created Physical Standby for disaster recovery, performed Failover and Switchover using Data Guard Broker, convert standby to snapshots for testing.
  • Responsible for Creating Users, Roles, Profiles and assigning the users to groups and granting necessary privileges to the relevant roles.
  • Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
  • Intensify database security using integrity constraints, database triggers and TDE.
  • Extensively worked on setting up auditing in many databases we supported.
  • Tools Used: Oracle OEM, Toad, Service now, RMAN, Data pump, Jira, RAT, SQL TRACE, TKPROF, EXPLAIN PLAN, SQL DEVELOPER, etc.

Education

Bachelor of Science - computer science

Gulf University
12-2009

Skills

  • Database patching and upgrades
  • SQL performance tuning and monitoring
  • Backup and recovery solutions
  • Data migration and replication
  • Database security management
  • Oracle database administration
  • RMAN backup and restore strategies
  • Disaster recovery planning

Certification

  • OCA/OCP Oracle Certified Associate
  • Oracle 11/12c/19c Certified Database Administrator (OCA, OCP)
  • Oracle 11/12c SQL Fundamentals
  • Certification in Microsoft applications package
  • Oracle Cloud Infrastructure 2020 Architect Professional

Technical Areas

Proven experience & expert in Oracle Database Versions: 8i, 9i, 10g, 11g, 12c, 18c, 19c & 23ai, RMAN, Data Guard, Goldengate replication setup and monitoring, Flashback, Windows Server, Linux (RHEL), AIX, Solaris (8/9/10, AIX, HP-UX), Bash, Shell, Python, OEM 12c/13c, AWR, ADDM, SQL Trace, Oracle Cloud Infrastructure (OCI)

Timeline

Sr. Oracle Database Administrator

UBS
01.2019 - Current

Oracle Database Administrator

Whitehall Holdings Inc
04.2015 - 12.2018

Oracle Database Administrator

Mayo Clinic
01.2012 - 03.2015

Bachelor of Science - computer science

Gulf University

Similar Profiles

CREATE PROFILE
John Ngepung