DB2 Mainframe IMS Administrator

CloudVital

Toronto

On-site

CAD 80,000 - 100,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

A leading software development firm in Toronto seeks a skilled DB2 Mainframe IMS Administrator. Responsibilities include database administration, tuning, and development. The ideal candidate will have experience with IMS/DB2 to Oracle replication and large-scale database systems development. This full-time role requires collaboration across multiple testing environments and offers a dynamic work environment.

Qualifications

  • Experience with IMS/DB2 to Oracle replication is required.
  • Extensive experience with large-scale database systems development is essential.
  • Experience with database development including stored procedures and programming languages is necessary.

Responsibilities

  • Participate in review of project and maintenance release artifacts.
  • Prepare and implement database changes according to design.
  • Promote database changes through various testing environments.
  • Maintain and tune performance of databases including IMS and DB2.

Skills

Experience with IMS/DB2 to Oracle replication
Database development (stored procedure, PL/SQL, PL/I, Cobol, Assembler)
Large-scale database systems development
Capacity planning
Maintenance and performance tuning

Job description

We are looking for a highly skilled DB2 Mainframe professional for one of the leading firms.

Job Title

DB2 Mainframe IMS Administrator

Job Type

Full-Time/Contract

Responsibilities
  • Participate in review of project and maintenance release artefacts – Use Case, System
  • Prepare and implement database changes according to design
  • Promote database changes through Development, Integration Testing, QA, UAT, Production
  • Prepare, install, configure Operating Systems, databases and database patches
  • Maintain, administrate, tune performance of databases, e.g., IMS, DB2, Oracle
  • Provide database space calculations for the supported database environments
  • Perform reference data administration as required
  • Design and write data loading and/or conversion scripts/stored procedures
  • Maintain and enhance Mainframe to Oracle data replication utilizing Tibco IMS Data Replicator, Oracle stored procedures and GoldenGate
  • Build and test database backup/recovery scripts
  • Build and test database automation scripts
  • Document and resolve any database problems/issues
Required Skills
  • Experience with IMS/DB2 to Oracle replication
  • Extensive experience with large‑scale database systems development, capacity planning, configuration, maintenance, performance tuning
  • Experience with database development, e.g., stored procedure, PL/SQL, PL/I, Cobol, Assembler
Seniority Level
  • Mid‑Senior level
Employment Type
  • Full‑time
Job Function
  • Information Technology
Industries
  • Software Development and Technology
  • Information and Media
Application

If interested, please apply via LinkedIn or share your profiles at hr@cloudvital.ca

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior DB2 Mainframe IMS Admin - Replication & Tuning
Senior DB2 Mainframe IMS Admin - Replication & Tuning

CloudVital • Toronto

On-site
CAD 80,000 - 100,000
DB2 / IMS Database Administrator
DB2 / IMS Database Administrator

PHET Enterprise Services (AP) Limited, Philippines Regional Operating Headquarters • Toronto

Remote
CAD 92,000 - 142,000
Health insurance
Dental insurance
Vision insurance
+2
Database Specialist
Database Specialist

Randstad Digital • Toronto

Hybrid
CAD 124,000 - 207,000
Senior DB2 for z/OS & IMS DBA — Remote Canada
Senior DB2 for z/OS & IMS DBA — Remote Canada

MainframeMaster • Toronto

Remote
CAD 129,000 - 199,000
Health insurance
Retirement savings plan
Paid holidays
Database software developer
Database software developer

E PRO Inc • Montreal

On-site
CAD 96,000 - 165,000
Senior DB2 DBA
Senior DB2 DBA

MainframeMaster • Toronto

On-site
CAD 98,000 - 210,000
Mainframe DB2 Developer.
Mainframe DB2 Developer.

Astra-North Infoteck Inc. • Toronto

Hybrid
CAD 110,000 - 140,000
Administrateur systèmes TI
Administrateur systèmes TI

International Business Machines Corporation • Bromont

Hybrid
CAD 80,000 - 100,000
DB Developer: SQL, DB2, Data Warehouse & Unix
DB Developer: SQL, DB2, Data Warehouse & Unix

Info-Ways • Montreal

On-site
CAD 70,000 - 85,000
Senior Mainframe Backend Developer (IMS/DB2)
Senior Mainframe Backend Developer (IMS/DB2)

Rubicon Path • Toronto

On-site
CAD 90,000 - 130,000