IMS/DB2 System Administration
Job Overview
Job title: IMS/DB2 System Administration
Job description: 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
(1.) To independently resolve tickets and esnure that the agreed SLA of ticket volume and time are met for the team.
(2.) To provide support for on call escalations orL3 level support and doing incident and problem management
(3.) Work on value adding activities such Knowledge base update and management, Training freshers, coaching
Company: Zortech Solutions
Expected salary:
Location: Canada
Job date: Fri, 21 Oct 2022 22:23:43 GMT
Job Source: Careerjet.ca