Database Administrator

Mainframe DB2 SYSTEMS & DBA

Eligibility Criteria:

Total years of experience: 8.5 - 10 years

Location: Noida

Notice Period: Immediate - 15 days

Technical Specifications

- DB2 for z/OS

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

• Strong knowledge of DB2 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 DB2 Utilities JCL, execution, restart, an understanding of utility impact on DB2 object availability

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

. Conversion of non UTS to UTS

. Performance tuning of long running threads and batch job tuning

• Knowledge of SQL and basic DB2 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 DB2 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.

If you are interested, please apply using the below link:

https://forms.office.com/r/cYEqdKcECE