Database Administrator

ThoughtStorm; Toronto; On-site; CAD 90,000 - 120,000; Full time

Job summary

ThoughtStorm in Toronto seeks a Senior Database Administrator to manage on-premises and Azure SQL Server environments, optimize performance, ensure backups, and support GP/Great Plains integrations. The role includes hands-on development support for Dynamics GP, Salesforce CRM, reporting tools, and SharePoint/MS Teams in a Microsoft cloud stack, with a focus on reliability and security.

Candidates should bring senior-level DBA experience, experience with DB design, migration, and integration

Qualifications

• Senior-level DBA with hands-on SQL Server experience and database maintenance.
• Experience with Microsoft Dynamics GP/Great Plains and ERP integrations.
• Experience with Salesforce CRM and reporting tools.
• Experience in a Microsoft Cloud stack including SharePoint/MS Teams/Power Apps.

Responsibilities

• Create physical database designs and operate the DBMS, including optimization, capacity planning, installation and migration.
• Manage day-to-day operations of Microsoft Dynamics GP and collaborate with the finance team.

Skills

SQL Server

Database Admin

Dynamics GP

Great Plains

Salesforce

SQL Reporting

ASP.NET MVC

SharePoint

MS Teams

Power Apps

Azure

Shopify

Siriusware

Umbraco

API Integration

Tools

SQL Report Builder

Team Foundation Server

SharePoint

MS SQL

Azure Cloud

Job description

Database administration, On-premises and On-cloud (Azure)

Microsoft Dynamics - Great plains (GP )

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.

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

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.

Additional Terms

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