Infrastructure SQL Engineer
Department: D365 Support
Employment Type: Full Time
Location: Dublin
Description
We are seeking an experienced Infrastructure SQL Engineer for an initial 6-month contract to support and enhance our SQL Server infrastructure. The ideal candidate will have expertise in SQL Server, SSIS, and SQL Agent, along with experience in data transformation, scripting, and API data processing. Experience with Dynamics 365 On-Prem/Cloud is highly desirable.
Key Responsibilities
* Maintain, optimize, and administer SQL Server databases.
* Develop, deploy, and troubleshoot SQL Server Integration Services (SSIS) packages.
* Manage and configure SQL Agent jobs to ensure smooth database operations.
* Design, develop, and implement Data Transformation Services (DTS).
* Work with XML and SQL XML to manipulate and transfer data efficiently.
* Develop and enhance scripts using PowerShell to automate processes (highly advantageous).
* Integrate and process data from APIs (understanding of API consumption is beneficial).
* Support and optimize Dynamics 365 On-Prem/Cloud environments (highly advantageous).
* Collaborate with cross-functional teams to ensure data integrity, performance, and security.
Skills, Knowledge and Expertise
* Strong expertise in SQL Server administration, development, and optimization.
* Experience with SSIS (SQL Server Integration Services) for ETL and automation tasks.
* Proficiency in SQL Agent for job scheduling and monitoring.
* Hands-on experience with DTS (Data Transformation Services) development and deployment.
* Familiarity with XML and SQL XML for structured data handling.
* PowerShell scripting skills for automation (highly advantageous).
* Understanding of APIs and ability to process data from API endpoints (beneficial).
* Experience with Dynamics 365 (On-Prem/Cloud) is a strong advantage.
* Strong problem-solving and troubleshooting skills.
* Ability to work independently and collaborate with remote teams.
* Experience with cloud-based database environments (Azure SQL, AWS RDS, etc.).
* Knowledge of DevOps practices related to database management.
* Understanding of security best practices in SQL environments.
#J-18808-Ljbffr