Our client, a leader in bricks, stones and masonry products is looking to add a talented SQL server administrator and dynamic 365 Developer to their IT team

ROLE SUMMARY The SQL Server Database Administrator & Dynamics 365 Developer will be responsible for managing and optimizing the company’s SQL Server databases, as well as designing, developing, and supporting solutions within the Dynamics 365 Business Central and Customer Relationship Management (CRM) platforms. Reporting to the Director of IT, this role combines deep technical expertise in database administration with hands-on development and support of business-critical Dynamics systems. This individual will collaborate with IT teams, developers, business analysts, and external stakeholders to ensure the successful deployment and operation of database and CRM solutions, ensuring optimal performance, availability, and security.

RESPONSIBILITIES

SQL Server Database Administration:

• Database Management: Oversee and manage all SQL Server databases, including installation, configuration, and maintenance.
• Performance Optimization: Monitor system health and performance metrics, troubleshoot bottlenecks, and optimize SQL queries to maintain high levels of performance and availability.
• System Security: Implement and maintain SQL security controls, ensuring compliance with company and industry standards.
• Backup & Recovery: Manage database backup processes, including backups, restores, and recovery models, with a focus on disaster recovery and high availability (HA) strategies.
• Automation & Maintenance: Refine and automate regular processes, including database health checks, maintenance plans, and reporting on system status. Document changes, solutions, and processes to ensure accuracy and ease of access for the team.
• Real-Time Problem Solving: Analyze and correct performance and availability issues in real-time, providing solutions to minimize downtime and improve system reliability.
• Support Development Teams: Collaborate with software developers to assist in query tuning, indexing, and schema design to ensure efficient use of database resources.
• 24/7 Production Support: Provide critical support for production systems, addressing issues and performing routine maintenance, including after-hours work for planned maintenance or release deployments.
• Service Packs & Updates: Regularly download, test, and apply SQL Server service packs, updates, and security patches to maintain the integrity and functionality of the systems.
• Architecture Recommendations: Provide recommendations on database architecture, implementing industry best practices for optimal performance and scalability.
• Disaster Recovery Planning: Work closely with the IT Director to develop, maintain, and test disaster recovery plans, ensuring readiness in case of system failure.

Dynamics 365 Business Central & CRM Development:

• Business Central Development: Design and develop business solutions within Dynamics 365 Business Central, ensuring integration with SQL Server databases.
• Client Consultation: Work closely with internal teams and clients to understand business processes, requirements, and key objectives related to Business Central and CRM solutions.
• Technical Specifications: Document detailed design and technical specifications to support the implementation and delivery of Dynamics 365 solutions.
• Integration Development: Provide development and support for integrations between Dynamics systems and external applications, using Microsoft technologies like Azure and Power Platform.
• Customizations: Perform customizations within Dynamics CRM to align with business processes, including coding, configuration, and unit testing.
• Lifecycle Development: Oversee full lifecycle application development within Dynamics 365, including design, development, testing, and deployment using Microsoft Azure DevOps and established SDLC best practices.
• Support & Troubleshooting: Provide ongoing support for deployed Dynamics solutions, troubleshooting issues, and ensuring smooth integration with other enterprise systems.
• Collaboration: Work closely with business analysts, management, and IT infrastructure teams to design and deliver effective technical solutions for the company’s CRM and ERP systems.

QUALIFICATIONS

• Education: Bachelor’s Degree in Computer Science, Information Technology, or a related field is preferred.
• Experience:

·        5+ years of experience as a SQL Server Database Administrator or in a similar role.

·        Proven expertise with Performance Tuning and Optimization (PTO), backups, restores, and disaster recovery strategies.

·        Strong understanding of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.

·        5+ years of experience working with Windows Servers and Active Directory.

·        Hands-on experience with Dynamics 365 Business Central and Dynamics CRM (5+ years preferred).

·        Knowledge of integration techniques with Microsoft Power Platform, Azure services, and third-party applications.

• Certifications: Relevant certifications such as MCTS, MCITP, MVP in SQL Server, Dynamics 365, or related areas are advantageous.

SKILLS AND COMPETENCIES

• Technical Expertise: Proficient in both SQL Server database architecture and Microsoft Dynamics 365 development.
• Problem-Solving: Strong critical thinking and troubleshooting skills, with the ability to diagnose and solve issues across SQL databases and Dynamics systems.
• Collaboration: Excellent communication skills, with the ability to work closely with developers, business stakeholders, and external clients.
• Ownership: A sense of accountability and pride in maintaining critical systems that support company operations.
• Process Improvement: A continuous improvement mindset with the ability to refine processes, automate tasks, and streamline operations.
• Time Management: Strong ability to manage multiple projects and priorities efficiently.