SQL DBA and Data Warehouse Administrator Information Technology

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 ISO
  27001.

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 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.

#J-18808-Ljbffr