SUMMARY:

Talented Senior Oracle DBA with diverse experience in all aspects of Oracle Database Administration starting with Oracle version 5.1. Goal - oriented, self-starter, team player with expertise in the design, development, implementation and support of multi-TB OLTP and Data Warehouse databases for both vendor-supplied and in-house custom Oracle based applications. Exceptional problem solving, strategic thinking and communication skills.

EXPERTISE IN:

• Oracle installation, configuration, patching and upgrading, SQL tuning, database monitoring and troubleshooting, database design, development and refreshes, schema refreshes, security controls, shell scripting, space management
• Oracle Enterprise Manager (OEM), RMAN backup and recovery, PL/SQL (procedures, packages, functions and triggers), Data Pump, Oracle*Loader, Oracle Forms, JDBC, Hibernate, TOAD, SQL*Navigator
• Creating and implementing database policies, procedures and capacity plans
• Collaboration with development teams, QA teams and mentoring junior DBA team members
• Linux, AIX, Solaris, Windows, NAS, SAN, VMWare
• Oracle RAC/ASM, Data Guard, Exadata

PROFESSIONAL EXPERIENCE:

Confidential, Marlborough, MA

Senior Oracle Database Administrator

Responsibilities:

• Provided development, QA (Windows) and 24/7 production support (Linux RAC) for custom Real Estate/GIS Oracle-based application using Oracle 12C.
• Assisted application team with design, tuning and implementation questions.
• Provided guidance for creation and implementation of Oracle best practice recommendations.
• Stabilized all database environments.
• Provided guidance for creation and implementation of development life cycle best practices.
• Proposed new hardware and Oracle options for company growth and future migration to Amazon AWS environment.

Confidential, Irving, TX

Senior Oracle Database Administrator

Responsibilities:

• Provided development, QA and 24/7 production support for both the 12TB Data Warehouse databases and the 4TB OLTP high-availability databases (AWS) on an AIX platform.
• Collaborated with the in-house application teams on design, tuning and implementation questions or issues.
• Upgraded RMAN and revised backup scripts for all supported databases. Revised clone process for development, QA databases and reporting database.
• Created upgrade plans and upgraded all databases to Oracle 11GR2 RAC/ASM.
• Created migration plans and migrated development and QA databases to Exadata/Linux platform. Created blueprint documentation for production database migration to Exadata/Linux (RAC/ASM) platform.
• Created Oracle 12C databases and migrated development and QA databases.

Confidential, Dallas, TX

Senior Oracle Database Administrator (consultant)

Responsibilities:

• Provided development, QA and 24/7 production support for the mission-critical multi TB OLTP Oracle RAC/ASM databases.
• Created upgrade plans and upgraded databases from Oracle versions 9i or 10G to Oracle 11GR2 running on Linux.
• Assisted development team with SQL tuning questions and production issues.

Confidential, Irving, TX

Senior Oracle Database Administrator

Responsibilities:

• Provided development, QA and 24/7 production support for multi TB, high availability RAC/ASM primary and standby databases.
• Collaborated with the application development and QA teams on design, implementation issues and SQL tuning questions.
• Refreshed development and QA databases from Production after major releases.

Confidential, Dallas, TX

Senior Oracle Database Administrator (consultant)

Responsibilities:

• Provided development, QA and 24/7 production support for databases associated with multiple engineering applications on Linux, AIX and Windows platforms.
• Optimized databases and re-engineered RMAN backups.
• Assisted engineers with modelling questions, SQL statements and PL/SQL packages.

Confidential, Ft. Worth, TX

Senior Oracle Database Administrator

Responsibilities:

• Provided development, QA and 24/7 production support for databases associated with WebLogic retail pharmacy application developed in-house.
• Re-engineered running single instance databases into three node 10G RAC/ASM clusters on AIX.
• Designed and implemented a pilot Data Mart database.
• Collaborated with application development and QA teams to create users, create DDL, develop and implement security, promote schema changes and assist with any design or implementation issues or questions.
• Refreshed development and QA databases from Production after major releases.
• Assisted QA testing by suggesting and implementing Flashback Database option for QA databases.
• Exposure to MySQL

Confidential, Dallas TX

Senior Oracle DBA

Responsibilities:

• Led Oracle team of four Oracle DBAs and two SQLServer DBAs.
• Collaborated with application teams, system administration team and management to plan enhancements to current applications, new applications or projects.
• Gathered manpower and hardware requirements for enhancements, new applications and/or projects.
• Scheduled, coordinated and tracked DBA team work efforts on existing projects and new projects.
• Provided development, QA and 24/7 production support for three Oracle database application teams.

Confidential, St. Louis, MO and Keller, TX

President and Senior Oracle Database Administrator

Responsibilities:

• Specialization in design, performance tuning and backup/recovery issues.
• Extensive experience using Designer 2000/Developer 2000 suite for database and application design.
• Designed and implemented multiple custom Data Warehouse and OLTP databases for clients.
• Author and instructor for three Oracle based training classes.
• Developed and presented customized training classes for clients.
• Served as editor and/or contributor for Oracle training material.
• Served as Beta test participant for Oracle version 7.
• Conducted Oracle 7 new features seminars for large audiences.

Confidential, St. Louis, MO

Principal Consultant

Responsibilities:

• Specialized in Oracle database performance tuning and application development for Oracle versions 5 and 6.
• Designed and developed multiple custom applications for customers using the Oracle Application Development suite.

Confidential, St. Louis, MO

Senior Software Engineer/Oracle DBA

Responsibilities:

• Supported three large development teams creating custom CAD/CAM software for customers using Oracle version 5.1.
• Supported all databases and created applications using SQL*Forms 2.3.
• Co-founder of the Confidential Oracle Users Group.
• Co-founder and vice chairperson of St. Louis Oracle Users group.
• Beta test site for Oracle database version 6 and application tools.