MARISSE MBEH CHOP

ORACLE DBA

240-***-**** /// adg668@r.postjobfree.com

PROFILE

A talented and resourceful Oracle DBA professional with over 5 years of diligent experience. I have supported the complete life cycle of the SDLC. I have worked on Oracle 10g, 11g, 12c and 19c versions. I have done database administration duties including production support, installation and configuration, database upgrades, patch management, database migration, backup, and recovery, database design and data modelling, performance tuning, database cloning, golden gate, and security management. I have supported customized Applications like HR, FIN and PEOPLESOFT.

TECHNICAL PROFICIENCIES

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 95/98/NT/2000.

RDBMS

Oracle 10g, 11g, 12c,19c

Languages

SQL, PL/SQL, UNIX Shell Scripting,

Tools

TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM Toad, Putty, Mobaxterm, WinSCP.

Database Utilities

SQL*Plus, Oracle Enterprise Manager, RAC, ASM, SQL*Loader, RMAN, DataPump, SQL Developer, SQL Developer DataModeler

APPLICATIONS

HR, FIN, PEOPLESOFT, EBS, SERVICENOW

SKILLS SUMMARY

Have ample knowledge in implementing policies, and procedures for disaster recovery and archival processing to ensure data protection.

Expert in delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, SQL TRACE, OEM Grid, monitoring custom scripts troubleshooting oracle databases using SQL trace utilities.

Experience with SQL coding including DDL, DML and fine-tuning those SQL's for better performance.

Experience in using 10g features Flash-Back Recovery, Data Pump, AWR, ASM, ADDM, ASH, Recycle Bin, 10g Grid Monitoring. Expert in RMAN backups including full, incremental, and cumulative.

Excellent knowledge in Flashback Recovery, Hot/Cold Backup and Cloning/Refresh of databases using RMAN.

Experience in applying patches/ patch sets to the databases.

Extensively worked on Import/Export and Data Pump Import/Export tools.

Knowledge in configuring ASM (Automatic Storage Management)

Expert in implementing High Availability solutions with Oracle 11g RAC, Oracle Data Guard and Real time replication using Golden gate.

High ability to analyse and understand the AWR reports and can fine tune the databases for maximum performance.

Install, configure, and upgrade to Oracle 12c; consolidate multiple databases into multi-tenant database containers; evaluate and implement latest database technology and new Oracle 12c features.

Performed database monitoring and tuning to ensure databases run at peak performance, troubleshooting production performance issues.

Extensively managed users, privileges, profiles, schemas using Oracle Enterprise Manager (OEM).

Expertise in implementing partitioning methodologies (Range partitioning, List partitioning, Hash partitioning, Composite partitioning) on tables and indexes for high performance.

Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.

Expertise in maintaining Database Security using auditing and High-level Security using Transparent Data Encryption (TDE).

Experienced in Performance Monitoring tools like OEM, AWR report, DBMS_PROFILER to troubleshoot some PL/SQL codes.

WORK EXPERIENCE

World Financial Group Inc- Largo MD Sept 2015 - Sept 2020

Oracle Database Administrator

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

Configured Oracle Data Guard to ensure disaster recovery, high availability and data protection

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.

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

Installed Oracle 11g on Linux platform using ASM.

Experienced using GOLDEN GATE for UNIDIRECTIONAL AND BIDIRECTIONAL Replication.

Creating Materialized views and Materialized View Logs for Data Replication.

Working with optimizer Hints and Explain Plan for estimating performance and to generate optimal solutions.

Worked on building and rolling out new 12c databases for TEST/DEV/QA environments.

Worked as a team member for 24x7 support with on call rotation in all Prod, QA and Dev Environments

Worked on Multitenant Databases (Oracle 12c Container and pluggable databases)

Experience working on POC of 12c new features like RMAN Recover table, In-Memory database, multiple indexes on single column, In-Database Archiving.

Hand on experience in cloning the non-multitenant container database to pluggable database in 12c using the PDB Metadata clone, Plugging and unplugging PDBS from Containers, PDB Remote Clone.

Performed database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, and cloning on the above said versions.

Implemented oracle 12c active standby database for test database environment

Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATS PACK reports and AWR Reports. Provided recommendations using ADDM reports. Analyzed the trace files Using TKPROF utility.

Hands on experience in troubleshooting RAC environment, using srvctl, crs_stat and crs_profile.

Diagnosed Oracle bugs and coordinating with Oracle support to resolve them in timely manner.

Performed various tasks like Administering RAC using SRVCTL, adding nodes and instances, Administering Storage Components, Parameter Management, and Configuring High Availability Features for RAC.

Upgraded databases from 10g to 11g, 11g to 12c and minor version upgrades.

Developed compliance reports and performed auditing at higher levels.

Scheduling repetitive activities like gathering schema statistics, exports, tablespace usage report using crontab.

Applied PSU Patches (10.2.0.3, 10.2.0.4) as a part of maintenance activity.

Extensively used Data pump, conventional export/import utilities for loading data to & from databases, logical backups, and migration of databases.

Creating physical databases with multiple tablespaces from logical and physical data model

Monitoring and optimizing the performance of the database/application using OEM.

Capacity planning: Allocate system storage and plan future storage requirements.

Worked on SQL tuning using SQL Tuning Advisor, SQL Access Advisor, SQL Profiler and SQL Optimizer.

Installation and configuration of Oracle databases environments (10/11g), upgrades, patching for security vulnerabilities (CPU and PSU).

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.

Troubleshooting of various database performances by proper diagnosis at all levels like SQL.

Used GOLDEN GATE for Zero Downtown Upgrade and Migration.

Experience in writing UNIX/SHELL scripts.

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

Using AWS management console to deploy AWS services like IAM, S3, EC2, VPC, RDS etc.

Environment: Oracle 11g/11g RAC/10g, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.

EDUCATION

Presbyterian Secondary School (High School Diploma).

BSc in Nursing (St Louis University of Health and Biomedical Sciences)

AWS Certified Solution architect Associate.

Oracle Database 12c Certified Associate.

Certified Scrum Master

Contact this candidate