HM Note: This hybrid role is three (3) days in office and candidate can work in Toronto or North Bay and commences Feb 10, 2025
Description:
Scope:
- Creation of functional and technical specifications for database development, analyze requirements and help project team in solution, technical design, implementation, and support.
- Work with the project team in completing all relevant and required documentation in alignment with OPS standards.
Skills
Experience and Skill Set Requirements
Deliverables:
- Creation of technical specifications for Azure, SQL and Oracle database systems development
- Design, implement and work with the project team in completing all relevant and required documentation in alignment with OPS standards
- Undertake special assignments/sub-projects as assigned
- Conduct, assess, evaluate and document stakeholder interests and business needs
- Create and validate business scenarios and use cases
- Produce visual depiction of use cases and process flows; ensure alignment with the program area and associated business architecture, as well as traceability to solution logical and physical architectures
- Create, review, provide input and support of Enterprise Architecture artifacts for all checkpoints as required
- Create system and user interface design and modifications (data & screen) as required
- Review all test scenarios to ensure the requirements are met; establish traceability matrix to monitor output
- Ensure alignment and adherence to Ministry of Government Services' processes and standards
- Support the testing team during system and UAT testing
- Participate in Knowledge transfer
Skills and Knowledge:
- Experience administering database management systems (i.e. ORACLE, Exadata, Microsoft SQL Server, Azure etc.) for business intelligence and analytics applications
- Create, test and implement safeguards to maintain data integrity and protect against unauthorized access
- Assist with SQL optimization and code reviews to ensure queries are efficient
Criteria Ratings MUST TOTAL 100
Criteria 1: Technical Skills
Criteria 1 Points: 50 points
Criteria 1 Details:
- Oracle Exadata, Golden Gate, MSSQL, Azure SQL technical knowledge and experience.
- Demonstrated experience in modifying database structures using information provided by application developers
- Demonstrated experience with monitoring, optimizing and performance tuning using either manual or automated tools
- Able to develop and interpret highly complex SQL to support queries and provide feedback for developers.
Criteria 2: Analytical and Problem Solving Skills
Criteria 2 Points: 30 points
Criteria 2 Details:
- Research, and evaluation of complex design options.
- Superior ability to identify root cause of complex environmental or underlying database specific issues.
- Determining areas of risk, and recommending innovative alternatives and options for resolution to meet program needs.
- Demonstrated experience working within a team environment to troubleshoot and resolve technical problems.
Criteria 3: Communication Skills
Criteria 3 Points: 20 points
Criteria 3 Details:
- Oral and written communication skills, Interpersonal and consultative skills,
- Experience preparing operational documentation (build guides, procedures, etc)
Knowledge Transfer
Knowledge to be Transferred:
Knowledge to be Transferred to: Project Manager / Team members
Details of Transfer:
(how transfer will occur) 1:1 meetings / team meetings / documentation on SharePoint site, throughout the duration of the project life cycle etc.
