Oracle Database Administrator with a Top Secret Clearance and 5 years of experience designing, installing, upgrading, and maintaining 11gR1/R2 databases in large-scale UNIX/Linux environments. Professional skills include Backup and Recovery methodologies (RMAN), Performance Tuning, Security and User Management.
Oracle Enterprise Manager (OEM)
Database Configuration Assistant (DBCA)
Database Upgrade Assistant (DBUA) / MetaLink
UNIX/Linux Shell Scripting & PL/SQL
SQL*Plus / SQL Developer
SQL Loader / Data Pump
AWR / ADDM Report Analysis
12/2014 - Current
U.S. Department of State - Washington, DCOracle Database Administrator
Assisted in planning and implementing Disaster Recovery and High Availability strategies.
Perform ongoing database maintenance, patching and upgrading for Oracle 11gR1/11gR2 databases.
Utilize Oracle diagnostics tools like Explain Plan, SQL Trace, TKPROF, and the AWR to analyze timing & execution plan for tuning. Also use TOP and VMSTATS to understand the impact on memory & CPU processes.
Design and implement standard and advanced security enhancement and monitoring policies using Fine Grain Access Control (FGAC) and Fine Grain Auditing (FGA).
Provide guidance and recommendations for efficient use of database resources using various Resource Management techniques.
Plan and implement backup and recovery strategies using RMAN.
Utilize Oracle support to troubleshoot and solve critical database issues.
Work with clients, information architect, system admin, and developers to define information flow helping to transform business requirements into environment specific databases.
Attend bi-weekly / monthly meetings to understand business needs and provide suggestions for enhancement.
Assist in the design and implementation of several databases using Data-Flow Diagrams (DFD's) and E/R Models.
Provide database maintenance using SQL Developer and OEM.
05/2014 - 12/2014
Best Buy - Washington, DCOracle Database Analyst (Contract)
Utilized Metalink for opening tickets, downloading and applying patches.
Monitored and administered numerous databases in UNIX/Linux environments on Oracle 11gR2 databases.
Responsible for the creation and management of users, roles, profiles, and privileges.
Troubleshooted and resolved user connectivity and account lockout issues.
Planned and implemented backup and recovery strategies.
Performed capacity planning for efficient database growth.
Configured Oracle Enterprise Manager (OEM) to automate and monitor numerous databases.
Responsible for creating and managing tablespaces and datafiles.