Job Summary:

The Intermediate Database Administrator is responsible for managing and optimizing both on-premises and cloud-based databases, primarily focusing on Microsoft SQL Server environments. This role involves administration of Microsoft Dynamics GP, Salesforce CRM, and migration of databases to Azure cloud. The position requires hands-on experience with database design, performance tuning, backup, recovery, and integration with Microsoft cloud services and related applications.

Responsibilities:

- Create and maintain physical database designs and administer the database management system (DBMS).
- Optimize database performance, capacity planning, installation, and migration tasks.
- Manage day-to-day operations of Microsoft Dynamics GP and collaborate with finance teams.
- Lead migration projects including VM sizing, disk configuration, network/security setup, and replication prerequisites.
- Develop and maintain backup, monitoring, and security baseline plans for migrated workloads.
- Support application development and integration in Microsoft Cloud environments, including SharePoint, MS Teams, and Power Apps.
- Administer and support public-facing websites using Microsoft content management solutions and third-party API integrations.

Required Skills:
- Proven experience in database administration for SQL Server in both on-premises and Azure cloud environments.
- Hands-on expertise with Microsoft Dynamics GP and finance system concepts.
- Experience with Salesforce CRM administration and integration.
- Strong skills in database migration, backup, recovery, and performance tuning.
- Familiarity with report generation tools such as SQL Report Builder.
- Experience supporting Microsoft cloud-based applications including SharePoint, MS Teams,



and Power Platform.

Desired Skills:
- 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).
- Salesforce Certified Administrator.
- Experience with Microsoft Dynamics 365 Finance and Business Central.

Rated Criteria:
- SQL Server Database Administration - 30 Points
- Microsoft Dynamics GP Expertise - 20 Points
- Cloud Migration and Azure Administration - 20 Points
- Salesforce CRM Experience - 15 Points
- Report Generation and Application Integration - 10 Points
- Backup, Recovery, and Security Management - 5 Points

Total: 100 Points Deliverables:
- Optimized and fully operational SQL Server databases across on-premises and cloud platforms.
- Successful migration of databases and workloads to Azure with configured VM sizing and security.
- Maintained Microsoft Dynamics GP environments supporting finance operations.
- Integrated Salesforce CRM with database systems and generated required reports.
- Documentation of database designs, migration plans, backup procedures, and security baselines.
- Support and maintenance of cloud-based Microsoft applications and public-facing websites.

Must Haves:
- Extensive experience in SQL Server database administration both on-premises and Azure cloud.
- Proven track record managing Microsoft Dynamics GP environments.
- Hands-on experience with Salesforce CRM systems.
- Robust skills in database migration, backup, and recovery processes.
- Ability to configure and support Microsoft cloud applications and integrations.

Public Sector Experience:

Preferred

📌 Database Administrator (Toronto)
🏢 vTech Solution
📍 Toronto