Mainframe DB2 System programmer

Responsibilities:-

· Upgrade/Migrate DB2 Versions to newer versions

· Regularly applying PTFS/APARS if required.

· Manage DB2 IVS Products and upgrade to supported versions if required.

· Managing system catalogs

· Manage application data and database environments, performing reorganizations when required to optimize performance

· Offline utilities - DSNJLOGF, DSNJU004, DSNJU003 etc.

· Database and related object security – manage user ids, rights and privileges

· DB2 administration on z/OS, SQL creation, DB2 command line creation and execution, DB2 performance tuning,

· Physical database definition (DDL) and understanding of logical database design

· Implement DBDC (CICS, DB2, or IMS) base software installs and upgrades

· Implement DBDC (CICS, DB2, or IMS) related product installs and upgrades

· Implement DBDC (CICS, DB2, or IMS) security compliance corrections

· Monitoring – threads, table space and index spaces.

· Monitoring instances for events and resolution/escalations

· Performance tuning – Database and SQL tuning

· DB2 recycle

· DB2 Image copy (full/incremental)

· Database creation

· Grant/revoke of authorities

· DB2 archive logs

· Having experience of DR setup through various synch methods

· Build and maintenance of database and related objects like table space, tables, indexes, views, triggers etc.

· Online utilities -CHECKDATA, COPY, QUIESCE, REPAIR, REORG, LOAD, UNLOAD etc.

Years of Experience

· Relevant : Minimum of 4 yrs in DB2 UDB on z/OS