Mainframe Administrator

Mainframe DB2 Systems Programmer Phoenix, AZ (Hybrid) Plano, TX Charlotte, NC Richmond, VA Jacksonville Beach, FL Pennington, NJ Chicago, IL 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. Responsibilities: DB2 Installation & 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 & 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 & 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 & 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 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) Best Regards, Naresh J | Team Lead M 732 640 5076 | Jnaresh@ipolarityllc.com https://www.linkedin.com/in/naresh-janapati-53ab8576/ 200 Centennial Ave, Suite 204, Piscataway, NJ 08854 Flexible work from home options available. WELCOME TO IPOLARITY LLC IPolarity LLC. is a Professional Services firm composed of highly trained professionals with a wide range of experience in various industries. We provide our clients in key industry verticals with focused expertise in IT Solution, Application Development, Application Maintenance, Testing services and Systems Integration. IPolarity LLC integrates expert industry knowledge, process and technology frameworks, strong partnerships, and a reliable work force to provide strategic solutions that generate sustainable results. We are able to leverage our expertise via a flexible delivery model, which includes onsite and offsite resources.