Description

You will manage and maintain DB2 databases in high-transaction production environments.

Responsibilities

• Tune SQL performance, manage DSNZPARM, and utilize DB2 utilities for high availability.
• Design, model (logical/physical), and implement database backup, recovery, and DR plans.
• Develop and maintain Stored Procedures, Triggers, and enforce Referential Integrity.
• Operate and monitor DB2 using tools like Data Studio, Query Monitor, and OPTIM.

Required Skills

• 10+ years of experience with DB2 z/OS 12+.
• Expert proficiency in SQL and DSNZPARM tuning.
• Strong knowledge of mainframes, including TSO/ISPF, JCL, and REXX.
• Experience with DFSORT and mainframe utilities.
• Ability to perform database design and modeling.
• Familiarity with DB2 Admin/Automation Tool.

Preferred Skills

• Experience with IMS DB or ETL tools like Informatica/InfoSphere.
• DB2 Certification.

Key Skills

Education

Any Gradute