We provide IT Staff Augmentation Services!

Senior Oracle Dba Consultant Resume

Kansas City, MO

SUMMARY:

Lead/Senior Oracle Database Analyst/Administrator skilled in all phases of the product life - cycle, from requirements modeling/design/ETL to tuning, implementation and operational support. Broad range of experience with successful projects in the telecom, airline and banking industries. Dedicated worker who puts a high priority on the success of projects and routinely goes above and beyond with little or no direction required.

CORE STRENGTHS IN:

  • Instance/DB/Query Tuning
  • Logical/Physical DB Design
  • Upgrades/Patching/Support

PROFESSIONAL EXPERIENCE:

Confidential, Kansas City, MO

Senior Oracle DBA Consultant

Responsibilities:

  • Installed/maintained/upgraded/patched 10/11g/12c RAC/ASM environments with DataGuard standbys
  • Instance/Memory performance analysis and tuning
  • Query and PL/SQL design, analysis and tuning
  • Reviewed and developed policies, standards and procedures
  • Unix scripting
  • 10.2/11G to 12C upgrades/migration
  • 24x7 rotating oncall

Confidential, Kansas City, MO

Oracle DBA Consultant

Responsibilities:

  • 24x7 support for 9/10/11g environments.
  • 11g/12c environment upgrades/setup/patching, EBS cloning
  • SSL setup for environments

Confidential, Longmont, CO

Oracle DBA Consultant

Responsibilities:

  • Development design through Prod support/upgrades in multiple 11g RAC environments.
  • Rotating 24x7 on-call support for multiple DEV/PROD 11g RAC environments.
  • Performing upgrades/patching for 11.2.0.4 environments
  • Performed software licensing audit with custom scripts and Oracle's OMT.
  • Using Agile methodologies with PowerDesigner16 to model DDL changes
  • PL/SQL and Unix shell scripting
  • Active Security Clearance

Confidential, Southlake, TX

Principal Oracle DBA

Responsibilities:

  • Complete life cycle of project schema changes -design through implementation
  • Performed new database setup in multiple environments including: db sizing, configuration, system testing, ETL and app/performance testing.
  • Worked with apps team in design/modeling/implementation of new DW and OLTP databases including initial and ongoing ETL.
  • Led SQL and system testing for both OLTP and DW projects
  • Led SQL & PL/SQL performance tuning effort with apps team
  • Standardized environments for consistency among projects using best practices
  • Developed and Implemented CRON initiated extracts
  • Set up & maintained Data Guard
  • Set up & maintained GoldenGate replication across multiple platforms/dbs.
  • Led database effort to port projects to new hardware with no database downtime using Golden Gate for initial load ETL and to keep new and old systems in sync.
  • Setup Golden Gate switchover procedures for going from Primary to Backup DBs
  • Admin for boxes running Oracle RAC 10/11.2.0.3 including applying patches

Confidential, Johnston, IA

Database Analyst/Administrator

Responsibilities:

  • Enhanced and maintained several environments for multiple concurrent projects in a banking environment.
  • Maintained and enhanced Golden Gate between Primary and Backup DBs
  • Developed DB utilities/prototypes.
  • Led SQL performance reviews and effort to define standards and procedures.

Confidential, Columbus, OH

Application/Database Consultant

Responsibilities:

  • Developed new batch programs for ETL of data warehouse using C and SQL.

Confidential, San Juan, Puerto Rico

Application Architect

Responsibilities:

  • Designed back office subsystem and DB for a financial environment.

Continental, San Diego, CA

Applications Consultant

Responsibilities:

  • Enhanced performance on an existing catalog application and trained junior developers.

Confidential, Overland Park, KS

Design Analyst/Database Analyst/Administrator

Responsibilities:

  • Enhanced and maintained databases for large-scale projects in a Telecom environment.
  • Developed database utilities for reverse-engineering environments.
  • Led SQL performance reviews with developers.
  • Supported multiple prod environments and defined standards for life cycle.

Hire Now