We provide IT Staff Augmentation Services!

Senior Oracle Database Administrator Resume

Marlborough, MA

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.

Hire Now