Thomas Cox Email & Phone Number

Charlotte, Nc, Us

Charlotte, Nc, Us

Jersey City, Nj, Us

 Database Engineering/Administration for Db2 databases on the mainframe environments Extremely proficient with SMP/E for product installations and maintenance Db2 12 upgrade for 13 Db2 subsystems on 8 different LPARs Review and modify Db2 ZPARM definitions as required Review, analysis, and tuning of production environments for performance improvements Problem analysis and troubleshooting for any outages experienced Collaboration with application teams for data management (loads, unloads, reorgs, etc.) Assisted application teams with Db2 issues, questions, or concerns  Assisted mainframe engineering team with software installations Install/Upgrade/FixPacks for Db2 and Db2 Connect on LUW

New York, Ny, Us

 VP/Manager of the DB2 engineering team with 3 offshore and 3 onshore engineers Provide guidance and mentoring for team members Project manager assigning and managing all projects for the Db2 database engineers Change management approver for all changes introduced to all environments Installation, maintenance, and support of DB2 and related products on all environments Assisted DBA’s with DB2 requests and analysis for problems Client collaboration with the business to deliver expected requirements  Set annual goals and performed employee performance evaluations and reviews  Member of the VP nominating committee to put employees up for promotion  Published in house documentation outlining policies and procedures

San Jose, California, Us

 Technical lead of the mainframe service delivery environment and 9 systems programmers Responsible for maintaining a zEC12 mainframe running R&D, a z196 running production, and a z10 running legacy, a total of 38 LPARs consisting of z/OS and z/VM Installation, maintenance, and support of z/OS on production and legacy systems Upgraded operating systems from z/OS 1.10 up to z/OS 1.13 Installation, maintenance, and support of DB2 database on production systems Installation, maintenance, and support of CICS/TS on production systems Published in house documentation outlining policies and procedures Extremely proficient with SMP/E for product installations and maintenance WLM modifications adjusting service classes, classification rules for tasks to produce better performance, define application environments for DB2 stored procedures WLM APPLENV wild-carding put in place to eliminate the need for multiple definitions  SMS modifications setting up the different classes and groups via ISMF panels. Coding ACS routines, translating, validating, and activating Administered UNIX Systems Services via OMVS, ISHELL, and TELNET  Communication Server changes, TCPIP modifications, VTAM definitions, TRL definitions TCPIP DVIPA definitions for DB2 data sharing, load balancing, and high availability INFOBLOX updates to assign DNS entries to associated IP addresses Assisted DBA’s with DB2 database requests and problems Assisted R&D with any operating system issues or software related problems  Published in house documentation outlining policies and procedures

 Responsible for maintaining a z10 mainframe running 3 z/OS partitions and 4 z/VM systems with Suse Linux Enterprise Servers running within Installation, maintenance, and support of z/OS on development and production systems Installation, maintenance, and support of DB2 on development and production systems. Build new subsystems as required Perform all DB2 9.1 database administration and LINUX administration for the SAP implementation Modify DSNZPARM and DSNHDECP definitions as needed Create storage groups, databases, tablespaces, tables, and indexes. Performed binds, and grants of plans and packages. Monitoring and tuning of bufferpools as needed DB2 flashcopy implementation via SMS using copypools Monitor DB2 subsystems and diagnose problems for quick resolutions Running of REORGS and RUNSTATS when required Running DSNJU003 for BSDS updates when needed, DSNJU004 to show BSDS and LOGCOPY information, DSN1SMFP to analyze DB2 SMF data Running of DSN1CHKR to verify catalog integrity and DSN1COPY to copy DB2 datasets Extremely proficient with SMP/E for product installations and maintenance Assist SAP developers with DB2 and LINUX requests and problems Publish in-house documentation outlining policies and procedures

Us

 Team lead of the mainframe environment and 3 systems programmers. Installation, maintenance, and support of z/OS on production and development systems Upgraded operating systems from z/OS 1.4 up to z/OS 1.10 Installation, maintenance, and support of DB2 on production and development systems Build new subsystems as required Migrated all DB2 database subsystems from 7.1 up to 9.1 Installation, maintenance, and support of CICS/TS on production and development systems. Build new regions as required Upgraded all CICS regions from 1.3 up to 3.2 Upgraded all WebSphere environments from 6.0 to 7.0 Assisted applications with DB2, z/OS,CICS, and WebSphere requests or problems Assisted end users with any operating system issues related to the business Administered UNIX Systems Services via OMVS, ISHELL, and TELNET Security administrator defining users, modifying profiles and classes WLM modifications by adjusting service classes, classification rules for tasks to produce better performance  SMS modifications setting up the different classes and groups via ISMF panels. Coding ACS routines, translating, validating, and activating DASD management assigning and taking back volumes as needed. IODF configuration via the HCD panels Communication Server changes, TCPIP modifications, VTAM definitions, USSTAB Project manager for all mainframe tasks. Created plans and set timelines and milestones  Coordinator for disaster recovery testing. Work with Sungard staff on requirements prior to test date. Code all JCL for backups, restores, or formats  Set up CPU for sub capacity pricing by adjusting the weights to 50%. Implemented SCRT creating monthly reports for IBM to produce a cost savings of $400,000 annually  Evaluate new software products that might be beneficial to our needs Software product replacement resulting in a cost savings of $200,000 annually Write annual reviews and performance appraisals

New York, Ny, Us

 Manager of the mainframe environment and 3 systems programmers Installation, maintenance, and support of z/OS on production and development systems. Upgraded operating systems from z/OS 1.4 to 1.7 Installation, maintenance, and support of DB2 on production and development systems. Build new subsystems as required Migrated all DB2 database subsystems from 7.1 to 8.1 Modify DSNZPARM and DSNHDECP definitions ad needed Create storage groups, databases, tablespaces, tables, and indexes. Perform binds and grants of plans and packages. Monitor DB2 subsystems with TMON and diagnosed problems for quick resolutions Use of BMC LoadPlus, CopyPlus, and ReorgPlus Installation, maintenance, and support of CICS/TS on production and development systems. Build new regions as required Upgraded CICS regions from 1.3 up to 3.1 Assisted DBA’s with DB2 requests and problems Assisted applications with DB2, z/OS, and CICS requests or problems Assisted end users with any operating system issues related to the business Coordinator for disaster recovery testing. Work with Sungard staff on requirements prior to test date. Data replication from home site to Sungard every 2 hours Evaluate new software products that might be beneficial to our needs Project manager for all mainframe tasks. Created plans and set timelines and milestones Write annual reviews and performance appraisals Approve change control requests for any mainframe updates Responsible for fiscal year budgets for all software and hardware Responsible for SOX compliance and working with auditors

Fort Lauderdale, Florida, Us

 Provide pre sales support to field SE’s, tech managers, and sales force Reproduce and troubleshoot client issues in-house and provide solutions On-site visits to clients for installations, problem resolution, and performance/tuning Installation and evaluation of new releases of our products as they become available Install products on MVS, z/OS USS, Linux, UNIX, and Windows platforms

Fort Lauderdale, Florida, Us

 Supervisor of all database environments and 3 systems programmers Set up DB2 Data Sharing environment across all LPARs in the Sysplex Responsible for all database products running on all platforms  Installation and maintenance of all software using SMP/E  Work with software vendors to order current releases of the products Work with other supervisors in computer services on various issues within our group  Work with managers, directors, and VP’s from the user community to satisfy requests Created in-house database procedures manual

San Jose, California, Us

 Responsible for two MVS 4.3 systems used for demos and education Worked closely with the sales force for product demos and the field SE’s for education Installation, maintenance, and support of CICS, DB2, IMS, QMF, IBM program products, and CA products that were used on our production, test, demo, and education systems Interface with Level 1 and Level 2 support and product development Worked in Level 1 a couple of years doing software support, research, and troubleshooting for clients using Computer Associates software

New York, Ny, Us

New York, New York, Us