Cover letter for Michael Levine - August, 2007 Attached please find my current Resume. I am currently working for a large Information Technology Consulting firm located in Tallahassee Florida, where I am the Team Lead of the Database Administration Group supporting a large multi-subsystem DB2 V8.1 development project on z/OS. I have 20+ years of DB2 Database Administration (DBA), Database and subsystem performance tuning and DB2 System Programming experience on the z/OS (MVS) mainframe platform. I am currently the lead development DBA on a large child welfare system (SACWIS) for the state of Florida that went live on July 30, 2007. On my prior engagement I was the lead production support DBA and performed the DB2 upgrade from V6.1 to V7.1. I also have significant and extensive DB2 upgrade and program product installation experience, SMP/E and non-SMP/E. I have extensive experience with the BMC and Platinum DB2 products, Omegamon for DB2, ASG-TMON, IBM Query Monitor and Insight/DB2, DB2 Connect, Control Center, CA Erwin data modeling tool, CA DBA-Xpert, etc. I completed a ten year DB2 Database Administration and System Programming consulting engagement at Northeast Utilities (NU) where I was the primary DB2 DBA and DB2 Systems Programmer. I was the lead DB2 DBA on a very large and successful CICS/DB2 supply chain application implementation project. The application supported four nuclear plants, hundreds of facilities, covered three states and has over 9,000 users. I also completed a nine month DB2 Database Administration assignment at Florida Power and Light (FPL) where I was the lead DB2 DBA on the migration of a large DB2/CICS supply chain application from the NU mainframe to the FPL data center. I have also sub-contracted for IBM Professional Services as a Senior DB2 Technical Specialist and was a Price Waterhouse Senior DB2 Consultant. I am also an IBM DB2 Certified Solutions Expert (V7.1). Please contact me to discuss the position requirements in detail. Sincerely, Michael Levine Michael Levine IBM Certified Solutions Expert - DB2 V7.1 Database Administration for OS/390 (850) 222-4390 email: mike@tekhelp.net RESUME: Michael Levine email: mike@tekhelp.net (850) 222-4390 Position: Senior z/OS DB2 DBA and/or Senior z/OS DB2 System Programming Technical Specialist. IBM Certified Solutions Expert - DB2 V7.1 Database Administration for z/OS. Professional Experience: Large IT Consulting and System Integrator, Tallahassee, FL July 2006 – Present Senior DB2 z/OS DBA and DB2 UDB Database Consultant For a large State of Florida Agency perform z/OS DB2 DBA and UDB on Windows DBA activities in support of a large, state wide project. Configure and maintain multiple DB2 database environments, perform refreshes, data unloads, REORGs, image copies, performance tuning, etc. Performed application tuning and stress testing using IBM DB2 Administration Tool, Query Monitor and Thread Expert. Configured DB2 Control Center, DB2 Connect, set up Work Load Manager Application environments, create and maintain all DB2 objects, configured and tune DB2 bufferpools, create indexes as required and recommend SQL code changes. Created stored procedures, TRIGGERs and sequence objects. Work with TMON/DB2, ERWin, DBA Xpert and DB2 Control Center on a daily basis. Gave technical presentations to client DBA staff and management. DB2 z/OS V8.1, UDB V8.2. BearingPoint, Inc. (formally KPMG Consulting), Tallahassee, FL Dec 2003 – July 2006 Database team lead and on-site Performance Manager. At a large State of Florida Agency, currently engaged as database Team Lead for DB2 and SQL Server. Expert level knowledge of all DB2 DBA and DB2 z/OS system programming functions as well as working knowledge of Microsoft SQL Server. Performed SMP/E install and implementation of DB2 V7.1 in all environments. Installed IBM DB2 utility suite and related product features including Client Management package, REXX support, net.data and JAVA support. Configured DB2 z/OS UNIX System Services (USS). Installed and configured UNIX database administration server (DAS), DB2 control center and DB2 Connect V8. Configured and implemented Resource Recovery Services (RRS). Setup and maintain Work Load Manager (WLM) policy and application environments. Implement subsystem DSNZPARM changes as required. Installed Omegamon DB2, File-Aid DB2, File-Aid RDX, CA/Pan SQL and Easytreive Plus. Apply corrective and preventative service as required. Extensive performance monitoring and tuning experience using Omegamon DB2. Implemented Omegamon DB2 historical collector. Run application performance traces and assist programmers with SQL performance tuning and problem determination. Implemented DB2 audit trace for a critical table and created audit reports utilizing SAS/MXG. Implemented DB2 distributed data facility (DDF). Maintain DB2 subsystem and database security, perform database physical design and maintain physical database objects including tables, views, indexes, triggers, stored procedures, etc. Set up and run DB2 REORGs, LOADs, UNLOADs, BINDs, etc. as required. Work on a daily basis with BMC Catalog Manager and Change Manager, Princeton Access/DB2, File-aid/DB2, QMF, etc. Perform SQL Server DBA activities utilizing Microsoft SQL Server Enterprise Manager. Provide support for IBI EDA/IWAY middleware product. Assisted with upgrade of MVS operating system from OS/390 V2.10 to z/OS V1.6. Installed ADABAS V7.4, Natural V4.1 and Predict V4.4. Also serve as BearingPoint’s on-site Performance Manager for the Mainframe, database and Oracle employee staff. Perform performance reviews and mentoring for six BearingPoint employees. Interface with client management. Participated in mainframe upgrade planning and capacity meetings. FPL Group, Juno Beach, FL Mar 2003 – Nov 2003 Senior DB2 Database Administrator (DBA) Was engaged as a senior DB2 DBA providing DB2 database administration and system programming support for two production Passport applications supporting five nuclear units. Assisted with the move and conversion of Nuclear facility Seabrook Station’s Passport application to FPL. Provided DB2 database administration and application support for the upgrade of Passport to version 9.1. Performed performance analysis and problem determination. Created and scheduled production REORG and IMAGE COPY JCL and batch jobs. Assisted with testing and scheduling the application batch cycle. Created production UNLOAD JCL and reload jobs to LOAD training and lower region databases. Created TSO edit macros to generate LOAD and UNLOAD JCL. Recommended DB2 subsystem and CICS parameter changes which were accepted and implemented. Created and implemented Production Data Modification and Audit procedures to satisfy Sarbanes Oxley requirements. Authored Passport V9.1 Operation, Performance and Configuration Guide. Provided 24x7 on-call support. Wrote COBOL/DB2 data extract programs which extract data and perform work management calculations from Passport DB2 tables. Also wrote COBOL compare programs which compare the full extract files producing delta files which are then FTP’d down to a work management data warehouse residing in an ORACLE database. Michael Levine (2 of 5) email: mike@tekhelp.net (850) 222-4390 Professional Experience: Northeast Utilities (NUSCO), Berlin CT Aug 1993 – Feb 2003 (continued) Senior DB2 Database Administrator. Was engaged as lead DB2 DBA in support of 4,000+ user ERP supply chain CICS/COBOL II application (INDUS Passport V9.03). Perform all DB2 DBA activities, including creating and managing DB2 objects, database and SQL performance monitoring and tuning, security, backup/recovery procedures and problem resolution. Install new Passport baseline versions. Implemented REORG, RUNSTATS, BIND and IMAGE COPY procedures and set system-wide naming standards. Maintain DB2 TRIGGERs and STORED PROCs. Implemented application disaster recovery procedures and successfully performed disaster recovery drill. Extensive internals and performance tuning experience with Passport supply chain modules Accounts Payable, Inventory and Purchasing. Non-ERP modules: Action Tracking, Material Safety Data Sheet, Controlled Documents and Records Management. Senior DB2 System Programmer. Provided DB2 system programming support for six DB2 subsystems. Installed and implemented DB2 V5.1 and V6.1. Implemented DB2 data sharing in a parallel sysplex OS/390 environment. Responsible for DB2 security. Maintain DB2 subsystem parameter module DSNZPARM and CICS RCTs, perform all subsystem tuning. Installed and implemented DB2 V3.1. Install and evaluate third party DB2 program products. Installed OMEGAMON DB2 V520, Platinum products and Candle DB/Tools. Work on a daily basis with Platinum, QMF, OMEGAMON, TSO clists, edit macros, SPUFI, EXPLAIN, DB/DASD, DB/EXPLAIN, Passport toolkit, MVS utilities, JCL, etc. Implemented DB2 system disaster recovery procedure. Performed successful DB2 subsystem disaster recovery drill. Extensive SMP/E experience. Passport 9.03 upgrade and data filter/conversion project. Was lead DB2 DBA on upgrade to Passport V9.03. Responsible for setting up, testing and running conversion and data filter jobs (operation, performance and configuration). Responsible for on-line transaction and batch performance tuning. Performed extensive performance analysis, stress testing and tuning. Created and maintained training regions. Performed data refreshes and many other project related activities in support of this highly successful and under-budget project. Yankee Gas Customer Service performance tuning. At a large gas distribution company performed DB2 performance tuning on IBM’s DB2/CICS Customer Service application (CCIS) which resulted in a 50 percent reduction in overall CPU usage and a 50 percent reduction in end user response time and an almost total elimination of -911 contention abends. The end result was also a savings of over 1.5 million dollars to the client. Assisted in migrating Yankee Energy Service Company’s data center to Northeast Utilities’ Wethersfield data center. Electric deregulation. In support of deregulation and sale of generating assets, performed data filter and database separation for nuclear facilities Millstone and Seabrook stations. Assisted with successful moves of applications and data from data center. IBM Integrated Systems Solution Corp (ISSC), Newington, CT May 1991 -Aug 1993 At several divisions of a large aerospace holding company, provided primary DB2 System Administration support. Installed and implemented DB2 V2.3. Installed Omegamon/DB2, BMC products for DB2, CIM/CDF and other DB2 program products. Tailored and implemented the QMF governor exit and set QMF governor resource limits. Was responsible for subsystem problem resolution, SMP/E maintenance, performance tuning, backup and recovery, security and other DB2 System Administration activities. Implemented Resource Limit Facility (RLF); provided training procedures and gave DB2 presentations. At a large helicopter manufacturer provided primary DB2 System and Database Administration support. Provided primary installation and maintenance support for all DB2 related program products. Other activities included MVS system programming support. Installed DFHSM 2.5 and 2.6, ADW/MVS, PROLOG, Platinum DB2 program products. Actively involved in Sikorsky's DF/SMS implementation. Provided DB2 DBA support as required and assisted with the development of DB2 company-wide standards and procedures. Michael Levine (3 of 5) email: mike@tekhelp.net (850) 222-4390 Professional Experience: IBM Professional Services (Systems Integration Division) Aug 1989 - May 1991 (continued) DB2 Database Administration (DBA) support: At a large utility performed database administration activities in support of several major DB2 application development projects. Working with client staff and outside consultants, performed physical database design, taking logical model and creating a physical design; created DB2 databases, tablespaces, large tables (60+ million rows), indexes and other DB2 objects. Implemented DB2 security using ACF/2 and DB2 secondary authorization ids. Performed application performance reviews and implemented performance recommendations. Developed and executed database migration and alteration strategies using Platinum Technology's DB2 tools. Developed and implemented backup and recovery procedures and created a corporate disaster recovery procedure for DB2. DB2 System Administration and System Programming support: At a large utility performed SMP/E installation and implementation of DB2 V2.2, migrating from V2.1. Restructured the DB2 system environment; establishing separate DB2 subsystems and SMP/E zones. Installed many DB2 program products including DB2PM, Platinum DB2, Insight/DB2, BMC's Master Mind and QMF. Developed and implemented accounting and statistics reports to facilitate capacity planning and performance monitoring. Affected subsystem parameter changes (DSNZPARM) to support application requirements and performance objectives. Activated and tailored DB2 Resource Limit Facility (RLF). Maintained CICS RCTs, performed QMF administration, tailored and implemented the QMF governor exit. Implemented DB2 logging enhancements and addressed other DB2 operational issues. At a major department store chain performed MVS System Programming activities in support of migration from DOS/VSE to MVS/ESA. Assisted with MVS CBIPO installation. Installed many program products both SMP/E and non-SMP/E. Installed DB2 V2.1, migrating from DB2 1.3. Implemented DB2 security exits DSN3@ATH and DSN3@SGN and established the DB2 security policy. Installed and implemented BACHMAN/DBA catalog extract and re-engineering product. Other program product installs include: DF/SORT R11, Info/System, Info/Management, JES328X, DBDS, CICS/CEMT, OMEGAMON CICS, CANDLE VTAM session manager, CA/JCL CHECK, IRC's RCP for Info/Management and SDSF. Price Waterhouse - MCS, New York, NY Mar 1989 - Aug 1989 Senior Technical Consultant in Information Technology Engagements included: - Performed a technical General Controls review (MVS and RACF) at a large public utility. - Performed a Data Center and Telecommunications review at a large Depository. - Was an instructor for a three day Price Waterhouse DB2 class, "Managing, Controlling and Auditing in a DB2 Environment". - Developed an operations procedures manual for a large consumer electronics company. Engagement included interviewing operations support personnel, creating a documentation library, developing update procedures and implementing automated printing facilities. Michael Levine (4 of 5) email: mike@tekhelp.net (850) 222-4390 Professional Experience: Mutual of New York (MONY), Syracuse, NY Apr 1984 - Mar 1989 (continued) Senior DB2 and MVS Systems Programmer Was responsible for the installation, maintenance and tuning of five DB2 subsystems and related program products. Installed and implemented DB2 V2.1, migrating from V1.3. Applied corrective and preventive service as required. Created new subsystems, performed system performance tuning and other DB2 System Programming activities. DB2 Program products Installed: QMF V2.4, DB/EDIT, DB/Maui, DB2PM and DB Pro/Edit. Was also responsible for the installation and maintenance of additional system software, both IBM and non-IBM. Experienced with large multi-system MVS/XA system configurations in a PR/SM environment. Performed initial SMP/E installation and implementation of DF/HSM V2.2, later upgrading to V2.3. Implemented DF/HSM space management and availability management functions. Gave four technical presentations on DF/HSM. Other software installations include: QMF, Info/Management and Info/Access, DF/DSS, GDDM, DFP, ISMF, DB/EDIT, DB/Maui, Duquesne's MIM, MSM and GCD, CA/Blockmaster, Softwork VSM and VSAM assist, Phoenix CBT. Extensive experience using SMP/E and MVS system utilities. Related Skills: - z/OS UNIX System Services (USS). Hierarchical File System (HFS). OMVS, ISHELL (partial list) - Work Load Manager Policy definition and Application environments. - DB2 UDB V8.2 and DB2 control center. - Conversion of DB2 tablespaces and indexes to DF/SMS - Resource Recovery Services (RRS) configuration. - INDUS Passport V9.03 Application: Supply Chain (Inventory, Accounts Payable, and Purchasing), Document Management, Action Tracking, MSDS, Work Management. - SAS/MXG. Developed DB2 Audit reports to report on sensitive tables using SMF data, SAS and MXG product. - DB2 Security, Disaster Recovery, Recovery/Restart, Problem Determination and Resolution. - DB2 Performance and Tuning, DB2 data sharing in a parallel sysplex OS/390 environment. - CA Platinum Products. IBM High Performance Unload (HPU). - BMC DB2 tools. BMC DB2 Activity Monitor. - DB2 Database Conversion, RACF Security Administration, System Integration. - COBOL, ASSEMBLER, FOCUS, PL/I, SQL, CLISTs, REXX, reporting tools, etc. - DF/SMS Planing, Installation and Implementation. - Technical Audits and Reviews (i.e., DB2, MVS, RACF, General Controls, etc.). - Technical Presentations and Training. - General MVS System Programming. Education: Syracuse University, Syracuse, NY 1980 - 1984 Crouse Hinds School of Management - B.S. Management Information Systems (MIS) - B.S. Marketing Management Certifications: IBM Certified Solutions Expert - DB2 V7.1 Database Administration for OS/390. Michael Levine (5 of 5) email: mike@tekhelp.net (850) 222-4390 Technical Training: (partial list) IBM Technical Training - DB2 Facilities and planning - DB2 Database Administration workshop - Using SMP/E workshop - IBM SMP/E - Tailoring DF/HSM - DASD Storage Subsystem Management - MVS/XA Installation and MVS/XA Facilities and Planning - Assembler language coding workshop - MVS/XA Structure and Logic - Integrated Catalog Facility (ICF) availability - VSAM performance workshop Non-IBM Technical Training - Amdahl MVS/XA Diagnostic Techniques - Computer Task Group (CTG) ten week COBOL programmer training - Compuware JCL - Fundamentals of I/O Processing and Storage Subsystems - Implementing JES2 - Implementing DF/HSM - SRA RACF series Conferences and Affiliations: - Member North Florida Database Users Group. - Member NASPA - National Association of System Programmers. - Attended IDUG Conference May 2001 Orlando, FL. - SHARE 71 - Attended five day SHARE conference NYC 1988. References: Available upon request.