Mainframe DB2 Consultant
W3Global
Date: 3 weeks ago
City: Toronto, ON
Contract type: Contractor
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
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
How to apply
To apply for this job you need to authorize on our website. If you don't have an account yet, please register.
Post a resumeSimilar jobs
Track Inspector
RailWorks Corporation,
Toronto, ON
CA$42.72
per hour
16 hours ago
Position SummaryReporting to the Track Inspection Supervisor, the Track Inspector is responsible for conducting regulatory and non-regulatory track asset inspections, reporting deficiencies, and assisting Track Department in scoping out Maintenance and Capital activities. The track inspector will be responsible for identifying and communicating any outlying issues directly inhibiting the track infrastructure in meeting customer railway standards. The position will be...
Analyst
Labatt Breweries Canada,
Toronto, ON
1 day ago
Dreaming big is in our DNA. It’s who we are as a company. It’s our culture. It’s our heritage. And more than ever, it’s our future. A future where we’re always looking forward. Always serving up new ways to meet life’s moments. A future where we keep dreaming bigger. We look for people with passion, talent, and curiosity, and provide...
Financial Crime Risk Management Investigator I, FIU Transformation (2372)
TD Bank,
Toronto, ON
CA$59,500
-
CA$84,000
per year
1 day ago
Work Location: Toronto, Ontario, Canada
Hours: 37.5
Line of Business: Financial Crime Risk Management
Pay Details: $59,500 - $84,000 CAD
TD is committed to providing fair and equitable compensation opportunities to all colleagues. Growth opportunities and skill development are defining features of the colleague experience at TD. Our compensation policies and practices have been designed to allow colleagues to progress...
