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
• Online utilities -CHECKDATA, COPY, QUIESCE, REPAIR, REORG, LOAD, UNLOAD etc.

Years of Experience:-

• Total : Above 8+ Years of experience.
• Relevant : Minimum of 8 yrs in DB2 UDB on z/OS.