ETL Tester (Contract)

CoreFactor Inc.; Toronto; On-site; CAD 70,000 - 115,000; Full time

Job summary

CoreFactor Inc. is seeking a Database Administrator (Intermediate) to join our Information Technology team in a largely in-office role.

The position focuses on managing on-prem and Azure-based databases, particularly SQL Server, and supporting Microsoft Dynamics GP/Great Plains. Experience with Salesforce CRM and cloud migrations is highly valued.

Qualifications

• Database administration for on-premises and cloud (Azure).
• Microsoft Dynamics GP (Great Plains) experience required.
• Migration of on-premises databases to Azure cloud.

Responsibilities

• Create physical database designs and operate the DBMS including optimization and backups.
• Manage day-to-day operations of Microsoft Dynamics GP with the finance team.
• Position may extend beyond initial term based on performance (6–12 months).
• For OSC, perform SQL Server, Salesforce administration, GP support, and Azure migration tasks.

Skills

Database administration

CRM administration

Cloud knowledge

Education

Microsoft SQL Server certifications

Microsoft Certified: Fabric Data Engineer Associate

Microsoft Certified: Azure Solutions Architect Expert (AZ-305)

Microsoft Fabric Data Engineer Associate (DP-700)

Microsoft Dynamics GP / Dynamics 365 Finance experience

Tools

Azure

SQL Server

Salesforce CRM

SharePoint

MS Teams

Umbraco

Job description

Assignment: RQ00834 - Database Administrator - Intermediate

Full-time

5 days in office

Start Date: 2026-11-16

End Date: 2027-03-01

Business Days: 76.00

Department: Information Technology

Public Sector Experience: preferred but not required

Salary: CA$70,000.00–CA$115,000.00 yearly

Must Haves

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

Nice to have

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

Description

Must Have:

• Database administration, On-premises and On-cloud (Azure)
• Microsoft Dynamics - Great plains (GP )
• 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
• 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