Need L3 Level of candidate 12+ year experience
JD :- - 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
•
Last updated on Nov 9, 2023