Database Administrator

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.
• Strong skills in database migration, backup, and recovery processes.
• Ability to configure and support Microsoft cloud applications and integrations.

Public Sector Experience:

Preferred