Assignment: RQ00834 - Database Administrator - Intermediate
Full-time
5 days in office
Start Date: 2026-11-16
End Date: 2027-03-01
Business Days: 76.00
Department: Information Technology
Public Sector Experience: preferred but not required
Salary: CA$70,000.00–CA$115,000.00 yearly
Must Haves
- Database administration, On-premises and On-cloud (Azure)
- Microsoft Dynamics - Great plains (GP )
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
Description
Must Have:
- Database administration, On-premises and On-cloud (Azure)
- Microsoft Dynamics - Great plains (GP )
- Migration of on-premises Databases to cloud
- 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.
- Confirm target VM sizing and disk configuration.
- Configure migration project and replication prerequisites.
- Prepare target network/security settings for migrated VMs.
- Prepare backup, monitoring, and Defender baseline plan for migrated workloads.
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
- Note: this role can be extended based on the performance for next 6 months/1 year
- 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+ Migration of on-premises databases to Azure cloud environment
#J-18808-Ljbffr
ETL Tester (Contract) in Toronto employer: CoreFactor Inc.
CoreFactor is an exceptional employer that fosters a collaborative and innovative work culture, where you can thrive as a Senior AI Engineer. With a strong emphasis on mentorship and professional growth, you'll have the opportunity to lead cutting-edge projects in Generative AI while working alongside passionate colleagues in a dynamic environment. Located in a vibrant tech hub, CoreFactor offers competitive benefits and a commitment to employee development, making it a rewarding place to advance your career.
