Senior Sql Database Administrator

BITS Recruiting; Toronto; On-site; CAD 90,000 - 130,000; Full time

Job summary

BITS Recruiting is assisting a client in Toronto in hiring an experienced Database Administrator (Intermediate) to manage SQL Server databases on on-premises and Azure, while supporting Dynamics GP and Salesforce CRM and driving reporting solutions across the enterprise.

The role emphasizes data migration, performance tuning, backup/recovery, and integration work with business stakeholders in finance and IT. A mix of on-site collaboration and cloud-based work is expected.

Qualifications

• Hands-on administration, maintenance, and support of Microsoft SQL Server databases in on-premises and Azure environments.
• Experience migrating on-premises databases/workloads to Azure including planning, configuration, validation, and post-migration support.
• Hands-on support of Microsoft Dynamics GP including financial system operations and coordination with finance teams.
• Practical experience administering Salesforce CRM.
• Experience developing, maintaining, and troubleshooting SQL reports using SQL Server Report Builder.
• Senior-level DBA capabilities: performance tuning, capacity planning, installation, backup and recovery, design, and production troubleshooting.

Responsibilities

• Design, implement, and maintain SQL Server databases across on-premises and Azure environments.
• Perform installation, configuration, optimization, capacity planning, performance tuning, and troubleshooting.
• Manage security, access controls, backups, recovery, and data integrity.
• Monitor health, availability, storage, and performance to ensure reliable operations.
• Support upgrades, migrations, replication, and maintenance across dev/test/prod environments.
• Diagnose and resolve complex database issues with minimal disruption to critical applications.
• Plan and execute Azure migrations and configurations, ensuring compatibility and data integrity.
• Collaborate with finance and business stakeholders to support financial systems and reporting.
• Administer Salesforce CRM, support integrations with other enterprise apps, and assist with reporting.

Skills

Database admin

Cloud migration

Dynamics GP

Salesforce CRM

SQL reporting

Senior DBA

Tools

SQL Server

Azure

SQL Server Report Builder

Dynamics GP

Salesforce

Job description

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 SQL Server certifications.
• Microsoft Certified: Azure Solutions Architect Expert (AZ-305).
• Microsoft Certified: Fabric Data Engineer Associate (DP-700).
• Microsoft Certified: Fabric Data Engineer Associate (DP-700).
• 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.

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.