MARIAME OSSENI

301-***-**** ac63u9@r.postjobfree.com

Oracle Database Administrator

P

ROFESSIONAL SUMMARY

* ***** *** ******** ** experience as an Oracle Database Administrator with experience on 24x7 production and mission critical database support. I possess strong analytical and problem solving skills, self-motivated, results-driven, team player with excellent verbal and written communication skills.

I have worked on Oracle 12c, 11g, 10g versions. Areas of work include Installation, upgrades and patches, database migration, backup and recovery, performance tuning, database security, database and schema refreshes, Dataguard, RAC and Golden Gate

Experienced in implementing High Availability solutions with Oracle 11g RAC, Oracle Data Guard and real time data replication using Golden Gate.

High ability to analyze and understand the AWR reports and tune the databases for maximum performance.

Adept at installation of OEM Database Control, OEM grid control and Deploying Agents.

In-depth knowledge and understanding of Oracle Database features such as RMAN for backup and recovery, Export/Import, Data Pump and Data Guard.

Working knowledge of Auditing and Database Security.

Experienced in using Oracle's Transportable Tablespace (TTS) to migrate Tablespace across Oracle databases.

Upgraded databases from 10g and 11g to 12c.

Worked on Oracle Migrations. Migrated database from Windows to Linux to AIX.

Proficient in using Recovery manager (RMAN), Flash-Back Technology.

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

Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF, AWR, Automatic Database Diagnostic Manager (ADDM) and also Cluster Interconnect Tuning (RAC) and Automatic Storage Manager (ASM).

Performed RMAN backups (Full, Incremental and Cumulative) and recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard.

Used Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for upgrading to Oracle 12c and applied patches and patch sets using OPACTH utility and OPATCH AUTO as required.

Also responsible for database performance by checking applied Patch sets and Interim Patches.

Installed, Configured and Administered STREAMS and good knowledge on GOLDEN GATE.

Have implemented two type of standby databases supported by Data Guard, logical standby and physical standby databases in 11gR2 on two node RAC.

Experienced in Performing Tuning Database - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK, SQL*Trace, TKPROF.

Expert in Performance Tuning and Monitoring of Oracle Databases on Unix/Linux platform using Tkprof, Explain plan, AWR, ASH and ADDM reports, SQL tuning Advisor.

Created indexes to facilitate easy user interface implementation and tuning.

Involved in construction of Disaster Recovery sites for all the Production and TST environments.

Performed Database Refresh from Production to TST, UAT and Development databases. Proficient with Database Cloning, Migration of Oracle Databases.

Upgrade of oracle databases from 10g to 11g to 12c and 10gRAC to 11gRAC.

Worked on Set up, configuration and maintained Oracle Data Guard/Active Data Guard to control Primary and Secondary databases and also to ensure disaster recovery using various data protection modes.

Exporting and Importing of dumps using expdp and impdp.

Experience in Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, AWR report, 12c OEM Grid Monitoring custom scripts troubleshooting oracle databases using SQL trace utilities.

Database security using Oracle Security Features (roles, privileges), auditing, Transparent data encryption etc

Used Import/Export and Data Pump Import/Export tools.

Knowledge in configuring ASM (Automatic Storage Management)

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

E

XPERIENCE SUMMARY

Pfizer - Peapack, NJ

April 2015 – Present

Oracle Database Administrator

DBA supporting three major projects from Development to Production via Test and development environments.

Database sizes range from 4GB to 4TB in ODS (Operational Data Store) & EDW (Enterprise Data Warehouse) environments.

Supported 400+ databases including RAC production database, a Data warehouse database and a lot of Development and Test databases.

Upgraded databases from 10g to 11g.

Provided Production & test environment support while coordinating with Unix Team and storage team to configure the OS infrastructure for Oracle Databases.

Worked on setting up/installation and configuration of release 11g R2 RAC with ASM and Raw Devices and 11g CRS on IBM AIX.

Performed conversion of Single Node Instance to multi node RAC with ASM, and adding instance to existing RAC.

Installed and configured 2 nodes oracle 11gR2 RAC for production environment.

Installed 12c Databases and responsible for upgrading Oracle 10g RAC to 11g RAC.

Involved in Oracle Golden Gate installation, configuration, troubleshooting Golden Gate EXTRACT and REPLICATE issues.

Implemented and administered Oracle Golden Gate for Database Replication between production and reporting node, by using Oracle Streams in parallel to secure data and having the availability of the database with Document Standard Operating procedures (SOP) attached to it.

Implemented Data Pump, Export and Import on day to day basis as per development and test servers.

Responsible for Performance Monitoring and analysis of 11g RAC (Real Application Clusters) with AWR (Automatic Workload Repository) reports and ASH (Active Session History).

Monitoring database performance and database operation to prevent downtime and slowness of the services.

Implemented backup (Cold/Hot backups, RMAN Incremental backups & Import/Export), USER MANAGED, handled media recovery using RMAN (Recovery Manager) in accordance of company SLA.

Cloning RAC to RAC and RAC to NON RAC using hot backup and RMAN.

Strong experience in Space and User Management.

Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, AWR, ADDM, SQL TRACE and SQLT with a Strong analytical and problem-solving skills.

Applied database patches using Opatch utility; Opatch Auto & building Clone instances for Development and Test teams.

Maintained and monitored various production servers with Oracle 11g R1, 11g R2, 10g.

Scheduled database maintenance tasks such as tables/indexes analysis, index rebuild.

Maintained DATA GUARD to provide high availability and Disaster Recovery and Continuity Of Operations (COOP) by implementing physical standby database and snapshot-standby and worked with Oracle 11g features 11g Grid Control and Automatic Storage Management (ASM) with Document Standard Operating procedures (SOP) attached to it.

Troubleshooting Space Management & User accounts and privilege issues while coordinating with Unix and application teams.

Performed proactive database maintenance procedures to ensure optimal performance and uptime and implemented shell scripts for automation of day to day activities.

Identify Top SQL that are consuming heavy resources and provide support to the development team in identifying SQL queries that are consuming high resources and interact with the development team to see if these queries can be fine-tuned further.

Regular Security Patching and Critical Patch Updates (CPU) and Patch Set Updates (PSU) on Oracle databases and interim patches for various bug fixes on database products.

Production support for Oracle database 10g/11g RAC.

Implemented and configured of Oracle Enterprise Manager OEM 12C and Oracle Management Server for maintenance and monitoring of production databases.

Creating and Managing Users, Roles, privileges, profiles, schemas, SQL Monitoring, SQL Advisor, SQL tuning and Metrics, using Grid Control of Oracle Enterprise Manager (OEM) 12C.

Creating and Managing Procedures, Packages, Triggers, Alerts & Functions, Views, Indexes, user accounts, roles, privileges and performing day-to-day operations.

Monitoring database using Oracle Enterprise Manager (OEM).

Participated in on-call rotation for off-hours support.

ADMIRAL INSURANCE COMPANY - AUSTIN, TX

JUNE 2013 – MARCH 2015

ORACLE DBA

The work involved overall Maintenance of Oracle Database, Backup, Recovery in accordance of company SLA and other database related activities.

Installed, configured and maintained Oracle 11g Real Application Cluster (RAC) / ASM on Redhat Enterprise Linux with Document Standard Operating procedures (SOP) attached to it.

Implemented 11g DataGuard Physical using DG Broker, and experienced with 11gR2 Data Guard new features Active Data Guard and Snapshot Standby.

Performed Data Guard switchover/failover as per the requirements.

Worked on Golden Gate 12c Replication configuration like unidirectional as well as bidirectional as per the requirement and addition of tables for the existing in Golden Gate configuration.

Database Growth and Space management; distributing the tables, redo logs, archived redo logs and rollback segments on different disks to optimize data retrieval.

Implemented Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11g R2.

Knowledge in Partitioned tables Maintenance, adding new partitions, exchanging one-year-old partitions then archiving of the exchanged partitions, dropping or truncating of old portions.

Modified database structures including tablespace, tables, views, triggers, stored procedures as well as configuration and storage allocation to support application enhancement.

General DBA daily jobs such as disk usage monitoring, table/index rebuild and reorganization as needed.

Monitoring of database for growth and performance.

Defined backup procedures using daily hot backups and weekly cold backup.

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

Used TOAD for database management.

Creating and administering 2 tier-Users, creating Roles, managing privileges, granting and revoking privileges as required.

Made optimal use of Oracle Support in resolving the SRs.

Worked with latest 10g/11g features Data pump, Flash-Back Recovery, ASM, Grid Monitoring, and Recycle Bin.

SQL Queries/Application and Database performance monitoring and tuning using various tools like ADDM, AWR, Explain Plan and Statspack reports.

Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN for the better performance with a Strong analytical and problem-solving skills.

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.

Configured DATA GUARD for high availability, data protection by implementing physical standby database and snapshot-standby for disaster recovery and continuity of operations (COOP) with Document Standard Operating procedures (SOP) attached to it.

Constantly monitor the performance of the Databases and viewing Alert log files & Trace files.

Ensuring proper online and offline backup. Periodical reading and checking of backups taken.

Participated in on-call rotation for off-hours support.

T

ECHNICAL SUMMARY

OPERATING SYSTEMS: Red Hat Linux RHEL 5.x and Windows Server 2012R2

RDBMS: Oracle 12c/11g/10g

LANGUAGES: SQL, PL/SQL, UNIX Shell Scripting

SOFTWARE/ APPLICATIONS/ TOOLS:

DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), OEM Grid Control, Oracle Data Guard, Oracle Management Service (OMS), Real Application Clusters (RAC), ASM, SQL Navigator, TOAD, Data Pump (expdp, impdp), SRVCTL, SQL*Plus

TUNING TOOLS: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM.

E

DUCATION

Bachelor degree in Computer Sciences Cotonou-BENIN.

OCA certified

Comptia Security+ Certification

Contact this candidate