Oracle dba

Mattou Nicaise

Mobile No: +434*******

E-Mail : adhknl@r.postjobfree.com

Objective

An Oracle database administrator with 0ver 8 years of work experience managing oracle database versions 10g, 11g, 12c, 18c, 19c and SQL server databases. Excellent experience in installation and configuration of both standalone and Oracle RAC databases. Excellent knowledge in managing databases running on Golden Gate and Data Guard environments. Conversant with DB2 and PostgreSQL databases. I worked on projects both of Agile and Waterfall approach .A very good team player, self-motivated individual, Self and fast learner.

Educational Qualification/Certifications

Degree

University/College/Institute

Bachelor in Computer Science

SQL fundamental certified

Oracle Certified Associate

Oracle Cloud professional certified

Oracle Autonomous DB certified

Oracle Cloud Associate certified

AWS Solutions Architect

Sec+ certified

Certified ethical hacker

University of Yaounde

Professional Summary

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.

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

Over 7 years of experience in areas of Oracle Database Administration in Production Environments handling different versions of Oracle from 9 to 18c database’s on various Operating systems like IBM AIX, Red Hat Linux, with good Knowledge on Oracle Architecture.

Experience in High Availability solutions for Oracle products like Real Application Clusters and DataGuard and also Database Performance Tuning using ASH, AWR and ADDM.

Experience in Exadata Machine L3/L4 Support, managing Exadata compute nodes/cell storage nodes.

Experience in Storage management and administration.

Experience in Trouble shooting all types of Oracle Database error messages like Message Stacks, Exception messages of internal errors.

Experience in Planning, coordinating, executing Quarterly Full stack patching for EXADATA with no downtime.

Analyzing data to troubleshoot, isolate, and resolve technical issues running on Oracle databases and Installing, configuring and maintaining Enterprise Manager Cloud Control.

Co-coordinating with Oracle on the ASR’s generated for hardware issues in EXA environment

Generating EXACHK reports, analyzing the report and take corrective actions.

Experience in Exadata ILOM management and troubleshooting connectivity/node eviction/server crash issues in EXADATA

Experience in end to end OEM 12c administration/configuring alerts/deploying agents/configuring notification rules/automating reports using information publisher reports/BI publisher reports/discovering PeopleSoft targets etc.

End to end management of EXADATA in OEM12c, configuring incident rules, monitoring templates, generating tickets etc.

Analyse and optimise the ticket stratergy and find scope for automation and work with the automation team to see the feasibility of automation

Proficient in Oracle Database Design & Administration, Backups & Recoveries, Performance Monitoring & Tuning and Shell Scripting.

Experience in installation and maintenance of RAC and ASM

Installation of Grid Infrastructure RAC and Standalone Server

Experience in Setting up Oracle Data Guard, Data Guard real time apply and Data Guard Broker for administration of Physical Standby databases.

Experience in Capacity Planning, Space Management, Database Upgrades / Migration and applying oracle patches on single instance & RAC DB

Experience in identifying KPI (Key Performance Indicators) for the db env and develop/automate a process to generate reports which shows how the DB tower is healthy

Design database backup strategy for production, non-prod databases, database duplication and recovery operations through Recovery Manager (RMAN) and Flashback technology

Experience in data transfer utilities like Data pump and import/export

Administrating all database objects like Table/Index segments, Constraints, stored procedures and triggers. Managing Database Structures, Database Access, Roles and Privileges

Experience on using ADDM, AWR, Oracle Enterprise Manager for performance monitoring

Proficient in Unix Administration part pertaining to DBA i.e. User maintenance, Monitoring of CPU, Disk and Memory usage, File system monitoring and writing Shell scripts for basic database administration

Experienced and confident in handling customer escalations

Innovative in approach, hardworking, structured, performance oriented, with a penchant for strategy, knowledge transfer, analysis and research, is extremely committed to the job and eager to work towards the excellence of my company

Possess quick and strong grasping power, excellent communication and organizational skills. Always adaptive to new environments and enjoy learning new things

Proficient problem-solver who envisions business and technical perspective to develop workable solutions. Experienced in handling Production issues and providing efficient solutions.

Excellent database support record demonstrating excellent customer service, ability to troubleshoot and ability to innovate

Experience in working with global teams & self-motivated, desire to learn independently

Details of Specific Projects

COMPANY:

PROFILE:

DURATION:

Oracle Corporation America Inc. Colorado

Principal Software Engineer/Oracle Database Administration

March 2019 – Present

Roles & Responsibilities

Worked as a team member for 24x7 support with on call rotation in all prod, QA and dev environments.

Responsible for adhock prechecks on demand where upgrade is done manually and also with Ansible Playbooks.

Perform Oracle Cloud patching of object storage system{oss} and core nodes, using Rolling&Non rolling method.

Plan and coordinate data migration between system.

Development and maintenance of database store procedure, views and function.

Ensure all database system meet business and performance requirements.

Conducted analysis and feasibility studies for development of Oracle Exadata solutions.

Assisted in integration of Exadata applications into current IT actionable events and solutions.

Assisted in installation, assembly and patching of Exadata and Oracle applications.

Administration of Exadata components.

Running and analyzing Health check, ExaChk and Report.

Monitoring Exadata Db-Servers and Cell-Servers, InfiniBand and Admin Switches using OEM, CellCLI and DCLI.

Checking out the effectiveness of Flash Cache.

Performing Image upgrade of the Exadata Machines.

Working on Exadata performance issues.

Administering Oracle ASM Diskgroup on Exadata Storage Servers.

Maintaining Exadata Storage Server Software and Setting up Exadata Storage Snapshots

Applying quarterly patches to Customers Oracle Exadata Database Machines.

Preparing Patch Assessment, Patch Plan and Performing Prechecks Work before the patching Window.

Applying YUM patches, Database Bundle Patch (DB BP), IB Switch (InfiniBand), Grid Infrastructure Bundle Patch (GI BP), CATBUNDLE/DATAPATCH and OJVM (PSU and Mitigation).

Perform GI upgrade from 11.2.0.4 to 12.1.0.2, 12.1.0.2 to 12.2.0.1 and from 12.2.0.1 to 18.0.0.0 on Exadata Machines.

Resolved conflicting patches and checks.

Performing Non-Rolling, Rolling and Hybrid Method of Patching.

Worked on physical Exadata Baremetal, ZDLRA and also VM's Environments.

Creating new GI and RDBMS Homes.

Analyzing and interpretation of Patch Assessment and Patch Plan for customer.

Hosting WebEx calls and Videos with Customer.

Creating New SR with Support for Customers in respect to Patching Issues.

Troubleshooting and fixing patching issues and also working with Oracle Support.

Experience working on OCC (Oracle Cloud and Customer) and ExaCC (Exadata Cloud at Customer)

Performed patching activities on the Cloud, upgrades and Post upgrades.

Experienced working on the CWD (Cloud Watchdog)

Troubleshooting and fixing Cloud patching issues.

Work with Oracle Support and Developers.

Management and Tracking - JIRA

Experience working on EXADATA servers. Patching the OS systems, Cells, IB switches.

Worked on physical Exadata BareMetal and also VM's Environments. Also performed GI upgrade.

Oracle Database capacity planning, space management, storage management on different platforms

Extensive experience Real application Clusters (RAC), ASM, RMAN, Data Guard and maintain Standby database.

Data guard Broker configuration and Managing Physical Standby databases using Oracle Data guard Broker.

GoldenGate Unidirectional and Bidirectional replication.

Proficient knowledge in RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery.

Experience on working with data guard physical/logical standby databases.

Documented the Standard Processes for peers to follow.

Applying upgrade patch, maintenance and interim (Opatch) patches on all the databases.

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

Expertise in performance-tuning, SQL tuning services with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, AWR, ADDM to collect and maintain performance statistics and improve the database performance.

DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.

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 10g, 11g, and 12c database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.

Resolved conflicting patches and checks.

Details of Specific Projects

COMPANY:

PROFILE:

DURATION:

Infosys Limited

Oracle Database Administrator

May 2017 – March 2019

Roles & Responsibilities

Loading data from flat files to database using SQL*Loader, External Tables.

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

Implemented proactive monitoring using SQL Trace & TKPROF, EXPLAIN PLAN.

Database monitoring/maintenance, replication process and performance tuning are done using OEM.

Experience using PLSQL tools for errors handling

Implemented data modeling to determine the logical and physical structure of the database

Experience with working on SOLARIS which is the most advanced OS enterprise for data security.

Excellent knowledge and skills with Golden gate implementation and configuration.

Implemented Active Data guard, creating both Logical and Physical Standby databases in 10g, 11g RAC& 12C environment for the Production databases.

Configured and managed Data Guard extensively for Production databases. Converted physical dataguard to snapshogt and logical standby database.

Experience in creating and managing databases on windows servers.

Implemented Flashback technology of the Oracle 12c, 11g and 10g along with Recycle bin for a faster recovery of the databases and database objects.

Performed Database upgrade from 10g to 11g and 12C, Successful in Appling PSU and CPU patches, security patches for improving the security and functionality of the databases.

Participated in Disaster Recovery Drills, documented database and application validation steps.

Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM) in RAC for Performance Tuning.

Implemented Security through Virtual Private Database and Fine-grained Auditing.

Created users, roles and granted privileges according to the business requirements.

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

Experience in using OEM, TOAD and SQL Developer for database management.

Made optimal use of Oracle Support in resolving the SRs.

24 X 7 Production & Development database support and administration.

Install and Configured Data Guard

Disaster Recovery

Carried out yearly DR Testing of Oracle ERP Systems / Critical Oracle Databases.

Team player with excellent interpersonal, analytical, critical resolution, documentation and communications skills.

Experience with AWS

Worked with development and operations staff in resolving problems quickly and efficiently

Delivering Oracle Database performance-tuning services for users with EXPLAIN PLAN, AWR, ASH, ADDM, STATSPACK, SQLTRACE, 11gOEM Grid and OEM cloud Monitoring custom scripts troubleshooting oracle databases using sqltrace and Tkprof utilities.

Able to resolve the performance issue in database 12c using automatic big data caching, full database caching and In-Memory Aggregation features.

Experience in managing large Oracle databases (VLDB) which includes OLTP as well as DW databases.

Hand on experience in cloning the non-multitenant container database to pluggable database in 12c using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot Cloning feature.

Developed RMAN scripts for database backup and recovery.

Excellent knowledge in Hot/Cold Backup and Recovery of databases using RMAN. Worked with company's SLA to determine backup and recovery strategies of small and large databases. Performed incremental backups, scheduled backups using CRONTAB.

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

Refreshed/cloned databases using RMAN utility.

Configured Oracle on different Operating Systems for OLTP & Data Warehousing environments.

Implementation of high availability (HA) solutions with Oracle 11g and 12c RAC installation and Management of multiple nodes accessing ASM storage. Installed ASM, configured disk groups.

Experienced in Oracle Support processes for technical requests through Oracle and other Support.

Created and managed users, Grant and revoked privileges. Implemented standard, value-based and fine-grained auditing to monitor user's activities. Implemented TDE, data masking and data reduction for advanced security.

Details of Previous Specific Projects

COMPANY:

PROFILE:

DURATION:

US FOOD

Oracle Database Administrator

March 2012 - May 2017

Roles & Responsibilities

Monitoring and Troubleshooting of Database Replication issues using Golden Gate, dealt with conflict resolution and performance issues.

Recovering Golden Gate corruptions and managing host/cluster maintenance mode blackouts.

Implemented Initial Data Load, Batch/Online replication, Security in Golden Gate.

Installation, maintenance and tuning of Oracle 11g RAC databases including ASM and CRS.

Resolved/Diagnose Node Eviction issues.

Implementing Best Practices for migration regular databases to Oracle Exadata

Able to resolve the performance issue in database 12c using automatic big data caching, full database caching and In-Memory Aggregation features.

Hand on experience in cloning the non-multitenant container database to pluggable database in 12c using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot cloning feature.

Have implemented two type of standby databases supported by Data Guard, logical standby and physical standby databases in 11gR2 on two node RAC Implemented and maintained Oracle 11g Data Guard/standby databases for fail-over purposes

Having hands on experience in Hot/Cold Backup, Recovery, restore and Cloning of databases using RMAN.

Implemented Active Data guard, creating both Logical and Physical Standby databases in 10g, 11gRAC& 12C environment for the Production databases.

Configured and managed Data Guard extensively for Production databases.

Experiencing in Installing OEM 12c Cloud Control and upgrading the 11g management agents to 12c agents.

Experience on Solaris, continuous innovations of delivery and data security.

Hands on experience with data modeling, relational modeling which uses a table-based format, minimization of data redundancy, minimization of data restructuring, minimization of I/O by reducing the transaction sizes, enforcement of referral integrity which helps to determine the logical structure of the database.

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

Strong mastering in PLSQL that adds several features to the structure query language and error handling, row processing and declared variables.

Developed RMAN Backup strategies for cloning the test databases with the production environment and worked on RMAN active-active duplication.

Experience with Logical backups EXPDP/IMPDP and extensively used for Re-hosting the application using Golden Gate and worked with conventional EXP/IMP for migrating data from 9i to 10G.

Experience with database packages, groups related PLSQL types and using constant variables.

Designed and implemented different backup strategies like Cold, Hot, MAN with Flash Recovery Area and Logical Backups EXPDP/IMPDP.

Handled Chained Rows and Row migration and solved the database performance issues. Experienced with ASM, adding, deleting disks to the disk group. Supported development teams for all the database related issues and handled the critical issues like network failures and ASM DISK group errors and node failures in the RAC cluster.

Generated Stats pack/AWR reports using OEM 12C from Oracle 11g database and analyzed the reports for Oracle wait events, time consuming SQL queries, tablespace growth, database growth.

Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements. Involved in SQL Query tuning and provided tuning recommendations to Application jobs, time/CPU consuming queries

Trainings

Splunk-master

Edureka

Python Programing

Edureka

ORACLE 18&19C NEW FEATURES

Attended course on Oracle 18&19c and it was conducted by Oracle University

Oracle Exadata Database Machine:12c Administration workshop Ed 2

Attended course on Oracle Exadata and it was conducted by Oracle University

Contact this candidate