Job Summary
z System Db2 Software Engineer OVERVIEW Experienced z System DB2 Infrastructure Software Engineer. SME-level knowledge of the installation/Software-System administration/support process starting with SMP/E through the removal of software components. REQUIREMENTS SME-level knowledge of the installation/software-system administration/support process starting with SMP/E through the removal of software components. Must have dedicated 15+ years’ experience in the following capabilities: Configuring and using the SMP/E tool Working with Db2 Logging and System Recovery/Disaster Recovery including GDPS Incorporating the DB2 Subsystem into the LPAR IPLs Working with DB2 Storage Groups Defining and implementing Performance features to Buffer Pools and other Db2 System level components Defining and maintaining Data Sharing environments including the DB2 Simple Downloading System Software from the vendor, installing Db2 and Db2 Administration Tools throughout the Tech, Test/Dev, and Prod environments including following all Change procedures, ensuring Application Developer testing, and the overall post implementation validation steps Basic requirements for a systems Db2 system programmer: Demonstrated knowledge and fully proficient in the use of TSO and ISPF Demonstrated knowledge of z/OS, primary operations console operations and commands Demonstrated understanding of JCL and ability to create and modify JCL job streams Demonstrated understanding of z/OS dataset configurations and the ability to properly allocate various dataset configurations Experience working with all types of z/OS file types and file systems Including PDS/PDSE and VSAM Has responsibility and capability to work multi-platforms including z/OS, LINUX, and Windows Practical understanding of SMPE and how to use it Experience with ziffs including allocation and related Unix commands to manage the space Experience working with ITSM processes including Incidents, Change and related processes Familiarity with Configuration Manager a plus Ability to work independently Interprets policies and applies experience Ability to work as a team player in both a partner role and mentor as appropriate Experience working with Vendors to create/manage support tickets including describing the issues, gathering, packaging and uploading documentation and follow up as needed Fully proficient on use of enterprise z System monitoring tools Omega Mon MXG Splunk Ability to use AI tools to analyze data and provide recommendations and implement solutions Ability to use M365 Copilot AI to recap meetings and draft emails Ability to stay educated in the role of AI for a System Programmer 10+ years of mainframe systems experience, with specific concentration in the Db2 Software Administration/PLM area, working in a large z Systems environment (90,000+ MIPs, Multiple LPARs, Multiple Simple): Multiple Parallel Simple configuration DB2Plex Cusplet Multiple physical z Systems machines Multiple Production LPAR environment General Processors / zip Processors Proven ability to cover the 24x7 on-call rotation Available for the on-call frequencies based on team size Ability to work in an atmosphere with heightened pressure and visible to all levels of Leadership Ability to work effectively in an Incident ‘War Room” scenario partnering with other teams on the initial root cause determination Ability to follow all processes and procedures in this environment
Key Responsibilities
Install/Maintain/Configure the Db2 software and related Db2 ISV software
Experience automating process using zoom
Experience recovering the Db2 environment in a Disaster Recovery environment
Demonstrates knowledge in all areas of z System Db2 Software administration
Designs and documents technical solutions required to support complex business system and/or integrations
Generate documentation for use by Computer Operations as well as the Technical Help Desk:
Install and support latest releases of Db2 software
z Systems Infrastructure/Platform lifecycle management (the lifecycle of Db2 Software from planning, through operation, and disposal or end-of-life)
Experience applying all types of vendor Db2 software fixes:
High-impact pervasive (HIPER)
PTF Pre-requisite fix
Co-requisite fix
Technical Refresh Requisite Fix
Distribution requisite fix
Cumulative PTF packages
Service packs
Authorized Program Analysis Report (APAR)
Program Temporary Fix (PTF)
Proven ability to
Break complex topics into meaningful pieces of information
Sort through large amounts of data to assess for relevancy
Seek out multiple sources to gather information
Identify cause and effect relationships between known and unknown variables
Evaluate quality processes and seeks opportunities to streamline
Consider the customer experience, business impact and solution objective when managing risks and development and design of solutions
Pro-actively identify patterns in issues and research root-cause to improve overall quality
Holding self-accountable for meeting high performance standards and agreed upon commitments
Taking responsibility for outcomes of actions and decisions
Identify and analyzes options and selects course of action based on best fit with desired outcomes
Monitor and analyze multiple systems and researching/proposing solutions to issues
Skill Requirements
Software
Software needed for this position:
system Db2 SYSTEM Software:
BMC AMI
Abend Aid for DB2,
File Aid for DB2
File Aid for Data Solutions
DAS Manager Plus for DB2
High-Speed Apply Engine
IBM SMP/E
Extended Buffer Manager for Db2
Db2 Assist
LOADPLUS for Db2
REORG PLUS for Db2
Data Rep for Db2 for z/OS
Db2 Accessories Suite for z/OS
High Performance Unload
Db2 Log Analysis Tool
Db2 Utilities Suite
Non-system Db2 SYSTEM Software (awareness required):
Qlik Replication