Database Consulting Services

DATABASE CONSULTING SERVICES 
PeopleSoft DB2 UDB DBA and Performance Tuning Specialists

Home

Bio

Consulting Services

Webinars

Monitoring, Optimizing,
Configuring,
Architecture
Guide

White Papers

Conference Presentations

Customer List & References

Resumes

Contact Us

BRIAN HOLROYD

Career Summary - Education - Hardware - Software - Other Accomplishments - Career Details 

Career Summary  

 


1995 - present 

PeopleSoft Performance Engineer/DBA

 

DB2 for z/OS, DB2 for LUW
 

1987-
1995

DB2 DBA

 

Data Warehousing, Database Design & Support, Performance Monitoring and Tuning, Conversions, Software Installation Support/Programming

1985 - 
1987

Manager 

 

Database Design, Database Technical Support, Data Administration, Development Center 

1984 - 1985

Project Leader/DB2 DBA

 

Database Design

1980 - 1984

IMS DBA

 

 Database Design

1971 - 1980

Programmer/Analyst

 

PL/1,COBOL, IMS DB/DC, CICS

Academic Education
1975: BS Math and Computer Science Sheffield University, England 

Professional Education Highlights 

DB2/UNIX Database Administration & Performance Tuning

IBM

Online Dynamic Server System Administration

Informix

Oracle Installation, Administration and Tuning for UNIX

UC Berkeley

UNIX System Administration

UC Berkeley

Using the UNIX Operating System

UC Berkeley

C Programming

UC Berkeley

DB2 for OS/390 V1-9 Overview

IBM

DB2/MVS Performance and Tuning

Candle

Bachman Data Analysis and Database Administrator

Bachman

The Management Course

AMA

Hardware 

Mainframes

IBM 1401-zSeries 9

UNIX Servers

IBM, Sun, HP

PCs

IBM and compatibles

Software 

OS

Mainframe

z/OS and OS/390

 

UNIX

AIX, Solaris, HP-UX, LINUX

 

PC

Windows 3.1/95/98/NT/2K/XP, OS/2

DBMS

Mainframe

DB2-z/OS, IMS/DB

 

UNIX

Informix, DB2 for LUW, Oracle

 

PC

DB2 for LUW

TP Monitors

TUXEDO, TSO, IMS/DC, CICS

Programming Languages

PL/1, COBOL, SQL, CLIST, REXX, SQR

Web Servers

UNIX, NT

Apache, Weblogic, WebSphere

Performance Monitoring & Tuning Software

All

Many, from Loadrunner to DB2 Performance Expert, Nmon to StatsPak

Other Accomplishments 

Speaker 

International DB2 User Group Conference 2000/2001/2002/2005/2006 (PeopleSoft Performance & Tuning on DB2 for z/OS and DB2 for LUW). Top 10 speaker IDUG 2006.

 

PeopleSoft US Users Conference 1997/1998/1999/2000/2001/2002/2004 (DB2 Performance & Tuning)

 

PeopleSoft European Users Conference 1998 (DB2 Review)

 

DB2 Technical Conference 1998 (PeopleSoft on DB2/OS390)

 

SHARE 2000/2001/2002 (PeopleSoft Performance & Tuning)

 

CMG 2001 (PeopleSoft Performance & Tuning)

 

Bay Area DB2/MVS User Group, Seattle DB2/MVS User Group and Portland Chapter DPMA/ASM meetings

Lecturer

Knauer DB2/MVS and QMF classes. PeopleSoft Tuning on DB2 for OS/390

Author

PeopleSoft DB2 for OS/390 Performance Tuning Guide

Reviewer 

"Advanced Topics in DB2/MVS", Blaine Lucyk, Addison-Wesley Publishing 

 

"Installing PeopleSoft on OS/390 with DB2" IBM Manual

BM DB2 Gold Consultant   Elected to IBM Gold Consultants Team - 2000  

IBM Information Champion

Elected to IBM Information Champion Team - 2008

Career Details

2006 - Present: DATABASE CONSULTING SERVICES - Independent Consultant/ IBM Gold Consultant/ IBM Information Champion

7/08 - present: DB2 Performance Consultant

       Engaged by CPT Global Limited for several Fortune 100 customers to undertake MIPS reduction projects.

§ Identify expensive SQL statements using various software tools (Strobe, Freezeframe, Expetune, Apptune, Detector etc).

§ Review DB2 Subsystem Environment. Perform Health Checks.

§ Review program code for inefficiencies

§ Present and implement solutions.

Engaged by HMNA for Mid-West Supermarket chain to identify and tune expensive SQL using EZ-DB2.

§ Reduced Production DB2 CPU usage by 30% over 3 month period, resulting in a reduction of assigned     MSU’s and considerable cost savings.

Engaged by IBM Canada to support upgrade and new product install to HCM9, and DB2 9 for large  government customer

2/06 - present: PeopleSoft Performance Consultant/DBA

For various PeopleSoft Customers:

     § Supported upgrades of PeopleSoft HCM 8.3 to 8.90

     § Performance Audits of PeopleSoft Environments on DB2 for z/OS and DB2 for LUW

     § Architecture reviews

     § Performance tuning of a wide variety of PeopleSoft processes.

     § Tested features of DB2 for z/OS V8 on PeopleSoft databases for IBM. Wrote White paper. Presented Webinar.

     § Tested features of DB2 9 for z/OS on PeopleSoft databases for IBM. Wrote White paper. (Webinar presentation pending)

     § Wrote 600 page e-Book ‘Monitoring, Optimization, Configuration and Architecture eBook for PeopleSoft Enterprise Applications on the Mainframe.

     § Developed, marketed and conducted a 30 hour Webinar based on the book.

List of clients appear on http://db-consulting.com/references.htm

2003-2006: PeopleSoft/Oracle

§          Benchmarked the following PeopleSoft products:

o         HR Help Desk 8.8 on DB2 for LUW

o         CRM 8.9 for Communications on DB2 for LUW

o         Financials 8.9 “Day in the Life” on Oracle 10g

o         Payroll 8.9 on DB2 z/OS V8

§          This involved installing all required software, implementing the PeopleSoft products, using the appropriate operating system, DBMS, and PeopleSoft monitors to identify and debug performance problems, and delivering an optimized product to customers

1989 - 2003: DATABASE CONSULTING SERVICES - Independent Consultant/IBM Gold Consultant 

6/95 – 3/03: PeopleSoft Performance Consultant

For PeopleSoft customers:

§          Troubleshooted performance problems, conducted performance audits, developed, marketed and taught a 3-day Performance Monitoring and Tuning Class for PeopleSoft on DB2

§          List of clients appear on http://db-consulting.com/references.htm

For PeopleSoft:

 Benchmarked the following PeopleSoft products:

§          Accounts Receivable 8 on DB2 for OS/390

§          Time & Labor 8 SP1 on DB2 for OS/390

§          Payroll 8 SP1 on DB2 for OS/390

§          HRMS 8 SP1 online on DB2 for OS/390

§          Order Management 7.5 online on DB2 for OS/390

§          Accounts Payable 7.5 on DB2 for OS/390

§          Accounts Receivable 7.5 on DB2 for OS/390

§          Purchasing 7.5 on DB2 for OS/390

§          Billing 7.5 on DB2 for OS/390

§          Benefits Administration 7.5 on DB2 for OS/390

§          Financials 7 Application Server Sizing on DB2 for OS/390

§          Financials 7 Online TCP vs SNA on DB2/OS390

§          Financials 7 Online on DB2 for OS/390 

§          HRMS 7 Online on DB2 for OS/390

§          Financials 6 Online on Informix.

§          General Ledger 6 on DB2/OS390

§          HRMS 6 Online on Informix.

§          Payroll 5 on DB2/MVS and DB2/UNIX 2.1.1.

§          HRMS 5 Online on DB2/MVS and Informix

9/94 - 5/95: IBM (for GAP Stores) - DB2/MVS and DB2/2 DBA 

§          Designed databases for an inventory control system to support direct-to-store shipments for Gap Stores. Environment was VISUALGEN, DB2/MVS, DB2/2, CICS, CICS/OS2 and DDCS/2. 

§          Set up and supported development database environment for the project on DB2/2 & implemented on DB2/MVS

10/92 - 6/94: PACIFIC BELL - DB2/MVS DBA 

§          Designed 100+ tables for a Data Warehouse Marketing system. Largest table consisted of 1.1 billion rows storing Usage and Revenue information. Used Bachman DBA tool for design and documentation. Used DDF for distributed DB2/MVS access. Analyzed, reviewed and tuned all processes accessing the database

7/92 - 9/92: MERVYNS - DB2/MVS DBA 

§          Designed databases for a Clearance Tracking system.

4/92: WELLS FARGO BANK - DB2/MVS Performance Specialist 

§          Undertook a performance review for a Returned Checks system. Implemented improvements to the database design, load process and SQL coding.

9/90 - 7/92: ACS (for CENTEX TELEMANAGEMENT) - DB2/MVS DBA 

§          Converted databases for a telephone billing system from VSAM to DB2/MVS

§          Retrofitted several programs with DB2/MVS checkpoint/restart logic.

4/91 - 7/91: PACIFIC BELL - DB2/MVS DBA 

§          Converted databases for a journalizing application from Honeywell IDS to DB2/MVS.

2/90 - 8/90: SAFEWAY - DB2/MVS DBA 

§          Converted a VSAM based promotion and allowances system to DB2/MVS for Safeway Stores.

2/90: RALEYS - SQL/DS DBA 

§          Performed database design and performance review for an Item Movement system.

4/89 - 1/90: LUCKY STORES - DB2/MVS DBA 

§          Benchmarked a check authorization system comparing the CPU utilization of DB2/MVS, VSAM and IMS/DB. 

§          Implemented automated DB2/MVS Utility Generation system.

7/89 - 12/89: USS-POSCO - DB2/MVS and IMS/DBA 

§          Wrote automated utility generation system using Dialogue Manager/COBOL/REXX and CLISTs

1987 - 1989: COMPUTER TASK GROUP - Consultant DB2/MVS DBA 

§          Designed databases for a DB2/MVS/CICS/CSP Statement of Account system for SAIF Corp. 

§          Designed databases for DB2/MVS/CICS/COBOL performance benchmark application for a Canadian oil company on behalf of IBM, Canada. 

§          Supported a DB2/MVS/QMF pilot application for Glendale Federal Bank

§          Installed DB2/MVS and QMF, established the DB2/MVS environment (standards, procedures, security etc) for USS-POSCO and SAIF 

§          Developed disaster recovery procedures, and recommended system performance enhancements for Kroger 

§          Supported implementation of a customer order system for AT&T

1980 - 1987: LUCKY STORES - IMS & DB2/MVS DBA and Manager 

§          Managed up to 15 people in the Database Group, including the Design, Technical Support,Data Administration and Development Center functions.

§          Led a project to build a Corporate Data Model using "BSP" and "SISP" methodologies. Developed 5 and 10 year software technology plans.

§          Performed DBA tasks (design, support, troubleshooting) in an IMS DB/DC,PL/1 and COBOL environment. Supported the implementation of DBRC, Datavantage, SHRINK, Database and Block Level Data Sharing. Developed and conducted numerous advanced IMS and DBRC classes

§          Set up the DB2/MVS environment. Established standards and procedures for DB2/MVS, including naming conventions, security, backup and recovery, programming guidelines etc. The environment included DB2/MVS, CICS, IMS/DC, TSO, QMF, DBEDIT, DXT, DB2PM and CSP.

 1975 - 1980: ALTERGO LTD - Programmer/Analyst 

§          Worked for clients including IBM, Rowntree-Macintosh, British Leyland, Aramco, Lucas, Fodens and Lucky Stores on a variety of applications. All programming was done in PL/1, COBOL IMS DB/DC. Also taught PL/1 and IMS classes.

1971 - 1975: IBM - Programmer/Analyst 

§          Programming and analysis of financial and inventory control systems using 1401 Autocoder and PL/1.

  

 

Contact us at:  925-575-0232

 

Info at db-consulting dot com 

 

 

 PeopleSoft DB2 UDB DBA and Performance Tuning Specialists. Upgrades, Installs , Administration, Audits

 

  Copyright © Database Consulting Services
All other products listed are registered trademarks or trademarks of other corporations