Oracle Professional Experience

KIZITO KABA Tel: 980-***-**** E-mail:**********@*****.***

PROFILE

Oracle DBA with 5+ years of extensive experience supporting next-generation oracle database solutions on a multi-platform, integrated IT environment

Rich hybrid of process improvement and service delivery optimization experience

Strong business acumen, communication skills and ability to effortlessly interface and build rapport with technical and non-technical users.

Multi-lingual; English, French & Dutch.

KEY COMPETENCIES

SQL Optimization

Oracle RAC (HA solution)

Capacity Planning & Monitoring

Oracle Data Guard (DR Solution)

RMAN Backup & Recovery

OEM Grid Control

Partitioning

Advanced Compression

Business Communication

Agile (SCRUM) Methodology

EXPERT IT SKILLS

Databases: Oracle 12c/11g/10g, SQL Server 2008, MS Access

Methodologies: Structured Analysis/Design

RDBMS Tools/Technologies: OEM, Toad, DBArtisan, SQL*Plus, RMAN, DGMGRL, EMCTL, SRVCTL, ASMCMD, Golden Gate, Oracle streams, TCP/IP Protocol

Office Applications: MS Office 2013–Access, Excel, Word, Power Point, Project

Hardware: IBM AIX pSeries with the 47 GHz PowerPC_POWER7, Sun Fire V880, EMC Data Storage devices

Data Models: ERD, Logical/Physical

Operating Systems : UNIX (AIX, Sun), Red Hat Linux, Windows

Languages: SQL, T-SQL, PL/SQL

PROFESSIONAL EXPERIENCE

Oracle DBA

The Home Depot, Atlanta, GA 03/2015 – 05/2017

Provided database support for three (3) production Oracle11.2.0.3/4 and 12.1.0.2 two-node RAC and single instance DG databases running on AIX and Linux platforms; the databases ranged in size from 0.7 TB – 4.1 TB.

Leveraged TOAD and OEM heavily for administrative, monitoring, scheduling, and query (SQL) optimization tasks

Traced user sessions and utilized AWR/ADDM/ASH reports for tuning

Wrote shell (korn and bash) scripts to automate routine work like backups and refreshes

Conducted security audit vulnerability assessments and remediate flagged flaws

Utilized a variety of tools - OEM, EMC TimeFinder, RMAN, Data Guard, Data Pump, UNIX shell scripts - to backup, refresh/clone databases

Leveraged AWR/ASH/ADDM/ reports and OEM (SQL Monitoring and Tuning Advisor) to monitor and optimize poor performing reports

Routinely applied scheduled PSU/CPU and one-off oracle patches to and upgrade databases using DBUA

Utilized SQL*Loader to load data in flat files from DB2 into Oracle

Participated in primary and back up 24X7 DBA on-call rotation schedule

Participated in the high-level design (HLD) and low level design (LLD) of projects with database impacts

SME on partitioning and advanced compression techniques

Oracle DBA

Cameroon Shipyard and Industrial Engineering Ltd, Douala, CMR 08/2012 – 11/2014

Installed, configured and administered Oracle 10g and 11g Development, Test, QA, and Pre-Prod single instance and RAC (two-node) databases on Red Hat Linux platform

Supported Change Management processes by migrating changes between environments

Utilized RMAN and Data Pump for physical and logical backups

Worked with the Network team during OEM configuration to define ports in the firewall to enable traffic between the Oracle Management Server (OMS) and the Oracle Enterprise Manager (OEM) agent

Reviewed and optimized SQL and PL/SQL code for and from developers

Tested, assessed and recommended alternative processes, procedures and tools to streamline operations and provide a more efficient database environment

Jr. Oracle Application DBA

ECCO Bank, Douala 05/2011 – 07/2012

Installed, configured and supported the sandbox, development, test, and QA Oracle 10g and 11g R2 databases running on Sun Fire V880 servers for the Loan Solutions, group

Planned backup/restoration strategy; scheduled physical backups using RMAN and logical backups using Data Pump in OEM and cron

Utilized OEM and DBArtisan for monitoring, administrative, reporting and tuning tasks

Migrated objects/schemas between environments and tuned bad queries

Level III IT Support Specialist

BICEC Bank, Douala 11/2006 -04/2011

Managed user accounts, network access and file permissions using DOS & UNIX utilities

Installed newly built and re-imaged desktops/laptops in offices

Built test cases and performed software testing prior to release.

Troubleshoot and resolved network related issues over the phone and remotely via WebEx/GoToMyPC

EDUCATION & TRAINING

BA Law & Management Information Systems, University of Yaoundé, Cameroon, 2011

Oracle Training Workshops

Oracle 12c: New Features, Charlotte, NC, 2014

Oracle 11gR2 RAC and Data Guard, Douala, 2013

Oracle 11g Performance Tuning, Douala, 2011

Oracle 10g Administration Workshops I & II, Douala, 2010

REFERENCES

Available upon request.

Contact this candidate