SQL DBA and BI Developer Information Technology · GuildfordSurrey Satellite Technology Ltd (SSTL) • Guildford, England, United Kingdom
SQL DBA and BI Developer Information Technology · Guildford
Surrey Satellite Technology Ltd (SSTL)
- Guildford, England, United Kingdom
- Guildford, England, United Kingdom
À propos
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 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 .
BI & Analytics Enablement
Develop and maintain
BI datasets, semantic models (Tabular), and reports/dashboards
following best practices.
Optimize DAX measures and Power Query transformations for
performance and usability .
Manage
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)
Qualifications Bachelor’s degree in Computer Science, Information Systems, or equivalent experience.
Relevant certifications are a plus:
Microsoft Certified: Azure Database Administrator Associate ,
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
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.
Details
Department: Information Technology
Role: SQL DBA and Data Warehouse Administrator
Locations: Guildford
Employment type: Full-time
Job Reference: 2109
#J-18808-Ljbffr
Compétences linguistiques
- English
Avis aux utilisateurs
Cette offre provient d’une plateforme partenaire de TieTalent. Cliquez sur « Postuler maintenant » pour soumettre votre candidature directement sur leur site.