Mainframe DB2 System programmer Admin

1 month ago


Mississauga ON, Canada Epsilon Solutions Ltd. Full time

Job title :- Mainframe DB2 System programmer Admin

Location :- Mississauga, ON (Remote )

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

Thanks and Regards

Saurabh Srivastava

Account Manager

E: Saurabh.srivastava@epsilonsolutions.ca #J-18808-Ljbffr

  • Mississauga, Canada Epsilon Solutions Ltd. Full time

    Job title :- Mainframe DB2 System programmer AdminLocation :- Mississauga, ON (Remote )JD :-Upgrade/Migrate DB2 Versions to newer versionsRegularly applying PTFS/APARS if required.Manage DB2 IVS Products and upgrade to supported versions if required.Managing system catalogsManage application data and database environments, performing reorganizations when...


  • Mississauga, Canada Epsilon Solutions Ltd. Full time

    Job title :- Mainframe DB2 System programmer AdminLocation :- Mississauga, ON (Remote )JD :-Upgrade/Migrate DB2 Versions to newer versionsRegularly applying PTFS/APARS if required.Manage DB2 IVS Products and upgrade to supported versions if required.Managing system catalogsManage application data and database environments, performing reorganizations when...


  • Mississauga, Canada Epsilon Solutions Ltd. Full time

    Job title :- Mainframe DB2 System programmer AdminLocation :- Mississauga, ON (Remote )JD :-Upgrade/Migrate DB2 Versions to newer versionsRegularly applying PTFS/APARS if required.Manage DB2 IVS Products and upgrade to supported versions if required.Managing system catalogsManage application data and database environments, performing reorganizations when...

  • Db2 System Admin

    19 hours ago


    Mississauga, Canada International Talent Resources INC. Full time

    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...


  • Toronto, ON, Canada Line Reflection Full time

    Position: Mainframe Developer-Java/CAP/Angular/DB2/IMS/VSAMLocation: Toronto,Canada.Work Shift: 9:00 AM to 5:00 PM ESTWeekly Schedule: Monday to FridayWork Mode: Hybrid (1-2 days office presence required weekly, remote for the rest)Contract Duration: Minimum one yearRequirements: Must be a resident of Toronto, Canada, and hold a valid work permit.Salary:...


  • Toronto, ON, Canada Line Reflection Full time

    Position: Mainframe Developer-Java/CAP/Angular/DB2/IMS/VSAMLocation: Toronto,Canada.Work Shift: 9:00 AM to 5:00 PM ESTWeekly Schedule: Monday to FridayWork Mode: Hybrid (1-2 days office presence required weekly, remote for the rest)Contract Duration: Minimum one yearRequirements: Must be a resident of Toronto, Canada, and hold a valid work permit.Salary:...

  • DB2 Admin

    3 weeks ago


    Toronto, ON, Canada Epsilon Solutions Ltd. Full time

    Job Title: DB2 Admin Location: Toronto, ON Required Skills Database Administration, who cares deeply about the security, stability, and performance of databases (predominantly DB2 and Mongo) Perform Database Installs and Upgrades and config changes. Install IBM TSA /Pacemaker and manage IBM Replications Monitor DATABASE Performance and tune as...


  • Toronto, ON, Canada Ad Analytica Full time

    Location: Toronto,Canada.Work Shift: 9:00 AM to 5:00 PM ESTWeekly Schedule: Monday to FridayWork Mode: Hybrid (1-2 days office presence required weekly, remote for the rest)Contract Duration: Minimum one yearRequirements: Must be a resident of Toronto, Canada, and hold a valid work permit.Salary: Negotiable (Canadian Dollar), attractive package for skilled...


  • Toronto, ON, Canada Ad Analytica Full time

    Location: Toronto,Canada.Work Shift: 9:00 AM to 5:00 PM ESTWeekly Schedule: Monday to FridayWork Mode: Hybrid (1-2 days office presence required weekly, remote for the rest)Contract Duration: Minimum one yearRequirements: Must be a resident of Toronto, Canada, and hold a valid work permit.Salary: Negotiable (Canadian Dollar), attractive package for skilled...


  • Toronto, ON, Canada Line Reflection Full time

    Position: Mainframe Developer-Java/CAP/Angular/DB2/IMS/VSAM Location : Toronto,Canada. Work Shift: 9:00 AM to 5:00 PM EST Weekly Schedule: Monday to Friday Work Mode: Hybrid (1-2 days office presence required weekly, remote for the rest) Contract Duration: Minimum one year Requirements: Must be a resident of Toronto, Canada, and hold a valid work...


  • Toronto, ON, Canada Ad Analytica Full time

    Location : Toronto,Canada. Work Shift: 9:00 AM to 5:00 PM EST Weekly Schedule: Monday to Friday Work Mode: Hybrid (1-2 days office presence required weekly, remote for the rest) Contract Duration: Minimum one year Requirements: Must be a resident of Toronto, Canada, and hold a valid work permit. Salary: Negotiable (Canadian Dollar), attractive...


  • Toronto, ON, Canada TekStaff IT Solutions Full time

    This is a 12 month contract located in Toronto, ON/ Hybrid (once or twice a week)Candidate Requirements/Must-Have skills: 1. 8-10+ years of experience developing and managing reporting solutions. 2. 7+ years of hands-on experience in building data pipelines using tools like Mainframe/TSO (JCL/ PROC, ISPF), Mainframe SAS with exposure to SQL based analysis on...

  • Mainframe Developer

    3 weeks ago


    Toronto, ON, Canada Infotek Consulting Services Inc. Full time

    Infotek Consulting is searching for a mainframe developer with solid SAS experience Project: The team is seeking as Database Analyst/Programmer to support the Bank’s software upgrade as part of compliance. o Supports the SAS upgrade projects within GOCT as an expert with ability to provide leadership. o Supports enhancements to SAS and Mainframe based...

  • Mainframe Developer

    3 weeks ago


    Toronto, ON, Canada Infotek Consulting Services Inc. Full time

    Infotek Consulting is searching for a mainframe developer with solid SAS experience Project: The team is seeking as Database Analyst/Programmer to support the Bank’s software upgrade as part of compliance. o Supports the SAS upgrade projects within GOCT as an expert with ability to provide leadership. o Supports enhancements to SAS and Mainframe based...

  • Mainframe Developer

    1 week ago


    Toronto, ON, Canada Infotek Consulting Services Inc. Full time

    Infotek Consulting is searching for a mainframe developer with solid SAS experience Project: The team is seeking as Database Analyst/Programmer to support the Bank’s software upgrade as part of compliance. o Supports the SAS upgrade projects within GOCT as an expert with ability to provide leadership. o Supports enhancements to SAS and Mainframe based...

  • Mainframe Developer

    1 week ago


    Toronto, ON, Canada Infotek Consulting Services Inc. Full time

    Infotek Consulting is searching for a mainframe developer with solid SAS experience Project: The team is seeking as Database Analyst/Programmer to support the Bank’s software upgrade as part of compliance. o Supports the SAS upgrade projects within GOCT as an expert with ability to provide leadership. o Supports enhancements to SAS and Mainframe based...

  • Mainframe Developer

    3 weeks ago


    Toronto, ON, Canada Icon Technologies Full time

    We are looking for an outstanding Splunk Data Scientist/API Developer to join our innovative team. In this key role, you will utilize your skills in data science and API management to drive innovation and enhance our analytical capabilities in cybersecurity and observability. This is a unique opportunity to work on the cutting edge of data-driven technology,...

  • Mainframe Developer

    3 weeks ago


    Toronto, ON, Canada Icon Technologies Full time

    We are looking for an outstanding Splunk Data Scientist/API Developer to join our innovative team. In this key role, you will utilize your skills in data science and API management to drive innovation and enhance our analytical capabilities in cybersecurity and observability. This is a unique opportunity to work on the cutting edge of data-driven technology,...


  • Toronto, ON, Canada TekStaff IT Solutions Full time

    This is a 12 month contract located in Toronto, ON/ Hybrid (once or twice a week) Candidate Requirements/Must-Have skills: 1. 8-10+ years of experience developing and managing reporting solutions. 2. 7+ years of hands-on experience in building data pipelines using tools like Mainframe/TSO (JCL/ PROC, ISPF), Mainframe SAS with exposure to SQL based...

  • Mainframe Developer

    2 weeks ago


    Toronto, ON, Canada Akkodis Full time

    Position:- Mainframe DeveloperLocation:-Toronto, ONJob Type:- ContractCandidate Requirements/Must-Have skills:1. 8-10+ years of Development experience.2. 7+ years of hands-on experience in building data pipelines using tools like Mainframe/TSO (JCL/ PROC, ISPF) and Mainframe SAS.3. Expert knowledge of Mainframe (JCL/PROC) and SAS.4. Previous exposure to...