Note: Hybrid 3 days a week onsite

Public Sector Experience: Not required

Must Haves:

• 8+ years' experience with Database Administration specially SQL server, maintaining and managing databases as a DBA, Senior level experience as a DBA is required
• 3+ years' experience with Microsoft Dynamics Great plain and finance systems, Microsoft Business Central and Finance system concepts, Senior level experience with GP is required
• 5+ years' experience with different report-generating tools specifically SQL Report builder
• 2+ years' experience with MS 365 administration

Description

Responsibilities

• Creates physical database designs and operates and administers the database management system (DBMS) including database optimization, capacity planning, installation and migration, database design, performance tuning, backup and recovery.
• Manages day to day operation of Microsoft Dynamics GP and works with finance team

REQUIRED SKILLS

Technical Expertise (50%):

• 8+ years' experience with Database Administration specially SQL server, maintaining and managing databases as a DBA, Senior level experience as a DBA is required.
• 3+ years' experience with Microsoft Dynamics Great plain and finance systems, Microsoft Business Central and Finance system concepts, Senior level experience with GP is required.
• 5+ years' experience with different report-generating tools specifically SQL Report builder.
• 1+ years' experience with Application development (e.g eCommerce and Website & Sharepoint /MS Teams Online support) in a Microsoft Cloud environment, leveraging technologies like .Net MVC, MS SQL, Team Foundation Server and SharePoint, to provide capacity to the team in support of the Strategic Plan.
• 2+ years' experience with MS 365 administration/development of SharePoint, MS Teams, Power Apps/Platform, and ticketing systems like Shopify and Siriusware.
• 1+ years' experience with supporting Public Websites that use Content Management Solutions built on the Microsoft development stack (Umbraco etc) and integrating third party software API's with Microsoft web applications and technologies.
• Knowledge of Artificial Intelligence systems, tools and programming languages.
• Knowledge of OPS policies and procedures related to software design, development, implementation and maintenance; OSC IT strategic plan and applicable legislation; systems analysis, programming concepts/languages, Internet technology, emerging technologies, industry, and trends
• Plan and lead the design, development, implementation, testing, maintenance, and evaluation of business system projects/initiatives; evaluate application software/hardware
• Assess quality assurance and capacity of existing systems and applications and make recommendations for improving performance; and to develop/prepare technical documentation

Research, Analytical and Problem-Solving Skills (20%):

• Identify/ assess the client's information/systems needs and research solutions to make cost effective recommendations to the Director and to clients
• Demonstrate research, analytical and reasoning skills, attention to detail and sound judgment to identify and coordinate/manage and provide insight into problems and incidents.
• Maintain currency in the field and upgrade knowledge of emerging technologies, industry, and trends to plan and lead the design, development, implementation, testing, maintenance, and evaluation of business system projects/initiatives; evaluate application software/hardware ; support the development and implementation of the OSC's IT strategic direction and objectives; provide expert advice, business analysis and consulting expertise in addressing a full range of client's business software requirements/issues

Project Management Skills (20%):

• Knowledge of project planning methodologies and project management skills to lead/conduct projects and major assignments to support the Ontario Science Centre's new strategic plan.
• Team leadership skills to coordinate development of technical project plans, control project processes and provide technical guidance, set priorities, and assign activities to project teams.
• Knowledge of risk assessment methods and techniques to evaluate options, select and support best solutions.
• Ability to identify the most appropriate resources for projects and ongoing work.

Interpersonal & Communication Skills (10%):

• Interpersonal and relationship management skills to develop and maintain effective working relationships and liaise with clients, management and collaborate with other technical teams to achieve goals.
• Written and oral communication skills to develop and present technical/business documentation, project reports, status reports, business cases, recommendations and presentations to Director and client management.