NKONGHO TABI OJONG

Oracle Database Administrator

Phone: 240-***-****

Email: adbgcb@r.postjobfree.com

Professional Summary

•Over 8 years of strong experience in Oracle database administration in heterogeneous system environment including Solaris, AIX, Linux, UNIX, and Windows, supporting a variety of mission critical applications with Oracle 10g, 11g and 12c.

•Five years of experience working with Oracle database security. And new features of Oracle 12c such as Oracle Data Redaction.

•Basics knowledge on AWS and supporting Databases on AWS

•Utilized data redaction, preventing data exposure to database users who run ad hoc queries directly against the database and also avoiding the exposure of data to unauthorized users.

•Experience in implementing database level security solutions; data redaction and data masking.

•Experience as On-Call 24x7 production DBA support, application/development DBA, system administrator.

•Monitored physical I/O and Proper sizing of rollback segments.

•Optimized SQL using explain plan, Auto trace feature and TKPROF to analyze the execution plan and tune the statements.

•Over 4 year of experience with RAT from my previous enviroments

•Tuning of database using Utlstat scripts Statspack and dynamic performance views to monitor system statistics and wait events, AWR, ADDM and Tuning of SGA.

•Proven technical knowledge of infrastructure management (network, systems), combined with outstanding leadership ability and creative problem solving skills in both strategic and tactical areas as well as excellent communication /documentation skills and strong aptitude to analyze and resolve problems.

•Migrate to Multitenant Architecture using CDB and PDB of applications that otherwise have their own instances and qualify to be PDBs.

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

•Responsible for RMAN backups, and improvement to backup with incremental back by adding block change tracking feature of Oracle 11gR2.

•Created Users, Roles and Profiles, Privilege management with role-based security.

•Performed database tuning using Explain Plan, TKPROF, Statspack, Automatic Workload Repository (AWR), Active Session History (ASH), and Automatic Database Diagnostic Monitor (ADDM) and SQL Trace.

•Maintaining and scheduling Cold Backups, Hot Backups, and Export Dumps. Maintaining backups of Archive logs and automating cleaning of archive logs. Deploying RMAN to automate backup and maintaining scripts in recovery catalog.

•Upgraded Oracle 10g database version to 11g.

•Upgraded Oracle 11g database version to 12c version

•Provided database related services to their development & QA environments.

•Good experience of Installation and configuration of RAC (Real Application Server) on different nodes with ASM (automatic storage management).

•Upgraded various databases from 9i to 10g, 10g to 11g, 11g to 12c and minor version upgrades

•Upgraded 10g and 11g Standalone databases to 11g and 12c 2-node RAC

•Configured Offline and Online Disaster recovery sites to maximized the database availability

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

•Strong skills in SQL* PLUS, PL/SQL, SQL* Loader, UNIX Shell scripts (KSH and CSH), Import/Export Server Manager.

•Experience in installation, upgrades, patches and TAR support. Duties included database creation, Performance tuning/reorganization, cloning, backup/recovery, user and security management, auditing, general troubleshooting, coding, and configuring servers.

•Worked on Creation of table spaces, data files, roles, redo logs, rollback segments, stored procedures and Triggers.

•Worked on Data transferring with export/import utilities and Data pump.

•Highly experienced in performance monitoring/tuning/troubleshooting.

•Oracle Database performance-tuning services with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE. Applying patches under UNIX platform.

•UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.

•Participated in planning and implementation of off-site Disaster-Recovery planning and testing

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

•Resolve the bottlenecks in all the database environments.

•Extensive knowledge in maintain Oracle Cluster ware using Srvctl, Crsctl, has, ocrconfig, cluvfy, Private IP, public IP, SCAN IP and Virtual IPs along with NAS and SAN for ASM storage.

•Worked extensively in Performance Tuning at various levels including instance tuning, Query tuning, Database performance tuning. Experienced in performing Database related activities using GRID, Multitenant Architecture, OEM, Data Pump, SRVCTL, RMAN, SQL*Loader, datapump, Export, Import, PL/SQL, SQL*Plus, SVRMGR, SQL*Net/Net8, Listner, AGENT Tuning using explain plan, SQL Trace, AWR, ADDM, SGA tuning, Statspack and tuning of initialization parameters.

•On call technical support for 24x7 mission critical production databases. Willing to work beyond regular hours.

Technical Proficiencies

Operating Systems

Red Hat Linux RHEL 5.x, AIX 5.1, 5.2, 5.3 and 6.1, SOLARIS 2.5, 2.6,

RDBMS

Oracle 10g, 11g and 12c

Languages

SQL, PL/SQL,UNIX Shell Scripting, Ksh, bash and Perl Scripting

Software/ Applications/ Tools:

DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), OEM Grid Control, Oracle Data Guard, Oracle Management Service (OMS), Real Application Clusters (RAC), ASM, Sql Navigator, TOAD, Data Pump (expdp,impdp),SRVCTL,SQL*Plus,Oracle Communications Unified Inventory Management (UIM)

Tuning Tools

SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM

Web Tools

HTML, XML

Professional Experience

ENTERGY - Frisco TX Febuary - 2017 - Present

Role: Oracle DBA

Environment: Oracle 12c11g/10g/9i, Linux/Unix Solaris, OEM, Statspack, RMAN, AWR, ADDM, DataPump, Oracle Exadata

Responsibilities:

•Installed, configured, and maintained Oracle 10g and 11 g R2 on Linux and also Upgraded from Oracle 10g to 11g.

•Involved in checking and managing tablespace growth, monitoring the data file growth and extents too.

•Over 1 year of Experience with Unix

•Upgraded 10.2.04 to 11.2.0.1. Upgrade database along with OH, ASM_HOME and CRS. Upgrade RAC from 11R1 to 11R2 on 3 nodes.

•Installation, Administration of 11gR2 RAC on HP-UX. Configured ASM, and RAW devices for storage. Investigation of node eviction, CRS resources failure. Running Queries in parallel, setup inter instance parallelism, Load balancing. Resource utilization on each node. Fix corrupted OCR disk.

•Tuning of RAC environment. Managing fail-over of instances. Configure table for parallel load.

•Managed ASM storage. ASM cloning. Prepare/Add/remove ASM disks. Tuning of I/O on ASM based databases. Troubleshoot ASM crashes & memory problem.

•Data guard Implementation, configuration of data guard between two data center.

•Grid control, monitoring, configure UDM, troubleshoot error related to agents and other issues. Generate weekly report on system heath check.

•BACKUP, configure RMAN centralized backup for all database. Create standby database from Active database using RMAN. Cloning of RAC to Non-RAC database using RMAN. Test & validate restore and recovery for SLA.

CITI BANK - Irving, TX August 2013 – Jan 2017

Role: Oracle DBA

Environment: Oracle 11g/10g/9i, Linux/Unix Solaris, SQL Developer, PL/SQL, Shell scripting (Bourne), OEM, Statspack, RMAN, AWR, ADDM, DataPump.

Responsibilities:

•Capacity planning: Allocate system storage and plan future storage requirements.

•Oracle HA Stack: Install, Configure, Setup, Maintain and Support Oracle 11gR1, 11gR2, 12c RAC, Physical and Logical Standby database for Test, Development and Production for various home-developed applications

•Over 1 year of experience with Unix

•Over 1 year of exoerience with AWS

•Involve in supporting, migrating applications in AWS on Oracle

•Involve in 24x7 on-call support for 12 databases of 2.0 TB 3 Node production 10g and 11g RAC databases using Oracle 12c Cloud Control for Alert Monitoring and Notification

•Upgrade DBs from 11.2.0.4 to 12.1. Responsible for setting and managing USER MANAGEMENT, SPACE MANAGEMENT Granting required privileges to users.

•RAC- Administration/Trouble-shooting of 3 Node cluster on Oracle 10g/11G R2. Configuring Grid Infrastructure SCAN Listeners on 11gR2. Migrate OCR files to ASM. Trouble-shoot Resource related issues. Cluster-wide Resource management such as create resource plan, Service configuration, parallel instance group, Application Isolation. Stress testing, benchmarking of clustered database.

•Managed ASM storage. ASM cloning. Prepare/Add/remove ASM disks. Tuning of I/O on ASM based databases. Troubleshoot ASM crashes & memory problem.

•Data guard - configure primary -standby using duplicate from active database command of 11g. Apply SCN-based Incremental backup to sync standby after loss of Archivelogs on primary. Measure data loss based on latency/lag. Cross-platform migration using Data guard.

•Apply in-place/out-of-place PSU Patch in 11R2. Install bug fix patch.

•Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.

•Refreshing Dev and Test instances with data from Production on a regular basis.

•Creating and assigning appropriate roles and privileges to users depending on the user activity.

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

•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

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

•Created database link between two databases to access the table data from one local database to remote database using distributed database feature.

•Planned database backups (operating system, full/partial backups, and export/import) using various types of backups and designed the backup methodology for the organization..

•Performed other Oracle DBA responsibilities performance tuning, monitoring tablespaces, monitoring users, etc. as well as much problem solving.

•Designed Logical and physical database for business transaction functionality.

•Provide production support for the deployed project till it is stabilized.

•Written SQL scripts to create database objects like tables, views and sequences.

•Created procedures and functions using PL/SQL.

•Preparation of High Level & Low Level Design documents.

Farmers Chase Bank - Pheonix AZ August 2010– July 2013

Role: Oracle DBA

Environment: RHEL 5.X; Windows NT 2000/2003; Oracle 10g, 11g,Linux/Unix

Responsibilities:

•Installed, configured, and maintained Oracle 10g and 11 g R2 on Linux and also Upgraded from Oracle 10g to 11g.

•Involved in checking and managing tablespace growth, monitoring the data file growth and extents too.

•Over 1 year of Experience with Unix

•Upgraded 10.2.04 to 11.2.0.1. Upgrade database along with OH, ASM_HOME and CRS. Upgrade RAC from 11R1 to 11R2 on 3 nodes.

•Installation, Administration of 11gR2 RAC on HP-UX. Configured ASM, and RAW devices for storage. Investigation of node eviction, CRS resources failure. Running Queries in parallel, setup inter instance parallelism, Load balancing. Resource utilization on each node. Fix corrupted OCR disk.

•Tuning of RAC environment. Managing fail-over of instances. Configure table for parallel load.

•Managed ASM storage. ASM cloning. Prepare/Add/remove ASM disks. Tuning of I/O on ASM based databases. Troubleshoot ASM crashes & memory problem.

•Data guard Implementation, configuration of data guard between two data center.

•Grid control, monitoring, configure UDM, troubleshoot error related to agents and other issues. Generate weekly report on system heath check.

•BACKUP, configure RMAN centralized backup for all database. Create standby database from Active database using RMAN. Cloning of RAC to Non-RAC database using RMAN. Test & validate restore and recovery for SLA.

•Responsible for all database activities such as User management, space management, database security management.

•Implemented the resizing the online redo logs in production and in standby database.

•Automated Database refresh from the Host system to Oracle using, SQL and PL*SQL procedures.

•Implemented Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using Data Guard feature of Oracle 10g R2.

•Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration in RAC environment.

•Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.

•Collecting performance statistics using Stats pack/AWR (Automatic Workload Repository) and analyzing by ADDM (Automatic Database Diagnostic Monitor)

•Rebuilding indexes or analyzing the index as per the fragmentation level and minimize the performance issues.

•Refresh/Cloning of Database from production environment to test environment and application of patches.

•Monitoring the CPU usage, IO statistics, and CPU time to identify any OS level Performance killers

•Experienced of managing and administering 24 X 7 running databases and support

Education & Training

UNIVERSITY OF DSCHANG CAMEROON

POST GRADUATE DIPLOMA IN LAW OF INTERNATIOMAL TRADE AND INVESTMENT LAW

UNIVERSITY OF DSCANG CAMEROON

BACHELOR’S DEGREE IN LAW AND POLITICAL SCIENCE

Contact this candidate