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