ANNE JUMA

Oracle Database Administrator

Page * of 3

P.O Box 13324 Dovedale Way #F Germantown, MD 20874 Cell 301-***-**** Email: acug01@r.postjobfree.com

ORACLE DATABASE ADMINISTRATOR

Network Platform Infrastructure

Oracle certified database administrator specializing in database maintenance and administration. Over 5 years of hands-on experience as an Oracle Database Administrator with experience on 24x7 production and mission critical database support, experience in performance tuning, RAC and Data Guard. I possess strong analytical and problem solving skills, self-motivated, results-driven, team player with excellent verbal and written communication skills. Strengths include:

Database Administration

Production Support

12c/11g,10g Database Installation

12c/11g/10g Database configuration .

Database Upgrades, Patches and Migration

Database Backup and Recovery

Database Performance Tuning

Database Cloning

11g space Management and Security

TECHNICAL SKILLS

Operating Systems

Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1, Linux Enterprise Server 9, 10. Windows 95/98/NT/2000.

RDBMS

Oracle 10g, 11g, 12c

Languages

TSQL, PL/SQL, UNIX Shell Scripting

Tools

TKPROF, EXPLAIN PLAN, STATSPACK, AWR and ADDM, Toad, Putty, NX client, Winscp.

Database Utilities

SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export, Import

ANNE JUMA Page 2 of 3

PROFESSIONAL CERTIFICATION

Oracle Certified Associate (Oracle Database 11g Administrator)

PROFESSIONAL HISTORY

Fidelity Investments –Boston, MA

Oracle Database Administrator July 2013 - Present

Upgraded the databases to version 12c from 11g and 10g and applied patches as required

Installed, Setup, Configured Oracle version 12c Release2 64 Bit on Solaris 10 and Linux Enterprise Server

Worked on Automatic storage management (ASM) with EMC storage for managing data in SAN.

Successfully implemented 11g RAC on nodes for high availability.

Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 11g Grid 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 Datapump, conventional export/import utility of Oracle 11g for re-organizing Databases/Schemas/Tables to improve the performance.

Involved in construction of DR sites for all the Production environments.

Performed Database Refresh from Production to QA, UAT and Development databases.

Implemented and managed optimum physical database design (tablespaces, datafiles, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space.

Responsible for the smooth functioning of all ecommerce activities of the organization.

Monitored data transfer between the Database servers using Data Stage, Oracle Streams/CDC

Successfully implemented Backup & Recovery using RMAN which includes hot backups and Cold backups and participated in RMAN recovery testing.

Worked with T-SQL statements like DELETE and UPDATE statements and also like BULK insert of data into the datable.

MOTOROLA - Sunnyvale, CA

Oracle Production Support Database Administrator March 2011 – June 2013

Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.

Supporting multiple databases for production, development, test and staging purposes on Linux Enterprise Server and Windows environments.

Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.

Refreshing Dev and Test instances with data from Production on a regular basis.

Installed Oracle 11g on Linux platform using ASM.

RMAN point in time recovery and Instance recovery done on 11g.

Developed compliance reports and performed auditing at higher levels.

Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab.

Implemented Flashback technology of the Oracle 11g, 10g along with Recyclebin for a faster recovery of the databases and database objects.

Installation of 2 node and 3 node RAC, Migrating of database to RAC database. Monitoring Health checks of OCR, VOTING DISKS and Interconnect for better performance and troubleshooting issues in RAC environment (11GR2).

Worked on converting bigfile to small file tablespace conversion for very large data (included 2T of data)

Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.

Restoration of Data for users in the event of requirement or system crash.

Wrote SQL scripts to monitor tablespace and extent growth.

Tribune Company - Chicago, IL

Junior Database Administrator March 2010 – Feb 2011

Optimized data loading using SQL*Loader to load different types of data from flat files to the Oracle server.

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

Cleaning the ORACLE_HOME file system by cleaning the log files, alert log file and listener.log files

Identified and trouble shot everyday issues like locking, scripts execution, Data Audits etc.

Backup and recovery utilizing RMAN.

Working with the application support people to resolve database related issues and running the scripts for the application support people.

Creating users and database links, snap shots on production and development servers.

Education

Bachelor of Science, International Business Administration

United States International University

REFERENCES

References available on request

Contact this candidate