Job Description

A new job opportunity and I think you may find it interesting.

If you are interested kindly send the following documents to by Wednesday, Mar 15, at 10:00 AM EST if that interests you and matches your profile.

Without mandatory documents, we cannot submit a candidate. * Updated Resume in word format (Mandatory)

• Skills Matrix and References (Mandatory)
• Expected hourly rate (Mandatory)

Job Title: Database Administrator - Senior

Work Location: 125 Sir William Hearst Ave. Toronto, ON M3M 0B4, Hybrid

Estimated Start Date: 2023-04-01

Estimated End Date: 2024-03-31

#Business Days: 250.00

Extension: 253.00

Hours per day or Week: 7.25 hours per day

Security Level: CRJMC

Must have:

• Expert Database administration experience in
• IMS/DB2/PL1/COBOL Assembler

Description:

The Data Management Office (DMO) is seeking to hire two (2) Mainframe Database Administrator to deliver:

Support on preparation, installation, configuration and user test of mainframe z/OS, IMS and DB2 version upgrade:

• Participate in the review of project and maintenance release artefacts - Use Case, System Requirement Specification, etc.;
• Prepare and implement database changes according to design;
• Promote database changes through Development, Integration Testing, QA, UAT, Production environments;
• Prepare, install, configure Operating Systems, databases and database patches;
• Maintain, administrate, tune performance of databases, e.g., IMS, DB2, Oracle, Microsoft Azure SQL database and Synapse database;
• Provide database space calculations for the supported database environments;
• Perform reference data administration as required;
• Plan and co-ordinate implementation with developers, ITS, UNIX and .NET application support and other Data Management staff;
• 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;
• Deliver detailed system design documents and any other supporting documentation conforming to Ministry standards;
• Document and resolve any database problems/issues;
• Provide effective knowledge transfer to Ministry staff at all stages of this assignment;

Skill Set:

• Expert Database administration experience, e.g., IMS, DB2, Oracle, Microsoft Azure SQL database and Synapse database
• Extensive experience with large-scale database systems development, capacity planning, configuration, maintenance, performance tuning
• Experience with database development, e.g., stored procedure, PL/I, Cobol, Assembler
• Experience with Microsoft Azure technologies, including storage account, file share, Azure key vault, Azure portal, Azure monitoring tools
• Experience with IMS/DB2 to Oracle replication

Experience and Skill Set Requirements

Database Administration\xe2\x80\x93 50%

• Expert Database administration experience, e.g., IMS, DB2, Oracle, Microsoft Azure SQL database and Synapse database
• Experience with Microsoft Azure technologies, including storage account, file share, Azure key vault, Azure portal, Azure monitoring tools

Systems Development- 30%

• Extensive experience with large-scale database systems development, capacity planning, configuration, maintenance, performance tuning
• Experience with database development, e.g., stored procedure, PL/I, Cobol, Assembler

Data Replication- 20%

• Experience with GoldenGate & IMS/DB2 to Oracle replication

If you are interested to learn more about this opportunity or If not please feel free to send over any names or forward this email to anyone who may be interested. Please check it out on our career site.

(Click above for Skill matrix and for more details)

Note:

This position is currently listed as "Hybrid"; however, the consultant will be remote due to COVID-19 related Work from Home (WFH) direction. Once the I&IT cluster staff are required to return to the office, the resource under this request will be required to work onsite as well.

• 3 days a week in the office

Powered by JazzHR

S M Software Solutions Inc