RQ04318 - Senior Database Administrator

Are
you looking to partner with an organization that presents you to consulting
opportunities 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.

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

Technical Skills

·        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