ELLY NGOYA OLUOCH

DATABASE ADMINISTRATOR

346-***-****

adgd0s@r.postjobfree.com

OBJECTIVE

Database administrator (DBA) with 6 years of professional experience in the IT industry in various fields such as Help Desk Support and as an Oracle Database Administrator for a period of 3 years. Extensive experience in database design, analysis, modeling, development, administration, implementation, troubleshooting, and quality management. Proficient in Oracle 11g/12c software installations. Part of upgradations team, database capacity planning, responsible for migration of database from 11g to 12c, and handled the monitoring tool like the OEM.

EDUCATION —

CORE COMPETENCIES

University of Houston

Bachelor’s in Computer Science – Current

Houston Community College

AAS in Computer Science

St. Augustine High School

High School Diploma

•Oracle 11g/12c Administration.

•Database Upgrade Assistant (DBUA)

•Database Refresh.

•Data pump (Expdp, Impdp).

•RMAN Backup & Recovery.

•Data Guard

•Patching

•Database Configuration Manager (DBCA)

•Performance Tuning

•Virtual Machines (VMWare and Virtual Box)

•ServiceNow

•Unix/Linux Shell Scripting

•SQLplus

•Knowledge on RAC

•Knowledge on OEM

TECHNOLOGIES

•Operating systems: Linux Enterprise Server (9,10), Windows (95/98NT/2000)

•Relational Database Management (RDBMS): Oracle 11g, 12C

•Languages: SQL, Python, C++

•Tools: TOAD, PUTTY, OEM, RMAN

KEY SKILLS —

EXPERIENCE

August 2019 – August 2020

ORACLE BDA • Verizon Communication Inc., Houston, TX • (Contract)

•Installing and Configuring Oracle 11g, 12c Databases.

•Monitoring of Databases using OEM.

•Plan and Schedule RMAN Backup & Recovery activity.

•Managing and creating tablespaces and datafiles.

•Managed appropriate use of free space within tablespaces, reclaimed space whenever possible.

•Solving Database issues by checking alert logs and trace files.

•Data Guard monitoring Performed switchovers and archive gap recovery.

•Monitoring RAC Environments.

•Attended meetings to understand business needs and provide suggestions to suit different clients and projects.

•Build Automation on reporting by using Shell script.

•Experience in quarterly Database patching activity.

•Monitoring of services and client interaction on regular basis for day to day activity.

•Worked in production environment and provided on-call and day-to-day support.

•Maintaining physical and standby databases using Oracle Data Guard.

July 2018 -July 2019

ORACLE DBA • Novartis Pharmaceuticals, Plantation, FL • (Contract)

•Creation of users and assigning roles, profiles, and privileges.

•Assisted in database design and implementation.

•Performed database maintenance and patching.

•Used Oracle support to troubleshoot and solve critical database issues.

•Provided recommendations in bi-weekly meetings for efficient use of database resources.

•Plan and schedule RMAN backups (hot, cold, and incremental backups).

•Setup Oracle Enterprise Manager (OEM).

•Efficiently performed installation, setup, and creation of Oracle 12c databases.

•Successfully installed and maintained physical and standby databases using Oracle Data Guard.

•Used import/export utilities for cloning small sized databases.

•Upgraded from 11g to 12c.

•Performance Tuning

Sept 2014 -June 2018

WAREHOUSE ASSOSIATE / ASSEMBLEY • Alcon Manufacturing, Houston, TX

•Receiving, processing, labeling, and storing incoming stock.

•Maintaining clear records on all inventory and stock.

•Inspecting all stock for damages and keeping records of damages.

•Organizing the warehouse space.

•Preparing orders for shipment.

•Recording exact arrival and departure times for shipments.

•Operating stock management tools; for example, a forklift.

•Ability to use reason to solve problems as they arise.

•Counting stock and keeping inventory records.

October 2012 -May 2014

JUNIOR ORACLE DBA • Jumia Ke, Nairobi, Kenya •

•Installed, configured, and managed databases in UNIX and Windows environments.

•Assisted in database design and modelling.

•Maintained and updated the database schemas as requested by the Lead Oracle DBA.

•Created roles and users and managed their privileges.

•Performance tuning

•Managing and creating tablespaces and datafiles

•Solving Database issues by checking alert logs

REFERENCES

Available upon request

–Installing and configuring Oracle

–Basic monitoring and tuning

–Backing up and recovering databases

–Basic understanding of database security issues

–Database design

–Good knowledge of DBMS series of packages

–Command over SQL and PL/SQ

–Experience in troubleshooting databases for performance

–Knowledge with the UNIX operating system

–Experience in creating and maintaining UNIX shell and Perl scripts

Contact this candidate