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 SysPlex
· 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 zSystems 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 zFS 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
· Omegamon
· 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 SysPlex):
· Multiple Parallel SysPlex configuration
· DB2Plex
· CICSPlex
· Multiple physical z Systems machines
· Multiple Production LPAR environment
· General Processors / zIIP 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 DUTIES/RESPONSIBILITIES
· Install/Maintain/Configure the Db2 software and related Db2 ISV software
· Experience automating process using zOSMF
· 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
Software
Software needed for this position:
· zSystem Db2 SYSTEM Software:
o BMC AMI
o AbendAid for DB2,
o FileAid for DB2
o FileAid for Data Solutions
o DASDManager Plus for DB2
o High-Speed Apply Engine
o IBM SMP/E
o Extended Buffer Manager for Db2
o Db2 Assist
o LOADPLUS for Db2
o REORG PLUS for Db2
o Data Rep for Db2 for z/OS
o Db2 Accessories Suite for z/OS
o High Performance Unload
o Db2 Log Analysis Tool
o Db2 Utilities Suite
· Non-zSystem Db2 SYSTEM Software (awareness required):
o Qlink Replication
Job Types: Full-time, Permanent
Pay: ₹457,786.51 - ₹1,728,016.10 per year
Work Location: Hybrid remote in Noida