SUMMARY:

• IT professional with over 30 years of experience in Oracle and SQL Server database administration, management, performance tuning, application development, project and team management as well as data modeling and design experience. This includes installation, upgrades, and migrations of small to larger sized Oracle databases starting with early releases of Oracle RDBMS Server versions 6, 7, 8, 9i, 10g, and 11g as well as most recently a full install on a Linux virtual server of Oracle 12c. Roles have also included Information Assurance Officer for the United States Air Force, IT Service Desk Manager, Software Development Manager, Oracle Architect and Data Modeler.
• Oracle Tuning and Memory Management
• Expert in Defense Information Systems Agency (DISA) Security Technical Implementation Guide (STIG) as it applies to secure lock down of Oracle, SQL Server and Generic (MYSQL, DB2, etc.) relational database systems.
• Experienced in recent and older versions of Windows, AIX, Sun Solaris, and Linux/Red Hat.
• Experienced with SYBASE and POWERBUILDER.
• Experienced in performing system administration tasks, change management planning, testing and implementations utilizing Oracle Enterprise Manager (9i through 12c).
• Experienced with Oracle My Support and Oracle Metalink (over 15 years). Very experienced in resolving complex issues with Oracle database and application servers, storage server and databases.
• Expert in Oracle upgrades, apply Oracle patches (CPU and PSU), Oracle database migrations (Oracle 8 through 11g R2).
• Skilled in RMAN database backup and recovery procedures
• Skilled in the use of Oracle Performance tuning tools: AWR, ASH, TKPROF, Explain Plans, Snapshots and Database and Session tracing.
• Hands - On experience with Data Guard and Broker (10g-11g)
• Experienced in the use of DBVisit (Data Guard equivalent product)
• Expertise in SQL and PL/SQL language
• Skilled in the use of JavaScript, Perl script and T-SQL.
• Expertise in technical project management using MS Project
• Expertise in leading and managing technical teams, specifically DBA
• Skilled in the use of CMM and CMMI Level 3 processes
• Skilled in the utilization of ITIL IT service practices
• Experienced with Oracle Application Servers: (9i through 11g). Administration, Installation, Configuration and Deployments.
• Expertise in the Oracle Enterprise Manager: versions 8 through 12c. Change Manger, Performance Modules, SQL Advisor, Memory Advisor, Segment advisor and configuration of alerts.
• Expertise in Oracle Discoverer (Oracle BI tool)
• Expertise in Oracle Designer (6i-11g)
• Expert in all versions of TOAD
• Experiences in SQL Server . Administration and Configuration.
• Experienced in MySQL (version 5)
• Skilled in UNIX/LINUX shell scripting:
• SED
• GREP
• Vi editor
• Top
• Vmstat
• Oracle Data Guard and Standby Database (previous product to Oracle Database Guard) in both RAC and Non-RAC environments, primarily on Unix Solaris, IBM AIX and HP platforms. 2 years’ experience monitoring, administering and configuring Oracle RAC 10.2 on LINUX. Total 10 years of RAC experience. Oracle RAC projects include James River Insurance Group, Richmond Virginia, Signature Consulting at the Army Information Technology Agency (ITA) NISO Pentagon and the Northrop Grumman MISTS contract at Air Force Office of Scientific Research (AFOSR) as lead DBA, Software Engineer\Manager and Database architect.
• Worked with ORACLE APEX while on contract with DTIC and Justice Department - 2 years total experience.

PROFESSIONAL EXPERIENCE:

Confidential, Dulles, Virginia

Technical Environment: Windows Web Server .Net and ASP - Windows 2003/2008

Senior Oracle\PRISM Applications DBA

Responsibilities:

• DBA tasked with administrating, configuring and upgrading Oracle 10g, 11g and 12c, small, mid-size and large databases.
• Installed, maintained, performance tuned and upgraded the PRISM 7.x - 7.2 Federal Acquisition Regulation (FAR) Application and supporting Oracle database schemas.
• Use of Oracle Datapump (import and export) utilities
• Use of TKPROF Oracle Performance Tuning command line tool
• Use of AWR Oracle Performance Tuning tool. Both in Enterprise Manager and command-line.
• Problem solving in all aspects of Oracle (10g through 12c)
• Problem solving in all aspects of Microsoft IIS Web servers
• Write custom UNIX shell scripts
• Install and manage Data Guard configurations including third party product for high-availability, DBVIST
• Apply Oracle CPU patches
• Upgrade over 20 Oracle databases from Oracle 11.1 to 11.2.0.3
• Configure and Install Oracle Client 11g
• On-Site support to multiple Federal agencies in the Washington DC Metro area providing expert Oracle database and application support, troubleshooting, performance tuning, patching and upgrades.
• Provided expert remote Oracle DBA support to production environments via Webinars and VPN remote log in using P-Shell and Putty.

Confidential

Senior Oracle and SQL Server DBA

Technical Environment: Windows Web Server .Net and ASP - Windows 2003/2008

Responsibilities:

• Oracle 11g RAC DBA
• Monitored all aspects of Oracle 11g database production operations (24x7)
• Maintained and developed complex shell scripts in LINUX Red Hat environment to manage Oracle DB cron jobs and API to third party applications.
• Supported MS SQL Server 2008 R2 databases which support Health Industry standard Enterprise Resource Planning (ERP) applications that include McKesson, STAR and API
• Applying ERP patches and upgrades to the Oracle ERP databases, ERP applications, Web Servers
• Managed IIS (Windows 2008)
• Administered and managed Oracle Portal servers
• Applied Oracle CPU patches utilizing Oracle Opatch
• Provided Oracle software engineering support to Oracle Forms and Reports (11g)
• Administered and maintained LINUX shell scripts and custom coded server based applications written in a variety of programming languages.
• Versions include Oracle 10g 10.2.5 and Red Hat LINUX 5.10 (kernel 2., Windows Server 8 and MS SQL Server 2008 R2.
• Tools include TOAD, MS SQL Server Management Studio, MS Visual Studio, Oracle SQL Developer, Oracle Enterprise Manager and MS SQL Server Enterprise Manager.

Confidential

Principal Senior Oracle Consultant

Responsibilities:

• SAIC (Huntsville, Alabama) - Provide DBA support and expert analysis of architecture and configuration of Oracle Database with intent of improving synch time between client PC (MILTOPS) and Server databases based at Red Stone Arsenal in Huntsville Alabama for CAFRS Army System.
• James River Insurance Group (Richmond, Virginia): Senior Principal Oracle Consultant acting as technical lead and architect in the migration of customer’s Oracle 8i database (8.1.0.7) to Oracle 10g (10.2.0.3). Tasks/Deliverables include of staff, migration of data and database objects/applications from Oracle 8i production database, configuration/health check of new 10g databases, cloning and creation of additional Oracle 10g (10.2.0.3) to Windows 2003 (SP2) servers and documentation of processes involved to achieve these tasks/deliverables.