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.