Data Engineer & SQL DBA — Hybrid (Azure)

Zenith Group; Leeds; Hybrid; GBP 50,000 - 60,000; Full time

Benefits offered by this job

Life Insurance

Critical Illness Cover

Dental

Health Cash Plans

Tech Scheme

Cycle to Work Scheme

Season Ticket Loans

Onsite GP

Job summary

Zenith Group in Leeds is seeking a Data Engineer / DBA to design, build, operate and improve reliable data platforms. Based in Leeds with agile working, you will combine hands-on database administration with data engineering to ensure databases, platforms and data services remain available and performant.

Join our Technology team to collaborate with Security, Architecture and the wider business. You will deliver monitoring, migrations and documentation while driving automation and security

Qualifications

• Experience administering Microsoft SQL Server in production environments.
• Strong SQL and performance-tuning skills, including indexing and execution plans.
• Hands-on experience with Microsoft Azure data services (Azure SQL, Data Factory or Fabric).
• Experience designing and supporting robust ETL/ELT pipelines and data integrations.

Responsibilities

• Administer and optimise production Microsoft SQL Server environments, including configuration, patching, upgrades, security and performance tuning
• Manage Azure services supporting the data platform, including access, monitoring, networking dependencies, security and cost optimisation
• Build and support reliable data ingestion, transformation and integration pipelines across cloud and on-premises sources
• Manage backup, restore, high availability and disaster recovery processes, including regular recovery testing
• Implement monitoring, alerting and operational dashboards, resolving database, platform and pipeline issues promptly
• Deliver platform migrations, upgrades and modernisation activities with appropriate testing, validation and rollback plans
• Maintain technical documentation, runbooks and operational standards while improving automation, resilience and security

Skills

SQL Server Admin

Azure Cloud

Data Ingestion

ETL/ELT pipelines

Automation scripting

Tools

Azure Data Factory

PowerShell

Python

Git

Job description

Zenith Group in Leeds is seeking a Data Engineer / DBA to design, build, operate and improve reliable data platforms. Based in Leeds with agile working, you will combine hands-on database administration with data engineering to ensure databases, platforms and data services remain available and performant.

Join our Technology team to collaborate with Security, Architecture and the wider business. You will deliver monitoring, migrations and documentation while driving automation and security