Automation Database Administrator

Why join us?The Integrations Database Administrator will play a critical role in designing, developing, andsupporting data integrations across a diverse landscape of systems, with a strong emphasis onMicrosoft SQL Server and SQL Server Integration Services (SSIS). This role involves building andmaintaining robust SSIS pipelines, ensuring data integrity and performance, and supporting themigration of legacy integrations to modern orchestration platforms such as SnapLogic. Thepostholder will also contribute to the operational management of SQL Server environments,including patching, troubleshooting, and availability group administration. This is a predominantlyoffice based role with flexibility for occasional remote working.

Responsibilities

• Design, develop, and maintain integrations between multiple systems using APIs or SQL Server Integration Services.
• Build, test, and troubleshoot SSIS integration pipelines.
• Migrate legacy integrations into a new API orchestration platform 'SnapLogic'.
• Migrate SSIS pipelines to and from alternative integration platforms.
• Collaborate with cross-functional teams to identify integration requirements and develop solutions.
• Troubleshoot and resolve integration issues.
• Continuously monitor and improve the performance of integrations.
• Keep up to date with industry developments and trends in integration technologies.
  

What will help you succeed in this role?

Essential

• Proven experience building and maintaining integrations between multiple systems using APIs or SQL Server Integration Services.
• Experience migrating legacy integrations into a new API orchestration platform 'SnapLogic'.
• Experience migrating SSIS pipelines to and from alternative integration platforms.
• At least junior-level experience as a Microsoft SQL Database Administrator.
• Experience working with SQL Server versions 2012 through 2019.
• Experience patching and updating SQL Server instances.
  

Desirable

• Ability to articulate business and technical solutions to stakeholders who may not have technical knowledge.
• Familiarity with integration and orchestration platforms (e.g. SSIS, SnapLogic etc).
• Strong analytical and problem-solving skills.
• Ability to work independently and as part of a team.
• Ability to create and maintain relevant documentation on any integration you design or
  

contribute to.What we offerAt DWF, we deeply appreciate the significance of offering a comprehensive rewards package that extends beyond a basic salary. Our commitment is to ensure that each member of our team not only feels valued but is also duly rewarded throughout their tenure with us. Upon joining our organisation, you will have the opportunity to select from a diverse array of benefits, allowing you to carefully tailor a package that perfectly aligns with your individual needs and those of your family. In addition to our standard benefits, we offer a wide range of flexible benefits and robust well-being programs. Our recruitment process upholds the highest standards of fairness and engagement. It includes comprehensive interviews and, at times, a written assessment, an assessment day, or presentation. We aim to create a positive experience for all candidates and offer any adjustments or additional support.

About Us

DWF is a global legal business providing Complex, Managed and Connected Services. We empower people to be themselves within an inclusive and supportive environment, enabling everyone to achieve their full potential in line with their abilities and career aspirations.