Resume

Sign in

Manager Oracle

Location:
Hyattsville, Maryland, United States
Posted:
August 20, 2018

Contact this candidate

Resume:

Marc Ngueleumeni

Email: ac6qt0@r.postjobfree.com

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

Professional Skills

* ***** ** ********** ** the field of Database Technology. I managed Oracle and SQL Server databases supporting many different applications. Expert knowledge in performance tuning, Backup and Recovery, High Availability Solutions like Dataguard, RAC and Golden Gate, Database Migrations, Database and scheme refreshes, Installations, Patches and Upgrades.

Administer over 600 databases across Development, QA, UAT and PROD environments via use of command line and Oracle tools-Oracle Enterprise Manager Cloud 12c.

Manage large complex Oracle RAC clusters with 50+ applications.

Installed Oracle 11g RAC and Upgrading Oracle 10g RAC databases.

Upgraded databases from 11g to 12c.

Set up Active Dataguard Configurations for oracle database 11.2.0.3 for thirty databases whose size varies from 10TB to 30TB on a 6 node RAC.

Designed GoldenGate configuration for databases & implemented filters with rules to meet the business usage which will reduce load on the production databases for better performance with replication on multiple sites.

Migrated and upgraded Oracle 11gR2 Databases from Sun Solaris 10 to Red hat Linux 6 using Transportable Tablespaces.

Worked on SQL Tuning and how to use the available tools outside of Oracle Enterprise Manager.

Worked on Performance Tuning, identifying large objects, analyze those objects and recommend changes to improve performance.

Identifying objects no longer accessed and remove those objects which results in saving space in the databases.

Worked on moving data from one storage area to another.

Installed and Administered Oracle 11g & 12c RAC software with ASM.

Had fixed several performance tuning issues which relates to RAC & standalone databases by recommending better solutions that could save cost, virtualization, and resources.

Implemented fast start failover on databases and configuring disaster recovery site using dataguard. Also proficient with new 12c features such as Active Dataguard and Snapshot standby database.

Implemented & Managed Physical Standby and even Configured Automatic Storage Management (ASM).

Applying Patch set, Critical Patch Update (CPU)/Patch Set Update (PSU) and One-off Patches using OPatch and run Installer under UNIX and Windows.

Performance Tuning of Oracle database using OEM, SQL analyzer, AWR, ADDM, ASH, Explain plan, TKPROF, and SQL TRACE.

Data transferring using Export/Import utilities and SQL*Loader.

Expertise in creating and maintaining databases to Oracle Optimal Flexible Architecture (OFA) standards in very large-scale database environment (VLDB) and mission critical OLTP and DSS systems.

Performed database tuning by using various tools such as ADDM (Automatic Database Diagnostic Monitor) from AWR (Automatic Workload Repository), OEM (Oracle Enterprise Manager).

Performed SQL Tuning using Explain Plan, TKPROF with SQL trace and STA(SQL Tuning Advisor) Coordinated with System administrators, application developers and other DBAs.

Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms

Installed Oracle 11g,12c RAC software with ASM & ACFS File systems

Resolved database network problems using Oracle Net Configuration Assistant, Oracle Net Manager, Netstat and ping utility.

Involved in writing stored Procedures, Functions and Triggers in PL/SQL to interface application with database system.

Experience

Sun National Bank – Toms River, NJ

February 2015 – Present

Oracle Database Administrator

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

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

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

Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.

Participates on project teams as database administration support to ensure that databases are appropriately modified to support new business applications and requirements

Install, patch and upgrading Oracle 10/11g & 12c to support internal production and test environments.

Installation of 12c OEM and customize it to our needs.

Installing Oracle Golden gate on RHEL and setup table level replication as well as DDL replication.

Migrate Database across different servers and platforms using Transportable Tablespaces (TTS) and Data Pump Export/Import and perform database Refresh and RMAN Cloning.

Planned and implemented Disaster Recovery solutions using Oracle Standby Database / Data Guard and performed data Replication using Golden Gate Technology.

Rebuild Indexes, table partitioning, tuning memory usage and SQL tuning using Explain Plan, SQL Trace, and TKPROF for best performance.

Manage alerts, notification, jobs and Solve ORA errors and Fix Bugs with the help of Oracle support and Meta Link.

Installed OEM 11g agent on servers and configured to OEM 12c Grid Control.

Administer RAC Database servers using SRVCTL, OEM Grid control, V$/GV$ views and System wide tuning using UTLBSTAT and UTLESTAT.

Automated the Data Replication process using Materialized Views for reporting databases.

Used Oracle Enterprise Manager (OEM) 12c Grid Control for monitoring multiple database and notification of database alerts, and configured EM agents on multiple database servers.

Implementing Datapump, conventional export/import utility of Oracle 11g 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/11g 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.

Alert management, Created and setup alerts to send notification to Users from application wherever necessary.

Perform day to day activities like backup-restore, space management, monitoring database alerts, performance tuning.

Proficient in troubleshooting Node Eviction in Oracle RAC Environment

Applied PSU patches and other database related patches.

Have a good experience in administering Oracle Clusterware components.

Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption and Configured user log on load balancing and failover on RAC database.

Responsible for SQL query tuning and optimization. Performed database tuning and optimization using tools such as Tkprof, Explain plan and SQL*Trace. Efficiently performed installation, setup and creation of four node cluster RAC with Oracle 11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 6.

Maintenance of 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.

Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.3

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

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

Bank of Oklahoma - Tulsa, OK

March 2012 – January 2015

Oracle Production Support Database Administrator

Installation, configuration and maintenance of Oracle 11g/12c Real Application Clusters (RAC).

Implement Grid based monitoring solution for large Databases and Installation of Cluster ware, configuring public, private and VIP.

Extensively worked in various areas of Data guard i.e. Installation, Recovery, RTA (Real Time Apply), Patching, Tuning, Switchover, Switchback and Failover.

Implemented and configured 11g grid control on RHEL.

Performed Logical backup of critical application databases using EXPDP/IMPDP with a scheduled job (Cron Job).

Responsible for creating RMAN catalog Database and Registering the Databases in Catalog Database and Cloned production RAC instances to development and QA systems using RMAN duplication.

Experience in using 11g features such as Data Pump, Flash Back Recovery, ASM, AWR, and ADDM.

Involved in Defragmenting data blocks of table spaces for optimized performance. Also partitioned large tables to increase performance. Evaluated Oracle 11gR2 Golden Gate for future purposes that is for reducing the complexity involved in Oracle Streams.

Configured Oracle Streams on Oracle 11g, 10g databases for data replication and monitored them using Grid Control.

Performance tuning of Queries by maintaining Aggregates, Compression, partition, Indexing

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

Efficiently performed installation, setup and creation of four node cluster RAC with Oracle 11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 5.5.

Maintenance of 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.

Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.3.

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

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 10g/11g environments.

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.

Technical Skills

Operating Systems

HP-UX 11.x. Sun Solaris 8, 9, 10. AIX 5.x, 6.x, Linux Enterprise Server 9, 10. Windows 2010, 2012

RDBMS

Oracle 12c, 11g, 10g

Languages

SQL, PL/SQL, UNIX Shell Scripting.

Tools

TKPROF, EXPLAIN PLAN, AWR, and ADDM.

Toad, Putty, NX client, Winscp, Remote Desktop Connection, VNC and Cisco VPN Client

Database Utilities

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

Education

ORACLE CERTIFIED ASSOCIATE (OCA), Oracle University

Master’s Degree in Science from University of Douala, Cameroon



Contact this candidate