I am a proactive trained DBA, certified in oracle with five (5) years’ experience working on different oracle versions like 10g,11g and 12c supporting over 300 databases across the SDLC. I have good experience in backup and recovery, performance tuning, database upgrade and patches, installation and configuration of oracle software. I have participated in different projects like DataGuard, RAC and GoldenGate. Iam good at database migration, refreshes, ensuring security, monitoring and managing databases, create databases using both manual scripts and DBCA, create users and tablespaces.
Bachelor’s Degree in Social Sciences – Makerere University Kampala -Uganda
Oracle Database 12c administrator Certified Associate – University of Oracle USA.
UNIX (salaries 8/9/10, AIX, HP UX), RedHat LINUX, WINDOWS 2010,2012
Sql*Plus, Sql*Loader, Toad, OEM Grid Control, Rman, EXP/IMP/Data Pump, Log Miner, AWR, DBCA, DBUA, ADDM, Rman and Sql Developer.
NFP - Austin, TX
April 2017 – Present
Oracle Database Administrator
DBA supporting major projects from Development to Production via Test and UAT environments. Duties involve daily administration, maintenance and tuning. Database ranging from 50GB to 10TB.
Database, Table and schema refreshes using Data pump, expdp and impdp and transportable tablespaces.
Experienced in cloning the databases using online and offline backups and using Rman duplicate backup to migrate data from 11g to 11.2.o.3
Configured deployed and administered 2 and 3 node RAC clusters on Solaris 10 and Redhat Enterprise Linux 5.0.
Extensively involved in performance tuning of applications, SQL queries and databases using Explain Plan, STA, ADDM, SQL TRACE, TKPROF and AWR reports.
Installation and configuration and administration of Oracle Golden Gate
Created a standby database using RMAN Duplicate in order to reduce the down time for the PROD database during the migration process.
Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
implemented database security management, backup/recovery strategy using Rman, monitoring methods. Provided technical support for all application administrators and users.
Applied critical patches to Oracle databases and application servers.
used Grid control (OEM Grid) to administer and manage large number of databases and enterprise wide targets.
Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics. And PL/SQL Tuning.
Responsible for setup and implementation of 2 Node RAC on Linux in 11g and 12c R2.
Implemented Data guard, creating both logical and physical standby databases in 10g and 11g RAC environment for production database.
Create database Objects, Tablespaces, Schemas as needed.
Tempus Resorts International - Orlando, FL
June 2014 – April 2016
Oracle Database Administrator
Successfully installed and configured Oracle 220.127.116.11, Oracle 18.104.22.168 databases on AIX platforms.
Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 12c Cloud Control.
Loading data from flat files to database using SQL*Loader, External Tables.
Extensively used AWR, ADDM and explain plan for periodic performance tuning.
Implementing Data pump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance, cloned using Rman.
Trouble shooting and performance tuning golden gate replications, monitoring scripts for Golden gate in Unix scripting
Involved in Performance Planning and Tuning, using baselines and proactive monitoring, bottleneck elimination and the wait event interface to identify issues and generated weekly reports
Involved in capacity planning and resource planning.
Applied patches and worked closely with Oracle support to make Application environment up to date.
Configure Oracle Advanced Security on 12c databases to implement Transparent Data Encryption at tablespace.
Implemented Flashback technology of the Oracle 11g, 10g along with Recyclebin for a faster recovery of the databases and database objects.
Performed full & incremental backup (cumulative and differential), incremental updated using Rman
Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases., as well as performing database upgrade.
Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts,
Involved in the installation and configuration of Oracle 11g, 10g 2 Node RAC (Real Application Cluster) with ASM file system.
NAME: FARIDAH NAKKAZI