Management Oracle

I am an IT personnel with a solid understanding and experience in Oracle Database Management system and Linux system administration. I currently manage Oracle Stand Alone, RAC and Dataguard Architecture databases on Unix/Linux servers. I have experience in providing day-to-day support in a fast-paced environment as well as the ability to multi task. I have assisted with process management, troubleshooting of various system issues, monitoring of resource contention and analysis, running of queries and scripts with the Development Team.

Core Competencies

Oracle Technical Training

Oracle 10g/11g Database Administration

Oracle Performance Tuning

SQL Scripting

Technical Documentation

Linux/UNIX Administration

Capacity Planning

Shell Scripting/CRON

Proactive and Efficient individual

Excellent Communication Skills

Critical Thinker

Exceptional Problem Solving Skill

Technical Skills

SQL Plus

Automatic Workload Repository (AWR)

Oracle 10g, 11g and 12c Administration

Installation on Windows, Linux, UNIX

Cross Platform Migration (SFTP)

Datapump Exports & Imports

RMAN Backup, Restore and Recovery

Dataguard

Oracle Critical Patch Update (CPU)/Opatch

SQL Loader

Oracle Upgrade Implementation

OEM and Grid Control

Oracle - Single and RAC instances

Oracle ASM

GNU/Linux OS – Red Hat and OEL

Education

B.A Economics (Major) – University of Science and Technology, Ghana

Oracle Database Administration, Chaveran Inc.

Certification

Oracle Certified Administrator (OCA)

Expected Oracle Certified Professional – March 2017

Professional Experience

CosmoPortals Inc., Silver Spring, MD

Oracle Database Administrator

September 2014 – Present

Serve as team member in the completion of medium/large scale implementations, managing projects from business requirement analysis to solutions delivery and support.

Administers and support Oracle version 10g, 11g and 12c on UNIX (Solaris), Linux (RHEL and OEL) and Windows Server 2003 and 2008 platforms.

Quickly resolve performance related issues as well as performance tuning of assigned databases using snap shots run from AWR report.

Support activities including performance tuning exercises, backup and recovery, installations, replication and disaster recovery, scripting, data loading, and data reporting.

Schema -object management and User Security implementation.

Responsible for the version management of the various oracle databases and the application of patches to Databases using Opatch utility as per company SLA.

Automate database administration routines, e.g. backup and recovery, data pump export/import activities, schema refresh from different sources, creation and disk usage monitoring

Administer Automatic Storage Management (ASM) on Linux (red hat 5.4) platform utilizing fail groups and stamped disks.

Configuring ASM with normal, high and external redundancy.

Monitoring, administering and troubleshooting database issues using OEM, Grid Control, SQL Developer, and SQL command line.

Work with Oracle Support when necessary to resolve various issues and Service Request (SRs)

Perform backup, restore and recovery using RMAN and using Data Pump as supplemental backup method for Logical backups of all major schemas.

Develop and test backup and recovery strategies on development and production environments.

Manage database by reviewing Alert logs and dump files to check for any problems related to the database.

Performed disaster recovery and provided recommendations to senior management for implementation

Implemented database performance tuning activities using reports like ADDM,AWR,ASH and SQL tuning advisors

Participate in 24x7 “On-call” support for Oracle database systems, products and services.

Analyzed database research results and documented findings.

Home Depot,Data Center, Baltimore, MD

Oracle Database Administrator

January 2012 - August 2014

Installed and configured Oracle 11g using the OUI on Linux servers.

Created Optimal Flexible Architecture, (OFA) compliant databases.

Automated database administration routines, e.g. backup and recovery, data pump export/import activities, schema refresh from different sources, creation and disk usage monitoring

Use DBUA to migrate various Oracle versions from Windows to the Linux platform

Assisted with automating various manual routines like DB backup and recovery, data pump activities; overall helped relieve DBA time by over 30%.

Taking Incremental backup using RMAN.

Creating tables, tablespaces, users, views and related objects.

Used SQL*Loader to load data into database tables.

Performed Online and Offline backups with RMAN, traditional export/import and expdp/impdp.

Implemented Point in time recovery using RMAN.

Configuration and implementation of Oracle for high availability.

Used SSH Secure File Transfer Client for cross platform transfer from Windows to Linux.

Implemented advanced features of Oracle such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.

References available upon request.

Contact this candidate