Support Customer

ROY CARUTHERS

TEAM LEAD FOR UDB & INFORMIX DBA TEAMS

CONTACT: 214-***-****

QUALIFICATIONS:

Senior DB2 UDB DBA and Informix Team Lead with over 20 years experience of leading fifteen to twenty worldwide DBAs doing operational support for hundreds of databases across multiple clients and platforms. Improved overall team delivery of database team by rewriting infrastructure and working with customer’s on common issues. Motivated self-starter and hands-on leader that works to deliver a leveraged product and automated assembly for managed services.

PROFESSIONAL EXPERIENCE:

July 2001 - September 2017 EDS/HP/HPE/DXC Plano, TX

Team Lead for DB2 and Informix DBA Teams

Achieved 90% reductions in database incidents.

Reduced database infrastructure setup time by 90%.

Managed VPC (Virtual Private Cloud), virtualized, and physical databases across multiple platforms.

Created automated collection of databases across servers on UNIX/Linux platforms

Mentored team members on procedures and practice to manage databases and tune SQL.

Supported UDB LUW and Informix team members in a collaborative environment to support full life-cycle support across DB2 V8, V9.1, V9.5, V9.7, V10.1, V10.5.

Setup standard, clustered, and DB2 HADR databases and infrastructure.

Lead client meetings to discuss future projects, share status with management, assess currently delivery success, and remediate any issues.

May 1997 - June 2001 Sabre Fort Worth, TX

Lead DBA

Automated conversion process for Traverse Applications (a leveraged solution supporting 13 small airlines)

Reconciled point/mileage balances across disparate systems during conversion process – this had never been accomplished prior to my engagement.

Work with the customer to create methods and port their existing system/data to a new system/new data structures.

Worked with the customer on a daily basis to design data models to support data and operational requirements for airlines systems.

Create methods to track and report any numeric difference when porting from one system to another.

Attended and lead discussions with customer and IBM in Toronto Canada regarding design and operational requirements of airline systems.

Supported Ticket Deliver System (TDS), running on DB2 for windows, with Pitney Bowes printing equipment, in support of American Airlines, Expedia, and Travelocity airline tickets.

Designed, created, implemented, and maintained complex processes to support on-going operations for airline customers operating on DB2 mainframe, UNIX, and windows environments.

April 1990 - May 1997 American Airlines Fort Worth, TX

IMS/DB2 DBA

Created advanced methods to improve processing time of critical systems resulting in a $50,000 per month savings.

Created an automated process to manage IMS databases and reduce development time for application developers.

Lead IMS DBA for the American Airlines Advantage Frequent Flyer System

Perform day-to-day maintenance and support of American Airlines Advantage system

Designed, coded, implemented, and maintained advanced performance techniques for the American Airlines Advantage system. Techniques reduced processing for Member Detail from 6 hours to 30 minutes. This effort reduced monthly Member Details processing cost around $50K per month.

Designed, coded, implemented, and maintained ISPF interface for developers to conduct individual testing of applications on their private database.

Performed runtime enhancements to Member Merger, removing the operational limit of 500 per- day to all merger request..

Performed runtime enhancements to IMS utilities reducing run-times by over 70% for some utilities.

Assisted application team in coding techniques to remove system deadlocks on IMS databases.

Coded, implemented, and maintained, in MVS assembler, phonetic search algorithm for customer names.

Designed, coded, implemented, and maintained, in MVS assembler, customer number generation for Advantage system.

Worked with IBM to predict system performance when converting AA Advantage system from MVS IMS to MVS DB2.

Lead DBA in the design of the American Airlines MIRS (Marketing Information Reporting System), which tracks all tickets flow by American Airlines.

Assisted in the porting of the IMS MIRS system to Solaris UNIX with DB2.

Lead DBA in the design of the data model for AA MIRS. Attended daily sessions with the customer regarding design and system functionality for about six months.

Lead and assisted in the logical to physical data model transformation for MIRS.

Assisted the customer in writing ad-hoc queries for the AA MIRS system

April 1985 – April 1990 EDS Richardson, TX

Systems Design Engineer

Implemented DBRC across 5,000 IMS databases

Automated process for the Quality Assurance team to perform regression testing and environment preparation.

Developed training classes to indoctrinate new team members on architecture / framing of applications.

Developed job conflict report for use in implementation IMS DBRC reducing incidents by over 90%

Performed advanced application/system tuning using TPNS (Teleprocessing Network Simulator)

Assisted with patch panel / cabling of terminals at RIPC.

Assisted in the IPL of machines at RIPC (Richardson TX Processing Center) location.

Attended SED training at Plano, TX location.

Wrote Cobol and assembler applications, using Expeditor to perform debugging.

Participated in the automation of processes to monitor and manage 5,000 IMS database as part of the IMS DBA team (five team member and one lead)

Created training materials and conducted training classes for member of the Insurance Machine.

Completed 8 of 10 Fellow Life Management Institute (FLMI) courses for the Insurance Industry.

Addressed ad-hoc request by management for complex technical solutions.

CLIENT LISTS:

CLIENT INDUSTRY TECHNOLOGY

US NAVY DOD DB2 MIDRANGE

UTC AEROSPACE DOD DB2 MIDRANGE

JP MORGAN CHASE FINANCE DB2 MIDRANGE

MERCEDES BENZ FS FINANCE DB2 MIDRANGE

STATE FARM FINANCE DB2 MIDRANGE

WESTERN UNION FINANCE DB2 MIDRANGE

ALLSTATE INSURANCE IMS

AVIVA CANADA INSURANCE DB2 MIDRANGE

CHUBB INSURANCE IMS

PHOENIX LIFE INSURANCE DB2 MIDRANGE

SPECIALTY INS SVCS INSURANCE DB2 MIDRANGE

EDS INTERNAL IMS, DB2 MAINFRAME, DB2 MIDRANGE

BCBS MEDICAL DB2 MIDRANGE

EXPRESS SCRIPTS MEDICAL DB2 MIDRANGE

COKE RETAIL DB2 MIDRANGE

KRAFT FOODS RETAIL DB2 MIDRANGE

MONDELEZE RETAIL DB2 MIDRANGE

TOP MARKETS RETAIL DB2 MIDRANGE, INFORMIX

AMERICAN AIRLINES TRANSPORTATION DB2 MAINFRAME, DB2 MIDRANGE, IMS

CONTENTIAL AIR TRANSPORTATION DB2 MIDRANGE

DAIMLER CHRYLSER TRANSPORTATION DB2 MIDRANGE

GENERAL MOTORS TRANSPORTATION DB2 MIDRANGE

GOODYEAR TRANSPORTATION DB2 MIDRANGE

SABRE TRANSPORTATION DB2 MIDRANGE, INFORMIX

US AIRWAYS TRANSPORTATION DB2 MAINFRAME, DB2 MIDRANGE

SKILLS:

Training: Perform mentoring and training of new team members worldwide

Documentation: Reviewed and/or documented procedures for team members to follow

ITSM: Manage change, incident, and problems in ITSM systems across all clients

Resources: Forecast resource and man-time for service delivery across all clients

Finance: Report monthly hours by resource and client

Provide budget forecast for standard and non-standard work requests

Automation: Automated DB maintenance and house-keeping tasks for operational stability of systems

Automated event management for notifications as appropriate (email/ticket/page)

Automated collection of DB software installation and databases

Databases: IBM DB2 Mainframe, IBM DB2 LUW across all platforms

Languages: Cobol, Assembler, TSO ISPF, TSO Clist, REXX, UNIX Scripting

Software: ITSM, DB HADR, Clustering, IBM Content Manager, IBM OnDemand, SAP,

Vormetrics, Informatica, DataStage, FileNet, DB2 Explain, DB2 Trace/Event Monitors, db2batch, db2pd, in-house written tools, Erwin, HP Data Protector, IBM TSM, EMC Networker/Legato, Strobe, TPNS

EDUCATION:

Bachelor of Business Administration

Corpus Christi State University, Corpus Christi, Texas

TRAINING / CERTIFICATIONS:

CompTIA Security+ (SYS-401)

IBM Certified DBA DB2 UDB V10 for LUW, IBM Professional Certification

IBM Certified DBA DB2 UDB V9 for LUW, IBM Professional Certification

IBM Certified DBA DB2 UDB V8 for LUW, IBM Professional Certification

ITIL Certified

ITAR Compliant

HIPAA Training Compliance

Gramm-Leach-Biley Training Compliance

Contact this candidate