Senior Sql Database Administrator

Database Administrator – Intermediate

• Location: Bay Street, Toronto, Ontario
• Assignment Type: Onsite
• Start Date: November 16, 2026
• End Date: March 1, 2027
• Duration: 76 business days
• Work Schedule: 5 days per week onsite
• Incorp Rate: $60-$67.17

Position Overview

Our client is seeking an experienced Database Administrator (Intermediate) to support its database infrastructure, Microsoft Dynamics Great Plains (GP) financial systems, Salesforce CRM, reporting solutions, ticketing systems, and application integrations.

The successful candidate will have strong hands-on experience administering Microsoft SQL Server databases in both on-premises and Microsoft Azure cloud environments, including database migration, performance optimization, backup and recovery, and ongoing operational support.

This role requires practical experience supporting Microsoft Dynamics GP and Salesforce CRM, working with finance and business stakeholders, and supporting integrations across enterprise applications. Experience with Microsoft 365, SharePoint, Microsoft Teams, Power Platform, and web-based applications will also be valuable.

Must-Have Qualifications

• Database Administration: Hands-on experience administering, maintaining, and supporting Microsoft SQL Server databases in both on-premises and Azure cloud environments.
• Cloud Migration: Demonstrated experience migrating on-premises databases and workloads to Microsoft Azure, including migration planning, configuration, validation, and post-migration support.
• Microsoft Dynamics GP: Hands-on experience supporting Microsoft Dynamics Great Plains (GP), including financial system operations, troubleshooting, and coordination with finance teams.
• Salesforce CRM: Practical experience administering and supporting Salesforce CRM.
• SQL Reporting: Experience developing, maintaining, and troubleshooting reports using SQL reporting tools, particularly SQL Server Report Builder.
• Senior-Level DBA Capabilities: Strong database administration experience involving database performance tuning, optimization, capacity planning, installation, backup and recovery, database design, and production troubleshooting.

Nice-to-Have Qualifications

• Microsoft Certified: Azure Database Administrator Associate (DP-300).
• 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).
• Microsoft Certified: Fabric Data Engineer Associate (DP-700).
• Salesforce Certified Administrator.
• Experience with Microsoft Dynamics GP, Dynamics 365 Finance, or Microsoft Business Central.
• Previous experience working in the Ontario Public Service or another public-sector organization.

Key Responsibilities

Database Administration and Operations

• Design, implement, administer, and maintain SQL Server databases across on-premises and Azure environments.
• Perform database installation, configuration, optimization, capacity planning, performance tuning, and troubleshooting.
• Manage database security, access controls, backup and recovery procedures, and data integrity.
• Monitor database health, availability, storage capacity, and performance to ensure reliable business operations.
• Support database upgrades, migrations, replication, and ongoing maintenance across development, testing, and production environments.
• Diagnose and resolve complex database issues while minimizing disruption to business-critical applications.

Azure Cloud Migration and Infrastructure

• Plan and execute migrations of on-premises databases and workloads to Microsoft Azure.
• Assess existing database environments and confirm target virtual machine sizing, compute resources, and disk configurations.
• Configure migration projects, replication prerequisites, and target network and security settings.
• Validate database compatibility, connectivity, data integrity, and application functionality following migration.
• Establish backup, monitoring, security, and Microsoft Defender baselines for migrated workloads.
• Support post-migration optimization, troubleshooting, and operational stabilization.

Microsoft Dynamics GP and Financial Systems

• Manage the day-to-day operation and support of Microsoft Dynamics GP.
• Work closely with finance teams to resolve system issues and support financial reporting and business processes.
• Troubleshoot database and application integration issues affecting financial systems.
• Support system maintenance, configuration, implementation, and upgrades as required.
• Contribute to the reliability and ongoing improvement of financial applications and related databases.

Salesforce CRM, Reporting, and Integrations

• Administer and support Salesforce CRM, including configuration, troubleshooting, and business-user support.
• Support integrations between Salesforce, ticketing systems, databases, and other enterprise applications.
• Develop, maintain, and troubleshoot SQL-based reports using SQL Server Report Builder and related reporting tools.
• Support data extraction, validation, reconciliation, and reporting requirements across business systems.
• Assist with application integrations using APIs and Microsoft technologies.

Microsoft Cloud Applications and Application Support

• Support Microsoft 365 administration and development, including SharePoint, Microsoft Teams, Power Apps, and the Power Platform.
• Provide application support for e-commerce platforms, websites, and other SaaS applications, including Shopify and Siriusware.
• Support public-facing websites built using Microsoft development technologies and content management systems such as Umbraco.
• Assist with integrating third-party APIs into Microsoft-based web applications and services.
• Collaborate with developers, infrastructure teams, vendors, and business stakeholders to resolve technical issues and maintain application availability.
• Maintain technical documentation, operational procedures, and support records.

Key Deliverables

The successful candidate will provide practical technical support across the Centre's database and business application environment, with particular emphasis on:

• SQL Server database administration across on-premises and Azure cloud environments.
• Migration of on-premises databases and workloads to Microsoft Azure.
• Salesforce CRM administration, support, and integration.
• Microsoft Dynamics GP support, implementation, and financial system operations.
• SQL Server reporting and business intelligence support.
• Ticketing system support and integrations, including relevant CRM and SaaS applications.
• Database performance optimization, security, backup and recovery, monitoring, and production troubleshooting.
• Technical documentation and knowledge transfer to support ongoing operations.