Welcometo Yoush Consulting. Are you an independent IT Consultant or wish to becomeone?

Areyou looking to partner with an organization that presents you to consultingopportunities and supports you as a partner?

4318 - Database Administrator - Senior - 1 Year Contract - Hybrid Work - Toronto
We are seeking the services of four (4) Senior Database Administrator.

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

Responsibilities

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

Skills

Database Administration (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

Requirements

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

#J-18808-Ljbffr

📌 Senior Database Administrator (Ontario)
🏢 Yoush Consulting
📍 Ontario