Database Administrator – Intermediate

About the job
Database Administrator – Intermediate- RQ00749

Client: Ontario Science Centre

Location: 777 Bay Street, Toronto, ON

Work Arrangement: 100% Onsite – 5 days/week

Contract: Approx. 3 months / 60 business days

Openings: 1

Public Sector Experience: Preferred

Ideal Candidate: A hands-on DBA who has all three core areas: SQL Server + Dynamics GP + Salesforce, rather than someone with general database experience only.

Role Overview

The Ontario Science Centre is seeking an experienced Database Administrator with strong hands-on expertise across SQL Server, Microsoft Dynamics Great Plains (GP), Salesforce CRM, and Azure/cloud database environments. The successful candidate will support databases, finance applications, CRM, reporting, integrations, and other Microsoft-based enterprise applications.

Must-Have Skills

Strong hands-on Microsoft SQL Server DBA experience, including:
Database administration and maintenance
Performance tuning and optimization
Backup and recovery
Capacity planning
Database installation and migration
Physical database design
Experience supporting databases in both on-premises and Microsoft Azure/cloud environments
Strong hands-on Microsoft Dynamics Great Plains (GP) administration and support experience
Hands-on Salesforce CRM administration/support experience
Experience with SQL Server Reporting Services / SQL Report Builder
Strong communication skills and ability to work directly with business and Finance teams

Additional Experience Preferred

Microsoft Business Central / Dynamics 365 Finance
Microsoft 365, SharePoint Online and MS Teams
Power Apps / Power Platform
.NET MVC and Microsoft web application environments
Website/CMS support, including platforms such as Umbraco
API and third-party application integrations
SaaS/ticketing applications such as Shopify or Siriusware
Public-sector experience

Key Responsibilities

Administer, maintain and optimize Microsoft SQL Server databases.
Manage database performance, backups, recovery, migrations and capacity.
Support the day-to-day operation of Microsoft Dynamics GP, working closely with the Finance team.
Administer and support Salesforce CRM.
Support reporting, ticketing systems, integrations and related enterprise applications.
Troubleshoot database and application issues across on-premises and Azure environments.
Support Microsoft cloud applications and technologies as required.

Nice-to-Have Certifications

Azure Database Administrator Associate, Microsoft SQL Server certifications, Salesforce Certified Administrator, AZ-104, AZ-305, DP-700/Fabric Data Engineer, or Microsoft Dynamics GP/Dynamics 365 Finance certifications.

Requirements added by the job poster

• 5+ years of work experience with Microsoft SQL Server