Database Administrator
- Toronto, ON, Canada
Contract
Applications open in a new tab.
Job details
- Job type
- Contract
- Apply by
- Posting language
- English
- Posted
Original job description
The ideal candidate will have strong hands-on experience with Microsoft SQL Server administration, Microsoft Dynamics Great Plains (GP), Salesforce CRM, and migrating on-premises databases to Microsoft Azure.
This role involves maintaining critical business systems, optimizing database performance, supporting financial applications, and collaborating with IT and business teams to ensure reliable and secure operations.
Key Responsibilities
- Administer, maintain, monitor, and optimize Microsoft SQL Server databases across on-premises and Azure cloud environments.
- Manage database installation, configuration, performance tuning, capacity planning, backup, recovery, and troubleshooting.
- Plan and execute migrations of on-premises databases and workloads to Microsoft Azure.
- Validate target virtual machine sizing, storage capacity, and disk configurations.
- Configure migration projects, replication prerequisites, and Azure networking and security settings.
- Establish backup, monitoring, and Microsoft Defender security baselines for migrated workloads.
- Manage and support Microsoft Dynamics Great Plains (GP), collaborating with finance teams on daily operations and system-related issues.
- Support Salesforce CRM administration, integrations, and data management activities.
- Develop, maintain, and troubleshoot reports using SQL Server Reporting Services (SSRS) and SQL Report Builder.
- Support enterprise applications, including ticketing systems such as Shopify and Siriusware, and related SaaS platforms.
- Maintain and support Microsoft 365 applications, including SharePoint Online, Microsoft Teams, and Power Apps/Power Platform.
- Support application development and maintenance using .NET MVC, Microsoft SQL Server, Team Foundation Server (TFS), and SharePoint.
- Troubleshoot and maintain public-facing websites built on Microsoft technologies and CMS platforms such as Umbraco.
- Support third-party API integrations with Microsoft-based applications and enterprise systems.
- Collaborate with internal stakeholders to resolve technical issues, maintain system availability, and support business operations.
- Strong hands-on experience administering Microsoft SQL Server databases in on-premises and Azure cloud environments.
- Senior-level practical expertise in database administration, performance optimization, backup, recovery, and troubleshooting.
- Extensive experience supporting and administering Microsoft Dynamics Great Plains (GP), particularly in financial environments.
- Working knowledge of Microsoft Dynamics 365 Business Central and finance system concepts.
- Hands-on Salesforce CRM administration and support experience.
- Proven experience migrating on-premises databases to Microsoft Azure.
- Experience with SQL Server Reporting Services (SSRS) and SQL Report Builder.
- Familiarity with Microsoft cloud technologies, including SharePoint Online, MS Teams, and Power Platform.
- Experience supporting enterprise applications and integrations within a Microsoft technology environment.
- Strong problem-solving, troubleshooting, communication, and stakeholder management skills.
- Experience working within the Ontario public sector or similar enterprise environments.
- Microsoft Certified: Azure Database Administrator Associate.
- 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).
- Salesforce Certified Administrator.
- Microsoft Dynamics GP / Dynamics 365 Finance experience.
- Experience with .NET MVC, SharePoint development, Umbraco CMS, and API integrations.
- Experience with enterprise ticketing platforms, including Shopify and Siriusware.
More about this job
Responsibilities
Administer, secure, optimize, and migrate SQL Server databases across on-premises and Azure environments, including planning capacity, backups, recovery, monitoring, and performance. Support financial and enterprise applications - including Dynamics GP, Salesforce, Microsoft 365, reporting tools, websites, and integrations - in collaboration with IT and business stakeholders.
Requirements
Requires senior-level hands-on SQL Server administration experience, including Azure migrations, performance optimization, backup and recovery, and troubleshooting. Candidates should also have extensive Dynamics GP experience, Salesforce administration experience, SSRS and SQL Report Builder knowledge, and familiarity with Microsoft cloud technologies and enterprise application integrations.
Skills
- Microsoft SQL Server Administration
- Azure Database Migration
- Database Performance Optimization
- Database Backup and Recovery
- Microsoft Dynamics Great Plains
- Salesforce CRM Administration
- SSRS and SQL Report Builder
- Microsoft 365
- SharePoint Online
- Power Platform
- .NET MVC
- Umbraco CMS
- API Integrations
- Troubleshooting
- Stakeholder Management
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Data & Analytics
- Software
- Finance & Accounting
- Government & Public Sector
Keywords
- Microsoft SQL Server
- Azure
- Azure Database Migration
- Database Administration
- Performance Tuning
- Capacity Planning
- Backup and Recovery
- Microsoft Dynamics Great Plains
- Dynamics 365 Business Central
- Salesforce CRM
- SSRS
- SQL Report Builder
- SharePoint Online
- Microsoft Teams
- Power Apps
- Power Platform
- .NET MVC
- Team Foundation Server
- Umbraco CMS
- API Integrations
- Microsoft Defender
- Azure Networking
- Cloud Security
- Shopify
- Siriusware
- Azure Database Administrator Associate
- Azure Administrator Associate
- Fabric Data Engineer Associate
- Salesforce Certified Administrator