David A Nkeng

Tel: 240-***-****

Email:ac0wm4@r.postjobfree.com: us Citizen

Oracle Database Administrator

An Oracle Database Administrator working for 6+ years. I possess complete life cycle knowledge including Installation and configuration. Worked on Oracle versions 12c, 11g, 10g performing database administration production and project support. Skills include installation, configuration, performance tuning, cloning, space management upgrades, migration, backup and recovery, patches and security management.

Work Experience

NFP - Austin, TX April 2013 – Present

Oracle Database Administrator

DBA supporting three major projects from Development to Production via Tech-Test environments, involving daily configuration, administration all running on Red Hat Linux 5.3. Database sizes range from 4GB to 1TB (in ODS & EDW environments).

Table refreshes and schema refreshes using Datapump, expdp and impdp.

Database refreshes using expdp, impdp, RMAN Duplicate and cloning.

Experienced in cloning the databases using HOT and COLD backups.

Used RMAN Duplicate and HOT/COLD backups to migrate the data from 11.2.0.1 to 11.2.0.3.

Configured deployed and administered 2 node RAC clusters on Solaris 10 and Redhat Enterprise Linux 5.0.

Extensively involved in performance tuning of applications, SQL queries and databases using Explain Plan, ADDM and AWR reports.

Installation and configuration and administration of Oracle Golden Gate

Replication of data in heterogeneous data environments using Oracle Golden Gate

Created a stand by database by using RMAN Duplicate in order to reduce the down time for the PROD database during the migration process.

Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).

Installation of oracle enterprise manager 12c, oracle management repository and deployed agents

Rebuilt a 2-node RAC databases due to a SAN crash and recovered the 4-node production database after the SAN recovered with latest RMAN backups.

Designed, developed, and implemented database security management, backup/recovery strategy, monitoring methods, and performance tuning. Provided technical support for all application administrators and users.

Applied critical patches to Oracle databases and application servers.

Installed Oracle Cluster ware Software to set up 4-nodes in a production environment.

Manage agents using emctl utility and creating incident rules in enterprise manager 12c

Configuring administration groups, and creating template collections in oem 12c Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).

Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers and Indexes on the tables.

Hands on experience of database Backups and Recovery strategies using RMAN, Export Import Utility (Classical & Data Pump) and Transportable Table spaces.

Installed RAC 12c on 3 node cluster for large production system and migrated the legacy system from Non-RAC environment to RAC 12c cluster database.

Installed and configured EM Central Grid control (OEM Grid) to administer and manage large number of databases and enterprise wide targets.

Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.

Responsible for capacity planning, database security, recovery planning and installing patches

Configured and implemented different types of Advanced Replication Models of distributed databases.

Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF, AWR and also Cluster Interconnect Tuning (RAC).

Provided valuable inputs for various performance tuning issues. Explored 12c features by doing POC, including multi-tenant features

SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.

Responsible for setup and implementation of 2 Node RAC on Linux in 11g and 12c R2.

Implemented Dataguard, creating both logical and physical standby databases in 10g and 11g RAC environment for production database.

Work closely with Systems Analysts, Systems Engineers/Admins & Application Developers through the SDLC from Development to Production, via Tech-Test in Needs Assessment, Requirements Gathering (Server hardware/OS specifications for Oracle Installs), Database Designing (Physical & Logical) and Implementation, database user creation and database access both at role & table levels, as well as final Project Performance Assessment/Evaluation.

Create database Objects, Tablespaces, Schemas as needed.

Schema migrations from Development to Production via Tech Test environments.

Database refresh from Production to Tech Test as needed.

Tools Used: Linux, HP-UX, SQL, PLSQL, SQL Developer, Toad, Oracle 10g/11g, RMAN, Oracle RAC, DATAPUMP, DATAGUARD, ASM

Xcel Energy - Minneapolis, MN Feb 2011 – March 2013

Oracle Production Support Database Administrator

Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.

Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.

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 support of Oracle Databases of sizes ranging from 100 GB to 40 TB.

Part of DB support team, providing 24/7 support for Production databases.

Responsible for design, installation, administration, capacity planning, upgrade, security, management, performance tuning, backup & recovery, patch management, shell scripting, 24/7 technical support of Oracle 12c/ 11g, 10g databases, on Development, Test, QA and Production environments.

Responsible for implementation and administration of disaster recovery strategies for 24/7 operations and deployment of high availability systems on Oracle 11g, using Oracle RAC, Data-Guard, Streams, ASM, RMAN.

Loading data from flat files to database using SQL*Loader, External Tables.

Extensively used AWR, ADDM and explain plan for periodic performance tuning.

Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.

Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 9i and 10g/11g environments.

Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.

Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).

Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) and Network attached storage (NAS).

Documented the Standard Processes for peers to follow.

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

Implemented Flashback technology of the Oracle 11g, 10g along with Recyclebin for a faster recovery of the databases and database objects.

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

Refreshed/cloned databases using RMAN utility.

Performed Database upgrade from Oracle 9i (9.2.0.7) to Oracle 10g (10.2.0.5) and to Oracle 11g (11.1.0.7) RAC database.

Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.

Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.

Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.

Involved in the installation, configuration and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) with ASM file system on AIX platform.

Involved in converting a single instance database to Oracle 11g, 10g RAC databases.

Installed ASM environment and migrated databases from NON-ASM to ASM.

Used TOAD for database management.

Made optimal use of Oracle Support in resolving the SRs.

24 X 7 Production & Development database support and administration.

Environment: Oracle 11.1.0.7, 10.2.0.5, IBM AIX V6.1, Suse Linux, RAC, ASM, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM, TOAD 10.0.

Education

University of Buea (UB), Cameroon

B.sc in Journalism and Mass Communication

Oracle Database Certified Associate 11g (OCA)

Oracle Structured Query 11g Certification (SQL Fundamental)

Professional Summary

Experience in translating business requirements into conceptual, logical, and physical data models.

Experience in configuring Oracle network, RMAN, Recovery Catalog, and Performance Tuning of database by optimizing SQL and PL/SQL scripts and instance. Used statspack report, AWR report, ADDM advisors, autotrace and execution plan.

Experienced with Database Security Administration, system monitoring including adding and removing users, configuring quotas, auditing, and analyzing security problems.

Experience providing 24x7 Production Support, troubleshooting / resolving various types of production issues.

Expertise installing, configuring and maintaining Oracle high availability solutions like Real Application Cluster (RAC) on Oracle 10g & 11g both on Windows and Linux platforms.

Experienced in using 10g features Data pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Monitoring, Recycle Bin.

Experienced performing manual recovery using archived logs, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backups. Proficient at performing major Database Release Upgrade (manually as well as using DBUA) along with applying various PSU patches using OPatch for 10g 11g databases.

Adept at routine Database Administration tasks including automated installation, creation and replication of databases, management of tablespaces, logs, grants, roles, users, indices.

Working experience in database cloning, database backup, recovery procedures and security.

Experience in application Support, SQL Loader, Data pump, Data Guard, Fine Grain Auditing (FGA), performing Flashback, transportable tablespaces.

Experience in designing and configuring high-availability systems using DATAGUARD with physical standby. Effectively used DATAGUARD BROKER utility.

Hands on experience in installation and maintenance of enterprise manager 12c and Grid Control 11g and addition of targets for database Monitoring/Performance/Diagnostics purposes.

Installed Grid Control with RAC repository and configured cloning of agent installations

Resolved the crs issues in RAC database in different scenarios ( time synchronization, kernel parameters, inter instance communication bugs, ASM monitoring from OEM, SAN modifications, network modifications, cluster hung, temporary tablespaces)

Modified network interface for RAC public and private interconnects

Implemented and maintained 12c multitenant architecture using container and pluggable databases and performed conversion of non-container databases to pluggable databases

Experience in Performance Tuning, Tuned various large critical OLTP and OLAP databases using various tools like AWR, STATSPACK, ASH, SQL-TRACE, TKPROF, ADDM and Explain Plan Utilities. Experience in the management and implementation of database models, data flow diagrams, database schemas, database scripts, to support a robust data management infrastructure.

Qualified at writing SHELL Scripts and using CRONTAB for automatic backups.

Adept at installation of OEM Database Control, OEM grid control and Deploying Agents

In-depth knowledge and understanding of Oracle Database features such as RMAN for backup and recovery, Materialized Views, Export/Import, Data Pump and Data Guard. Working knowledge of Auditing and Database Security.

Installed and configure Veritas cluster(Veritas storage foundation) for RAC database installation an configuration and upgraded it from 10g to 11gR2

Migrated OCR and Voting disk from GPFS to ASM

Explored 12c RAC features like Flex cluster etc

Experienced in Designing, Installing, Configuring and Maintaining Real Application Cluster (RAC) using raw devices, OCFS, Automatic Storage Management (ASM) and SRVCTL utility.

Technical Skills

Operating Systems

HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise Server 9, 10. Windows 95/98/NT/2000.

RDBMS

Oracle 10g, 11g, 12c

Languages

SQL, PL/SQL, UNIX Shell Scripting, PERL.

Tools

TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM.Toad, Putty, NX client, Winscp, Remote Desktop Connection, VNC, Team Viewer, LogMeIn and Cisco VPN Client

Database Utilities

SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export, Import

Contact this candidate