RQ10815 Database Administrator (OPS - Labour and Transportation Cluster) at HIS LLC

Toronto, Ontario, Canada -

Full Time

Start Date

Immediate

Expiry Date

24 Jun, 26

Salary

0.0

Posted On

26 Mar, 26

Experience

10 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Oracle, Microsoft Azure SQL, Synapse, Mainframe IMS, DB2, Database Replication, Microsoft Azure Technologies, Capacity Planning, Performance Tuning, Stored Procedure, PL/SQL, PL/I, Cobol, Assembler, Azure Storage Account, Azure Key Vault

Industry

IT Services and IT Consulting

Description

Job Summary This position requires an expert in database administration with experience in Oracle and Microsoft Azure SQL, along with a strong understanding of Microsoft Azure technologies and database replication. It is an onsite role with a deadline for candidate submissions of March 30, 2026, 3:00 p.m. Responsibilities Participate in the review of project and maintenance release artifacts. Prepare and implement database changes according to design. Promote database changes across various environments. Prepare, install, configure operating systems, databases, and patches. Maintain, administrate, and tune the performance of databases including Oracle, Microsoft Azure SQL, Synapse, and Mainframe IMS, DB2 databases. Provide database space calculations for the supported environments. Perform reference data administration as required. Plan and coordinate implementation with various technical teams. Design and write data loading and/or conversion scripts/stored procedures. Maintain and enhance Mainframe to Oracle data replication utilizing specific tools. Build and test database backup/recovery and automation scripts. Deliver detailed system design documents and other supporting documentation. Document and resolve database problems/issues. Provide effective knowledge transfer to Ministry staff. Skill Set Requirements Expert database administration experience with Oracle, Microsoft Azure SQL, Synapse, and Mainframe (IMS & DB2) databases. Extensive experience with large-scale database systems development, capacity planning, configuration, maintenance, and performance tuning. Database development experience including stored procedure, PL/SQL, PL/I, Cobol, and Assembler. Proficiency with Microsoft Azure technologies such as storage account, file share, Azure key vault, Azure portal, and monitoring tools. Experience with IMS/DB2 to Oracle replication. Evaluation Criteria Type/Details Percentage Database Administration 50% Systems Development 30% Data Replication 20%

Responsibilities

Responsibilities include participating in artifact reviews, preparing and implementing database changes across environments, and installing/configuring operating systems, databases, and patches. The role also involves maintaining, administering, and tuning various databases like Oracle, Azure SQL, Synapse, and Mainframe IMS/DB2.