DB2 Systems Programmer

Job Description:

• Administer a large Db2 Data Sharing Production and Test environment (Sysplex mainframe environment, Multiple CECs & LPARS)
• Administer 3rd-party systems software
• Create new and/or modify existing Db2 subsystems in support of new applications or Db2 architecture re-engineering initiatives
• Provide problem resolution, including diagnosis and root-cause analysis of Db2 application software problems, configuration and/or software-related problems. Ability to resolve Production DB2 issues quickly and effectively 
• Installing, customizing and maintenance of Db2 V12 Function Levels to maintain a reliable and stable infrastructure, monitor and tune buffer pools and manage zParm configurations
• Exposure to Db2 tools such as Log Analyzer, SQL Performance Analyzer, OPTIM and BMC's suite of tools for Db2. Additional experience in general support of z/OS operating systems as well as associated program products is highly desired
• Working knowledge SMPE, IBM DB2 tools, JCL, System maintenance and patching
• Experience supporting high throughput OLTP and batch applications  
• Working knowledge of DB2Connect and DDF workflow
• Working knowledge of DB2 stored procedures
• In-depth knowledge of ISPF, JCL, SQL, and DB2 utilities
• Working knowledge of DB2 data replication (CDC) is a plus
• Proficiency in the use of DB2 monitoring tools (Omegamon, Query Monitor)
• On-call rotation / weekend work required