Database Engineer - Haydock

ABOUT THE ROLE

As part of our continuous growth and commitment to excellence, we are excited to introduce a brand-new role: Database Engineer. This pivotal position will operate within our technology department, which plays an essential role in ensuring the smooth and efficient functioning and development of our databases and pipelines. 

You will be responsible for developing, optimising and managing these databases and ensuring a high-level of data quality and integrity. You will be defining the principles and processes that underpin data management while ensuring we maintain the highest standards for data management, security, privacy and compliance.

WHAT YOU WILL BE RESPONSIBLE FOR

Design, develop, and optimise relational and non-relational databases across production and non-production environments.

Provisioning, configuring, patching, upgrading, and maintaining databases.

Automating the management of new and existing databases to ensure that processes are repeatable and scalable.

Create and manage database schemas, tables, stored procedures, indexes, and triggers.

Ensuring high availability of databases through clustering, replication, and other techniques.

Implement and maintain data pipelines and ETL processes for real-time and batch data ingestion.

Monitor database performance and proactively address issues related to tuning and optimization.

Ensure data security, privacy, integrity, and compliance with internal and external regulations.

Collaborate with third-party suppliers, software developers, data analysts, DevOps, and other stakeholders to meet project requirements.

Plan and implement database backups, restores, and disaster recovery strategies.

Taking an active role in supporting and in finding the root cause of operational issues and preventing recurrences.

Support the migration of databases and data systems between environments or platforms.

Develop detailed step-by-step guides to facilitate user understanding and implementation

Working with internal teams to document processes, procedures, and technical designs related to database management.

Taking an active role in collaborating across the various departments on database related topics and integrations.

Working with colleagues, internal customers and stakeholders on new features and capabilities.
WHAT WE ARE LOOKING FOR

Knowledge and experience of SQL

Azure experience or certification

Programming experience with Python, Ruby, R or at least one modern language

Experience in operating and maintaining cloud infrastructure

Experience with automation frameworks

Understanding of database architecture, backup and recovery, and performance tuning

Experience with database clustering and replication mechanisms.

Experience of working with Cloud SQL

Experience of using (and ideally developing) REST APIs

Experience with CI/CD pipelines, tools and DevOps practices in data engineering

Experience in contributing to the architecture and design of new and existing systems

Unix shell scripting or programming experience

Strong conceptual skills, logical/analytical thinking & problem-solving skills
Desirable

Experience with Infrastructure as Code, for automation and configuration management

Knowledge and experience of Databricks
THE PACKAGE

A Competitive starting salary with annual pay reviews.

25 Days holiday plus bank holidays.

Plenty of opportunity for progression.

Flexibility for hybrid working.

Health care and medical insurance available after a qualifying period