Overview
Skills
Job Details
Role : Mainframe DB2 Systems Programmer
Location : Salisbury, NC/Boston, MA/Frisco, TX
DB2 Systems programmer: L3
Mainframe DB2 Systems Programmer to join our core infrastructure team. This critical role involves the installation, maintenance, and upgrade of IBM DB2 for z/OS subsystems, ensuring their optimal performance, availability, and stability. The successful candidate will work closely with DB2 DBAs, z/OS Systems Programmers, application development teams, and operations staff to provide expert-level support for our enterprise-wide DB2 environment.
Required Skills and Experience:
5-8 years of hands-on experience as a Mainframe DB2 Systems Programmer.
In-depth knowledge and hands-on experience with IBM DB2 for z/OS installation, configuration, maintenance, and migration (preferably including recent versions like DB2 12 or 13).
Strong proficiency in JCL, TSO/ISPF, and SMP/E.
Extensive experience with IBM DB2 utilities (COPY, RECOVER, REORG, RUNSTATS, LOAD, UNLOAD).
Proven experience with installation and support of leading DB2 ISV tools (e.g., BMC DB2 tools, Broadcom/CA DB2 tools, IBM DB2 Admin Tool, Omegamon for DB2).
Solid understanding of DB2 architecture, data sharing, buffer pool management, and logging.
Experience with DB2 performance monitoring, tuning, and problem diagnosis (e.g., reading traces, interpreting DSNZPARM settings).
Ability to read and interpret DB2 dumps for problem determination.
Proficiency in REXX, CLISTs, or other scripting languages for automation.
Familiarity with z/OS operating system fundamentals, including JES2/JES3, SMS, VSAM.
Excellent analytical, problem-solving, and troubleshooting skills.
Strong communication (written and verbal) and interpersonal skills, with the ability to collaborate effectively with various teams.
Ability to work independently and manage multiple priorities in a dynamic environment.
Desired Skills and Experience (Plus Points):
Experience with Parallel Sysplex and DB2 Data Sharing environments.
Knowledge of IBM MQ for z/OS, IMS, or CICS connectivity with DB2.
Experience with DB2 DDF (Distributed Data Facility) and remote connectivity.
Certifications related to DB2 for z/OS.