SKILLS/ABILITIES

• Oracle Database Administration (v8i/9i/10g/11g)
• ASM (Automatic Storage Management)
• SQL, PL/SQL
• Database Performance Tuning
• Backup and Recovery (RMAN)
• Oracle Enterprise Manager Grid Control
• Logical Data Modeling, Physical Database Design
• Unix (Solaris/Linux/HPUX)
• Shell Programming (bash/ksh/csh)
• Real Application Cluster
• Apex
• Toad
• Data Guard (Logical/Physical Standby)

PROFESSIONAL EXPERIENCE

Database Administrator Confidential 6/2008 to present

Production Support of large (~4TB) databases supporting Mission Critical Databases. Primary responsibilities included:

• SQL Perform tuning
• Install, upgrade and patch Oracle 10g/11g software
• Extensive backup/recovery ope using RMAN (utilizing Veritas Net Backup and DataProtector)
• Install and maintain Oracle\'s Grid Control facility to monitor and analyze production databases
• Provide application support including development and/or execution of SQL/shell scripts.
• Cloning of production databases into development and test environments- utilizing RMAN duplicate function and shell scripting.
• Monitor and troubleshoot Logical and Physical Standby databases

Database Administrator Confidential 11/2006 to 4/2008

Database Administrator for company providing telecommunications products (including VOIP) to international customers. Responsible for supporting the company\'s Oracle 8/9i/10g databases in all environments (i.e. dev/test/production). Responsible for backup and recovery using both locally developed backup scripts as well as Oracle’s RMAN facility. Assisted in troubleshooting and problem resolution of Customer databases.

Responsibilities also included development of numerous PL/SQL and shell scripts to support both customer and local functionality. Some recent examples include:

• Shell scripts to incorporate Oracle’s silent installation functionality to allow for ease of oracle installation on customer premises
• PL/SQL and shell scripts to enable a low-cost failover solution for a customer incorporating Oracle’s Data Pump utilities.
• Developed Data Replication installation scripts utilizing Oracle’s data replication functionality (Materialized Views).

Database Administrator Confidential 06/2003 to 11/2006

Responsible for Database Administration of multiple Oracle (v8/9i/10g) databases in all phases of project development (ie. Dev/QA/PROD). The databases supported batch, online/Web and Data Warehouse applications. Installed, maintained and tested RMAN backup and recovery processes to ensure database recoverability. Performed database and SQL tuning to greatly improve overall database performance using both third party software (TOAD) and oracle provided utilities. Installed and configured Oracle’s grid control to allow for centralized administration and monitoring of the company’s databases. Assisted in migration of databases from 9i to 10g RAC. The migration also included the upgrade of Veritas’ volume manager to Veritas’ Storage Foundation (v4.1).

Database Administrator
Java Developer
Project Manager Confidential 6/2001 to 11/2002

Project Manager and Lead DBA on successful project to greatly expand functionality of existing “trouble ticket” application. Designed, wrote and implemented numerous SQL and PL/SQL programs. Designed and implemented replication strategies to allow consistent view of data between inventory databases and ticketing application.

Installed and administered the company’s Local Area Network. This consisted of a heterogeneous environment consisting of Solaris, Linux and Windows NT 4.0 operating systems. Set direction, developed project schedule and managed the development/testing efforts for development team consisting of 12 software engineers.

Participated in the design and coding of a java-based application which provides managers the ability to monitor the current status of mission critical entities/matrices. The application was built using several W3C specifications including: Java, WSDL, SOAP, XML, RMI.

Responsible for Design, Development and Deployment of the logical and physical data models for an application used by Outside Plant (OSP) and Central Office Facility Network Engineers to analyze and plan all aspects of Qwest’s 14 state regional telecommunications network. Led team responsible for designing and developing interfaces to Oracle, DB2 mainframe and Telco legacy databases.

Senior Operations (production support ) Oracle DBA in a distributed client/server environment consisting of over 400+ SUN/Solaris and HPUX servers with 30+ production databases supporting over 5000 OSP engineers. Installed and administered many Oracle (v. 7/8) databases on Unix Sun/HP platforms. Responsible for performance tuning of mission critical databases. One of the databases for which I was responsible supported an Order Tracking application, which served over 2800 concurrent users (5000+ user base) in a VERITAS High Availability (HA) environment.

Developed, tested and implemented strategies and processes for database deployment, population, backup and recovery. Created an environment for production DBA support personnel to simulate database failures and thus validate backup and recovery processes

Confidential Pre 2001
OVERALL - Database Administrator on projects supporting development organizations in Network Operations Center (NOC).

PROCESS MANAGEMENT - Oversaw and participated in the development of corporate processes and standards for developing and maintaining the Logical and Physical Data Models for Corporate Subject Databases (CSDBs). Served as chairperson of the Corporate Data organization\'s Database Administrators User Group.

DATA ADMINISTRATOR - Developed logical data models for many diverse business functions. This included a major finance project, a new billing system and an error tracking database for a high volume transaction application.

SYSTEM ARCHITECT/PROGRAMMER - Designed, programmed, installed and maintained numerous programs in both assembly language and COBOL. Served as lead programmer and system engineer on an application responsible for assigning long distance charges to toll calls.