Db2 System Admin - Mississauga, Canada - International Talent Resources INC.
Description
Upgrade/Migrate DB2 Versions to newer versions- Manage DB2 IVS Products and upgrade to supported versions if required.
- Managing system catalogs
- 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
Salary:
Up to $70.00 per hour
Benefits:
- Dental care
Schedule:
- 8 hour shift
Experience:
- DB2: 10 years (required)
Work Location:
In person
More jobs from International Talent Resources INC.
-
Tech Lead
Toronto, Canada - 4 days ago
-
Functional Consultant
Toronto, Canada - 2 weeks ago
-
Oracle Cloud Consultant
Montréal, Canada - 3 weeks ago
-
Tech Lead
Brampton, Canada - 1 week ago
-
QA Analyst
Toronto, Canada - 1 week ago
-
Mainframe Admin Lead
Markham, Canada - 2 weeks ago