DBA & Legal Applications Technician

What we will offer

What we will offer:

We will offer you a place where you can be yourself and where there are no limits on what you can achieve. With us, you can take ownership of your career and have honest conversations throughout. You would join an ambitious firm with a clear strategy for profitable growth where you can get early responsibility and early involvement in growing the business. Here you can expect a competitive and fair reward as well as recognition based on all round performance. This forms part of our internal promise to you, The Deal, between the firm and its employees.

You can expect:

• A competitive salary and a host of family friendly policies
• Life assurance, private health and dental care for you and your family
• A range of flexible benefits including gym discount and retail vouchers
• We support the causes you care about by giving you one day per year off to volunteer with any charity that you are involved with outside of work
• A wellbeing strategy that focuses on preventative measures to maintain overall health, and tools and support for when our people experience physical or mental difficulties. The strategy focuses on four pillars: physical, emotional, financial and social aspects.
• Most of our roles are hybrid, meaning that colleagues benefit from working in our office and remotely. We are happy to discuss this and other flexible working arrangements with you as part of the application and interview process.
• We are an equal opportunity organisation, committed to having a diverse workforce. We do not discriminate on the basis of age, sex, race, disability, sexual orientation, culture, or any other protected characteristics. We aim to create a culture where everyone can be themselves and is valued for their strengths and unique perspectives.

Team Structure

The team sits in the IT Department and works closely with both IT Applications and Development teams and Accounts departments with ownership of the firm's key business systems including; PMS – Aderant Expert, Reporting & Budgeting and the Intapp suite of products as well as integrations between all of the firms systems.

The team leads innovations around the utilisation of systems, best practice and develops bespoke solutions to support business needs. This position will suit an individual with proven experience in reviewing, recommending and implementing both processes and solutions. They should also have good accounting knowledge, Billing, Accounts Payable or Cashiering processes, excellent technical skills and be comfortable leading all aspects of project delivery.

Main Responsibilities

• Responsibility for maintaining the integrity and performance of SQL servers and related databases together with recommendations for enhancements.
• Management and implementation of security of all SQL Server databases, including regular review as per ISO27001.
• Ownership and control of user access permissions and privileges.
• Commissioning and decommissioning of SQL Servers in all environments.
• Maintain and automate refreshes of environments, patching and upgrades – this may be regular or ad-hoc.
• Software installations of the firms key business systems such as Aderant Expert, I4G, Spotlight, PTX, Intapp in all environments.
• Ownership of ISO27001 within Business Systems Team.
• Testing after monthly Windows Patching (Server and PCs), Powerdown and other IT system upgrades.
• Aderant Expert – Reviewing and executing fixes via SQL (post CAB approval).
• Mobile devices – deployment, upgrading and testing of Apps (after OS upgrades).
• Deployment of SSRS reports and maintenance of environments.

Attributes/Skills Required

• Substantial experience as a SQL Server DBA or in a similar role
• Substantial experience with Performance Tuning and Optimization (PTO)
• Substantial experience with backups, restores, and recovery models
• Substantial experience with High Availability (HA) and Disaster Recovery (DR) options for SQL Server
• Familiarity with the main data manipulation languages and the principles of database design
• A willingness to keep up to date with developments in new technology
• Experience with Windows server, including Active Directory preferred
• Previous law firm experience preferred

Flexibility - some out of hours working will be required; particularly around enhancements and upgrades, month-end processes, potential unexpected downtime and monthly server patching.

This job description is indicative only and does not represent an exhaustive list of responsibilities. The firm reserves the right to alter or change the responsibilities at any time, in line with the firm's strategy and business needs.

About the Firm

Stephenson Harwood is an international law firm, and we're committed to creating 'positive partnerships' with our clients. We represent listed and private companies, institutions and individuals, building lasting relationships to help them succeed in a complex andever-changing world.

Our focus is on five core sectors: Energy Transition, Life Sciences and Healthcare, Private Capital and Funds, Technology, and Transportation and Trade.

With more than 1,400 people, including 210+ partners, across eight offices in Europe, the Middle East and Asia, we combine deep legal capabilities and broad commercial expertise. We have also forged close ties with high quality law firms around the world, blending local knowledge with global savvy for clients in over 100 countries.

We understand the power of diversity in delivering that high calibre advice to our clients. We want to attract diverse talent and we particularly encourage applications from underrepresented demographics.

Our brand strengths:

• GO FAR, GO TOGETHER
• EXPERTS IN MORE THAN LAW
• CAN DO PERSONALITIES
• ALWAYS READY