Senior z/OS DB2 Database Administrator @ New York Life Insurance Company
Senior DB2 Technical Specialist (contract) @ Premier Data Services, LLC
Senior z/OS DB2 DBA and DB2 system programmer and team lead @
Bachelor of Science (B.S.) @
Syracuse University - Martin J. Whitman School of Management
Michael Levine is a highly skilled database professional specializing in DB2 database administration and system administration on the LUW (Linux, UNIX and Windows) and IBM z/OS mainframe platforms. Mike has over 25 years of overall IT experience including over 20 years of DB2 experience on all major platforms and has served in all DB2 support roles, including
Michael Levine is a highly skilled database professional specializing in DB2 database administration and system administration on the LUW (Linux, UNIX and Windows) and IBM z/OS mainframe platforms. Mike has over 25 years of overall IT experience including over 20 years of DB2 experience on all major platforms and has served in all DB2 support roles, including physical DBA, developer DBA, production support DBA and DB2 z/OS systems programmer. Mike is a Syracuse University Graduate with a B.S. in Management Information Systems and a B.S. in Marketing Management. Mike also holds IBM Advanced DBA certification on LUW and is an IBM Certified Solutions Expert on z/OS. Mike currently resides in Tallahassee, FL with his wife and two step sons.
IBM Certified Advanced DBA - DB2 9 for LINUX, UNIX & Windows (validation id 2703403)
IBM Certified Solutions Expert - DB2 Database Administration for z/OS (registration number 2703403)
Senior DB2 Database Administrator @ Senior DB2 z/OS and LUW UDB Database Administrator (DBA) and IDAA Administrator.
At a leading global financial services company and a large national retailer provide DB2 z/OS (V11.1) database administration (DBA) and IBM DB2 Analytics Accelerator (IDAA V4.1) systems support. Configured and monitor InfoSphere Change Data Replication. Perform loads to IDAA Netezza and archive very large table partitions to IDAA High Performance Storage System (HPSS). Work on a daily basis with Data Studio, Omegamon for DB2, Visual Explain, Putty and TSO. Also provide DB2 z/OS V10.1 and DB2 LUW V9.7 (Red Hat Linux) DBA support at a large state of Florida Agency. Perform all DB2 DBA support activities including logical and physical database design, performance tuning, COBOL batch support, TRIGGERs, Data Warehouse support, JCL, TSO, putty, NMON, TOPAS, SDSF and other DB2, UNIX and z/OS utilities. Performed upgrade of DB2 Connect to V10.1. Providing analysis and planning for conversion of legacy data warehouse and data marts to DB2 IDAA Netezza architecture which will provide near real time reporting, complex ad hoc query and predictive analytics capabilities. From October 2013 to Present (2 years) Tallahassee, Florida AreaPresident and Senior DB2 Technical Specialist @ At Citizens Property Insurance Company, provided primary application and infrastructure DB2 DBA support during application conversion to Microsoft SQL Server. Supported 45 DB2 LUW V9.7 databases (18 TB of data) residing on 15 IBM AIX V6.1 Power Systems servers and two federated DB2 databases residing on Windows servers in an HACMP cluster environment. Monitor server I/O and review object placement, logging, memory and CPU utilization. Provide detailed recommendations to improve performance. Implemented DB2 AUDIT facility and policies to AUDIT database activities. Maintain DB2 registry variables, instance and database configuration parameters. Perform database restores from production image to lower database environments. Optimized, maintain and execute data redaction procedures to redact production data. Create, execute and maintain SQL DML and DDL scripts and use Perforce Visual Client version control software to manage and promote scripts. Extensive use of performance monitoring tools: NMON batch and interactive, DB2TOP, DB2 admin views, IOSTAT, TOPAS and DB2MON. Extensive experience with PUTTY, DB2 Control Center, Data Studio, DB2MOVE and DB2LOOK utilities. Assist with load test performance testing activities. Implemented performance improvements identified during performance load tests. Attend application database design review meetings. Write and maintain KORN shell scripts as required. Run DB2EXPLN utility to facilitate SQL performance tuning. Maintain stored procedures and triggers. Work with Windows Server 2008 Management Console and SQL Server Management studio and provide backup SQL Server support. From August 2012 to September 2013 (1 year 2 months) Tallahassee, FLSenior DB2 LUW and z/OS DBA Technical Specialist @ Working primarily off-site, provided primary DB2 DBA application and infrastructure support at CIGNA, a Connecticut based health insurance company. Performed a top to bottom database and application infrastructure stability and performance review. The result was detailed database and infrastructure recommendations which when implemented, significantly improved production system stability and performance of the application. Maintained database and instance configuration parameters, database performance monitoring and tuning, advised on SAN disk I/O configuration, server memory and CPU utilization, database object placement, etc. Extensive experience with AIX and DB2 monitoring tools TOPAS, NMON, IOSTAT, VMSTAT, DB2TOP, DB2PD, EXPLAIN, DB2LOOK, DB2ADVIS, Control Center, Data Studio, etc.
Sr. DB2 LUW Technical Consultant - At Moody's Investors Services, performed a database environment review and project technical assessment for a large, multi-vendor billing and ratings application development effort. Reviewed logical and physical data model, project organizational structure, database environments, data placement, database and instance configuration parms, hardware capacity, server configuration, change and build management procedures. Reviewed SQL queries and joins for performance improvements.
Sr. DB2 z/OS and DB2 LUW Technical Specialist & Team Lead - At the Florida Department of Children and Families, performed DB2 z/OS and DB2 LUW DBA activities in support of the successful implementation of FSFN, a large scale, 7000+ user, state-wide child protection
system which was a replacement of the existing HSN legacy system. Configured, tuned and maintained large, high volume DB2 database environments on multiple platforms. Performed all database administration activities including physical and logical design, performance tuning, backup and recovery, REORGs, etc. Worked with TMON/DB2, PUTTY, ERWin, DBA-XPERT, IBM Data Studio and DB2 Control Center on a daily basis. From July 2006 to July 2012 (6 years 1 month) Tallahassee, FLSenior z/OS DB2 DBA and DB2 system programmer and team lead @ At the Florida Department of Management Services (DMS) performed senior z/OS DB2 DBA and DB2 system programming support activities. 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 aces and assist programmers with SQL performance tuning and problem determination. Implemented DB2 audit trace facility. Maintained 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. Installed ADABAS V7.4, Natural V4.1 and Predict V4.4. Also served as BearingPoint’s on-site Performance Manager for the Mainframe and database employee staff. Performed performance reviews and mentoring for six BearingPoint IT staff. Interface with client management. Participated in mainframe upgrade and capacity planning meetings. From 2003 to 2006 (3 years) Tallahassee, FlSenior DB2 Database Administrator @ 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. From March 2003 to November 2003 (9 months) Senior DB2 DBA and Senior DB2 System Programmer @ 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. From August 1993 to February 2003 (9 years 7 months) Berlin, CTSenior DB2 DBA and Senior DB2 System Programmer @ Senior z/OS (MVS) DB2 DBA
At United Technology Corporation (UTC) Sikorsky Aircraft and Hamilton Standard divisions, 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.
Senior DB2 Database Administrator (DBA) and Senior MVS System Programmer
At Sikorsky Aircraft Corporation 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. From May 1991 to August 1993 (2 years 4 months) Newington, CTSenior Database Consultant @ Senior DB2 Database Administrator (DBA)
At Northeast Utilities 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.
Senior DB2 and MVS System Programmer
At Ames Department Stores, Inc., 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 [email protected] and [email protected] 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. From August 1989 to May 1991 (1 year 10 months) Berlin, CTSenior Technical Consultant in Information Technology @ Technical Consultant in Information Technology
- Performed general technical controls review (MVS and RACF) at NYC based Consolidated Edison.
- Performed a Data Center and Telecommunications review at NYC based Depository Trust Company.
- Was an instructor for a three day Price Waterhouse DB2 class, "Managing, Controlling
and Auditing in a DB2 Environment".
- Developed an operations procedures manual at Park Ridge, NJ based SONY Corp of America.
Engagement included interviewing operations support personnel, created documentation
library, developed update procedures and implemented automated printing facilities. From March 1989 to August 1989 (6 months) New York, NYMVS and DB2 system programmer @ DB2 Systems Programmer
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.
MVS Systems Programmer
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 all MVS system utilities. From April 1984 to March 1989 (5 years) Syracuse, NY
Syracuse University From 1980 to 1984 Bachelor of Science (B.S.), Management Information Systems, General @ Syracuse University - Martin J. Whitman School of Management From 1980 to 1984 Mike Levine is skilled in: Data Warehousing, DB2, Performance Tuning, Database Design, Data Modeling, z/OS, SQL, Relational Databases, Unix, Database Administration, JCL, SDLC, Databases, Disaster Recovery, Microsoft SQL Server, AIX, SQL Tuning, Shell Scripting, Mainframe, DB2 LUW AUDIT facility..., UDB, KORN Shell scripting, backup and recovery, TSO, COBOL, MVS, VSAM, SPUFI, REXX, Fileaid, CICS, QMF, OS/390, IBM AIX
Looking for a different
Get an email address for anyone on LinkedIn with the ContactOut Chrome extension