Summary
Overview
Work History
Education
Skills
Certification
Affiliations
Timeline
Generic

Bruce Matthews

Melbourne,Australia

Summary

Experienced and enthusiastic Consultant with track record of success across wide range of industries. Possesses exceptional interpersonal, problem-solving and analytical skills to provide advice and expertise to client organizations improving business performance. Experienced in all aspects of operations, strategy and finance.

Overview

41
41
years of professional experience
1
1
Certification

Work History

DB2 Systems Adminstrator/Consultant Technical Specialist

IBM Global Services Australia, IBMGSA
07.1997
  • Telstra (Outsourced to IBMGSA in, : IBM 9021/720, OS390, DB2 V6.1 & DB2 V7.1 , QMF, DB2PM, OMEGAMON, BMC, REXX, SAS, STROBE, IMS DB/DC, CICS, COBOL, NATURAL, REXX, RACF, ISPF, JES2, HTML, NetData
  • Responsibilities/Achievements: Telstra and later IBMGSA acquired the services of Bruce to provide DB2 Systems Programming support initially for the Telstra environment then across a number of IBMGSA accounts
  • Broadly speaking this role entailed the following:
  • Providing Senior DB2 Systems Administration support
  • This covers all facets of the environment such as installation, maintenance, tuning, recovery, security, problem resolution, housekeeping, vendor liaison and project management etc
  • Bruce’s skills were also employed to investigate and provide solutions regarding specific technical issues concerning the management and utilisation of DB2 and associated third party software
  • This included:
  • Acting as the principal DB2 technician in the implementation of DB2 Data Sharing for Telstra (two system software DB2 Data Sharing Groups, two stress test DB2 Data Sharing Groups & one 4-way production DB2 Data Sharing Group)
  • Acting as the principal DB2 technician liasing with the Storage Management Group in the implementation of SMS managed storage for the various DB2 environments within Telstra
  • Design, development and implementation of WEB based (NetData) DB2 Performance Monitoring and Integrity checking application for the Telstra Environment which is used to monitor the health of DB2 Subsystems (Architecture based on a combination of NetData macros, HTML, REXX, Cobol, SAS and Natural)
  • Installation, support and maintenance of the DB2 environment within Telstra, Victoria Police and Australian Gas & Light (AGL) accounts which includes third party software products such as BMC, OmegaMon for DB2, Strobe and Princeton Softech (Relational Tools)
  • Providing consultancy on DB2 configuration and tuning to other DBA teams
  • Undertaking investigations into new products and/or features making recommendations on the suitability for the existing and future DB2 applications
  • Conducting DB2 subsystem and application technical reviews to improve performance, resource utilisation and integrity
  • Investigate and resolve problems in all aspects of the environment relating to DB2 and associated software
  • Performing DB2 software generation and associated DB2 and third party product customisation where required
  • The formulation and performance of acceptance testing of new DB2 and associated third party product software
  • Providing after hours on call support
  • Develop and implement in-house tools/scripts – COBOL, REXX and Adabas Natural scripts etc.

Senior DB2 Database Administrator/Technical Lead

STRUCTURED ANALYSIS & DESIGN, DHA
11.2013 - 05.2023
  • Environment : IBM z/OS 2.5, DB2 V12 (RSU2212 – FL509), CDC for Db2, QMF, CA DB2 Performance and Administration Suite, Omegamon, CA CoolGen, CICS, COBOL, ISPF, JES2, ORACLE, DB2 UDB UNIX etc
  • Responsibilities/Achievements: The following is a summary of the role Bruce is currently performing for his client:
  • Reporting to the DHA Director of Cargo and Border Systems, the requirement was to provide technical Db2 leadership to the Database Services Group
  • The role was critical to the development and maintenance of technical solutions within the Mainframe and to ensure that the solutions provided were fit for purpose
  • Responsibilities included:
  • To act as the lead DBA for the team that provides mainframe DB2 z/OS database services to DHA
  • Provide technical advice on new technology in relation to the DB2 environment, Eg, Db2 AI
  • Performance Monitor and Tuning of the production DB2 environment – Application Databases, SQL and all components of the DB2 Subsystems
  • Accountable for overseeing the stability and high availability for the Departments Db2 for zOS databases
  • Accountable for Db2 for zOS services including technical validation of implementations and proposed database changes
  • Accountable for leading and advising on Db2 for zOS toolsets including technical validation of implementations and proposed configurations
  • Accountable for leading and supporting evaluation of technical changes, and assessment of root-cause-analyses and corrective actions
  • In close collaboration with DHA partners (the maintenance of Db2 System Software and Db2 Production housekeeping is outsourced to Kyndry – ex IBM GS)
  • Provide expert domain technical input to the ongoing planning and implementation of Db2 for zOS software maintenance and version upgrades
  • That process is driven by the Database Services Team within DHA
  • Keeping focus on Db2 for zOS operational priorities, engage with colleagues to jointly review service requests, assesses, and evaluates complex incidents and problems and lead the diagnosis and resolution of complex technical issues on day-to-day basis
  • Develop and implement in-house tools/scripts – COBOL, REXX and SAS scripts etc
  • Provides DBA support for client applications, that includes but is not limited to:
  • Advice, consultancy, troubleshooting and recommendations on technical and support issues
  • Helpdesk
  • Capacity planning
  • Performance tuning
  • Critical event monitoring
  • Database backups, recoveries and refreshes in the non-production environments
  • Document, test and implement database schema changes
  • Skill requirements included:
  • DB2 z/OS V12 Database and Systems Administration particularly in relation to performance monitoring and tuning at the application and DB2 subsystem level
  • Knowledge of IBM and CA database tools and solutions
  • Thorough knowledge in designing, implementing and maintaining enterprise databases and database solutions
  • A high standard of verbal and written communication skills
  • Team and Customer Focus
  • Managing Change and Risk
  • Skills transfer to permanent staff
  • Bruce’s skills were also employed to investigate and provide solutions regarding specific technical issues concerning the management and utilisation of DB2 and associated third party software wihin the Department
  • That included:
  • Liasing with external partners with regard to the ongoing Mainframe Modernisation process
  • Working closely with the DHA and Kyndryl Capacity Planning Teams to ensure that optimal use of the mainframes software and hardware resources.

Senior DB2 Database Administrator

Insurance Australia Group
03.2011 - 08.2012
  • IBM z9, Z/OS V8, DB2 V9, QMF, CA DB2 Performance and Administration Suite, IMS DB/DC, CICS, COBOL, REXX, ISPF, JES2, ORACLE, DB2 UDB UNIX etc
  • Responsibilities/Achievements: The following is a summary of the role Bruce is currently performing for his client:
  • Reporting to the Mainframe Database Team Leader, the contract role is to provide DB2 z/OS DBA services
  • Melbourne location
  • Responsibilities include:
  • To work in a team to provide mainframe DB2 z/OS database services
  • Provide Operational database support
  • Work on a large Transformation Project business project
  • Work on the DB2 z/OS V9 upgrade project
  • Skill requirements include:
  • DB2 z/OS V8 and V9 Database Administration
  • DB2 z/OS V8 and V9 System Administration
  • DB2 z/OS Upgrades, V8 to V9 preferred; CA DB2 tool upgrades
  • Knowledge of IBM and CA database tools, technologies and solutions
  • Thorough knowledge in designing, implementing and maintaining enterprise databases and database solutions
  • A high standard of verbal and written communication skills
  • Team and Customer Focus
  • Managing Change and Risk
  • Bruce’s skills are being employed to investigate and provide solutions regarding specific technical issues concerning the management and utilisation of DB2 and associated third party software
  • This includes:
  • Assisting in the DB2 V8 – V9 upgrade
  • Upgrading and maintaining 3rd party DB2 products
  • Ie
  • The CA tool set
  • Design, development and implementation of DB2 Real Time Statistics
  • General trouble shooting and support tasks as required
  • Develop and implement in-house tools/scripts – COBOL and REXX scripts etc.

Senior DB2 Systems Administrator/Database Administrator and Oracle

National Australia Bank
04.2003 - 04.2009
  • IBM z9, Z/OS V1.8, DB2 V8.1 , QMF, DB2 PERFORMANCE EXPERT, INSIGHT & MAINVIEW/DB2, BMC, REXX, SAS, STROBE, IMS DB/DC, CICS, COBOL, ISPF, JES2, ORACLE 9i/10g/RAC, UNIX, LINUX, AIX & WINDOWS and ObjectStar
  • Responsibilities/Achievements: Bruce joined the National Australia Bank post the Y2K downturn as a senior DB2 Systems Programmer and Database Administrator
  • His duties include support and maintenance of the Banks DB2, and ObjectStar environments for Australia and New Zealand which consisted of 15 DB2 subsystems across the system test, application development, stress test and production environments
  • DB2 Data Sharing is used extensively at the Bank
  • Bruce also performed similar duties in the Oracle Database space on various midrange platforms
  • More specifically, the role encompassed the following:
  • Providing Senior DB2 Systems Administration support
  • This covers all facets of the environment such as installation, maintenance, tuning, recovery, security, problem resolution, housekeeping, vendor liaison and project management etc
  • For example, Bruce project managed and performed the majority of work required to upgrade from DB2 V7 to V8 across all environments.
  • Providing Senior DBA Support for DB2, ObjectStar and Oracle Applications
  • Providing technical support and consulting to junior DBAs and application teams
  • Consulting on Physical Database Design and implementation
  • Support of Production Databases as required
  • Performance Monitoring, Tuning and maintenance of critical application databases
  • Installation, support and maintenance of the DB2 and ObjectStar environments within the National Bank which included third party software products such as BMC’s Catalog Manager and various BMC and CA products
  • Configuration and Tuning of DB2 and ObjectStar Subsystems
  • Undertaking investigations into new products and/or features making recommendations on the suitability for existing and future DB2 applications
  • Conducting DB2 subsystem and application technical reviews to improve performance, resource utilisation and integrity
  • Investigation and resolution of technical problems at the database and subsystem level and liasing with vendor support teams
  • Installation, support and maintenance of Oracle 9i & 10g database software on various operating systems such as Unix, Linux, AIX and Windows
  • Providing after hours on call support
  • Develop and implement in-house tools/scripts – COBOL and REXX scripts etc.

IBMGSA & Telstra
04.1994 - 10.2002

DB2 Database Administrator

Telstra Australia
11.1991 - 04.1994
  • IBM 9021/720, MVS/ESA, DB2 2.3, QMF, DB2PM, iMS/DB, OMEGAMON, BMC, SAS, STROBE, CICS, COBOL, NATURAL, RACF, ISPF/PDF, JES2
  • Responsibilities/Achievements: Telecom Australia acquired the services of Bruce to act as a DB2 Consultant to both the Application Teams and Database Administrators within the Network Product Management Group
  • The Network Product Management Group is principally responsible for developing and implementing the support systems for various products developed and marketed by Telecom
  • For instance, products such as National numbers (013), Mobile Phones (018), Customised Networks and TELECARDS are developed and supported by the Network Product Management Group
  • Applications worked on thus far range from a billing system (batch) which processes 32 million records per month (projected to grow to 55 million per month by June 1994) to CICS/DB2 and TSO/DB2 online systems
  • All the applications worked on have been developed using the Natural 4th generation language supplied by Software AG
  • Bruce's time thus far has centred on the following tasks :
  • Design and implementation of a performance monitoring and tuning strategy for CICS/DB2 Natural Applications
  • The strategy utilized the following products :
  • SAS
  • DB2PM
  • Omegamon for DB2 This task required Bruce to liase with Technical Support Groups within Telecom (to provide the necessary exit routines) as well as write a number of SAS programs to produce various reports to assist in the tuning of Natural/DB2 CICS Applications
  • Defining a Performance Monitoring and Tuning Strategy for use by DB2 Database Administrators within the Network Product Management Group
  • Performance Monitoring and Tuning of critical application databases
  • Providing recommendations on how to improve the efficiency of existing applications in order to meet service level agreements (response time and CPU cost etc)
  • This covered :
  • Recommendations on the use of common Database Access Routines
  • Recommendations on efficient SQL coding practices
  • SQL code reviews
  • Efficient Database Design Techniques
  • Assisting in the creation of logical data models
  • Providing Senior DBA Support for CICS/DB2 Natural Applications
  • Providing technical support and consulting to Telecom DBAs and application teams
  • Physical Database Design and implementation
  • Support of Production Databases as required
  • Providing training/education to junior DBA's
  • Develop and implement in-house tools/scripts – COBOL, REXX and Adabas Natural scripts etc.

DB2 Database Administrator

National Mutual Australia
06.1990 - 06.1991
  • IBM 9021/720 3090/600J, MVS/ESA, DB2 2.2, QMF, DB2PM, OMEGAMON, PLATINUM, CICS, COBOL, DELTA, ACF2, IMS/DB/DC, ISPF/PDF, JES3, STROBE
  • Responsibilities/Achievements: In June 1990, Bruce was offered the opportunity of a contract with National Mutual
  • Bruce was employed within the corporate DB2 Database Administration group and participated in the following projects
  • Production Support/Concepts Evolution
  • During Bruce's time at National Mutual, the DB2 Administration group assumed responsibility for the support of all the companies major production DB2 Databases
  • Bruce was heavily involved in the formulation of National Mutual's production support objectives
  • Those objectives covered :
  • DB2 DASD space management
  • Management of DB2 Database integrity
  • Monitoring of Production DB2 Databases
  • Plan Behaviour Management
  • DB2 Production Database housekeeping : DB2 Performance Monitor and Tuning - Strategy Definition
  • Bruce was given the task of defining a DB2 Production Performance Monitoring and Tuning Strategy for use by the DB2 Administration group
  • He had sole responsibility for this important project
  • The major objectives of the project were to :
  • Define the scope of DB2 Performance Monitoring
  • Establish the DB2 Performance Monitoring
  • Measurement Criteria
  • Information Requirements
  • Functional Requirements
  • Technical Requirements which must be met in order to effectively monitor DB2 applications
  • Evaluate and select suitable Performance Monitoring tools
  • Design, specify, and implement Monitoring and Reporting procedures
  • This task was completed within the allotted time frame
  • DB2 Production Backup and Recovery - Strategy Definition
  • The task of defining a DB2 Production Database Backup and Recovery Strategy for use by the DB2 Administration group was assigned solely to Bruce
  • The objectives of the project were to :
  • Define the scope of DB2 Production Database Backup and Recovery Strategy
  • Establish application backup and recovery Service Level requirements
  • Establish the business, technical and functional requirements to be met in order to ensure the integrity and recoverability of the companies production DB2 Databases
  • Define and recommend appropriate strategies for meeting the previous three objectives
  • This task was completed just prior to Bruce's departure from National Mutual.: 3rd Party Product Implementation
  • Prior to Bruce joining National Mutual, the company purchased a number of 3rd party productivity tools for use with DB2
  • One of those tools, Platinum Technologies Database Analyzer (PDA) was assigned to Bruce to implement
  • The role PDA was to play in the development, testing and production environments was :
  • The partial automation of various house keeping functions (Database utility job generation and submission etc)
  • The automation of Database Statistics collection and physical integrity checking
  • The generation of various Database reports on space utilisation and fragmentation etc
  • The major objective for Bruce was to produce a comprehensive set of standards and procedures on the use of PDA by application teams, Database Administrators and production support personal within National Mutual
  • Extensive customization of the product was required to meet National Mutual's objectives
  • The customization was performed by Bruce
  • The customization performed, and the standards and procedures produced by Bruce were adopted by DB2 Administration at National Mutual (some of the recommendations and standards produced were included into Platinum Technologies PDA education course in the United States)
  • 5 : DB2 Technical Support/Consultancy to Application Teams and Technical Support Groups
  • Technical support and consultancy was provided by Bruce on DB2 issues to application teams and the capacity planning group
  • This covered the following areas :
  • Physical and logical Database Design
  • Performance Tuning
  • Application design and SQL coding considerations
  • Providing Technical advice to the capacity planning group when developing resource usage and response time projection models for future DB2 Applications: DB2 Performance Monitor - Pre-Release Acceptance Test for IBM Australia
  • National Mutual was asked by IBM Australia to participate in a pre-release field test of the latest version of their DB2 Performance Monitoring Tool, DB2PM version 2.1
  • Bruce represented DB2 Administration in this project
  • The objectives of the project were to :
  • Establish the products serviceability and stability in a customer environment
  • Establish its strengths and weaknesses in respect to existing or proposed Performance Monitoring and Tuning strategies used by National Mutual
  • Evaluate the functionality of the product
  • From National Mutual's standpoint, the project provided the opportunity to have direct input the products development
  • The duration of the project was approximately two months and was deemed to be highly successful by both National Mutual and IBM Australia
  • DB2 Design Guidelines
  • Bruce was assigned the responsibility of establishing various guidelines concerning the use of DB2 at National Mutual
  • This included the following :
  • DB2 Tablespace use and design guidelines
  • The use of multi-volume Tablespaces with DB2
  • Tokenised Keys
  • The recommendations and guidelines produced (except tokenised keys which was re-prioritized) were accepted by National Mutual and incorporated into their standards
  • Production Support
  • From time to time, Bruce provided secondary production support when requested by National Mutual.

DB2 Systems Administrator, Senior DB2 Database Administrator, Police

Victoria Police
09.1989 - 06.1990
  • IBM 3090/180E, MVS ESA, DB2 2.1/2.2, QMF, CICS, DBRAD, DB2PM, CSP, TSO, ISPF/PDF, RACF, COBOL, JES2, ADABAS/NATURAL
  • Responsibilities/Achievements: Bruce joined Victoria Police in September 1989 as a senior Database Administrator
  • His duty was to help establish the DB2 environment within Victoria Police
  • This lead to the formation of a project team within the Database Administration group consisting of three
  • Bruce as the team leader, a DB2 consultant providing high level recommendations and assisting with education, and a trainee DBA
  • The objectives of the project were to :
  • Define and implement DB2 naming standards for DB2 Objects
  • Define and implement a DB2 subsystem and application security strategy
  • Define and implement DB2 subsystem and application database backup, recovery and integrity checking strategies
  • Define and implement a DB2 subsystem and application performance monitoring and tuning strategy
  • Define and implement DB2 operations standards and procedures
  • The DB2 environment was established concurrently with the customization and implementation of a major law enforcement package whose architecture was based on DB2, CICS and CSP
  • The package was to be implemented and customised by Aspect Computing (on behalf of IBM) and trialed by Victoria Police
  • Bruce was assigned the role of DB2 DBA for the project
  • The requirements of Victoria Police meant that the package underwent substantially modification (programs and database) prior to implementation
  • The application was implemented on schedule in early November 1989 and proved to be successful
  • Just prior to implementation, the DB2 consultant resigned to return to Asia and was not replaced
  • In the six months subsequent to the implementation, Bruce spent much of his time tuning the DB2 subsystem and application
  • This was done in conjunction with a senior IBM SE who provided input to the process
  • That support from IBM ceased in early May 1990, however, Bruce continued the important task of Performance Monitoring and Tuning until his departure
  • During his time at Victoria, , Bruce provided the necessary DB2 information required by the Systems Programming group to install and test DB2 version 2.2 and DB2PM version 2.0
  • In summary, Bruce was directly accountable for :
  • Physical Database design and implementation
  • DB2 standards and administration procedures
  • DB2 DASD Capacity Planning
  • Monitoring and controlling the DB2 subsystems
  • All aspects of DB2 Backup and Recovery
  • Performance Monitoring and Tuning
  • Technical support to application teams
  • Develop and implement in-house tools/scripts – COBOL and Adabas Natural scripts etc.

Database Administrator

Composite Buyers Ltd
07.1988 - 09.1989
  • NAS 8083, MVS/SP, IMS/DB, CICS, TSO, ISPF/PDF, DMS, JES2, MANTIS, OMCS, TLMS, : Composite Buyers employed Bruce as an IMS Database Administrator
  • He reported to the Technical Services Manager who in turn reported to the MIS Manager
  • The Database Administration group consisted of Bruce and a trainee DBA, working under Bruce's direction
  • Principal duties for which Bruce was responsible, included :
  • Logical and Physical Database Design
  • Performance Monitoring and Tuning
  • Creation of Standards and Procedures
  • Technical support to application teams
  • Maintenance of database security, backup and recovery procedures
  • Database recovery when required
  • Assessment of new DB software
  • Key tasks included :
  • Performance tuning and monitoring of production databases
  • Advising on Case Tools and Distributed Database Technology
  • Establishing secure database backup and recovery operations and procedures
  • Evaluating 3rd party software
  • Evaluation and selection of a CASE tool
  • Creation of a data model of the current system

Technical Services Manager/Database Administrator

David Syme & Co
02.1986 - 07.1988
  • Fujitsu 760/4, 180 2AD, MSP, TSS, PFD, AIM/DB/DC/RDB, ACS, AIDS/X, RACF, ITERACT, DEFINE/FDF, PDL/PDA, COBOL, SQL, MANASYS, CLIST, IPF, CICS, TRAPTRAN, TRAPIO, EXCELERATOR
  • Responsibilities/Achievements: Initially, Bruce was employed as the Database Administrator, reporting directly to the EDP Manager
  • After twelve months service, Bruce was promoted to the position of Technical Services Manager, reporting to the EDP Manager
  • In this position, Bruce managed three staff, two systems programmers and one junior DBA
  • Comprehensive position descriptions can be furnished on request
  • Applications worked on fall into the following categories :
  • Accounts Receivable
  • Advertisement Bookings
  • Distribution and Scheduling
  • Fixed Assets
  • Magazine Subscriptions
  • Other projects worked on or tasks which Bruce was directly responsible for include :
  • Administration of all Database environments
  • Administration of the AIM/DC and ACS online environments
  • Creation of the MANASYS Development Environment
  • Mainframe hardware and software evaluation study
  • AIM Version 10 to 11 conversion
  • MSP E20 System Generation
  • Introduction of RDBMS (AIM RDB) to the installation
  • Installation
  • Standards and Procedures
  • Physical Database Design
  • Evaluation of various software products including CASE tools, new system software or versions of existing software

Data Analyst

National Australia Bank
04.1985 - 02.1986
  • IBM 3090, 308x, MVS/XA, ISPF, PDF, TSO
  • Responsibilities/Achievements: Bruce was employed within the Data Administration section which was in the process of establishing themselves within the Bank
  • The section consisted of three groups, Database Administration, Data Dictionary Administration and Data Modelling
  • Several key strategic projects were in their initial stages of development
  • These were :
  • A Corporate Data Modelling exercise
  • Development of a Corporate Data Dictionary
  • Installation and Testing of DB2
  • Bruce was assigned to the team developing the Corporate Data Dictionary
  • Initially, IBM's Data Dictionary was in use
  • Subsequent evaluations resulted in DATAMANAGER being chosen as the Banks Corporate Data Dictionary
  • Bruce was partially or directly responsible for :
  • Design and development of a DMS front-end to allow generation of IMS and DB2 definition blocks and copy books from DATAMANAGER
  • Conversion from the IMS Dictionary to DATAMANAGER
  • Quality assurance of Corporate Data
  • Data Dictionary Standards and Procedures
  • Data Dictionary education for end users
  • Copy management between the various environments (development, test and production etc)

Database Administrator, Assistant Database Administrator Programmer

Directories Australia Pty Ltd
03.1983 - 03.1985
  • Environment : PRIME 750/850, PRIMOS, COBOL, SCREENS, DBMS, FORMS, MIDAS, DELTA, SIR/DBMS, CPL
  • Responsibilities/Achievements: During his time with Directories Australia, Bruce acquired significant skills in the areas of application design, development, Database Administration and Data Dictionary development and use
  • Although initially employed as a programmer working under the guidance of a DBA, Bruce enjoyed two promotions in quick succession to the position of Database Administrator
  • Bruce's responsibilities at Directories Australia included :
  • Logical and Physical Database Design
  • Performance Monitoring and Tuning
  • Database Administration standards and procedures
  • Creation, Maintenance and restructuring of Development, Test and Production Databases and their environments
  • Providing technical support to application teams
  • Bruce participated in the following major projects.: Directory Reference System
  • This system automated the index maintenance and creation functions of all the Telecom Yellow Pages throughout Australia
  • Information contained within the Database represented the first phase of a Corporate Database
  • The system was implemented over a nine month period and proved to be extremely cost effective.: Corporate Sales and Production System
  • This system provided significant enhancements to the 'Directory Reference System'
  • The broad requirements were to record client/advertising information to allow the automation of Advertising, Booking and Billing
  • This in turn was to provide marketing, sales and advertising statistics to the relevant departments
  • In-house Tools Development
  • Bruce was the major player in the development of various MIS tools such as a Data Dictionary and a Project Control System.: Installation and Customization of a 3rd party 4GL
  • Directories Australia purchased a 4GL package called DELTA
  • Bruce assisted in its installation and developed :
  • The front-end interface used by programmers to generate Database batch and online programs
  • Macros for generating batch and online program structures
  • Macros for standard DB/DC access routines
  • Macro naming standards and generation procedures

Programmer/Analyst

Australian Wool Corporation
11.1982 - 03.1983
  • Environment : PRIME 750/850, PRIMOS, COBOL, SCREENS, DBMS, FORMS, MIDAS, CPL
  • Responsibilities/Achievements: During his last months at Chisholm Institute, Bruce was engaged by the Australian Wool Corporation to help develop an online Project Control System
  • The major requirements for this project were
  • To support all stages of the systems development life cycle as per Yourdon's 'Structured Analysis & Design' methodology
  • To provide a reporting subsystem which allowed users to track work performed against estimated time at the Project, Sub-Project, Phase and Activity level
  • To provide an online facility to enable amendments to projected time and resource estimates
  • To provide an online facility for the entry of time sheets by users of the system
  • Bruce developed the system himself using COBOL, SCREENS and PRIME's Codasyl DBMS
  • It was implemented on schedule and was accepted by the users it was developed for
  • Bruce's other responsibilities included :
  • Establishing user requirements
  • Analysis and Design (including Logical and Physical Database Design)
  • Programming and Testing
  • Creation and maintenance of Test and Production environments
  • System Documentation (Technical and User Manuals) .

Education

Graduate Diploma - Electronic Data Processing

Chisholm Institute
83

Bachelor of Arts -

La Trobe University
80

HSC -

Warrnambool High School
1975

Skills

  • Bruce Matthews
  • Senior IBM Database Administrator & Systems Programmer
  • 2023
  • CONTENTS
  • ADABAS DBA Skills
  • DASD Performance Management
  • Strobe (Various)
  • RACF Concepts and Implementation
  • M-Series VSAM and Access Method Services
  • Introduction to ACS Cobol Programming (Fujitsu TP Monitor)
  • Introduction to AIDS/X (Fujitsu Screen Painting Editor)
  • Introduction to ACS
  • Manasys Overview (Fujitsu 4 GL)
  • Manasys Programming
  • ACS Cobol Programming
  • ACS Implementation and Administration
  • Oracle/Unix
  • Sun Unix Essentials
  • Oracle 9i – Introduction to SQL
  • Oracle Database 10g Administration Workshops I & II
  • Oracle 10g RAC
  • Oracle 10g SQL Performance Tuning
  • Oracle 10g Database Performance Tuning
  • Management
  • David Syme & Co Management Development Program (Seven day course covering general management, presentation, and strategic planning skills)
  • Skill Summary
  • Hardware
  • IBM z Series, 902x, 3090, 308x, NAS 8083
  • SUN, DELL and IBM Servers
  • FUJITSU 180 2AD, 760/4
  • PRIME 750, 850
  • Operating Systems
  • Z/OS 25
  • UNIX
  • LINUX
  • WINDOWS
  • AIX
  • MSP
  • PRIMOS
  • Database Software/3rd Party Packages
  • DB2 (V21 – V12)
  • IMS/DB
  • Oracle
  • ObjectStar
  • BMC (most products associated with DB2)
  • CA/PLATINUM
  • OMEGAMON
  • MAINVIEW/DB2
  • INSIGHT/DB2
  • AIM/DB
  • AIM/RDB
  • SIR/DBMS
  • PRIME/DBMS
  • TP Monitors
  • CICS
  • AIM/DC
  • ACS
  • Performance Monitoring Tools
  • DB2PM/PERFORMACE EXPERT
  • SAS
  • BMC DB2 POOL ADVISOR
  • OMEGAMON for DB2
  • STROBE
  • ASTEX

Certification

IMS/DB Concepts and Facilities IMS/DB Database Design IMS/DB Advanced Database Design IMS Fast Path Implementation DL/1 Programming Introduction to AIM/DB Introduction to AIM ADL and Programming AIM Cobol Programming Introduction to AIM/DC (Fujitsu TP Monitor similar to IMS/DC) AIM/DC Definition Language and Administration AIM Database Structures (Fujitsu's CODASYL Database) AIM Database Definition Language (ADL) AIM Database Maintenance Facilities (DMF) AIM Database Administration (Design, Maintenance, and Tuning etc), DBMS Design DBMS Support Specialist SIR/DBMS Introduction SIR/DBMS Advanced Concepts Other Introduction to SCO Xenix Data Resource Management Workshop NIAM Workshop (SQL International) Strategic Requirements Planning (Consulit) Information Engineering Planning (Arthur Young), PDL/PDA TRAPTRAN TRAPIO Other Software CDC – Change Data Capture for Db2 QMF RACF ADABAS NATURAL TSO / ISPF / PDF / DMS IMS Data Dictionary DATAMANAGER JES2/JES3 TSS PFD AF-JES AIDS/X DEFINE/FDF IPF MIDAS Programming Languages ADABAS NATURAL ASSEMBLER COBOL HTML NETDATA SQL SAS CLIST CPL PLI REXX RPG2 4 GLS DELTA MANASYS EASYTRIEVE Case Tools IEW EXCELERATOR Methodologies NIAM (Object Orientated Design)

Affiliations

Independent Contractors Association of Australia Marital Status: Married with three children. Courses and Personal Development IBM/Fujitsu DB2 Transition Courses (various) DB2 Database Administration Workshop DB2 Systems Administration and Programming Workshop DB2 Performance and Tuning DB2 Performance Management (Codd & Date)

Timeline

Senior DB2 Database Administrator/Technical Lead

STRUCTURED ANALYSIS & DESIGN, DHA
11.2013 - 05.2023

Senior DB2 Database Administrator

Insurance Australia Group
03.2011 - 08.2012

Senior DB2 Systems Administrator/Database Administrator and Oracle

National Australia Bank
04.2003 - 04.2009

DB2 Systems Adminstrator/Consultant Technical Specialist

IBM Global Services Australia, IBMGSA
07.1997

IBMGSA & Telstra
04.1994 - 10.2002

DB2 Database Administrator

Telstra Australia
11.1991 - 04.1994

DB2 Database Administrator

National Mutual Australia
06.1990 - 06.1991

DB2 Systems Administrator, Senior DB2 Database Administrator, Police

Victoria Police
09.1989 - 06.1990

Database Administrator

Composite Buyers Ltd
07.1988 - 09.1989

Technical Services Manager/Database Administrator

David Syme & Co
02.1986 - 07.1988

Data Analyst

National Australia Bank
04.1985 - 02.1986

Database Administrator, Assistant Database Administrator Programmer

Directories Australia Pty Ltd
03.1983 - 03.1985

Programmer/Analyst

Australian Wool Corporation
11.1982 - 03.1983

Graduate Diploma - Electronic Data Processing

Chisholm Institute

Bachelor of Arts -

La Trobe University

HSC -

Warrnambool High School

Similar Profiles

CREATE PROFILE
Bruce Matthews