SQL DBA

Job Specification

Job Title: Database Administrator

Department: IT

Location: LONDON

Reports to: Head of Applications

Date of Version: March 2025

Agreed by Jobholder: (name)

Agreed by Manager: Awin George

Jobholder Sign-off:

Manager Sign-off:

Reporting Relationships:

Reporting into the Westfield Specialty International (WSI) Head of Applications.

Main Purpose of Role:

• To create, manage, tune, develop, and remediate WSI’s database estate (currently Sql Server and Snowflake - Optional).

Key Accountabilities:

• Monitor health of WSI’s databases.
• Develop database DDL and DML code, including but not limited to functions, views, tables, stored procedures.
• Develop, implement, and monitor database backups and recovery within an Azure environment.
• Work with development and support teams to remediate database failures.
• Proactively tune the databases using maintenance plans.
• Liaise with Managed Service provider to deploy changes to the environment.
• Work in concert with and manage data architect role holder.

Role Requirements:

The WSI DBA will be responsible for the health and performance of WSI’s Azure based databases. Working closely with the Head of Applications, the application developers, and support teams, the DBA will be involved in all aspects of database creation, development, support, and tuning.

Skills/Competencies:

• Ability to prioritise multiple competing deadlines.
• Good written and verbal communication.
• Eye for attention to detail.
• Ability to think creatively to develop innovative solutions for business challenges.

Experience:

• Experience in managing multiple databases and instances in a cloud environment.
• Experience in developing and remediating database views, functions, and stored procedures.
• Experience in ETL and Analytics technologies (SSIS, SSAS, Click Replicate, Snowflake, Power BI).
• Working for a medium size organisation in a period of rapid change.
• London Market experience preferred.
• Lloyds experience desirable.

PRA Conduct Standards:

• You must act with integrity.
• You must act with due skill, care, and diligence.
• You must be open and cooperative with the FCA, PRA, and other regulators.
• You must take reasonable steps to ensure that the business of the firm for which you are responsible is controlled effectively.
• You must take reasonable steps to ensure that the business of the firm for which you are responsible complies with the relevant requirements and standards of the regulatory system.
• You must take reasonable steps to ensure that any delegation of your responsibilities is to an appropriate person and that you oversee the discharge of the delegated responsibility effectively.
• You must disclose appropriately any information of which the FCA or PRA would reasonably expect to have notice.
• When exercising your responsibilities, you must pay due regard to the interests of current and potential future policyholders in ensuring the provisions by the firm of an appropriate degree of protection for their insured benefits.

FCA Conduct Rules:

• You must pay due regard to the interests of customers and treat them fairly.
• You must observe proper standards of market conduct.