Linaker, Merseyside, England, United Kingdom
About the Role
We are excited to introduce a brand-new role: Database Engineer. This pivotal position operates within our technology department, ensuring the smooth functioning and development of our databases and pipelines. You will develop, optimize, and manage these databases, maintaining high standards for data quality, integrity, security, privacy, and compliance.
Office location: Haydock, St Helens, with flexibility for hybrid working.
What You Will Be Responsible For
* Design, develop, and optimize relational and non-relational databases across production and non-production environments.
* Provision, configure, patch, upgrade, and maintain databases.
* Automate the management of new and existing databases to ensure scalable, repeatable processes.
* Create and manage database schemas, tables, stored procedures, indexes, and triggers.
* Ensure high availability through clustering, replication, and other techniques.
* Implement and maintain data pipelines and ETL processes for real-time and batch ingestion.
* Monitor database performance and proactively address tuning and optimization issues.
* Ensure data security, privacy, integrity, and compliance with regulations.
* Collaborate with third-party suppliers, developers, data analysts, DevOps, and other stakeholders to meet project requirements.
* Plan and implement backups, restores, and disaster recovery strategies.
* Support ongoing operations, troubleshoot, and root cause analysis to prevent recurrence.
* Assist in the migration of databases and data systems between environments or platforms.
* Develop step-by-step guides and documentation for users.
* Document processes, procedures, and technical designs.
* Collaborate across departments on database-related topics and integrations.
* Work with internal customers 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 another modern language.
* Experience operating and maintaining cloud infrastructure.
* Experience with automation frameworks.
* Understanding of database architecture, backup, recovery, and performance tuning.
* Experience with database clustering and replication mechanisms.
* Experience working with Cloud SQL.
* Experience using (and ideally developing) REST APIs.
* Experience with CI/CD pipelines, tools, and DevOps practices in data engineering.
* Experience contributing to the architecture and design of new and existing systems.
* Unix shell scripting or programming experience.
* Strong conceptual, logical/analytical thinking, and problem-solving skills.
Desired
* 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.
Seniority level
Entry level
Employment type
Full-time
Job function
Information Technology
Industries
IT Services and IT Consulting
#J-18808-Ljbffr