Curriculum Vitae for Bruce Williamson

Contact

Location:	Sydney, Australia
Email:	Bruce Williamson
LinkedIn:	Bruce Williamson DB2 DBA

Interests

Rugby, golf, camping, fishing, photography, cooking, travelling, emerging technology and data analytics

Briefly

Over 30 years experience in the information & communications technology industry including 25 years database administration.
Experience includes all facets of database and systems administration including:
- Application, SQL & database performance monitoring, analysis and tuning
- Data modelling & database design
- Procedure development
- Technical support
- Software installation & maintenance
- Full systems development life cycle
- Training & mentoring
Ability to communicate effectively at all technical, operational, administrative and management levels to provide innovative customer-centric solutions.
Capacity to adapt to new technologies, becoming productive in limited time frames.
Documented broad work experience as well as the expertise to work with little or no supervision but at heart very much a team player both in the work place and outside of it.

Industry

Banking
Government
Telecommunications
Transportation
Marketing
Healthcare
Mining
Retail
Energy

Software

DB2 for z/OS
SAP (HANA, Banking, Bank Analyzer, BW, ERP, Insurance, PI & SolMan)
SAP NetWeaver
DB2 Administration Tool
DB2 Automation Tool
DB2 Utilities Suite for z/OS
SPUFI (SQL Processor)
Omegamon Performance Expert for DB2
DB2 Buffer Pool Analyzer
Omegamon XE for z/OS
z/OS, TSO/ISPF, SDSF, TWS & JCL
Windows & MS Office 365
KNIME, Python & Tableau

Commonwealth Bank of Australia - Sydney, Australia

12/10 to Present - SAP DB2 Database Administrator

Employed by CBA to provide DB2 database administration services to the Core Banking & Enterprise systems

Duties:

Designed CBM database REORG automation strategy based on ITSMO "Shift Left" initiative, to optimise database performance and eliminate customer impact
Implemented ITSMO REORG automation process in all sandpit, NFT (Non-Functional Test) and production systems, a total of 23 DB2 sub-systems managing hundreds of thousands of tables and indexes
Implemented SAP DBA Cockpit REORG automation process in all development, test and staging systems, a total of 40 DB2 sub-systems managing hundreds of thousands of tables and indexes
Documented REORG automation SOP (Standard Operating Procedure)
Worked closely with IBM software engineers to improve the REORG utillity to meet CBA's 24/7 availability requirements
Implemented SQL queries for accurate monitoring and tracking of outstanding database housekeeping to facilitate better housekeeping practices
Liaised with internal clients who utilise DBA services, providing detailed consultancy services and responses to problems and service requests
Attended zSAP VLDB Conference in 2012, 2014 & 2017 as CBA technical representative
Implemented process to capture DB2 SMF statistics and populate DB2 PM (Performance Management) database for easier access to performance data for reporting and problem diagnosis
Scheduling database housekeeping in the DBA Cockpit for all development, system test, UAT and staging environments
Provides constructive input into team meetings and mentors more junior members and new employees within the DBA area
Using RMF to collect performance data for z/OS and sysplex environments to monitor systems' performance behavior and to optimally tune and configure system according to business requirements

Environment:

DB2 13 for z/OS, DB2 Utilities Suite for z/OS, DB2 Administration Tool V13.1, DB2 Automation Tool V4.2, DB2 Recovery Expert V3.1, DB2 Buffer Pool Analyzer & SPUFI
z/OS 2.5, TSO, ISPF, JCL & TWS
SAP NetWeaver 7.50, SAP Banking, SAP Bank Analyzer, SAP Business Warehouse, SAP Enterprise Resource Planning, SAP Insurance, SAP Process Integration, SAP Solution Manager & SAP HANA
Omegamon DB2 Performance Expert on z/OS V5.5, Omegamon XE on z/OS V4.1 & z/OS Resource Measurement Facility (RMF)
DB2 Performance Expert Client, IBM Data Studio V4.1.4 & RMF Spreadsheet Reporter Version 5.3
KNIME 4.2 Python 3.10 & Tableau 10.4

Allied Irish Banks - Dublin, Ireland

02/08 to 11/09 - DB2 Systems Programmer/Database Administrator - Contract

Contracted to AIB to provide DB2 systems programming and database administration services on the Acorn/iFlex, SmartDoc and Integrated Markup projects

Systems programming accomplishments included:

Configured and installed the IBM Tivoli Omegamon XE V4.1.0 performance monitoring product suite using ICAT. The following products were also installed, IBM Tivoli Decision Support for z/OS V1.8.0 and IBM Tivoli Composite Application Monitor for WebSphere V6.1.0
Configured and installed the DB2 ESE V9.1 for LUW and IBM Tivoli Enterprise Portal Server V6.2 on z/Linux
Configured and installed the DB2 ESE V9.1 for LUW and IBM Tivoli Enterprise Portal Server V6.2 on Windows XP Professional
Configured and installed an assortment of DB2 Tools for z/OS
Configured and installed EZ-DB2 V9.1 product suite aswell as applying maintenance in the legacy environments

Database administration assignments on these projects included:

Assigned as the primary contact point for DBA to the Integrated Markup project where my role was to facilitate the project in getting timely service from the DBA group
- Reviewed the database design prior to implementing in development, system test, user test and finally in production
- Responsible for carrying out performance analysis using EXPLAIN reports, EZ-DB2 traces and reports, SMF reports, Omegamon performance monitors and traces
- Collated data from the performance analysis to provide detailed tuning recommendations to the project for poor performing SQL
Assigned as the primary point of contact to the SmartDoc project for all mainframe and middleware infrastructure services, including DB2 DBA, DB2 systems, z/OS systems, Data Storage, MQ-Series and Websphere
- As the primary point of contact one of my primary objectives was to facilitate the project in identifying and co-ordinating the resources they would require and ensuring that lead times for requesting the resources were met. This was an highly complex project due to the fact that it utilised all the latest technology available on the ZPlex
- The primary objective of the project was to migrate the existing database from Oracle to DB2 9.1 for z/OS and to enhance and port the backend processing from the legacy system to the new ZPlex
- Implemented the SmartDoc database ported from Oracle to DB2 9.1 for z/OS into 3 development environments, system test, user test, pre-production and production environments
- Evaluated IBM Migration Toolkit V2.0.5 and IBM Data Movement Tool for DB2 9.7 to determine which tool would be most suitable for moving approximately 290GB of data, primarily BLOBs, from Oracle to DB2
- Installed, configured and implemented DB2 ESE V9.1 Federated database server on mainframe USS (Unix System Services) to enable the cross-loader functionality using the DB2 9.1 for z/OS LOAD utility in order to extract data directly from the Oracle database into DB2
Undertook a review of housekeeping procedures, particularly backup, recovery and REORG processing, with a view to streamlining and cost cutting while maintaining data integrity, security, recoverability, availability and optimal data organisation. Using the DB2 Automation Tool resulted in the following actions:
- Reduced the number of backups being taken as a result of pre-emptively analysing log record aging, historical statistics and RTS (Real Time Statistics) to determine whether data had actually changed and also whether no archive log records existed for the data and only then taking backups
- As a result of analysing historical statistics and RTS (Real Time Statistics) determined whether data was in optimal location and what the impact was. This resulted in less unneeded REORGs and more required REORGs with an overall reduction in processing time, costs, etc and increased availability and better data organisation
- These tasks were fully automated with scheduled batch analysis generating the required housekeeping jobs

Environment:

DB2 for z/OS 9.1, DB2 Utilities Suite for z/OS 9.1, DB2 Administration Tool 7.1, DB2 SQL Performance Analyzer, DB2 Automation Tool, DB2 Recovery Expert, DB2 Object Comparison Tool, DB2 Buffer Pool Analyzer, QMF 8.1 & SPUFI
z/OS 1.9, TSO, ISPF, JCL & OPC
EZ-DB2 V9.1, EZ-SQL Warehouse, EZ-Tracer, EZ-Cache, EZ-Alerts, EZ-Index Analyzer, EZ-Impact Analyzer, EZ-Index Optimizer & EZ-Stats
SUSE Linux Enterprise Server 10.1, DB2 ESE V9.1 for Linux, IBM Tivoli Enterprise Portal Server 6.2 for Linux, DB2 ESE V9.1 for Windows, IBM Tivoli Enterprise Portal Server 6.2 for Windows & DB2 ESE V9.1 Federated database server
Omegamon DE on z/OS V3.1.0, Omegamon XE for CICS on z/OS V4.1.0, Omegamon XE for DB2 Performance Expert on z/OS V4.1.0, Omegamon XE for IMS on z/OS V4.1.0, Omegamon XE for Mainframe Networks V4.1.0, Omegamon XE for Messaging on z/OS V6.0.1, Omegamon XE for Storage on z/OS V4.1.0, Omegamon XE on z/OS V4.1.0, IBM Tivoli Composite Application Monitor for WebSphere V6.1.0, IBM Tivoli Decision Support for z/OS V1.8.0 & IBM Tivoli Monitoring Services on z/OS V6.1.0

Lloyds TSB Bank - London, UK

08/06 to 01/08 - DB2 Database Administrator - Contract

Contracted to Lloyds TSB Bank to provide database administration services on the OCIS, Internet Banking, BIT & Bank Letters projects.

Duties on these projects included:

Automating REORG housekeeping using BMC DASD Manager for production databases
Implementing DPROPR changes as required by the business to support MIS on data warehouse
Day to day applications DBA support making database changes and implementing them in production
Responsible for application & database performance analysis and tuning using BMC AppTune, BMC MainView and BMC SQL Explorer
Implement REORG housekeeping for DPROPR production databases
Responsible for QA of all SQL being developed and going into production
Mentoring applications developers in the use of SQL and efficient program design

Environment:

DB2 UDB for z/OS V7.1, DPROPR V9.1, BMC Utilities 8.1, BMC AppTune 5.2, BMC MainView for DB2 7.2, BMC SQL Explorer 5.2, QMF 7.1 & SPUFI
z/OS 1.7, TSO, ISPF, JCL, OPC & InfoJCL
DB2 Estimator 8.0

Bank of Ireland (HP Ireland) - Dublin, Ireland

05/01 to 10/05 - DB2 Database/Systems Administrator - Contract

Contracted to Hewlett-Packard Ireland to provide database and systems administration services to Bank of Ireland

Duties on the BoI Euro, CRM & Alnova projects included:

Provide support services for the configuration and implementation of the Alnova Banking System
Upgrade CA Platinum Utilities to allow DB2 V6 exploitation
Install and configure DB2 Buffer Pool Tool
Tune DB2 Buffer Pools saving 80% I/O and an estimated €1,000,000/year
Provide full production support services for installation and upgrade of Chordiant CRM database
Provide full production support services for all DBA functions during the Euro conversion
Database administration, data modelling, logical design and physical implementation
Setup Online REORGs to support 24x7 application availability
Install and evaluate BMC SQL Explorer GUI
Install and evaluate DB2 Connect PE to access DB2 UDB for OS/390
Install and evaluate graphical tools to administer and monitor DB2 applications across all platforms
Provide technical support for configuring DB2 Connect EE on AIX
Application, database & system performance analysis and tuning

Environment:

DB2 UDB for z/OS V7.1, BMC Utilities 5.4, Platinum Utilities 5.1, Omegamon II 5.0, BMC SQL Explorer 3.1.3, QMF 7.1.0, SPUFI, MXG & SAS
z/OS 1.4, TSO, ISPF, JCL, OPC, JMR & SMR
DB2 UDB for NT 8.1, DB2 Connect EE for AIX 7.2, DB2 Visual Explain 7.0, DB2 Estimator 7.0 & PowerDesigner 9.5

Northern Territory Government - Darwin, Australia

10/00 to 05/01 - DB2 Database Administrator - Contract

Contracted to Northern Territory Government to provide database and systems administration services to DCIS Department of Corporate Information Services

Duties on the DCIS project included:

Performance analysis and tuning DB2 Stored Procedures
Write DB2 Stored Procedures Standards Manual
Setup WLM Application Environments for DB2 Stored Procedures
Install and configure 390 Enablement to support DB2 UDB clients
Install and evaluate graphical tools to administer DB2 across disparate platforms
Application, database & system performance analysis and tuning

Environment:

DB2 for OS/390 V5.1, Platinum Utilities 5.1, QMF 3.3.0 & SPUFI
OS/390 2.8.0, TSO, ISPF & JCL
DB2 UDB for NT 7.2, DB2 Connect PE for NT 7.2 & ERWin 3.5.2

IBM Global Services Australia - Brisbane, Australia

12/97 to 08/00 - DB2 Database Administrator - Contract

Contracted to IBM GSA to provide database administration and production support services to the START Street and Address Reference Tables and NPAMS Network Plant Assignment Management System projects. START is 1 of the 6 most mission critical applications within the Telstra organisation, with approximately 1.5 million CICS transactions/day and 25,000 registered users 8,000 concurrent. NPAMS is another mission critical application with approximately 1.3 million CICS transactions and 7000 concurrent users

Duties on the START project included:

Database administration, data modelling, logical design and physical implementation
Formulate and implement backup and recovery strategy for all production data and application code
System performance monitoring, analysis and tuning to optimise performance across 6 CICS regions
Maintaining the 3 development, 3 system test, 3 user acceptance test, maintenance, education, stress & volume, production and 12 system integration test environments
Production application support providing oncall support for severity 1 & 2 problems
Providing oncall support for the production batch window
Monitoring production systems, problem analysis and resolution Natural, DB2, CICS, Batch etc.
Working with MVS Platform Security to insure that proper security is maintained for DB2 data
Responsible for SQL QA function which includes SQL code reviews, training, recommending SQL coding standards and implementing SQL coding standards
Managing the Y2K Certification Testing project, including building 3 full testing environments

Duties on the NPAMS project included:

Maintaining the development, system test, system integration test, stress & volume and production environments

Environment:

DB2 for OS/390 V5.1, BMC Utilities 5.4, QMF 3.3.0, SPUFI, Omegamon II 4.0.0, Omegaview 1.3.0, CICS 4.1, NATURAL 2.3.2, ADABAS 6.1, Predict 3.4.1 & COBOL for OS/390
OS/390 2.8.0, Control-M 5.0.0 & FileAid 8.6.0

Period	Organisation	Position	Location
\| 04/97 - 10/97	\| Burlington Northern and Santa Fe Railway	\| Analyst Programmer - Contract	\| Fort Worth, Texas, USA	\|
\| 04/96 - 04/97	\| RJ Reynolds	\| Analyst Programmer - Contract	\| Winston-Salem, North Carolina, USA	\|
\| 12/92 - 04/96	\| Telstra	\| Senior Analyst Programmer - Contract	\| Brisbane, Queensland, Australia	\|
\| 03/92 - 10/92	\| Comalco Mineral Products	\| Analyst Programmer - Contract	\| Brisbane, Queensland, Australia	\|
\| 01/90 - 09/91	\| Comtex Group Limited	\| IT Consultant	\| Wellington, New Zealand	\|
\| 11/87 - 07/89	\| Bougainville Copper Limited	\| Analyst Programmer - Contract	\| Brisbane, Queensland, Australia	\|
\| 07/87 - 10/87	\| Travelling around the New Zealand	\|	\|	\|
\| 10/86 - 07/87	\| M/V Jodimaro	\| 1st Mate	\| Fort Lauderdale, Florida, USA	\|
\| 07/86 - 10/86	\| Travelling around the US	\|	\|	\|
\| 03/86 - 06/86	\| Halfords Plc.	\| Analyst Programmer - Contract	\| Redditch, United Kingdom	\|
\| 07/85 - 02/86	\| Standard Bank S.A. Pty Ltd	\| Programmer	\| Johannesburg, South Africa	\|
\| 01/84 - 06/85	\| Total S.A. Pty Ltd	\| Programmer - Analyst Programmer	\| Johannesburg, South Africa	\|
\| 01/83 - 12/83	\| Travelling around Ireland, Europe and the UK	\|	\|	\|
\| 01/80 - 12/82	\| Anglovaal Pty Ltd	\| Learner Mine Official	\| Stilfontein, South Africa	\|
\| 01/79 - 01/80	\| 1 Rhodesian Special Air Service Regiment	\| National Service	\| Kabrit Barracks, Salisbury, Rhodesia	\|

Date	Course	Institution
\| 06/22	\| Python for Beginners	\| openSAP	\|
\| 11/17	\| Introduction to SAP HANA Administration	\| openSAP	\|
\| 06/16	\| Tableau Fundamentals	\| CBA	\|
\| 11/15	\| IBM Certified Database Administrator - DB2 11 DBA for z/OS	\| IBM	\|
\| 06/15	\| Experimentation: Advanced Proficiency Level	\| CBA	\|
\| 03/15	\| Data Analytics: SOUND Proficiency Level	\| CBA	\|
\| 10/14	\| Design Thinking: AWARENESS proficiency level	\| CBA	\|
\| 09/14	\| IBM Certified Database Administrator - DB2 10 for z/OS	\| IBM	\|
\| 09/14	\| IBM Certified Database Associate - DB2 10.1 Fundamentals	\| IBM	\|
\| 05/13	\| ES Breakthrough Service Performance	\| CBA	\|
\| 05/13	\| The Four Productivity Habits	\| CBA	\|
\| 04/13	\| Productivity Essentials	\| CBA	\|
\| 05/03	\| Alnova Application Back-End Development	\| Alnova Technologies	\|
\| 04/03	\| MainView for DB2	\| BMC Software	\|
\| 04/03	\| Log Master for DB2	\| BMC Software	\|
\| 03/03	\| DASD Manager for DB2	\| BMC Software	\|
\| 03/03	\| Change Manager for DB2	\| BMC Software	\|
\| 03/03	\| Catalog Manager for DB2	\| BMC Software	\|
\| 06/02	\| UNIX System Administration	\| Thomson Learning	\|
\| 05/02	\| Introduction to UNIX	\| Thomson Learning	\|
\| 03/02	\| Fast Path to DB2 UDB for Experienced Relational DBAs	\| IBM	\|
\| 06/99	\| DB2 High Performance Design	\| RYC Inc - DB2 Symposium	\|
\| 06/99	\| Advanced & Complex SQL	\| RYC Inc - DB2 Symposium	\|
\| 06/99	\| Advanced DB2 Programming - Techniques for Performance	\| RYC Inc - DB2 Symposium	\|
\| 06/99	\| Advanced DB2 Programming - Triggers, Stored Procedures & UDFs	\| RYC Inc - DB2 Symposium	\|
\| 03/95	\| Navigator Practitioner Overview	\| Ernst & Young	\|
\| 03/91	\| Business Systems Analysis	\| Software Education	\|
\| 08/90	\| Netware Systems Manager CNE	\| Comtex	\|
\| 07/90	\| Structured Systems Analysis	\| Software Education	\|
\| 07/85	\| TSO/ISPF Introduction	\| Standard Bank	\|
\| 07/85	\| MVS/XA Introduction	\| Standard Bank	\|
\| 07/85	\| OS JCL Coding	\| Standard Bank	\|
\| 07/84	\| NATURAL Applications Workshop	\| SPL	\|
\| 07/84	\| ADABAS Concepts and Facilities	\| SPL	\|
\| 01/84	\| Structured Programming and Design	\| van Zyl and Pritchard	\|
\| 12/82	\| National Diploma 2nd year - Metalliferous Mining	\| Witwatersrand Technikon	\|
\| 12/78	\| AEB 'M' Levels	\| Guinea Fowl School	\|

Curriculum Vitae for Bruce Williamson

Introduction

Contact

Interests

Summary of Industry & Software Experience

Briefly

Industry

Software

Detailed Work History

Commonwealth Bank of Australia - Sydney, Australia

Duties:

Environment:

Allied Irish Banks - Dublin, Ireland

Systems programming accomplishments included:

Database administration assignments on these projects included:

Environment:

Lloyds TSB Bank - London, UK

Duties on these projects included:

Environment:

Bank of Ireland (HP Ireland) - Dublin, Ireland

Duties on the BoI Euro, CRM & Alnova projects included:

Environment:

Northern Territory Government - Darwin, Australia

Duties on the DCIS project included:

Environment:

IBM Global Services Australia - Brisbane, Australia

Duties on the START project included:

Duties on the NPAMS project included:

Environment:

Summary of Employment

Education