OverviewAs 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.ResponsibilitiesDesign, 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 implementationWorking 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.QualificationsKnowledge and experience of SQLAzure experience or certificationProgramming experience with Python, Ruby, R or at least one modern languageExperience in operating and maintaining cloud infrastructureExperience with automation frameworksUnderstanding of database architecture, backup and recovery, and performance tuningExperience with database clustering and replication mechanisms.Experience of working with Cloud SQLExperience of using (and ideally developing) REST APIsExperience with CI/CD pipelines, tools and DevOps practices in data engineeringExperience in contributing to the architecture and design of new and existing systemsUnix shell scripting or programming experienceStrong conceptual skills, logical/analytical thinking & problem-solving skillsDesirableExperience with Infrastructure as Code, for automation and configuration managementKnowledge and experience of DatabricksThe PackageA 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. #J-18808-Ljbffr