George Peters

Profile

20+ years assisting companies domestically and internationally in Data & Database Management, Systems & Information Integration, Data Architecture, along with some technical line management & Management Consulting.  Extensive hands-on designing, implementing and supporting both centralized and distributed applications on diverse platforms; emphasis on design for Performance, Availability, Scalability and Integration.  Strong familiarity with Financial Services, Cap. Mkts.

GOAL

Enterprise Data/DB Arch., Info. Integration Arch., Manager DBA, Snr. Data Arch. role in distributed environment.

Software ExperiencE

I.   Database Managers, TP monitors, Application Servers:

·       DB2® Enterprise 9.1 for Linux, UNIX, and Windows (LUW), including DPF; familiarity with UDB’s predecessors back to OS/2 EE DBM (1988); Beta user (’06) and GA user (‘06-‘07) of DB2 Enterprise 9.1 for LUW with DFP, using new features of table (range) partitioning, data row compression; implemented V8.2 new features of HADR, Q Replication, Automatic Storage; DB2 9.5 Beta User (’07); IBM BCU methodology for Scalable Data Warehousing

·       DB2 for z/OS, DB2 Connect, CICS/DB2 attachment, IBM, CA, and BMC 3rd Party Tools and Utilities

·       IBM WebSphere Application Server V6, CICS, IMS DB/DC

II.    Business Intelligence/Data Warehousing (BI/DW), Enterprise Information Integration (EII), Interoperability:

Ø    Hands-on use / Formal Training / Certification / Working knowledge of:  Capabilities of various BI/DW, Enterprise Information Integration and Middleware technologies and product capabilities, over a dozen years:

·       WebSphere Information Integrator (WII) 8.2/ DB2 II; WebSphere MQ 6; IBM DPROP/R; Various middleware e.g. Message-Oriented Middleware (MOM); WebSphere MQ 6, including WS MQ AMI 1.2

·       Web Services: DB2 UDB as producer of Web Services; DB2 UDB as consumer via SOAP UDF’s;  familiarity with J2EE Development paradigm; XML, Java connectivity to RDBMS (JDBC, SQLJ)

·       DW/BI/ETL tools, architectural frameworks, methodologies, standards, toolsets and products over time, including: Informatica PowerCenter, MicroStrategy DSS Agent/Architect, Business Objects, IBM DB2 DW Center, etc.

III.   Operating Systems:

·       IBM z/OS and predecessors back to MVS/370, Linux (2.4, 2.6 kernels), various UNIX on and off over the years

IV.   Performance Monitoring/Management:

·      DB2 UDB System Monitor (Snapshot and Event Monitors), Visual Explain / Statistics Advisor, DB2PM V8/DB2PE V2.1, OMEGAMON, TMON, STROBE, RLF, QMF Governor

V.   Design tools, CASE, Metadata Management, Repositories:

·   ERwin, Embarcadero (DBArtisan, etc.), BACHMAN Re-Engineering Product set, TI’s IEF, ADW, LBMS

PROFESSIONAL EXPERIENCE

Employer / Client

Location

Title

Lehman Bros.

Jersey City, NJ, 02/07-06/07

 Ent. Arch. – Database domain (DB2)

 

Enterprise Architect in the database domain (DB2 9 for Linux, Unix); reviewed application designs; applying the feature/function of database and platform technologies to diverse application requirements.  Integration of DB technology into the broader technical architecture of the Firm, leveraging capabilities of the platform layer below, while providing services to the middleware and layers above.  Developed and disseminated best practices in the database domain.  Worked with DBAs and Application team leads to enhance the performance of major databases and re-factor databases and their applications to be resilient to change (business changes, growing volumes, performance, etc.).

Examples included:  Review and advise on the Data Models for core Positions and Balances;  Trades Applic. re-design.

For Firm Wide Application Monitoring Infrastructure app on DB2 9 (Linux). used by all Firm apps globally, designed ODS and DW Architecture exploiting interplay of complex DBMS data structures (MDC and new table (range) partitioning capabilities) for concurrent high-INSERT, analytics, and seamless data rotation from current period (ODS) to history (DW) i.e. Roll-Out / Roll-In, using inter-process communications across DB2 instances to maximize data availability.

Analyzed a major Funds Availability application recommending and implementing instance, database configuration, design enhancements, and SQL changes yielding over 100% performance and throughput improvement.

Headstrong Inc. (prev. James Martin)

New York NY, 02/06 – 02/07

Chief Data Arch., DW & BI Grp (F/T)

For Morgan Stanley’s ISG, Data and DB Architect charged with re-architecting and re-platforming Trade Settlements from DB2 for z/OS Data Warehouse, to new DB2 Enterprise 9.1 for Linux with Database Partitioning Feature (DFP), IBM’s MPP implementation on Distr. Platforms;  Open and Settled Trades, partitioned with DPF, both within, across clustered LINUX SMP servers.  Prepared Technical Architecture, methodology / Proof of Concept and benchmark testing for very high throughput mission-critical back-office Firm-Wide system for migration from mainframe.  Understood to be among the largest known clustered (DPF) DB2 Enterprise 9 implementations, per IBM.  Utilized major features of new DB2 Enterprise 9:  viz. data row compression, Table/Range Partitioning, etc.

Various Govt. entities (Austr.)

Remote; from NY, NY, 2H/2005

DB2 LUW DBA Cons./Arch.(Linux)

For national Medical Insurance Co (below, 2003), implemented and tested WebSphere Information Integrator 8.2’s new Q Replication (incl. setup of WebSphere MQ 6 Server and creation of required MQ objects across servers) for data distribution/consolidation, business continuity, and as alternative to DB2’s traditional SQL-based Replication.  Benchmarked the two for comparative performance, achieving triple throughput.

For same client, setup, testing and evaluation of DB2 V8.2’s new HADR failover feature, incorporating server role switching, failover of primary server, auto client re-route (ACR); part of broader Review of Best Practices for High Availability/DR, including log shipping, remote disk and/or log mirroring, intelligent storage sub-system mirroring; advised client on pros and cons of HADR vs. new Q Replication for failover/standby for this customer’s Availability requirements.

For Transportation client developed procedure to decompose externally supplied XML files to untagged relational data for later database manipulation.  Used DB2 UDB V8 XML Extender’s Collection-based access and storage method, RDB Node Mapping and RAD V6 to generate XML-related artifacts; tested  XML document movement between relational tables and WebSphere MQ 6 message queues. 


IBM Global Services, IBM Global Finance

Armonk, NY, 11/04-05/05

Snr. DB2 UDB Perf. Cons.

For IBM’s largest application, technical lead for DB2 for z/OS Performance/CPU Cost reduction project.  Introduced comprehensive performance analysis, reporting and tuning regimen, including install and setup of DB2PE V2 and hands-on loading of its Performance Database with detailed Accounting data, aggregated weekly, anticipating later use of MQT’s prior to incorporation in upcoming V8;  introduced Buffer Pool Analyzer for buffer pool sizing and DB2 object placement.

With IBM Software Group’s Optimizer Development, introduced new Statistics Advisor tool for advanced statistics collection, query optimization of poor data access paths (now part of Visual Explain V8, and RUNSTATS in DB2 UDB for z/OS V8); provided guidance on all performance-related issues relating to both this critical application, and associated downstream Data Warehousing offshoots (UDB on AIX, WIN); including install and benchmarking of both DB2’s new Q Replication with WebSphere MQ 6 and DB2 Information Integrator, later re-branded WebSphere Information Integrator.

Securities Ind. Automation Corp (NYSE)

New York, NY, 05/04-11/04

Snr. DB2 UDB DBA Cons.

For next generation NYSE trading floor system, provided database support in multi-tier, distributed environment, with Java-based Linux clients submitting to WebSphere Application Server (WAS), executing remotely via DB2 Enterprise Connect against DB2 for z/OS.  “Extreme Availability” environment required duplexing of all components, including the database itself, RDBMS (SYSPLEX), and WAS (“dual stack” concept).  Designed for platform independence, including usage of new application callable database Utility interface via new Stored Procedure presenting consistent SQL interface for invocation of systems commands, utilities..

With IBM Software Group Development, tested performance, failover, availability and identification of overheads of WAS stress-testing transactions to DB2 DataSharing Parallel Sysplex.  Concurrent evaluation of strategy and identification of deliverables to port 3-Tier server DBMS to DB2 UDB ESE (LINUX) in anticipation of mid-stream change of platform.

Various Govt. entities (Austr.)

Remote; NY, NY, 2003

Snr. DB2 UDB D/W Cons.

For various Government entities designed systems to extract operational data from DB2 for z/OS to DB2 UDB ESE to populate data marts in clustered SMP environments, including hands-on migration of DB2 UDB ESE from V7 to V8.1; design of databases; establishment of formal performance monitoring regimen with historical storage of data from then new V8 Snapshot Monitor Table Functions, and Event Monitor Write To Table data, for historical trend analysis, reporting and performance management. 

For national Medical Insurance Co., implemented UDB SQL Replication, exploiting new cursor cross loader, utilizing Federated database and associated object definitions to implement same (wrapper, server, mapping and nickname for source, in target DB), as appropriate.  This Federation functionality now part of the re-branded WebSphere Information Integrator 8.2 product set (now WebSphere Federation Server).

Strategic Database Systems, Inc.

New York, NY, 01/01-12/02

Stock and Futures trader.

Stock and futures trader – indexes, currencies, energy (for self)

PricewaterhouseCoopers (Mgt. Cons.Svcs) Svcs)

New York, NY, 03/00-12/00

Prin. Cons., DW & BI Practice (F/T)

At PwC Management Cons. Financial Svcs Vertical, worked with clients on applicability of appropriate tools for various Data Warehousing architectural components (database design, data acquisition, data management and storage, data delivery, data access, metadata management, etc.) in a formal, methodology-based environment;  Extensively researched critical Information Integration and EAI technologies (messaging, hub/spoke, integration brokers), and emerging e-Business inter-operability standards; viz. inter-enterprise communications via well-defined interfaces, formats and protocols: the emerging XML-based technologies SOAP, WSDL, UDDI (i.e. current Web Services paradigm).  Investigated and advised on impact of XML on reduction of proprietary API’S required for information integration, its value as mechanism for data interchange, application integration and as new abstracted layer in emerging SOA paradigm.

Guardian Life Insurance Co.

New York, NY, 03/98-11/99

Snr. DB2 DBA Cons.

Database support of the Firm’s various DB2 for z/OS environments; incl. DB design, performance and change management.



MCI Systemhouse (now EDS)

New York, NY, 04/97-03/98

Mgr., Sys. Integn., D/W Practice (F/T) Warehouse Practice

Advised clients on industry developments in BI/Data Warehousing, incl. design techniques for Enterprise Data Warehousing (EDW) vs. functional Data Marts, the painful debate between the two competing design approaches (Inmon and IBM’s EDW vs. Kimball’s conforming Data Marts etc.); methods for Data Mart consolidation; DW /DM design (Star Schema, Snowflake, 3NF etc.), development and implementation methodologies; emerging technologies: the new object/relational (“universal”) database servers, proprietary MDDB products, ODS, applicability of various categories of OLAP tools (ROLAP, MOLAP), exploitation of parallelism, novel architectures (NUMA, MPP), interoperability issues in distributed environments.  Prepared Customer RFP’s, presentations, new business development and service offerings.  Took lead in promotion of IBM’s then new Universal DB2 UDB V5 on diverse distributed platforms, including parallelized version (“EEE”, now DPF) within IBM’s Global Systems Integrator (GSI) program.

Hitachi Data Systems (HDS)

Seoul, Seth. Korea, 04/1996

DB2 Consultant Performance Review

For HDS client, Samsung Heavy Industries in Seth. Korea, formal performance review of poorly performing new Accounting System.  Top-down evaluation of all aspects impacting DB2/MVS performance; system-wide MVS Performance, DASD contention etc. through to individual SQL’s. 

Telstra Corp.

Melb., Australia 02/92-11/96

Ent. Sys. Integn Architect/ DBA Mgr.

For nation’s largest IT user, worked within Integration Services team to implement Enterprise-Wide Architecture for the entire Corporation, a proto-SOA, targeting application inter-operability and sharing of “Databases of Record” (Customer, Product, etc.), maintained by “System(s) of Record”; identified, designed and implemented middleware solution required to concurrently develop and integrate multiple huge new core business “building blocks” (Customer Billing, Service Delivery, Product, Network) sharing both data and process across platforms on a contract-based paradigm. 

Implemented a solution connecting these building blocks: OS, H/W platform, and language-independent architecture, isolated presentation, data and process layers with “contract definition”, (an IDL), contract registration, and well-defined application contract invocation i.e. networked service invocation via well-defined interfaces, formats and protocols for application inter-operability on heterogeneous platforms, implemented as a separately abstracted layer, transparent to app. developers.  This contract-based architecture has now morphed into the XML/HTTP-based enabling technologies (SOAP, WSDL) and services (contracts) defined in service registries (UDDI); Information understood and delivered as a contract/service.

Manuf. Hanover Bank (now JPM Chase)

New York, NY, 1989-1992

Snr. DB2 DBA Cons.

For the Trust Bank, introduced, established and implemented new DB2/MVS Environment for conversion of Global Custody system from VSAM to DB2.  Setup multiple testing environments, and seamless migration of objects between same (absent modern automated tools).  Wrote all standards for entire environment:  naming conventions, object migration, SQL programming techniques for performance, mentored and formally taught staff, guided the Bank through the new RI features of DB2 V2, complex Recovery/Restart issues in a High Availability global environment, and introduced the new DB2 Package Bind feature, later published in leading industry Journal (see Publications).  The application was an early user of BACHMAN Re-Engineering Product Set; single Repository for all logical / physical database design products.  Generated all DDL, including incremental, from the tool for transfer to the mainframe.

Bankers Trust Co. (now Deutsche Bank)

New York, NY, 1988-1989

Snr. DB2 DBA/Modeling Cons.

For Global Custody, Data Analysis, Data modeling and re-design of Bank's Master Trust system being re-engineered to DB2.

Loaded complex SMF performance-related DB2/MVS data into user tables for problem analysis, resolution and historical trend identification of system usage.  This functionality now included by IBM into its DB2PE product.

IBM Consulting Services

Purchase, NY, 1988

DB2 Perf. Specialist Cons.

For IBM client (MONY), QA review of 3rd Party Conversion to DB2: tuning of DB2 sub-system application with DB2PM; CICS/DB2 Attachment; SQL code reviews; mentoring of staff on Access Path Selection, efficient database design.


MetLife Insurance Co

New York, NY, 1987-88

DB2 Systems Programmer Cons.

As DB2 Systems Programmer, performed installation, upgrade and migration of DB2/MVS to V1.2. Installed DB2PM V1.



Merrill Lynch and Co.

New York, NY, 1985-87

Manager, DBA and DA (F/T)

As Manager of Database Administration and Data Admin., recommended adoption of, and initiated implementation of then new DB2/MVS product within the company, providing overall direction concerning the establishment of DB2 in both Operational and Informational environments; formulated standards, guidelines and procedures for DB design and administration, application design, program development, operation and recovery strategies, security and authorization, performance monitoring and tuning.  Introduced formal IBM Application/Database Design Review process for critical, OLTP systems; initiated implementation of DB2 extensibility into Corporate Data Dictionary, enabling generation of DB2 DDL from that product from day one; at same time, started Greater New York DB2 Users Group, 1985-1988 (First in Tri-State Region)  .

Concurrently with ongoing Name/Address “Householding” exercise, took initiative to consolidate entire Householded, demographics-enriched account Name & Address Master of some 7M accounts, integrating all accounts under a common Customer, and Household, respectively.  Again, Customer and this time also Household-centric approach as a new business value proposition, a new way of doing business.  Designed, and loaded a “proto” DB2 Data Warehouse of this data serving needs of diverse departments (Ops., Mktg., Compliance) as prototype for a Customer Information System, and for stress/volume testing of the then new DB2 product.  Organized and led a team, conducted a major on-line transaction performance benchmark against this DB2 database.  As Manager, trained and mentored staff, conducted staff Performance Reviews.

SELECTED Industry Achievements

Affiliate and Instructor, Codd and Date, Inc. (inventors of relational model for RDBMS)

·         DB2 Database Design/Development for Performance; DB2 Recovery/Restart courses

Publications

·         Contributor to book High-Performance Client/Server (named back cover), Loosley/Douglas, pub. Wiley, NY, 1998

·         Contributor – Database Programming and Design Magazine (now Intelligent Enterprise)

Founder and Coordinator

·         Greater New York DB2 Users Group, 1985-1988 (First in Tri-State Region)  aka “Merill Lynch DB2 Users Group”

Speaking Engagements

·         National Financial Computer and Automation Conference (FINCOM), New York, NY

·         Australasia Share Guide (ASG), Adelaide, Australia, (Best Speaker, Applications Enabling Division)

Certifications

·         IBM Certified Database Administrator - DB2 9 DBA for Linux, UNIX and Windows                      (2007)

·         IBM Certified Database Administrator - DB2 UDB V8.1 for Linux, UNIX and Windows                (2004)

·         IBM Certified Solutions Expert            - DB2 UDB V5 for UNIX, WIN Database Admin  (1998)

Education

Graduate Diploma of Computing Studies, University of Melbourne, Australia

Bachelor of Economics (Honors Degree), Monash University, Australia


Member number:9987
Additional Contact information is available on the Information Page.
Software Contractors' Guild (www.scguild.com)
Copyright(c) 1995 - 2006 George Peters and Software Contractors' Guild, 3 Country Club Dr., #303, Manchester, NH USA 03102