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, , 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, , 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, , stored procedure, PL/I, Cobol, Assembler
Data Replication 20%
·Experience with GoldenGate & IMS/DB2 to Oracle replication
RQ04318 Senior Database Administrator • Toronto, Ontario, Canada