Manager Oracle

NGANGWA MARCEL

Oracle Database Administrator

Telephone: 240-***-****

Email: ********@*****.***

Skills Summary

•Experienced Oracle DBA with 7 years of experience in Oracle Database Administration in large-scale production environments across multiple platforms.

•Ability to provide expert-level technical support in all aspects of database administration including installation, configuration, upgrades, patching, migration, capacity planning, performance tuning and backup & recovery Hands-on experience with Oracle Real Application Clusters (RAC) and Data Guard.

•Ability to work both as an individual contributor and as a member of a team.

•Experience in Performance tuning of Oracle GoldenGate Processes to achieve zero lag times.

•Hands on experience on using of macros, conflict resolution, filtering and transformation, exception handlers and Security.

•Experience with Oracle Data Guard setup, maintenance and troubleshooting for High Availability.

•Experience in performing Backups/Recovery using RMAN, Datapump and Flashback Technologies.

•Experience in SQL Tuning using tools like Explain Plan, SQL*Trace, TKPROF and OEM.

•Effective troubleshooting of Database Performance and tuning using ASH, AWR, ADDM.

•Experience in Database capacity planning, monitoring object growth and Storage Management.

•Performed data migration from flat files into an Oracle database using SQL*Loader.

•Experience in performing Cloning and Refresh using RMAN and Datapump.

•Experience in Oracle Advanced Compression techniques.

•Experience in Online/Offline Re-Organization of database objects.

•Experience in Partitioning Tables, Rebuilding of Indexes, Securefiles, DBLINKS, Materialized Views, Store Procedures, Triggers and constraints.

•Demonstrated proficiency in managing Oracle Instance, database storage structure, schema objects, managing tablespaces, Rollback and undo segments, creation of database objects, Data Modeling.

•Experience in defining Users, Roles, Privileges, Auditing to ensure database Security.

•Experience working with database security tools TDE, DB Vault / VPD.

•Experience in applying CPU/PSU patches to various versions of databases with minimum downtime.

•Experience in upgrading Oracle Binaries and databases from 10g to 11g and 11g to 12c.

•Experience in handling very large databases (VLDB) ranging up to 100TB.

•Proficient in writing SQL, PL/SQL (Stored Procedures, functions, packages and triggers) scripts.

•Proficient with PostgreSQL

•Experience in Shell Scripting for configuring monitoring alerts and automation.

•Experience in performing Data Migration between Non ASM and ASM databases and also between the databases of different vendors.

•Worked with EXP/IMP, EXPDP/IMPDP to refresh the schemas and

•Database Performance Tuning Diagnosing using AWR (Automated Workload Repository) / Stats pack and ASH (Active Session History) reports, ADDM (Automatic Database Diagnostic Monitor) analysis.

•Proactive database monitoring via automatic Email and Text alerts of Alert.log, Listerner.log and Space errors to DBA cell phone

•Experience in Upgrading databases, applying patches.

•Managing Security Management, Schema Management, Instance Management, Storage/Space Management.

•Proficient with Database Cloning, Migration, and Patching of Oracle Databases.

•Installed Oracle 11g with ASM and OCFS2 File systems.

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

•Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.

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

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 2008, 2010

RDBMS

Oracle 10g, 11g, 12c

Languages

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

- Experience with migrations using Oracle and PostgreSQL (absolutely must have)

- AWS migration experience DMS (data migration services)

Tools

TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM. Toad, Putty, NX client, Winscp.n Fire 15K, Sun 6320 Storage, Sun Enterprise Servers 890/880/420/450, Sun StorEdge 6320, Hitachi, EMC, Dell Servers, Compaq Servers 6000/3000/1600/800, HP/UX-9000, Red Hat Linux 6.2

Database Utilities

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

Career Summary

KROGER TECHNOLOGY -CINCINNATI, OH JAN. 2018- Current Job

Oracle Application Database Administrator

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.

•Experienced in configuration of ASM for RAC and NON- RAC environments.

•Configured Repository and clients for GRID Control and also implemented DB Control for some databases.

•Utilized Oracle streams to Capture, Propagate and apply the transfer of data, transactions and events within managed Databases.

•Scheduling and maintaining level 0 and level 1 RMAN (Recovery Manager) backups.

•Test backups periodically to ensure minimal recoverability time to meet business objectives.

•Used cross platform transportable table space (TTS) to transport table spaces across platforms.

•Data Refresh in Test and Integration Databases using Transportable Table spaces.

•Performed conversion Non RAC single instance to Real Application Cluster (RAC) database instances.

•Using Oracle Data Pump utility making faster exports/imports on large databases and saving lot of time.

•Performed patching on Oracle Database Server 10g and 11g using O patch utility.

•Implemented Data Guard, Physical Standby database in 10g and 11g RAC environment for the Production databases for Active and Passive cluster.

•Excellent troubleshooting skills to identify root causes and resolve problems related to application and systems functionality.

•Used AWR, ADDM and statspack Reports for troubleshooting performance issues and Capacity Planning. Extensively used Explain Plan, Tkprof and SQL Trace.

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

•Wrote shell scripts for purging trace files, alert log and network log files in Linux boxes which is used as standard script across all the databases

•Expertise in PL/SQL, SQL and UNIX Shell Scripting (Implemented UNIX Scripts using CRONJOB for Day-to-Day activities and Windows Task Scheduler)

•Installed the Oracle software using silent feature and also created databases

•Worked on designing, installing & maintaining OCR, 11gRAC and Dataguard components of Oracle.

•Writing SHELL SCRIPTS for the system and database for effective functionality and report generation

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

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

•Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 12c Grid Control.

•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

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

Pearson - Iowa City, IA Jan 2015 – Jan 2018

Oracle Database Administrator

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.

•Experienced in configuration of ASM for RAC and NON- RAC environments.

•Configured Repository and clients for GRID Control and also implemented DB Control for some databases.

•Utilized Oracle streams to Capture, Propagate and apply the transfer of data, transactions and events within managed Databases.

•Scheduling and maintaining level 0 and level 1 RMAN (Recovery Manager) backups.

•Test backups periodically to ensure minimal recoverability time to meet business objectives.

•Used cross platform transportable table space (TTS) to transport table spaces across platforms.

•Data Refresh in Test and Integration Databases using Transportable Table spaces.

•Performed conversion Non RAC single instance to Real Application Cluster (RAC) database instances.

•Using Oracle Data Pump utility making faster exports/imports on large databases and saving lot of time.

•Performed patching on Oracle Database Server 10g and 11g using O patch utility.

•Implemented Data Guard, Physical Standby database in 10g and 11g RAC environment for the Production databases for Active and Passive cluster.

•Excellent troubleshooting skills to identify root causes and resolve problems related to application and systems functionality.

•Used AWR, ADDM and statspack Reports for troubleshooting performance issues and Capacity Planning. Extensively used Explain Plan, Tkprof and SQL Trace.

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

•Wrote shell scripts for purging trace files, alert log and network log files in Linux boxes which is used as standard script across all the databases

•Expertise in PL/SQL, SQL and UNIX Shell Scripting (Implemented UNIX Scripts using CRONJOB for Day-to-Day activities and Windows Task Scheduler)

•Installed the Oracle software using silent feature and also created databases

•Worked on designing, installing & maintaining OCR, 11gRAC and Dataguard components of Oracle.

•Writing SHELL SCRIPTS for the system and database for effective functionality and report generation

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

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

•Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 12c Grid Control.

•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

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

Eastern Illinois University - Charleston, IL Mar 2012 – Dec 2014

Oracle Database Administrator

Responsibilities;

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

•Supporting multiple databases for production, development, test and staging purposes on Sun Solaris and Windows environments.

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

•Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.

•Thorough knowledge in setting up infrastructure for databases in huge datacenters.

•Installed Oracle 11g on Linux platform using ASM.

•RMAN point in time recovery and Instance recovery done on 11g.

•Developed compliance reports and performed auditing at higher levels.

•Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab.

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

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

•Performed Data refresh activities using the export data pump utility.

•Installation of 2 node and 3 node RAC, Migrating of database to RAC database. Monitoring Health checks of OCR, VOTING DISKS and Interconnect for better performance and troubleshooting issues in RAC environment (11GR2).

•Excessively worked on performing database backup and recovery using RMAN. Key player in troubleshooting backup issues. Taking the RMAN incremental and cumulative backups.

•Good hands on performance tuning related issues with Experience in query analyzing and Performance Tuning for the SQL queries, which are running slow, consuming high resources.

•Worked on converting bigfile to small file tablespace conversion for very large data (included 2T of data)

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

•Refreshed/cloned databases using RMAN utility.

•Restoration of Data for users in the event of requirement or system crash.

•Written SQL scripts to monitor tablespace and extent growth.

•Performance tuning which includes creating indexes, analyze, explain plan, optimizer hints. 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.

Metropolitan International College Jan 2008 – Dec 2011

Educator: Computer Application Technology

Responsibilities(taught the following)

■ Computers in all walks of life.

■ General concepts of information technology including hardware, software and

Network enviroments

■ Types of computer systems.

■ Typical components and characteristics of a computer.

■ Input and output devices.

■ Types of system software and application software.

■ Computer ethics, security and viruses.

■ Impact of computers on the environment and society.

■ Safety and health issues.

■ File management and trouble shooting simple end-user computer-related hardware

And software problems.

■ Processing of text, number and graphics at an advanced level, using a word processing programme:

-proficiency in the input of data;

-entering, editing and formatting text, numbers and graphics;

- creation of visual and printed matter

- design and layout of documents;

use of templates.

■ Basic processing of numerical data, using a spreadsheet programme:

• working with cells and ranges;

• formatting cells and worksheets;

• basic functions and formulae, including SUM, AVERAGE, COUNT, IF, COUNTIF, MIN, MAX;

• creating and editing charts.

■ Creation of single-table data sources to generate forms, queries and reports, using a database programme:

• creation of a single-table data source;

• manipulation of records and fields;

• generation of forms, queries and reports.

■ Presentations or web authoring tools or desktop publishing software or any other

Application software and own choices

• entering, editing and formatting text, numbers and graphics;

• application of good design principles.

■ Integration of end-user computer application programmes:

• working between applications;

• linking and exchanging (importing/exporting) data with other applications.

■ Effective communication of information:

• different types of communication tools;

• different modes of communication;

• use different modes and tools of communication;

• select appropriate communication modes and tools

EDUCATIONAL BACKGROUND

. University of Yaounde 1 BS (Computer Sciences) 2007

. Oracle University OCA( Oracle Certified Associate) 2017

Contact this candidate