Mainframe IMS and DB2

Job Description

 Please find the job description 

Pan India : Hyderabad, Chennai, Bangalore, Pune, Mumbai, Gurgaon.

·         Strong knowledge of IMS Database Manager, DBD source and generation, understanding of Database Recovery Control [DBRC] information and commands, BMP and basic DL/I coding imbedded in COBOL source.

·         Familiarity with IMS Transaction Manager, including basic control region and message region processing, PSB coding and generation, and ACB, MODBLKS, and FORMAT generation.  FORMAT coding is a plus, but not required.  A basic knowledge of Control Region commands for monitoring Sub-systems, Regions, Databases, and Transaction Queues is required. 

·         Strong working knowledge of HALDB partitioning schemes and underlying structures.   Ability to backup and restore and maintain partitions. 

·         Familiarity with IMS Utility JCL, execution, restart, commands for Database allocation changes, and IMS Database backup and recovery techniques.

- DB  for z/OS

·         Strong knowledge of DB   backup and recovery techniques.  Ability to recover DB2 databases as necessary.

·         Strong knowledge of DB  Bind plans and packages and associative permission necessary to implement and execute plans with appropriate application ID’s

·         Strong DB2 Catalog knowledge [Basic catalog table familiarity, ability to perform querying of dependencies, understanding of DB2 security administration including Grants, Revokes, and a basic knowledge of required authorities for application development including Bind, Plans, Packages, Stored Procedures, and Database level authorities permitting utilities, tablespace and table creation]

·         Familiarity with DB Utilities JCL, execution, restart, an understanding of utility impact on DB object availability

·         Understanding of DB Data Definition Language [DDL] constructs is required and experience with DB Administration tool or similar tool is a plus.

·         Knowledge of SQL and basic DB development techniques used in application coding.  Ability to understand COBOL and SQL/PL for analysis and partnering with application area personnel.

- z/OS, TSO, ISPF, JCL, and SDSF

·         Coding and debugging z/OS mainframe batch jobs, the applicant’s work and for application development team members needing assistance is required.  JCL knowledge is a must as is basic ISPF menu and TSO development experience.

·         Familiarity with RACF, rules protecting datasets, and how RACF interacts with both IMS and DB  instances is a plus.

·         Knowledge of source code editor commands, library maintenance, ISPF menus, listing of cataloged dataset information, TSO job scheduling, and the ability to read JES output from jobs to diagnose issues is required.  Experience with System Display and Search Facility [SDSF] or other z/OS JES output control facility is a plus.