DB2 Mainframe IMS Administrator

CloudVital; Toronto; On-site; CAD 80,000 - 100,000; Full time

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 [e-mail]