SQL DBA and Data Warehouse Administrator

Reports To Infrastructure Manager

About the Role

We’re looking for a hands-on SQL DBA with strong Data Warehouse experience who can manage, optimize, and secure our data platforms while delivering high-quality analytics through Power BI and creating/maintaining reports leveraging SAP Datasphere. This role spans operational database administration, data model governance, ETL/ELT pipelines, and BI/reporting enablement—working closely with business stakeholders, SAP teams, and BI developers to turn data into actionable insights.

Key Responsibilities

Database Administration & Data Warehouse

• Administer, monitor, and optimize Microsoft SQL Server instances, including backups, log shipping/AGs, patching, and security hardening.

• Own Data Warehouse operations, including star/snowflake schema design, indexing strategies, partitioning, and performance tuning for large datasets.

• Implement and maintain ETL/ELT pipelines, including scheduling, error handling, and data quality checks.

• Manage database capacity planning, storage optimization, and version control for DB objects.

• Ensure data integrity, governance, lineage, and compliance with GDPR and ISO27001.

Power BI & Analytics Enablement

• Develop and maintain Power BI datasets, semantic models (Tabular), and reports/dashboards following best practices.

• Optimize DAX measures and Power Query transformations for performance and usability.

• Manage Power BI workspace governance, data gateways, refresh schedules, and report lifecycle in coordination with IT and business teams.

SAP Datasphere Reporting

• Design, build, and maintain reports and data models integrated with SAP Datasphere.

• Collaborate with SAP teams to define data contracts, ensure model alignment, and troubleshoot data access and performance issues.

• Standardize semantic definitions and KPIs across SAP and non-SAP sources to deliver consistent analytics.

Security, Compliance & Reliability

• Implement role-based access control (RBAC), encryption at rest/in transit, auditing, and policy-based management.

• Maintain DR/BCP documentation and runbook procedures; perform regular restore tests and failover drills.

• Monitor system health using native tools and enterprise monitoring.

Collaboration & Stakeholder Engagement

• Translate business requirements into high-quality data models and BI solutions.

• Create and maintain technical documentation and data dictionaries.

• Provide L2/L3 support for BI/data platform incidents and mentor junior analysts/engineers.

PERSON SPECIFICATION (essential requirements)

Qualifications

· Bachelor’s degree in Computer Science, Information Systems, or equivalent experience.

· Relevant certifications are a plus: Microsoft Certified: Azure Database Administrator Associate, Power BI Data Analyst Associate, SAP Datasphere certifications.

Experience

· Proven experience in SQL DBA or Data Warehouse Engineer in enterprise environments.

· Strong expertise in Microsoft SQL Server administration (performance tuning, indexing, query optimization, backups/restore, HA/DR).

· Proven experience with Data Warehouse design.

· Hands-on with Power BI.

· Experience building reports/models against SAP Datasphere, including connectivity, permissions, and performance considerations.

· ETL/ELT tools: SSIS and/or Azure Data Factory (or equivalent).

· Strong SQL/T-SQL coding standards, stored procedures, functions, and query plan analysis.

· Understanding of data governance, privacy (GDPR), security controls, and audit requirements.

· Excellent communication skills and stakeholder management.

Department

Information Technology

Role

SQL DBA and Data Warehouse Administrator

Locations

Guildford

Employment type

Full-time

Job Reference

2109

Already working at Surrey Satellite Technology Ltd.?

Let’s recruit together and find your next colleague.