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.