DB2 Systems Programmer

NTT DATA Services•Buffalo, NY

4d•$106,575 - $142,100•Hybrid

About The Position

NTT DATA is seeking a DB2 Systems Programmer to join the DB2 Support Team in Buffalo, New York. This hybrid role involves undertaking all system programming aspects of DB2 for z/OS within a large environment of over 50 DB2 subsystems across various mainframes and geographies. The primary focus will be on ensuring the performance, integrity, maintenance, and security of the database estate in the US. Responsibilities include planning and development of databases, troubleshooting issues, and providing support for applications using DB2.

Requirements

Ability to provide 2nd and 3rd level support for production incidents and application issues.
Knowledge of DB2 security administration, access control, user authorization, and audit requirements.
Good understanding of mainframe technologies such as z/OS, CICS, JCL, TSO/ISPF, RACF, SMP/E, VSAM, SDSF, and batch processing.
Experience with DB2 performance and monitoring tools (OMEGAMON, IBM DB2 Query Monitor, BMC, CA/Broadcom, RMF, SMF, or similar tools).
Strong communication skills with the ability to work with technical, application, operations, and business teams.
10+ years of experience as a DB2 Systems Programmer, in a mainframe/z/OS environment.
7+ years of hands-on experience with DB2 installation, migration, testing, maintenance, and/or troubleshooting.
7+ years of DB2 performance monitoring, tuning, subsystem parameters, and/or workload management.
7+ years of experience with DB2 backup, recovery, archiving, storage management, and/or disaster recovery procedures.
3+ years of experience supporting CICS-DB2 OLTP environments.
3+ years of experience supporting distributed DB2 connectivity and application interfaces.

Nice To Haves

Experience with DB2 data sharing, high availability, disaster recovery testing, and Parallel Sysplex.
Knowledge of automation or scripting using REXX, CLIST, JCL, or scheduling tools.
Experience working in enterprise production support environments with formal change, incident, and problem management processes.

Responsibilities

Install and test new versions of DB2
Provide 2nd and 3rd Level Support for applications that use DB2.
Ensure support and management of distributed DB2 connections.
Ensure stability and integrity of a highly responsive OLTP (CICS) DB2 environment.
Establish the needs of users and monitor user access and security
Monitor performance and manage parameters in order to provide fast responses to front-end users
Develop, manage and test back-up and recovery plans
Ensure that storage and archiving procedures are functioning correctly
Carry out capacity planning
Communicate regularly with technical, applications and operational staff to ensure database integrity and security
Manage the security and disaster recovery aspects of a database.
Ensure there is provision for data security and recovery control (ensuring all data is retrievable in an emergency).
Ensure that we use supported versions for all database and monitoring solutions.