Intermediate Database Administrator - Toronto

Randstad Canada; Toronto; On-site; CAD 90,000 - 120,000; Part time

Job summary

Randstad Canada is seeking an experienced Intermediate Database Administrator to manage SQL Server environments on-premises and in Azure, with governance of GP Dynamics GP and Salesforce CRM systems. The role includes migration planning, performance optimization, backups, and security across cloud and local infrastructure.

The position is based in Toronto and is a 3-month contract requiring full onsite presence, collaboration with finance, development, and IT teams to support integrations and

Qualifications

• Experience managing SQL Server on-premises and Azure.
• Proven migration of on-prem databases to cloud.
• GP Dynamics GP administration experience.
• Salesforce CRM administration experience.
• SQL Report Builder experience with web applications.

Responsibilities

• Design and administer SQL Server DBs across on-prem and Azure.
• Plan and execute on-prem to Azure migrations.
• Support GP Dynamics GP and finance systems.
• Manage Salesforce CRM operations and data integrations.
• Develop reports with SQL Report Builder and support web apps.

Skills

SQL Server expertise

Azure cloud

Dynamics GP

Salesforce CRM administration

Reporting & integration

Tools

SQL Report Builder

SharePoint

APIs

.NET MVC

Job description

Role Description

We are seeking an experienced Intermediate Database Administrator with strong senior-level DBA expertise to oversee both on-premises and cloud-based (Azure) database environments. In this role, you will be responsible for managing Microsoft SQL Server, supporting Microsoft Dynamics Great Plains (GP) finance systems, and administering Salesforce CRM. You will play a key role in migrating on-premises databases to the Azure cloud, optimizing database performance, managing backups and security configurations, and supporting application integrations, reporting tools, and cloud-based systems.

Location: Toronto, ON (Fully Onsite – 5 days/week required)

Duration: 3-month contract.

Advantages

• Hybrid Cloud Exposure: Direct hands-on experience migrating legacy on-premises SQL Server databases to Azure cloud.
• Multi-Platform Scope: Combine expertise across database administration, ERP (Dynamics GP), and CRM (Salesforce) ecosystems.
• Modern Cloud Stack: Exposure to Azure infrastructure, Microsoft 365, Power Platform, and third-party API integrations.
• Dedicated Onsite Collaboration: Collaborate directly alongside finance, development, and IT teams in a focused workspace.

Responsibilities

• Database Administration & Design: Create physical database designs and administer database management systems (DBMS), focusing on performance tuning, capacity planning, database optimization, installation, and maintenance.
• On-Premises to Cloud Migration: Plan and execute the migration of on-premises databases to Azure cloud environments, including VM sizing, disk configuration, replication prerequisites, and target network/security setup.
• ERP & Finance Support: Manage day-to-day operations and administration for Microsoft Dynamics Great Plains (GP) and collaborate closely with finance teams.
• CRM Administration: Support and maintain Salesforce CRM operations, data integrations, and user administration.
• Backup, Security & Monitoring: Implement robust backup and disaster recovery strategies, performance monitoring, and security baseline plans for migrated cloud workloads.
• Reporting & Application Support: Develop and maintain custom reports using SQL Report Builder and provide technical support for web applications, CMS platforms, SharePoint/MS Teams, and third-party SaaS integrations.

Qualifications

• Database Administration (On-Premises & Azure): Hands-on DBA experience managing, optimizing, and supporting Microsoft SQL Server across both on-premises and Azure cloud environments (Strictly Required).
• Database Migration Experience: Proven experience planning and executing the migration of on-premises databases to cloud infrastructure (Strictly Required).
• Microsoft Dynamics Great Plains (GP): Hands-on experience administering, supporting, and managing Microsoft Dynamics GP and related finance system concepts (Strictly Required).
• Salesforce CRM Administration: Hands-on experience managing and supporting Salesforce CRM systems (Strictly Required).
• Reporting & Application Integration: Experience developing custom reports using SQL Report Builder and supporting Microsoft stack web applications (.NET MVC, SharePoint, APIs) (Strictly Required).

Nice-to-Have Assets

• Prior database administration experience within a public sector or enterprise environment.
• Azure certifications (e.g., Azure Database Administrator Associate, Azure Administrator Associate AZ-104, Azure Solutions Architect AZ-305, or Fabric Data Engineer DP-700).
• Microsoft SQL Server or Salesforce Certified Administrator certifications.

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to [e-mail] to ensure their ability to fully participate in the interview process.

This posting is for existing and upcoming vacancies.