SUMMARY:

• Database Engineer with 20+ years of experience spanning multiple roles in Database Engineering, Data Analysis, and Administration.
• Senior DBA with expertise in designing & supporting Confidential, OLTP databases.
• Diverse background with expertise in data analysis, logical/physical database design, performance and tuning, high availability, server/middleware installation and upgrades, and production support.
• Recognized for being proactive, providing effective problem resolution, and ensuring continuous improvement of database operational processes.

AREAS OF EXPERTISE:

DBMS: Oracle 10gR2, 11GR2, Mysql 5.0, 5.1 Sybase 11, 12, 12.5, MS - SQL Server, Sybase Replication Server, DB2 UDB 7.2, DB2 for OS/390

LANGUAGES: Korn Shell, PERL, PL/SQL, Transact SQL, Sybperl

OPER. SYSTEMS: Sun Solaris, Red Hat Linux, HP/UX, NT 4.0,95,Win2000, IBM AIX, IBM OS/390

MODELING TOOLS: ER Studio/ ERWin, MySQL Workbench

BUSINESS AREAS: Confidential Music Channel, Confidential Calendar, MapQuest B2B, SMART AD Links, Confidential Content Publishing, Confidential International Properties, KOL, Confidential .com, MovieFone, Confidential Finance, Security Filings & Collection systems, Mortgage Data Warehouse, Order Entry, Air Traffic Control, Asset Tracking, Labor/WBS, Ledger, Manufacturing, Purchasing

PROFESSIONAL EXPERIENCE:

Confidential

Senior DBA

Responsibilities:

• Database Engineer providing Oracle & MySQL engineering support for Confidential 24x7 Applications.
• Currently Senior Oracle/MySQL Database Engineer/Administrator responsible for migration of a 24x7 Oracle 10.2.0.4 database
• On Windows to Confidential 11.2.0.2. New instances of Oracle Confidential 11.2.0.2 were installed and Oracle Streams was utilized to minimize downtime for the customer. In addition, physical Data Guard was installed on both Oracle 10GR2, 11GR2.
• As part of migration, Oracle RMAN scripts were re-written for backup/recovery, archive log maintenance on Confidential .
• Also provided PL/SQL Stored Procedure, query, and instance tuning as required by the application resulting in
• Visibly faster performance by the customer.
• In addition, responsible for creation and support of MySQL instance(s) for newly engineered projects transitioning to
• MySQL within our department.

Confidential

Senior Staff Member

Responsibilities:

• Provided Oracle Database Engineering services for the development of an advanced File Management System. Created Oracle schema installation scripts to automate the Oracle Agile Development environment. Assisted with Implementation of Oracle Label Security to facilitate the flexibility of row level database security into the design.
• Installed Oracle 11GR2 RAC in a Confidential Linux LAB environment to become familiar with RAC.
• Providing MySQL Database engineering support for a Confidential Data Collection Application. Collaborated with Development Engineers to identify and resolve application and database performance bottlenecks. Created installation scripts to automate the installation of both MySQL and the database. Provided Database upgrade support to the latest MySQL 5.1 release.

Confidential

Senior DBA

Responsibilities:

• Provided high profile MySQL database support for customer facing Confidential websites including music. Confidential .com, Confidential .com, tourtracker, and TV listings.
• Collaborated with design teams and provided operational support for the implementation of the MapQuest Smart Ad Links system utilizing Oracle 10gR2 and Oracle Dataguard for a physical standby/failover.
• Provided primary support for mission-critical Sybase Servers/Databases supporting Welcome Screen publishing, International properties, Confidential Calendar, and Digital Asset Management. All servers required 24x7 availability implemented via Sybase Replication Server.
• Led successful implementation of Confidential ’s first DB2 UDB implementation.
• Provided timely and critical database support of financial accounts receivable/payable during the Time Warner Merger period including server upgrades, Cots software support, performance and tuning.
• Created process for Server Installation/Upgrades, replication procedures for replication setup/resync, and regular participation on a team to help improve Confidential ’s Database infrastructure.

Confidential

Senior DBA

Responsibilities:

• Installed and/or upgraded Sybase ASE, Replication Server, Direct Connect, DB2 OS/390, Replication Agent
• Designed/altered physical databases for Confidential applications central to the success of key Confidential business functions.
• Created and supported korn shell and perl scripts to support Sybase ASE and Replication Server support activities.
• Performed architecture selection, and implementation of bi-directional heterogeneous replication from Sybase to DB2. Installed and supported Sybase Direct Connect Gateway used to replicate Sybase data to DB2. Installed, configured, & maintained Replication Server warm standby of Confidential Sybase databases requiring replication.
• Reviewed Sybase stored procedures, for integrity and efficiency resulting in a competitive product line for the company.

Confidential

Senior DBA

Responsibilities:

• Supported and Maintained DB2 Catalog/Directory Backup and Recovery, Catalog and Directory Health checks, DB2 internals recommendations, Implementation and support of DB-Delivery, capacity planning for DB2 DASD.
• Planned and coordinated the DB2 portion of a data center move for Norwest

Confidential

Senior DB2 DBA

Responsibilities:

• Performed Physical Database Design Reviews on multiple Confidential applications which resulted in database design modifications, index tuning, and SQL modifications improving application performance
• Coordinated and Implemented DB2 packages for key Confidential applications including versioning and automated package bind configuration management
• Coordinated and performed DB2 environment setup and monitoring for a major Confidential Confidential application involving high volume transaction processing and large data volumes in a distributed CICS environment

Confidential

Lead DB2 System/Database Administrator

Responsibilities:

• Assisted with the technical DBMS product evaluation in selecting a client/server DBMS to support the FAA re - platforming decision. DBMS's evaluated were: Sybase System 10, Oracle 7.0, Informix, Ingres and DB2/6000.
• Coordinated, prepared and led application design reviews involving detailed analysis of logical and physical DB2 designs with the IBM Dallas System Center
• Developed and documented DB2 system/database administration support procedures to include: backup and recovery, security access controls, database reorganization, integrity controls, naming conventions, and storage management
• Conducted technical training sessions in DB2 access path analysis and physical database design for development DBAs and application programmers