Responsive Systems Company

Joel Goldstein - Resume

 


JOEL GOLDSTEIN
Principal Consultant

Industry Experience

Financial and Brokerage, Public Utilities, Insurance, Manufacturing, Transportation, Universities, Hospital and Nursing Facilities, Retail Sales, State and Federal Governments

Areas of Specialization

Mr. Goldstein is an internationally acknowledged DB2 performance expert. He has more than three decadess of information systems experience, with areas of specialization including organizational planning, technical staffing requirements, DBMS evaluation and selection, database design, standards for on-line systems development, service analysis and design procedures, systems design, project management, performance analysis and tuning of on-line systems, capacity planning and modeling studies, benchmarking, and hardware and software evaluation and selection. He has more than twenty-five years of experience with on-line database management systems, more than fifteen with distributed environments and applications, and ten with DB2. Mr. Goldstein has been a speaker and seminar leader at many large international user group conferences.

Professional Experience

As a consultant to a wide variety of national and international clients, Mr. Goldstein has provided database, application, and performance expertise to many large application development projects. This included the modeling of planned IMS/CICS and DB2 applications using BEST/1, CRYSTAL/IMS, and CRYSTAL/DB2 both for estimation of application performance and for processor sizing/selection. At one client site, he was responsible for the tuning of seven online IMS systems and six DB2 systems, operating in a multi-processor shared DASD environment. Additionally, he was responsible for the performance evaluations and benchmarking comparisons of different versions of database management software, and the comparison of products from different vendors. Mr. Goldstein has performed application modeling and performance tuning of several large DB2 applications and systems running on four processors using TSO, IMS, and CICS attach facilities. He has been responsible for the installation, testing, verification, and selection of DB2 performance tools for several clients, and has reviewed the overall design and specifications for several distributed client server applications. He provides ongoing Dynamic SQL Cache, DB2, database, IBM, z390, zSeries, DB2 performance, tuning, and design assistance for many worldwide clients, conducts design reviews, and has participated in additional client design reviews with IBMs Dallas Systems Center staff. He is currently working with clients to Implement, Size, and Tune the Systems and Coupling Facilities for Data Sharing environments.

As a consultant to national and international clients, he advises management of the benefits and performance expectations that can be derived from properly designed database, data-sharing, and client/server systems, and evaluates the impact of the planned systems on the existing environment. He has developed and guided the implementation of standards and procedures necessary to ensure the successful development of database systems at several client sites. He also guides the efforts of application development teams using service analysis and design review techniques to create systems, applications, and databases that are efficient and meet the business requirements of the corporation.

As Director of Information Systems for an international communications corporation, Mr. Goldstein coordinated the efforts of the application development teams creating new systems to operate within a CICS/IDMS environment. He recruited two managers and eight technical staff to bring the development teams to full strength, and reorganized the development area along functional lines of business. He guided the plans for the relocation of the data center to another state, and the simultaneous upgrading of the operating systems. He was administratively responsible for more than two hundred employees and a budget of ten million dollars.

While serving as manager of DB/DC systems at a major life insurance company he created and implemented the Systems Development Methodology that included naming conventions, programming standards, and service analysis and design review procedures. He created the standards and procedures for the Database Administration function, and recruited and trained a staff consisting of four managers and fifteen IMS specialists. He was directly responsible for the areas installing and tuning all DB/DC software including IMS/VS-MSC, VTAM, ACF/VTAM, NCP, and RACF; the selection and installation of TP hardware; the Database Administration function; and Security and Contingency Planning. He directed the efforts of four managers, twenty five technicians, and ten consultants in the course of planning and administering a budget of more than three million dollars.

As a senior consultant at a "big eight" CPA firm, Mr. Goldstein performed feasibility studies and performance analyses of IMS DB/DC systems for many clients on a worldwide basis. He designed and coded major portions of a data and resource security system marketed by the firm; he also created the documentation, installed the software at several client sites, and assisted the clients with the implementation of the software and the development of their installation standards.

At a communications utility, he had overall responsibility as IMS project manager for the maintenance and tuning of an IMS DB/DC system that supported more than six hundred terminals (in the mid 1970's), and processed eleven thousand transactions per hour on a 370/158. Through the usage of IBM software and other monitoring tools, his system and application tuning efforts reduced the average CPU utilization by eighteen percent. He designed and implemented operational procedures for emergency restart, database recovery, and daily maintenance of the IMS system and its databases. Through changes in software and procedures, he reduced the time required for the recovery of ALL the databases by eighty percent.

As the Database Administrator and senior systems analyst at a power utility, he was responsible for the evaluation effort that selected IMS, and then for the installation, testing, and maintenance of the software. As Database Administrator, he designed databases and developed the standards to be used by all applications. While a member of an MIS project team, he analyzed and developed the functional specifications for the purchasing and accounts payable systems, as part of the overall requirements for an Integrated Materials Management System.

Technical Summary

IBM, AMDAHL, HDS, MVS/XA/ESA, DOS, Windows, OS/2, IMS DB/DC (all releases from 360 ver 1.1 through IMS/VS 4.1, XRF), DB2 v1.1 thru v5.0, BEST/1, CRYSTAL/IMS/DB2, CAPTURE/MVS, MAP, CAPPER, SMF, RMF, GTF, IMF, IMSPARS, DBTOOLS, ASAP, BPA4DB2, BTS, STROBE, TPNS, SURF, ANDB2, DB2AM, DB2PM, INSIGHT/DB2, OMEGAMON/MVS/IMS/DB2, ACCUMAX, TMON/DB2, COBOL, FORTRAN, TSO, BAL

Professional Memberships and Affiliations

Association for Computing Machinery;
American Management Association, Presidents Assoc.;
Computer Measurement Group(CMG), National Program Committee;
Director, North East Region CMG;
Society for Information Management;
Technical Editor, Enterprise Systems Journal and DB2 Systems Journal;
Database Editor, CMG Transactions;
Director, TRIDEX DB2 User Group;
IDUG Conference Planning Committee.
Listed in Who's Who in US, in the East, Worldwide, and Who's Who in Scientific and Engineering Professions

Technical Publications

IMS Performance Tuning and Buffer Pool Management

SHARE 46

Making IMS Work

SHARE 47

Standards for IMS Systems Development

SHARE 50

DB2 - Do You Really Want to use Dynamic SQL?

Mainframe Journal, May, 1988

DB2 Version 2.1 Offers Major New Functional and Performance Enhancements

Mainframe Journal, September 1988

Design, Performance, and Capacity Planning for DB2 Applications

Mainframe Journal, November 1988

Performance and Catalog Locking Implications of Dynamic SQL

CMG Proceedings, December 1988

Should DB2 Be Your DBMS of Choice?

Mainframe Journal, May 1989

Dynamic SQL Performance Considerations

IDUG Proceedings, August 1989

DB2 Performance Planning, Analysis, and Tuning - A Tutorial

CMG Proceedings, December 1989

Performance Implications of DB2 Backout Processing

CMG Proceedings, December 1990

DB2 Performance Planning - A Management Perspective

CMG - BOF, December 1990

Performance Measurements of DB2 Backout Processes

Enterprise Systems, February 1991

DB2 Performance Metrics

CMG Proceedings, December 1991
ESJ, March 1992

DB2 Performance is a Management Problem

CMG Transactions, Fall 1991

DB2 Performance Planning - A Management Perspective

CMG Proceedings, December 1992
ESJ, February 1994

Integrating DB2 and MVS Performance Data

IDUG Proceedings, May 1993

DB2 Version 3 Wants Your Memory

DB2 Today, August 1993

DB2 Performance is a Management Problem!

Relational Journal, August 1993

Performance Engineering & Tuning Saves > $200K a Year

IDUG 1994

DB2 Buffer Pool Tuning & Sizing

IDUG 1995; IDUG/Berlin; CMG 94; Guide, France, 97;

DB2 Buffer Pool Tuning, The yellow Brick Road

IDUG 1996; IDUG/Amsterdam CMG 95; IDUG/Melbourne;

DB2 System Performance Metrics

IDUG 1997; IDUG/Barcelona CMG 96; UKCMG 97; IDUG/Sydney;

DB2 Buffer Pool Tuning - Top Down or Bottom Up?

IDUG 1998;



Seminars/Courses Developed and Presented by Joel Goldstein

IMS Database Administration

Coopers and Lybrand February, 1977

IMS Database Design and Administration

Mutual Benefit Life April, 1978

IMS Application Design and Programming

Bell Laboratories June, 1982

IMS Transaction Processing and Application Design

Westinghouse March, 1984

IMS Database Design

Rutgers University February, 1985

DB2 Design Review and Performance Planning Considerations

Bellcore May, 1987

IMS Performance, Tuning, and Capacity Planning

Bellcore November, 1988

Using the DB2 Performance Monitor During Application Development

Bellcore November, 1988

DB2 Performance Management and Capacity Planning*

1988-1998

Advanced DB2 Performance and Tuning (One Day)

1993-1998

Integrating DB2 and MVS Performance Data (One Day)

1993-1997

Client Server Design, Considerations, and Impacts for DB2

1994-1996

* This public 3 day seminar has been presented at the following locations, some many times: Kansas City; Dallas; Washington; San Francisco; Philadelphia; Los Angeles; Santa Monica, Orlando; Chicago; New York; Boston; New Brunswick; London; Ottawa; Sydney; Brussels; Milan; Frankfurt; Utrecht; Paris; Rome, The seminar has been attended by more than 400 corporations, including IBM, Amdahl, Candle, Landmark, Legent, Goal, BMC, Boole & Babbage, and all of the big 6 CPA firms.

During 1990, he also taught Candle's DB2 courses under contract - DB2 Performance and Tuning (4 times), DB2 High Performance Design (3 times), CICS/DB2 Interface(1); and was a featured speaker at Candles 1990 Performance Conference

Other Speaking Engagements:
Knauer DB2 User Group (5), Heartland DB2 User Group, Delaware Valley DB2 User Group (5), New England DB2 User Group (2), MidWest DB2 Users Group (3) LA DB2 User Group(3), NECMG (6), PhilaCMG (7), Chicago CMG, SCMG, Minneapolis CMG, Toronto CMG, Rochester CMG (2), Hartford DPMA, Boston CMG (2), Lakeland DPMA, NY Metro DB2 User Group (4), TRIDEX (6), Bostex(2), Ottawa DB2 User Group, Melbourne CMG & DB2 User Groups (Australia), Benelux GCM, PLUG, Jacksonville DB2 User Group, Cincinnati DB2 User Group, Kuala Lumpur, Malaysia, Singapore, Frankfurt, London, Brussels, Breda, Milan


  eMail Us with Your Questions or Comments 
 
Responsive Systems Company 1997-2014  All Rights Reserved.
281 Highway 79, Morganville, NJ 07751 USA
Office: (732) 972-1261, FAX: (732) 972-9416

Last modified: May 29, 2014 by Dr Bernie Domanski