IBM Engineer

Collabera
Chicago, United States of America
4 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 130K

Job location

Remote
Chicago, United States of America

Tech stack

Systems Engineering
Customer Information Control System (CICS)
IBM DB2
Database Queries
Disaster Recovery
Mainframes
Performance Tuning
Z/OS
Sql Tuning

Job description

We are looking for 2 Sr. Mainframe DB2 Logical Engineers to install, maintain, and support mainframe DB2 software within a complex z/OS environment. This is an individual contributor role focused on DB2 logical design, performance tuning, and serving as the primary liaison to application teams on DB2 best practices. Candidates need deep hands-on experience with DB2 system management functions, SQL tuning, and supporting customer transitions and disaster recovery activities. Day to Day:

  • Install, maintain, and upgrade mainframe DB2 software, including patches and product maintenance
  • Tune SQL statements, analyze access paths, and recommend index/query changes
  • Identify and resolve performance, locking, and concurrency issues across DB2 and related online environments (CICS/IMS)
  • Manage data migrations using DB2 utilities (LOAD, UNLOAD, REORG)
  • Serve as primary liaison to application teams on DB2 logical design and best practices
  • Implement and manage DB2 GRANT/REVOKE structures for secure, compliant access, o mainframe o DB2 o IBM o CICS o IMS o LOAD o UNLOAD o REORG o z/OS o installation o maintain o upgrade

Requirements

  • 10+ years Mainframe experience, including hands-on project work within the space

  • Bachelor's degree + 5 years of IT engineering experience performing DB2 system management functions (installs, upgrades, maintenance, configuration, administration), OR 9 years of IT engineering experience including 5 years in DB2 system management

  • Hands-on experience installing, maintaining, and supporting mainframe software products on mainframes (z/OS)

  • Primary support experience for DB2, QMF, and related OEM software products

  • Strong ability to analyze and resolve DB2 logical and data-related issues, including performance and query behavior

  • Experience with DB2 utilities (LOAD, UNLOAD, REORG) for data migrations Plusses:

  • Managed Services experience, per Jon's request

  • Knowledge of IMS

  • Knowledge of Assembler

Apply for this position