25 Oct
|
Cleo Consulting
|
Toronto
25 Oct
Cleo Consulting
Toronto
Assignment: RQ00834 - Database Administrator - Intermediate
Requisition: RQ00834
Job Title: Database Administrator - Intermediate
Client: Ontario Science Centre
Start Date: 2026-11-16
End Date: 2027-03-01
Department: Information Technology
Office Location: 777 Bay Street Toronto Ontario, Toronto
Business Days: 76.00
Location: 5 days in office
Public Sector Experience: preferred but not required
Must Haves:
- Database administration, On-premises and On-cloud (Azure)
- Microsoft Dynamics - Great plains (GP )
- CRM Salesforce experience
Nice to have:
- Microsoft Certified: Azure Database Administrator Associate
- Microsoft SQL Server certifications
- Microsoft Certified: Fabric Data Engineer Associate
- Microsoft Certified: Azure Administrator Associate (AZ-104)
- Microsoft Certified: Azure Solutions Architect Expert (AZ-305)
- Microsoft Fabric Data Engineer Associate (DP-700)
- Salesforce Certified Administrator
- Microsoft Dynamics GP / Dynamics 365 Finance experience
Description
Must Have:
- Database administration, On-premises and On-cloud (Azure)
- Microsoft Dynamics - Great plains (GP )
- CRM Salesforce experience
- 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 workplace, 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
Deliverables
- 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
Additional Terms
Nice to have:
- Microsoft Certified: Azure Database Administrator Associate
- Microsoft SQL Server certifications
- Microsoft Certified: Fabric Data Engineer Associate
- Microsoft Certified: Azure Administrator Associate (AZ-104)
- Microsoft Certified: Azure Solutions Architect Expert (AZ-305)
- Microsoft Fabric Data Engineer Associate (DP-700)
- Salesforce Certified Administrator
- Microsoft Dynamics GP / Dynamics 365 Finance experience
📌 Database Administrator - Intermediate (Toronto)
🏢 Cleo Consulting
📍 Toronto