Resume

Sign in

Manager Oracle

Location:
Riverdale Park, Maryland, United States
Posted:
December 18, 2018

Contact this candidate

Resume:

JOSEPH CHRISTIAN MOMNOUGUI

Phone: +1-202-***-**** Email: ac7z4j@r.postjobfree.com

SUMMARY

* ***** ** ********* ** experience as an oracle database administrator. I have supported 24x7 production and development environment. My expertise in Golden gate, data guard and RAC for high availability. I possess strong analytical and problem-solving skills, self- motivated, results – driver, team player with excellent verbal and writing communication skills. I have work on Oracle 12c, 11g and 10g

versions.

Skills & Abilities

Project configuration such RAC, data guard for high availability, performance and protection, Golden gate for replication and data consolidation

• Upgrading databases from 10g to 11g and 11g to 12c in stand-alone database.

• Migrating Oracle databases across data centers using datapump import/export utility, transportable tablespaces and RMAN.

• Migrating existing primary and standby databases in new hardware using Data Guard Broker.

• Converting physical standby database to snapshot standby database to open in read-write mode for testing purposes.

• Tuning slow running queries using Explain Plan, SQL Trace, AWR and ADDM.

• Transporting SQL profiles and SQL baselines between databases that enables the optimizer to create an optimal execution plan for a SQL statement.

• Cloning of databases using RMAN.

• Using DBCA to create staging/test databases.

• Installing & configuring Oracle Enterprise Manager (OEM) Grid Control 12c

• Administrating, monitoring and management of Oracle Database as a Service (DBAAS).

• Experience in implementing backup strategies using RMAN and performed complete and Incomplete Recovery of database in case of database crash, disk/media failure, etc.

• Performing complete backups (cold backups), incomplete backups (hot backups) and incremental backups using RMAN.

• Implementing Oracle 11g advanced features of Oracle such as table recovery using RMAN, Flashback technology.

Data warehouse concept for business intelligent

• Monitoring users account, creating users

• Refreshing databases along the SDLC using datapump utility

• Troubleshooting user related and database related issues using Oracle Support Services.

• Providing developers and end-users with 24/7 database support

WORK EXPERIENCE

M&T - Buffalo, NY

July 2016 – Present

Oracle Database Administrator

Upgraded the databases to version 12c from 11g and 10g

Installed, Setup, Configured Oracle version 12c Release2 64 Bit on Solaris 10 and RHEL 6

Up-gradation and Migration of Database from 10g to 11gand then to 12c and also applying patches whenever required.

Applying upgrade patches, maintenance and interim patches on all the databases.

Dataguard Setup using RMAN active clone.

Use of RMAN for Backups, rebuild out of sync Dataguard with incremental backup using RMAN.

Worked with application development team to resolve application related issues.

Implemented 11gR2 RAC with ASM and SCAN listener technology.

Installed Patches on Database home.

Support day to day user issues and troubleshooting like Locks, blocking sessions, Space issues, Slow performance, Grants, Roles, Profiles, SQL troubleshooting etc.

Worked on Automatic storage management (ASM) with EMC storage for managing data in SAN.

Successfully implemented 10g RAC on nodes for high availability.

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

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.

Involved in construction of DR sites for all the Production environments.

Installed 12c database

Worked on Multitenant databases.

Performed Database Refresh from Production to QA, UAT and Development databases.

Implemented and managed optimum physical database design (tablespaces, datafiles, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space.

Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.

Extensive experience in RMAN recovery testing, RAC and stand-alone database

Recovered huge Database (1 Terabyte) when UNDO table space got corrupted in Real Application Cluster (RAC)

Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases

Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests.

Responsible for the smooth functioning of all ecommerce activities of the organization.

Monitored data transfer between the Database servers using Data Stage, Oracle Streams/CDC

Successfully implemented Backup & Recovery using RMAN which includes hot backups and Cold backups.

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

Installed and configured Oracle 12c database and cloud control 12c to monitor all databases.

Worked with T-SQL statements like DELETE and UPDATE statements and also like BULK insert of data into the datable.

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

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

Worked on both VMS and UNIX environments.

Troubleshooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.

Knowledge in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments, Oracle OLTP.

Experience in writing UNIX/SHELL scripts for providing the reports.

Installed and configured Oracle 11g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.

Met Life Insurance - Aurora, IL Mar 2013 – July 2016

Oracle Database Administrator

Successfully installed and configured Oracle 12.1.0.2 and Oracle 11.2.0.3 databases on AIX platforms.

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

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 Recycle bin for a faster recovery of the databases and database objects.

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.

Implemented data guard for the critical production databases and tested switchover and failover. Logical standby databases for the real time DML apply in the remote databases. Disaster recovery plan for the production to standby database to check the data consistency.

Maintain databases build database backup and recovery routines (RMAN), monitor database activities and conducting performance monitoring. Clone Development, test and UAT databases using RMAN.

Handling multi-terabyte databases and the capacity planning for the data and application growth and recommend partitioning strategies for very large tables.

Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration in RAC environment.

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

Refreshed/cloned databases using RMAN utility.

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.

Performed Physical backup (hot and cold) as well as Logical backup (Export/Import).

Proactively managed the databases; set up alarms for managing any exceptions in day to day management of the databases; pre-empted and prevented issues, disasters from happening.

Prepare the documents of the process and knowledge transferring about the project to the new team members

EDUCATION

SOA UNIVERSITY 2011 (CAMEROON)

Bachelor Degree in commerce (option: international trade)



Contact this candidate