Resume

Sign in

Manager Oracle

Location:
Randallstown, Maryland, United States
Posted:
September 11, 2018

Contact this candidate

Resume:

Samuel Essombe

Oracle Database Administrator

U.S CITIZEN

410-***-**** ac6z6c@r.postjobfree.com

IT professional with over Five years of experience in Oracle Database Administration. Duties include Installation and Configuration, Patch Installation, Migration, Upgrades, Backup and Recovery, Database Cloning and refresh, Replication, Database Security and Data Modelling.

SKILLS SUMMARY

Excellent experience in managing large-scale OLTP and OLAP databases in HA and DR setup.

Solid experience in oracle database migration, upgrades, applying patch sets, code reviews, database release and deployments and data center consolidation activities. Proficient with Database Cloning, Migration, and Patching of Oracle Databases.

Upgrade/Migration of Databases from Oracle 10g to 11g and 11g to 12c.

Expertise in Database Space Management, Memory Tuning and Application Tuning, Expertise in troubleshooting and performance tuning. Have experience in Oracle Golden Gate 10.x, 11.x installation, Configuration, up gradation and administration.

Configured parameters for the unidirectional, Bi-directional replication.

Implemented both unidirectional replication as well as bi-directional replicate using Golden Gate.

Backup of Databases (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.) using RMAN and other backup techniques.

Installed Oracle 11g with ASM and OCFS2 File systems.

Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.

Knowledge in configuring ASM (Automatic Storage Management)

Experience in doing upgrades including maintenance & monitoring implementation.

Provide weekly metrics to team lead for documentation on the health of Oracle databases.

Create user accounts, unlock accounts, grant roles and privileges to users.

Administer and execute Change Requests(CR) for Oracle Database support

Executed and implemented user helpdesk tickets of various issues via REMEDY database from creating user accounts, read-only accounts on a database & table down to assisting them with logging into the database. Experienced in using 10g features like 10g RMAN, Data pump Flash-Back Recovery and ASM.

Extensive experience designing and implementing backup and recovery strategy for databases using Recovery Manager (RMAN), traditional Export/ Import, Export/Import Datapump as well as conventional Hot/Cold Backups.

Implemented various backup strategies for Large / Medium sized databases using RMAN

Worked extensively on Cloning /Duplicate of databases using RMAN.

Experience with various database Backup and Recovery methods like PITR, TSPITR, Export/Import and Flashback Technologies.

Expert in delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, SQL TRACE, ORADEBUG, 11g 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.

Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle 11gR2 Grid and 10g on ASM and OCSF2 file systems.

Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.

Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.

Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.

Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 11g, 10g.

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.

UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.

PROFESSIONAL EXPERIENCE

OSCA - Jefferson City, MO

August 2015 – Date

Oracle DBA

Automated daily, weekly and monthly system health reporting using Crontab, PL/SQL and shell scripts.

Performed online Backups and offline Backups.

Performed incremental backups using Recovery Manager (RMAN). Created recovery catalog, performed complete and incomplete recovery using RMAN.

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

Used Data Pump for export and import. Wrote scripts for Backup of databases, maintenance of archive logs for databases. Streamlined backup procedures and implemented RMAN for backup and disaster recovery.

Database Refreshing / Replication from production to testing using Exp/Imp.

Designed, developed and maintained UNIX shell scripts to collect and monitor database metrics and Statspack snapshots and reports.

Configured GoldenGate Downstream Mining and Integrated components for Active-Passive and Active-Active replication.

Configured GoldenGate High Availability using Oracle DBFS and Active DataGuard.

Installed and configured GoldenGate JAgent to work with OEM GoldenGate Plugin.

Performed Schema level and Table level data refreshes from Production to Development environments using Datapump EXPDP/IMPDP.

Monitored the various database activities such as Backup, Error Logs, Space, Object, Performance, User and Session monitoring to ensure proper Capacity and Availability.

Involved in User Management and Database Security by granting appropriate Roles, Privileges, and Profiles.

Monitoring the availability of system, listener, database, alter log file, trace file.

Performance tuning of the database – SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O, Sizing of tables and indexes

Used Grid Control extensively and set up Rules for alert notification and schedule RMAN backups with Failure notification

SQL Query tuning on the OLTP Environments with the the techniques like SPM(SQL plan management) fix by taking the advantage of cell offload efficiency.

Maintaining ORACLE Software (RAC and standalone) by upgrades, Apply PSU patches on regular basis

Performed numerous ORACLE software upgrades from 10g to 11g by managing whole process

Test and Implement Applicable new feature during each upgrade

Maintain 24*7 Availability by implementing standard processes and troubleshooting live issues within defined tight SLA times

Manage High Availability Architecture (ORACLE RAC and ORACLE Data guard)

Perform Database cutovers using ORACLE Data guard switchover

Design and implement Application aware ORACLE RAC Active/Active Service based infrastructure

Troubleshooting ORACLE RAC issues using ORACLE cluster ware and Database logs.

Troubleshoot and maintain ORACLE Data guard environment where TBs of log shipping and apply happen every day.

Troubleshoot Database Performance issues using OEM, AWR, ASH, TKPROF 10046 traces etc.

Developed custom scripts and implemented standard procedures to troubleshoot Live Production issues by leveraging ORACLE ASH and AWR and ADDM Data.

Monitor Production Databases using various internal tools and custom scripts.

Optimal Database parameter, Capacity Design for Heavy loaded High End OLTP systems.

Database Capacity Management (Working with Storage teams for ASM Disks) using automated scripts/processes and Reports.

Wrote shell scripts for purging trace files, alert log and network log files in Linux boxes which is used as standard script across all the databases

Expertise in PL/SQL, SQL and UNIX Shell Scripting (Implemented UNIX Scripts using CRONJOB for Day-to-Day activities and Windows Task Scheduler)

Installed the Oracle software using silent feature and also created databases

Worked on designing, installing & maintaining OCR, 11gRAC and Dataguard components of Oracle.

Writing SHELL SCRIPTS for the system and database for effective functionality and report generation

Supported & maintained the Production/Development databases on various servers

Extensively worked on setting up auditing in many databases we supported

Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.

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

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

Comcast - West Chester, PA

April 2013 – July 2015

Oracle DBA

Installed, configured, and maintained Oracle 10g, 11g and 12c on Linux platform and also Upgraded from Oracle 10g to 11g to 12c.

Involved in checking and managing tablespace growth, monitoring the data file growth and extents too.

Involved in export and import of database objects in order to copy them from one database to another & for backup the tables.

Responsible for continuous Monitoring of CPU usage, I/O contention, memory paging and identify the resource and performance bottleneck and reorganization for ensuring performance.

Monitored queries with high response time and high disk read per execution (Top SQLs) and tuning the same using Explain Plan, TKPROF and SQL tuning advisor.

Involved in De fragmenting data blocks of table spaces for optimized performance. Also partitioned large tables to increase performance.

Responsible for all database activities such as User management, space management, database security management.

Implemented the resizing the online redo logs in production and in standby database.

Automated Database refresh from the Host system to Oracle using, SQL and PL*SQL procedures.

Implemented Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using Data Guard feature of Oracle 10g R2.

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.

Collecting performance statistics using Stats pack/AWR (Automatic Workload Repository) and analyzing by ADDM (Automatic Database Diagnostic Monitor)

Rebuilding indexes or analyzing the index as per the fragmentation level and minimize the performance issues.

Refresh/Cloning of Database from production environment to test environment and application of patches.

Monitoring the CPU usage, IO statistics, and CPU time to identify any OS level Performance killers

Experienced of managing and administering 24 X 7 running databases and support

Applied bug patches according to the Oracle Critical Patch alerts.

Configured the automated alerts for the production servers, which alerts DBA with the alert log errors and proactively space related errors.

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 support for all the production and development databases.

Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF

EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O.

Used Grid Control extensively and set up Rules for alert notification and schedule RMAN backups with Failure notification

Performance tuning of Queries by maintaining Aggregates, Compression, partition, Indexing and use of Hints, Stored outlines, Statistics for the same.

Performance tuning and diagnosing DBMS and individual Production databases, organized various migration review meetings with the application team to discuss the migration strategy based on their requirements.

Performed policies on data confidentiality, integrity, availability, and auditability, based on Access controls for Access to Data at the database level.

EDUCATION

University of Buea

Bachelor of law.

South west province, Cameroon.



Contact this candidate