SQL DBA & Data Warehouse Administrator in Guildford

4Square Recruitment Ltd provided pay range

This range is provided by 4Square Recruitment Ltd. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

Direct message the job poster from 4Square Recruitment Ltd

We are seeking a hands‑on SQL DBA with strong Data Warehouse expertise to own, optimise, and secure our data platforms. You will play a key role in enabling high‑quality analytics across the business, delivering insights through Power BI and developing and maintaining reports using SAP Datasphere.

This role combines operational database administration with data warehouse design, ETL/ELT delivery, and BI enablement. You will work closely with business stakeholders, SAP teams, and BI developers to ensure data is reliable, well‑governed, and easy to consume.

Key Responsibilities

Database Administration & Data Warehouse

• Administer, monitor, and optimise Microsoft SQL Server environments, including backups, patching, log shipping/Availability Groups, and security hardening.
• Own day‑to‑day Data Warehouse operations, including schema design (star/snowflake), indexing, partitioning, and performance tuning for large datasets.
• Design, implement, and maintain ETL/ELT pipelines, with appropriate scheduling, error handling, and data quality controls.
• Manage capacity planning, storage optimisation, and version control for database objects.
• Ensure data integrity, lineage, and governance in line with GDPR and ISO27001 requirements.

Power BI & Analytics Enablement

• Develop and maintain Power BI datasets, semantic (Tabular) models, reports, and dashboards in line with best practices.
• Optimise DAX measures and Power Query transformations for performance and usability.
• Manage Power BI workspaces, data gateways, refresh schedules, and report lifecycle in collaboration with IT and business teams.

SAP Datasphere Reporting

• Design, build, and maintain reports and data models integrated with SAP Datasphere.
• Work with SAP teams to define data contracts, align models, and resolve data access or performance issues.
• Standardise KPIs and semantic definitions across SAP and non‑SAP sources to deliver consistent, trusted analytics.

Security, Compliance & Reliability

• Implement RBAC, encryption at rest and in transit, auditing, and policy‑based management.
• Maintain DR/BCP documentation and runbooks; perform regular restore testing and failover exercises.
• Monitor platform health using native and enterprise monitoring tools.
• Translate business requirements into robust data models and BI solutions.
• Produce and maintain technical documentation and data dictionaries.
• Provide L2/L3 support for data platform and BI incidents and support the development of junior team members.

Person Specification

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, or equivalent practical experience.
• Relevant certifications are desirable (e.g. Microsoft Azure Database Administrator Associate, Power BI Data Analyst Associate, SAP Datasphere).

Experience & Skills

• Proven experience as a SQL DBA or Data Warehouse Engineer in an enterprise environment.
• Strong expertise in Microsoft SQL Server administration, including performance tuning, indexing, query optimisation, and HA/DR.
• Solid experience designing and maintaining Data Warehouse architectures.
• Hands‑on experience with Power BI (datasets, models, and reporting).
• Experience building reports and data models using SAP Datasphere, including connectivity, security, and performance considerations.
• Experience with ETL/ELT tools such as SSIS and/or Azure Data Factory (or equivalent).
• Strong SQL/T‑SQL skills, including stored procedures, functions, and execution plan analysis.
• Good understanding of data governance, security controls, GDPR, and audit requirements.
• Excellent communication skills with the ability to work effectively with technical and non‑technical stakeholders.

Seniority level

Not Applicable

Employment type

Full‑time

Job function

Information Technology

Industries

Technology, Information and Media and IT Services and IT Consulting