Oracle Database Administrator

BLAISE FOGNO

276-***-**** ********@*****.***

SUMMARY

Database Administrator with Bachelor’s degree in Computer Science with 6+ years of experience supporting oracle databases (10g, 11g, 12c) and open source databases (PostgreSQL 1+ years) running on Linux, Unix, Aix, Solaris and Windows. I have also supported MS SQL databases (2008, 2012, 2014). Skilled at analyzing AWR, ASH, and ADDM reports in order to troubleshoot performance issues. Excellent in security management, database maintenance and establishing backup and recovery processes to safeguard data, paying attention to High availability configurations of the database as well as some PostgreSQL database activities like Replication. During this period, I have supported PostgreSQL databases where I migrated from Oracle to PostgreSQL. Supported 24/7 production and development environments. Support complete life cycle from Development, Test, QAT and Production. I am a proactive dba, a great team player, good in documentation, a fast learner and willing to learn more new things and make good use of them especially with the open source.

SKILLS

ORACLE POSTGRES

RAC Pg_bouncer

Goldengate Pg_dump

Dataguard & Broker Pg_backrest

Installation & Configuration Pg_admin

Upgrades & Patches Pg_restore

Migration of Systems Pg_hero

Backup & Recovery Pg_pool

Performance Tuning Explain analyze

RMAN Ora2Pg

Recovery Catalog Vacuum

Optimization of SQL & PL/SQL Scripts Pg_upgrade

Database Security Administration Psql

Stats pack Report

AWR Report

ADDM Advisors

Fine Grain Auditing DATABASE SOFTWARE

Flashback Oracle: 10g, 11g, 12c

SQL-Trace Postgres: 9.5, 9.6, 10

TKPROF Sql Server: 2008, 2012, 2014

SHELL Scripts

OEM Database & Grid Control

EXADATA

PROFESSIONNAL EXPERIENCE

Cigna-Dental - City of Sunrise, FL April 2016 – Present

Oracle Database Administrator

Worked extensively in Performance Tuning at various levels including instance tuning, Query tuning, Database performance tuning. Experienced in performing Database related activities using GRID, Multitenant Architecture, OEM, Data Pump, SRVCTL, RMAN, SQL*Loader, datapump, Export, Import, PL/SQL, SQL*Plus, SVRMGR, SQL*Net/Net8, Listener, AGENT Tuning using explain plan, SQL Trace, AWR, ADDM, SGA tuning, Stats pack and tuning of initialization parameters.

Good experience of Installation and configuration of RAC (Real Application Server) on different nodes with ASM (automatic storage management).

Upgraded various databases from 9i to 10g, 10g to 11g, 11g to 12c and minor version upgrades

Upgraded 10g and 11g Standalone databases to 11g and 12c 2-node RAC

Performed database tuning using Explain Plan, TKPROF, Stats pack, Automatic Workload Repository (AWR), Active Session History (ASH), and Automatic Database Diagnostic Monitor (ADDM) and SQL Trace.

Successfully implemented physical standby database using Oracle Data Guard feature for High availability configuration.

Installation and configuration of Oracle Golden gate for replication.

Maintaining and scheduling Cold Backups, Hot Backups, and Export Dumps. Maintaining backups of Archive logs and automating cleaning of archive logs. Deploying RMAN to automate backup and maintaining scripts in recovery catalog.

Configured Offline and Online Disaster recovery sites to maximized the database availability Applied Oracle Patches (CPU/PSUs and One-off patches)

Strong skills in SQL* PLUS, PL/SQL, SQL* Loader, UNIX Shell scripts (KSH and CSH),

Import/Export Server Manager. Implemented switchovers on primary and standby databases as a part of planned maintenance activities.

Implemented Dataguard, creating both logical and physical standby databases in 10g and 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 9i, 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 too.

Evaluated Oracle 11gR2 Golden Gate for future purposes that is for reducing the complexity involved in Oracle Streams.

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

Configured Streams to capture propagate, apply changes in multiple databases.

Performed Replication using materialized views with a complete refresh/Fast refresh.

Monitoring and Performance tuning of Golden Gate sessions at OS level, Database level and GGSCI level and investigate replication failures using ggserr.log, report files and Log Dump utility.

Performed Zero Downtime migrations from Non Exadata machines to Exadata machines using Oracle Golden Gate and Dataguard.

Good experience in Postgres software installation

Created users and granted privileges for my Postgres databases

Created databases and assigning specific tablespaces as best practice

Created tablespaces, views, functions, materialized views and schemas in Postgres

Migrated from Oracle to Postgres using Ora2Pg migration tool

Migrated from Oracle to Postgres using AWS Database Migration Services.

Performed backup and restore for Postgres databases

Intensively exposed to Postgres database performance tuning issues.

Developed Shell scripts, SQL & PL/SQL scripts for monitoring Golden Gate processes and their stats running on 60+ servers from one single database repository

Monitoring and maintaining 2/3 node RAC database on Red Hat Linux. Providing

Creating, granting and monitoring user access rights and privileges through roles and profiles.

Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.

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

Evaluated Oracle 11gR2 Golden Gate for future purposes that is for reducing the complexity involved in Oracle Streams.

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

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

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

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 and Oracle 10.2.0.5 RAC databases.

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

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

Installed Oracle 11g on Linux platform using ASM.

Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.

CareSource - Dayton, OH Mar 2013 – April 2016

Oracle Database Administrator

Performed Installation and configuration of Oracle 11.2.0.1 database on HP-UX

platform.

Performed space management, capacity planning, disaster recovery and overall

maintenance of the databases.

Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.

Maintained the data integrity and security using integrity constraints and database triggers.

Provided 24X7 supports for all the production and development databases.

Implemented Logical and Physical Standby Databases for RAC cluster on Sun

Solaris platform using Data Guard feature of Oracle 11g R2.

Successfully performed data replication using Materialized views and Oracle Streams in Oracle 11gR2.

Cloned/Migrated databases using RMAN and traditional Data Pump export/import utilities in Oracle 11gR2.

Perform RMAN operations (Incremental Backups). Helped developer to install

Oracle Client, troubleshoot and establish the connection to Oracle database through ODBC, JDBC.

Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, STATSPACK, AWR and ADDM reports.

Database tuning, Application Tuning & performance monitoring. Fine tuning

Initialization parameters, I/O, Memory and Operating System kernel parameters.

Monitored the production Oracle alert logs for database errors and data issues.

Used EXPORT/IMPORT to do table level and full database defragmentation

Performed patching of Oracle databases with latest patches from Oracle.

Install and configure block change tracking to work with RMAN Merged incremental backups.

Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.

Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.

Used to run the scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.

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 full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.

Refreshed/cloned databases using RMAN utility.

Performed Database upgrade from 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.

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.

Involved in converting a single instance database to Oracle 11g, 10g RAC databases.

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.

ACCOMPLISHEMENTS

Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g, 10g RAC servers for the purpose of disaster recovery procedures.

Configured Manager, Replicate and Extract processes and implemented unidirectional, bidirectional replication using Oracle 11g Golden Gate on RHEL 5 platform.

Completed Replication between PostgreSQL databases.

Backup and restore of PostgreSQL databases to a point in time.

Successfully carried out space reclamation activities like vacuuming

Motivated new employees and collaboratively worked with them during projects, resulting in quicker overall completion of a 3-node RAC configuration for maximum availability, scalability and reliability and also in a Bi-directional Golden-gate configuration for data real time replication.

Suggested a backup strategy that was later implemented which drastically reduced the time taken for the backup of databases.

Replicated PostgreSQL databases using the HOT STANDBY MODE

Completed a high availability configuration for MS SQL SERVER DATABASES

Completed the installation and configuration of MS SQL server on windows operating system.

Completed a real time Migration to EXADATA machine using GOLDENGATE and RMAN.

Successful configuration of ASM.

Successfully implemented advance security like DATA MASKING, REDACTION and TDE.

Troubleshooted performance issues and came up with some long-term fixes that went through change management and was implemented, and this drastically reduced performance issues.

Successfully configured a physical and logical standby data guard for disaster recovery and performance testing.

Successfully configured Integrated Extract (to support Compressed table extraction) during replication by Goldengate.

CERTIFICATIONS

Oracle 12c Certified Database Administrator (OCA)

Oracle 12c SQL Fundamentals

Scrum Master Certified.

EDUCATION

Bachelor’s degree in computer science

University of DSCHANG CAMEROON

Contact this candidate