Database Administrator

Title

Database Administrator

Open positions

4

Location

Hybrid - Toronto area - 2/3 days per week at the office.

Duration:12 months, renewable.

Start date

as soon as possible.

Responsibilities

• 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 and Experience

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