RQ04318 - Senior Database Administrator

Are
you looking to partner with an organization that presents you to consulting
opportunities and supports you as a partner? 

Database Administrator - Senior -  1 Year Contract - Hybrid Work - Toronto 

We are seeking the services of four (4) Senior Database Administrator.

Essential technologies experience:

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

Skills

Database
Administration %

· 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 %

· 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 %

· Experience
with GoldenGate & IMS/DB2 to Oracle replication