Senior Database Admin Contract

*************************************************
Client: Government
Type: Contract
Role: Senior Database Admin
Term: 6 Months + 1 year extension
Pay Rate: Open
Start date: 2-3 weeks
Location: Hybrid
Req ID: 6046
*************************************************

Requirements: What you’ll need

Skills, Knowledge, Experience, and Qualifications

Deliverables:

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

Skill Set Requirements:

·       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/SQL, 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

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/SQL, PL/I, Cobol, Assembler

Data Replication                                                                                                             20%

·       Experience with IMS/DB2 to Oracle replication

Must haves:

·       Expert Database administration experience, e.g., IMS, DB2, Oracle, Microsoft Azure SQL database and Synapse database
·       Experience with database development, e.g., stored procedure, PL/SQL, PL/I, Cobol, Assembler
·       Experience with IMS/DB2 to Oracle replication

HOW TO APPLY

Please apply for this opportunity by using the Apply button or sending your resume directly to careers@wirehead.com

We thank all candidates for their interest but advise that only candidates selected for interviews will be contacted directly. Rest assured that your resume will be kept on our database and will be considered for all future opportunities.

Wirehead is committed to meeting the accessibility needs of all individuals in accordance with the Accessibility for Ontarians with Disabilities Act (AODA) and the Ontario Human Rights Code (OHRC). Should you require accommodations during the recruitment and selection process, please let our recruiter know.

***This opportunity is in Toronto; preference will be given to local candidates. Wirehead does not offer a relocation package. We encourage you continue to refer to our Job listing page as new opportunities become available and updated on a regular basis. Thank you again for your interest in Wirehead!