SQL DBA & Data Warehouse Administrator
SQL DBA & Data Warehouse Administrator
Reporting to: Infrastructure Manager
About the Role
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.
Collaboration & Support
- 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
Essential Requirements
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.