**** ******** ****

Bowie MD *****

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

KENNEDY NGANJO

US Citizen

Clearance Level : Public Trust

PROFESSIONAL SUMMARY:

Over five (5)years of hands-onexperienceworkingonDBA/architecture,production24*7support,implementation, configuration, upgrades, replication, performance tuning/ optimization/ AWR, ADDM, user/security administration,backup/recovery,data/networkadministrationandmaintenance,databasemigration,ASM

Experienced in providing desktop technology, network support including setup trouble shooting.

Experienced in installing and supporting windows server environments

Experience (one year) peoplesoft application

Experience in the support of email environments including Microsoft exchange server and office 365

Experience in upgrading databases and applied patch sets to multiple databases

Highly skilled in all the phases of Software Development Life Cycle (SDLC)

Experienced in implementing scripts using bash, k-shell, and writing scripts for backup purposes

Skilled in handling multiple tasks simultaneously and extended 24 X 7 database support to developers and end users

Strong work experience in developing applications using Oracle SQL Scripts, PL/SQL

Upgrade/migration of Databases from Oracle 9i to 10g, 10g to 11g, and 11g to 12c as well migrating experience over cross platforms from Linux to Solaris, AIX to Solaris and from windows to Linux

Strong analytical and problem solving skills with ability to work within a team environment and independently when needed

Expertise in Database Space Management, troubleshooting, performance tuning, and attaining performance tuning for Oracle database using utilities like STATSPACK, TKPROF, Explain Plan, SQL TRACE, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes

Solid experience in SQL, PL/SQL, Shell Scripting, Partitioning, Logical and Physical Database Design, Backup and Recovery procedures

Expertise in maintaining Database Security using security compliance auditing and loading data from flat files using external tables

Implementing SQL tuning using SQL Tuning Advisor, SQL Access Advisor, SQL Profiler and SQL Optimizer

Result oriented, self-motivated, Team player, ability to work independently and within a team

Experience in migration projects including hands on experience migrating from Oracle 9i to 10g (10.2.0), 10g to 11g and applied oracle patches

Oracle RAC 11gR2 Database Administration including Installation, configuration, Analysis, Design, Backup and Recovery (RMAN)

Experience on Data Replication using Snapshot, Materialized views, import/export

Delivering Oracle database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, AWR, SQL TRACE

Evaluate the procedures done in testing and analyzing computer applications by using knowledge of Perl programming

Support development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan

Hands on experience using Oracle Enterprise Manager (OEM), SQL*PLUS, TOAD and Grid Controlling using OEM

Experience in HP-UX, AIX, SUN SOLARIS, RED HAT LINUX and WINDOWS environments

Extensive experience in the linx/unix platforms

PROFESSIONAL EXPERIENCE:

NU Dimensions, Washington, DC July 2012 – December 2015

Oracle Database Administrator

Upgraded from Oracle 11g to 12c in a recent project

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

Performed Database upgrade from Oracle 9i (9.2.0.7) to Oracle 10g (10.2.0.5) and Oracle 11g (11.2.0.3)

Successfullyapplied RDBMS patches, security patches for improving the security and functionality of the databases

Achieved optimized performance for the databases by rebuilding indexes, implementing portioning methodologies (Range partitioning, List partitioning, Hash partitioning, Composite partitioning) on tables and indexes

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

Utilized TOAD for database management

Leveraged Oracle Support in resolving the SRs

Extensively utilized AWR, ADDM and explain plan for periodic performance tuning

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

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

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

Implemented Flashback technology of the Oracle 11g, 10g along with Recycle bin 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

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

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

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

Environment: Oracle 11.1.0.7, 10.2.0.5, IBM AIX V6.1, RHEL 5.2, RAC, ASM, Datagaurd, Oracle Streams, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM, TOAD 10.0

United Healthcare, East Syracuse, NY October 2010 - June 2012

Oracle Database Administrator

Provided production support database on 9i, 10g and 11g versions with standalone and RAC environment

Supported database platform are Solaris 10 and AIX 5.3

Migrated databases from oracle 10g on Solaris 10 to oracle 11g on Linux on development, integration and production environment

Upgraded databases from 9i to 10g, 10g to different 11g versions

Managed auditing and security with Oracle databases

Monitored and configured Oracle 10g databases using OEM

Leveraged Flash Recovery Area

Created and managed user, table spaces, data files and archive log

Performance Tuned and optimized SQL Query, SGA, and Disk I/O using Oracle Enterprise Manager and by monitoring the Stats pack report generated from snapshots

Utilized Oracle Public and Private Database Link

Applied client patches and other patches as required

Scheduled jobs in crontab including RMAN backup and other memory maintenance, security jobs

Troubleshot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM). Tuned database for optimum performance

Communicated and coordinated with Oracle using My Oracle for major database issues/ problems

Scheduled jobs in crontab including RMAN backup and other memory maintenance, security jobs

Maintained Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC

Successfully installed/maintained Physical Standby database using Oracle Data Guard for Oracle11.2.0.3 and Oracle 10.2.0.5 RAC databases

Implemented switchovers on primary and standby databases as a part of planned maintenance activities

Tested and implemented different physical and logical Backup and Recovery methods like point in time, Media recovery, full/partial export/import

Created and configured of Oracle database of various sizes 200GB, 400 GB, and 2TB in Dev, ITG, Model and Production environments

Performed user management, creation, monitoring and management of database users, altering passwords of users and granting and revoking system/object privileges, roles, auditing user actions in the database

Environment: Oracle 11.1.0.7, 10.2.0.5, IBM AIX V6.1, ASM, Datagaurd, Oracle Streams, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM

ASC Inc, Totowa, NJ October 2009 - July 2010

Junior DBA

Performed in a 24 X 7 environment delivering production database administration, support and monitoring to ensure proactive problem recognition and resolution of database issues

Installed 2 node 11g RAC on ASM feature of oracle and Linux

Proactive monitored database using 11g grid monitoring tool

Handled large databases using Oracle Enterprise Manager (OEM) on daily basis observing the performance of the production database

Provided support to Application Database Administrators in designing the database

Installed and Implemented Backup & Recovery procedures

Utilized RMAN for backup and recovery, Implement Hot and Cold backup plans

Managed schemas and objects partitioning the tables & indexes

Automated data load using Korn shell scripting and SQL*Loader

Set and managed user accounts and granted required privileges to users

Performed other regular DBA activities including space management and performance monitoring

Involved in process improvement, Oracle server installations / upgrades/patches, space management, capacity planning, backup & recovery, disaster recovery, database performance tuning, memory tuning, application tuning, security administration, Data Guard, Oracle Advanced Replication, Real Application Clusters

Delivered performance tuning, memory (SGA) tuning, net backup, RAID, RAW Device

EDUCATION:

University of Yaounde, Cameroon 2002

Masters in International Relations

University of Yaounde, Cameroon 1999

Bachelors in History

Contact this candidate