About the Role:
We are seeking an experienced SQL Developer with expertise in Microsoft Dynamics to join our client's Dublin team on a contract basis.
In this role, you will work with cutting-edge technologies to enhance and support the Microsoft Dynamics environment, providing key insights and optimizing data systems to improve business processes.
Responsibilities:
* Develop and optimize SQL queries, reports, and stored procedures for Microsoft Dynamics systems.
* Design and implement custom solutions, using Microsoft Dynamics 365 (CRM/ERP) as a platform.
* Work with the business team to gather requirements and translate them into effective database-driven solutions.
* Ensure the successful integration of Dynamics 365 with other databases, applications, and third-party services.
* Troubleshoot and resolve SQL-related issues in Dynamics environments.
* Build data models and write custom queries for reporting and analytics in Power BI and other reporting tools linked with Dynamics.
* Maintain data integrity and improve database performance through regular tuning and optimization of queries and indexes.
* Provide ongoing maintenance and support for Dynamics-related SQL processes.
* Contribute to the development of automated workflows and system processes within the Dynamics ecosystem.
* Document SQL scripts, procedures, and processes to ensure clarity and maintainability.
Required Skills and Experience:
* Proven experience as an SQL Developer with a focus on Microsoft Dynamics (Dynamics 365, Dynamics CRM, or ERP).
* Proficiency in T-SQL, SQL Server, and querying Dynamics data.
* Experience with data integration between Microsoft Dynamics and external systems.
* Strong understanding of Dynamics 365, including data structures, customization, and reporting tools.
* Familiarity with data extraction, transformation, and loading (ETL) processes.
* Ability to write optimized queries and scripts for reporting and analytics in tools like Power BI.
* Experience in troubleshooting performance issues and optimizing SQL queries in a Dynamics environment.
* Solid understanding of relational database principles, data models, and database performance tuning.
Preferred Skills:
* Experience with Microsoft Power Platform, including Power Automate and Power Apps.
* Knowledge of Azure cloud platforms and integration with Dynamics.
* Prior experience with Agile development processes and collaborative team environments.