AS400IBM i Infrastructure Analyst

Please Note: As of July 22 2021 our team will require that all candidate submissions include a LinkedIn profile. Please do not submit any candidates that do not have a LinkedIn.

The Role: We are seeking a highly skilled Mainframe DB2 Systems Administrator to manage and support DB2 for z/OS subsystems in a mission-critical enterprise environment. This role is responsible for installation configuration performance tuning and overall health of DB2 subsystems ensuring high availability security and optimal performance.

This role requires employees to live in or around the Phoenix AZ area.

You will be responsible to be onsite 3 days a week.

We will consider candidates who are willing to relocate to the area.

Responsibilities:

• DB2 Installation and Configuration Install configure and maintain DB2 for z/OS subsystems Perform version upgrades patching (PTFs/APARs) and system maintenance Manage subsystem configuration and initialization parameters
• Maintain core DB2 components: ZPARMs (DSNZPARM) Buffer pools Logs and BSDS Catalog and directory Performance and Capacity Management Monitor and tune DB2 system-level performance (CPU memory I/O) Optimize: Buffer pools Locking and concurrency Thread and connection performance
• Support capacity planning and performance analysis using DB2 and system tools High Availability and Data Sharing Manage and support: DB2 Data Sharing environments (Sysplex) Coupling Facility integration Workload balancing and failover Ensure DB2 availability and resilience through DR strategies
• System Maintenance and Troubleshooting Analyze and resolve: Subsystem failures Dumps logs and abends Connectivity issues affecting DB2 operations Perform root cause analysis and implement preventive actions Support interaction with: Batch (JCL) CICS IMS MQ and distributed systems

Required Skills : Required Qualifications: 7-12 years of mainframe experience 3-5 years in DB2 Systems Programming / Administration Experience with IBM DB2 for z/OS and Replication products (Qrep SQLrep and CDC) - software installation version upgrades and maintenance certification testing documentation of operational procedures disaster recovery testing Deep knowledge of: ZPARMs and subsystem configuration Buffer pools logs BSDS catalog/directory Strong troubleshooting skills for: System-level DB2 issues Performance and connectivity problems Proficiency in: JCL TSO/ISPF SDSF SMP/E (preferred) Preferred Qualifications: Familiarity with: DB2 utilities and performance tools Monitoring tools (OMEGAMON MainView) Knowledge of: DevOps tools for mainframe (Endevor ISPW etc.) Exposure to: Cloud integration or hybrid architectures Experience with: Large-scale DB2 upgrades or migrations Performance optimization initiatives Knowledge of: Modernization tools (z/OS Connect APIs) Experience with software support for BMC for DB2 Tools IBM z/OS Connect Software AG ADABAS and Natural products Programming experience with REXX Working knowledge of SQL JIRA SMP/E RACF TCP/IP Network certificates Splunk Working knowledge of other Mainframe Subsystems (CICS IMS MQ)

Basic Qualification :

Additional Skills :

Background Check : No

Drug Screen : No