SQL Applications Systems Engineer

SQL Applications Systems Engineer - SQL Server, iManage, PowerBI, SSIS, SSAS, SSRS, Fabric, Azure

Our leading global law firm client are actively looking to take on a new SQL Applications Systems Engineer (SQL Server, iManage, PowerBI, SSIS, SSAS, SSRS, Fabric, Azure) to join their team on a permanent basis, this role will be responsible for the maintenance of all SQL Instances and databases & maximising availability.

Our client are one of the most pleasant firms within the City of London and take pride in their treatment of staff, well-being and balance. This role will sit within a small team who take care of backend technologies working globally with Developers, Engineers & Architects. It will require a strong understanding of how tech works from a back-end perspective and supporting modern technology & AI tools.

To be considered for this SQL Applications Systems Engineer (SQL Server, iManage, PowerBI, SSIS, SSAS, SSRS, Fabric, Azure) role, it's ideal you have:

• 5 + Years in a similar role
• Ideal but not required law-firm experience (or iManage knowledge)
• Strength within SQL and SQL Server tools
• Preferably Azure knowledge

Primary Responsibilities and/or Essential functions:

• Monitor and maintain all SQL instances and databases in order to maximize system availability. Promptly diagnose and resolve any issues as they arise. Provide support to the application owners, as needed.
• Configuration and installation of Microsoft SQL Server, including log shipping, database mirroring, SQL Replication, and AlwaysOn Availability Group setup.
• Proactively manage and monitor SQL Server infrastructure and assist teams to tune performance and remediate any issues utilizing the database infrastructure.
• Support the firm’s document management system and support any related tasks.
• Design, implement, and maintain data integrations between Firm systems. Maintain and enforce data consistency across those systems.
• Design, implement, and maintain solutions to assist in the delivery and analysis of data stored in Firm systems through the use of SQL Server business intelligence tools.
• Advise IS staff, managers, external vendors, and consultants, r on the architecture and configuration of new and existing SQL systems and their related applications. Responsible for installations, upgrades, and systems customizations. Establish, maintain, and follow group procedures and policies related to the SQL Server environment, including installations, configurations, backups, disaster recovery, and other such operations.
• Manage projects independently, adhering to and helping to establish timelines and budget limits.
• Act as a team leader and coach, and advise more junior staff members.
• Any additional responsibilities as required by management.