Oracle DBA

Tiana Bonner

***********@*****.***

Cell: 301-***-****

Highly motivated database administrator pursuing new opportunities to gain and share professional experience and knowledge. Experience in administering data in Oracle Database 10g, 11g, Oracle Enterprise Manager, and SQL Developer. Motivated and team oriented with strong verbal, interpersonal, and written communication abilities. Strong work ethic, problem solving, and multi-tasking skills will enable me to assist in creating efficient and productive solutions.

Software Tools

Microsoft Windows 2012/2008, Oracle 10g and Oracle 11g database systems, SQL PLUS, Linux Red Hat 6, Oracle Linux 7, Microsoft Windows 8, OS X Lion, Oracle Universal Installer, Database Configuration Assistant, VM Ware, VirtualBox, Team Viewer, Microsoft Windows Server 2012 R2 Datacenter

Technical Skills

Install Oracle 10g and 11g software using Oracle Universal Installer

Create databases using Database Configuration Assistant (DBCA) with a general purpose environment

Create directories and subdirectories under the Oracle Managed File (OMF) system

Manage file disk space using the Automatic Storage Management (ASM)

Compile and editing database objects, such as tables, synonyms, views, pl/sql packages, and indexes

Administer disk space and allocating oracle tablespaces using extent management

Write and execute pl/sql code to create, manipulate, insert, and delete data within various databases

Utilize pl/sql programming to assure SQL commands run with the least amount of errors

Determine the most effective sql statements using SQL Tuning Advisor and Enterprise Manager Database Console for database management

Manage oracle scheduled jobs using Oracle Scheduler utility

Ensure the Oracle Net Listener was properly established for using the listener control utility tool (lsnrcrtl)

Monitor database productivity using Automatic Database Diagnostic Monitor (ADDM) and the Automatic Workload Repository (AWR)

Improve system performance by using SQL Access Advisor

Determine backup and recovery strategies using programs such as Recovery Manager (RMAN) and user managed methods

Generate scripts to perform database cold and hot backups

Use flashback technologies to correct user errors

Normalize database objects

Utilize the crontab tool within Linux operating systems for scheduling database tasks

Professional Experience

Tactical Edge Inc. (U.S. Army Department of Defense Contract).

Aberdeen Proving Grounds, MD

2015-Present

Junior Database Engineer

Duties Include:

Analyzing existing databases and data repositories for optimized data integration

Tuning sql and pl/sql code and suggesting necessary improvements to maintain database integrity

Programing and monitoring database elements including schemas, tables, views, stored procedures, oracle scheduler jobs, and other related database objects

Monitoring and resolving issues from system and project status reports on a regular and timely basis

Resolving difficult design, build issues, and troubleshoot bugs for continuous system availability

Playing a support role in database solutions

Trouble shooting and performance tuning for database performance issues

Work with data source providers to solve data feed problems and data upgrades

Zegato Solutions, Inc.

Lanham, MD

2015

Freelance Oracle DBA Contractor

Duties Included:

Installed Oracle Database 11g using Oracle Universal Installer on Microsoft Windows Server 2012 R2 Datacenter

Created and administered accounts for database users

Optimized database performance by tuning sql code with the Oracle SQL Developer software tool

Advised and Assisted developers in database configuration management

Resolved bug and configuration abnormalities

Organized database software files for better efficiency within the Microsoft Windows Server environment

United States Capitol Police

Washington, DC

2009-2015

Communications Operator

Duties Included:

Utilized the CCURE System Monitor to monitor alarms and access control

Communicated with dispatchers to broadcast alarms for a timely response by responding officers using the Intergraph I/Dispatcher system through a CAD interface

Aided officers and Capitol Hill clients with alarm reports within I/Dispatcher that are supplied through an Oracle 11g database

Assisted officers responding to alarms with location and video playback assisting programs such as the Genetec Omnicast system’s Live Viewer, Archive Player, and Video Surveillance Plan Manager Mapping System

Pulled police report numbers from the USCP Capitol File Number (CFN) database on a Microsoft Access platform

Utilized department wide standard operating procedures to monitor alarms, access control and video security systems simultaneously

Education

M.S., Information Technology Database Systems Technology Specialization, 2013

University of Maryland University College

B.A., English, 2007

St. Mary’s College of Maryland

Certifications

Master Certificate in Oracle-10g Database Administration Program, 2009

Oracle 10g Certified Associate

Computer Career Institute at Johns Hopkins University

Current Security Clearances

Secret (Department of Defense)

Current Investigation in Progress for Top Secret

References Furnished Upon Request

Contact this candidate