Manager Management

YVETTE NDJIGUI

ORACLE DATABASE ADMINISTRATOR

********@*****.*** 240-***-****

PROFESSIONAL EXPERIENCES SUMMARY

Over 6+ years of strong experience in Oracle database administration in heterogeneous system environment including WINDOWS, HPUX, UNIX and LINUX amongst others.

Team player with excellent interpersonal, analytical and communications skills

Monitored and managed various database components (logical & physical) like tablespaces, segments

Worked extensively on Shell scripting for backup, recovery and maintenance for databases

Experienced in full life cycle of database administration in Oracle. Worked as a Development Support DBA in Oracle.

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

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

Good knowledge on the Creation of table spaces, data files, roles, redo logs, rollback segments, stored procedures and Triggers.

Extensive experience in Performance Tuning of database, instances, SGA, I/O, and Rollback segment using different methods and detecting locks.

Experience in Implementing FLASHBACK technology and its various features in Oracle 10g/11g.

Configured physical and logical Standby Database (Data Guard) and tested for business continuity/Disaster recovery plan.

Expertise on Installation/Configuring/Maintenance of Oracle Streams for replication, integration and transmission of data between different databases and applications.

Experience in applying several patches such as CPU/PSU patches, One-Off Patches, Interim patches, DST, Patch sets as per the oracle recommendations.

Wrote scripts to inform the DBA team on the status, performance and space management of the database

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

Duties included database creation, backup/recovery using RMAN, tuning/reorganization, user and security management, auditing, cloning, general troubleshooting, and configuring servers.

Extensively used Oracle Enterprise Manager (OEM) for maintaining and monitoring database.

Experience in Logical backup using and full/ partial export/import and Data Pump.

Data Migration from one platform to another using datapump.

Data cleansing, scrubbing to remove and amend data.

I have worked with golden gate which is a comprehensive software package for real-time data integration and replication in heterogeneous IT environment.

TECHNICAL ENVIRONMENT

OPERATING SYSTEMS:

Red Hat Linux RHEL 5.x and Windows XP

RDBMS:

Oracle 10g/11g

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), Agents, Real Application Clusters (RAC), ASM, Sql Developer, TOAD, Exp/Imp, DataPump (expdp/impdp),SRVCTL,SQL*Plus, Recovery catalog, Autosys, Crontab, HP Manager, My Services, OTG etc

TUNING TOOLS:

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

WEB TOOLS:

HTML, XML

Pfizer Inc - Kalamazoo, MI

Role: Oracle Database Administrator April 2013 – Present

Environment: Windows, RHEL, Oracle 11g, Oracle RAC (11g), Data Guard, Oracle Grid Control, RMAN, ASM, STATSPACK, SQL Developer, TOAD, SQL*Plus.

Responsibilities:

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

Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.

Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.

Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.

Performance tuning of the database – SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF

EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O.

Expertise in PL/SQL, SQL and UNIX Shell Scripting (Implemented UNIX Scripts using CRONJOB for

Day-to-Day activities and Windows Task Scheduler)

Supported Security User Management, Privileges, Roles, Auditing, Profiling, Authentication

Monitored and performed database sizing, tablespace management and rollback tablespace management, transaction management and security administration

Database monitoring and performance tuning using OEM (Oracle Enterprise Manager)

Index creation and management for optimization of DB Processes

Used Grid Control extensively and set up Rules for alert notification and schedule RMAN backups with Failure notification

Performance tuning of Queries by maintaining Aggregates, Compression, partition, Indexing and use of Hints, Stored outlines, Statistics for the same.

Performance tuning and diagnosing DBMS and individual Production databases, organized various migration review meetings with the application team to discuss the migration strategy based on their requirements.

Performed policies on data confidentiality, integrity, availability, and auditability, based on Access controls for Access to Data at the database level.

Performed SQL and PL/SQL tuning oracle contention and monitored production database using Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM) and Automatic Session History (ASH).

Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle 11gR2 Grid and 10g on ASM and OCSF2 file systems.

Highly experienced in Oracle 11g, 10g Automatic Storage Management (ASM) required to fulfill the storage needs.

Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g, 10g RAC servers for the purpose of disaster recovery procedures.

Supported & maintained the Production/Development databases on various servers

Extensively worked on setting up auditing in many databases we supported

Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.

Database reorganizations and refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins

Used hints for SQL tuning and optimization

Performed Explain Plan analysis for Query Optimization and SQL tuning

LIMITrader Inc. New York, NY

Role: Oracle Database Administrator February 2010 – March 2013

Environment: Oracle 10.2.0.1, HP-UX 11, Sun Solaris 10.0, RAC, Oracle Streams, RMAN, Data Pump, SQL TRACE, TKPROF, EXPLAIN PLAN.

Responsibilities:

Performed monthly and annual performance reports for trend analysis and capacity planning.

Successfully installed and configured Oracle 11.1.0.7

Performed housekeeping tasks like checking log and trace files.

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

Refreshed schema using Export/Import. Created the database, table space, tables, indexes, set privileges and user logins.

Assist in SQL tuning and providing consultation such as creating Materialized views, adding indices, dropping unnecessary indices, using hints wherever possible, amongst others.

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

Refreshed/cloned databases using RMAN utility.

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.

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 10g and 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).

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 Sun Solaris platform.

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

Utilized TOAD for database management.

Intermedia Communications, Inc - Brandon, FL January 2009 – December 2010

Oracle Database Administrator

Responsibilities:

Install oracle database software 9.2.0.1, 10.2.0.1 and 11.1.0.6.0 using oracle universal installer on development, test and production server for their claim, policy and online applications in IBM AIX 5.3 environment.

Install OEM grid control that includes oracle agent, management repository and management service on VMware Red Hat Linux virtual machine. Install agents on various AIX database servers.

Upgrade software and databases from 9.2.0.1 to 9.2.0.6, 10.2.0.1 to 10.2.0.3, 9.2.0.6 to 10.2.0.3 and 10.2.0.3 to 11.1.0.6.0 on development; test and production databases on AIX database servers. Apply patch set to upgrade software and use database upgrade assistant, export/ import and manual scripts to upgrade databases.

Migration of full 9.2.0.6 databases, schemas those are on Linux environment into AIX, 10.2.0.3 database environment using export/import and data pump utility.

Create development, test and production databases using database configuration assistant- DBCA, manual scripts and sqlplus using Automatic storage management- ASM.

Database performance tuning using AWR, ADDM, ASH, sql tuning advisor, explain plan, statistics, blocking sessions, STATSPACK, TKPROF, sql query restructure and sql trace.

Schedule cronjob for daily night hot/online backup of production databases on tape using RMAN scripts.

Refresh or restore development, test and reporting databases from production database backup using RMAN scripts or export/ Import and data pump utility.

Schedule a cronjob and create lots of shell script in Unix environment like backup and restore of databases, update statistics, export and import of tables, log file maintenance, cleanup archive logs, startup and shutdown databases, email logs and alert to users, mount point space check, tablespace size check and business related activity like automatic bill payment, check generation, bill generation and many more.

Created physical standby database on remote server to provide high availability.

Environment: RMAN, OEM, SQL*Loader, EXP, IMP, Data pump, Oracle 9i/10g, AIX 5.1, 5.2, 5.3

Education

University of Buea BSc Banking and Finance 2000-2003.

OCA Certified.

Contact this candidate