Mainframe DB2 System programmer

Responsibilities:Upgrade/Migrate DB2 Versions to newer versionsRegularly applying PTFS/APARS if requiredManage DB2 IVS Products and upgrade to supported versions if requiredManaging system catalogsManage application data and database environments, performing reorganizations when required to optimize performanceOffline utilities - DSNJLOGF, DSNJU004, DSNJU003 etc.Database and related object security manage user ids, rights and privilegesDB2 administration on z/OS, SQL creation, DB2 command line creation and execution, DB2 performance tuningPhysical database definition (DDL) and understanding of logical database designImplement DBDC (CICS, DB2, or IMS) base software installs and upgradesImplement DBDC (CICS, DB2, or IMS) related product installs and upgradesImplement DBDC (CICS, DB2, or IMS) security compliance correctionsMonitoring threads, table space and index spacesMonitoring instances for events and resolution/escalationsPerformance tuning Database and SQL tuningDB2 recycleDB2 Image copy (full/incremental)Database creationGrant/revoke of authoritiesDB2 archive logsHaving experience of DR setup through various synch methodsBuild 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:Total: Above 5+ Years of experienceRelevant: Minimum of 4 yrs in DB2 UDB on z/OS #J-18808-Ljbffr