Mainframe DB2 System Programmer

Job Description

Required Information Details

1 Role Mainframe Db2 Admin

2 Required Technical Skill Set Install, upgrade, maintain and customize DB2 and its associated IBM and 3rd party software,

3 Desired Experience Range Create, modify and maintain the DB2 databases on z/OS environment

4 Location of Requirement PAN INDIA

Desired Competencies (Technical/Behavioral Competency)

Must-Have Install, upgrade, maintain and customize DB2 and its associated IBM and 3rd party software

• Monitor DB2 on z/OS environment

• Create, modify and maintain the DB2 databases on z/OS environment

• Technical system support for DB2 sub systems, database tools and utilities

• Support DB2 business, end user and application requirements.

• Monitors DB2 Regions across life cycles, take necessary remedial action as required.

• Reorganize and update statistics in the DB2 System Catalog tables.

• Perform regular housekeeping activities like administer the data server on which DB2 resides like monitoring disk space and the DB2 logs, Backups and protect the integrity of the data.

• Review all data models for technical accuracy. This includes the enforcement of all modeling and naming standards

• Perform all structural changes to DB2 databases

• Work with Buyer’s Security Administration to insure that proper security is in place for DB2 data

• Regularly review Automation and Dependency of systems tasks

• Manage and maintain data definitions for all prod and non-prod databases

• DB2 SQL performance tuning

• Perform Database backups, reorg and recovery

• DB2 Plan and Package management

• DB2 Database maintenance using utilities

• Assisting the developer teams in debugging DB2 related issues

Good-to-Have Perform Database backups, reorg and recovery

• DB2 Plan and Package management

• DB2 Database maintenance using utilities

• Assisting the developer teams in debugging DB2 related issues