RQ00834 - Database Administrator - Intermediate

Flexstaf IT; Toronto; On-site; CAD 80,000 - 110,000; Full time

Job summary

Flexstaf IT is seeking a Database Administrator - Intermediate in Toronto, Ontario. The role encompasses managing on-premises and Azure databases, administering SQL Server, and supporting Salesforce and Microsoft Dynamics GP environments.

Responsibilities include design, optimization, backups, and cloud migrations, with potential extension based on performance. 5 days in office with a focus on public sector projects.

Qualifications

• Database administration on-premises and cloud (Azure).
• Experience with Microsoft Dynamics GP and Sage Great Plains alternatives.
• CRM Salesforce experience is required.

Responsibilities

• Create physical database designs and manage DBMS with optimization and recovery.
• Maintain day-to-day operations of Microsoft Dynamics GP with finance team.
• Migrate on-premises databases to Azure cloud and ensure performance.

Skills

Database administration

Azure cloud

Dynamics GP

Salesforce CRM

Migration to cloud

SQL Server administration

Report building

SharePoint/MS Teams

Tools

SQL Server

SQL Server Management Studio

SQL Report Builder

SharePoint

Umbraco

Job description

MSP Notes

Shortlist Date: 2026-10-29, 10:00 a.m.

Must Haves:

• Database administration, On-premises and On-cloud (Azure)
• Microsoft Dynamics - Great plains (GP )
• CRM Salesforce experience

Nice to have:

• Microsoft Certified: Azure Database Administrator Associate
• Microsoft SQL Server certifications
• Microsoft Certified: Fabric Data Engineer Associate
• Microsoft Certified: Azure Administrator Associate (AZ-104)
• Microsoft Certified: Azure Solutions Architect Expert (AZ-305)
• Microsoft Fabric Data Engineer Associate (DP-700)
• Salesforce Certified Administrator
• Microsoft Dynamics GP / Dynamics 365 Finance experience

Location: 5 days in office

Public Sector Experience: preferred but not required

# of submissions/supplier: 1

Job Title

Database Administrator - Intermediate

Description

• Database administration, On-premises and On-cloud (Azure)
• Microsoft Dynamics - Great plains (GP )
• CRM Salesforce experience
• Migration of on-premises Databases to cloud
• Hands on experience with Database Administration specially SQL server, maintaining and managing databases as a DBA, Senior level experience as a DBA is required.
• Hands on experience with Microsoft Dynamics Great plain and finance systems, Microsoft Business Central and Finance system concepts, Senior level experience with GP is required.
• Hands on experience with Sales force CRM
• Hands on experience with different report-generating tools specifically SQL Report builder.
• Hands on 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.
• Experience with MS 365 administration/development of SharePoint, MS Teams, Power Apps/Platform, and ticketing systems like Shopify and Siriusware and other SaaS applications
• 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.
• Confirm target VM sizing and disk configuration.
• Configure migration project and replication prerequisites.
• Prepare target network/security settings for migrated VMs.
• Prepare backup, monitoring, and Defender baseline plan for migrated workloads.

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

Note: this role can be extended based on the performance for next 6 months/1 year

Deliverables

For OSC, where there is significant focus on ticketing systems, CRM - salesforce , reporting, and integrations, practical experience with SQL Server + Salesforce Administration + Great Plains support and implementation+ Migration of on-premises databases to Azure cloud environment

Additional Terms

Nice to have:

• Microsoft Certified: Azure Database Administrator Associate
• Microsoft SQL Server certifications
• Microsoft Certified: Fabric Data Engineer Associate
• Microsoft Certified: Azure Administrator Associate (AZ-104)
• Microsoft Certified: Azure Solutions Architect Expert (AZ-305)
• Microsoft Fabric Data Engineer Associate (DP-700)
• Salesforce Certified Administrator
• Microsoft Dynamics GP / Dynamics 365 Finance experience