Our Client is seeking an experienced Database Administrator to support the Ontario Science Centre's database infrastructure, enterprise applications, financial systems, and cloud migration initiatives.
The ideal candidate will have strong hands-on experience with Microsoft SQL Server administration, Microsoft Dynamics Great Plains (GP), Salesforce CRM, and migrating on-premises databases to Microsoft Azure.
This role involves maintaining critical business systems, optimizing database performance, supporting financial applications, and collaborating with IT and business teams to ensure reliable and secure operations.
Key Responsibilities
- Administer, maintain, monitor, and optimize Microsoft SQL Server databases across on-premises and Azure cloud environments.
- Manage database installation, configuration, performance tuning, capacity planning, backup, recovery, and troubleshooting.
- Plan and execute migrations of on-premises databases and workloads to Microsoft Azure.
- Validate target virtual machine sizing, storage capacity, and disk configurations.
- Configure migration projects, replication prerequisites, and Azure networking and security settings.
- Establish backup, monitoring, and Microsoft Defender security baselines for migrated workloads.
- Manage and support Microsoft Dynamics Great Plains (GP), collaborating with finance teams on daily operations and system-related issues.
- Support Salesforce CRM administration, integrations, and data management activities.
- Develop, maintain, and troubleshoot reports using SQL Server Reporting Services (SSRS) and SQL Report Builder.
- Support enterprise applications, including ticketing systems such as Shopify and Siriusware, and related SaaS platforms.
- Maintain and support Microsoft 365 applications, including SharePoint Online, Microsoft Teams, and Power Apps/Power Platform.
- Support application development and maintenance using .NET MVC, Microsoft SQL Server, Team Foundation Server (TFS), and SharePoint.
- Troubleshoot and maintain public-facing websites built on Microsoft technologies and CMS platforms such as Umbraco.
- Support third-party API integrations with Microsoft-based applications and enterprise systems.
- Collaborate with internal stakeholders to resolve technical issues, maintain system availability, and support business operations.
Required Qualifications
- Strong hands-on experience administering Microsoft SQL Server databases in on-premises and Azure cloud environments.
- Senior-level practical expertise in database administration, performance optimization, backup, recovery, and troubleshooting.
- Extensive experience supporting and administering Microsoft Dynamics Great Plains (GP), particularly in financial environments.
- Working knowledge of Microsoft Dynamics 365 Business Central and finance system concepts.
- Hands-on Salesforce CRM administration and support experience.
- Proven experience migrating on-premises databases to Microsoft Azure.
- Experience with SQL Server Reporting Services (SSRS) and SQL Report Builder.
- Familiarity with Microsoft cloud technologies, including SharePoint Online, MS Teams, and Power Platform.
- Experience supporting enterprise applications and integrations within a Microsoft technology environment.
- Strong problem-solving, troubleshooting, communication, and stakeholder management skills.
Preferred Qualifications
- Experience working within the Ontario public sector or similar enterprise environments.
- Microsoft Certified: Azure Database Administrator Associate.
- Microsoft SQL Server certifications.
- Microsoft Certified: Azure Administrator Associate (AZ-104).
- Microsoft Certified: Azure Solutions Architect Expert (AZ-305).
- Microsoft Certified: Fabric Data Engineer Associate (DP-700).
- Salesforce Certified Administrator.
- Microsoft Dynamics GP / Dynamics 365 Finance experience.
- Experience with .NET MVC, SharePoint development, Umbraco CMS, and API integrations.
- Experience with enterprise ticketing platforms, including Shopify and Siriusware.
