Roles
Boohoo
SQL DBA DEVELOPER
Explore roles
This role has expired
Boohoo
SQL DBA DEVELOPER
Manchester
In office
Description
You will play a crucial role in managing, maintaining, and optimising our SQL database systems across the group, ensuring the availability, security, and performance of the database systems. You will help to fulfil the crucial requirement of maintaining our database servers, working alongside other members of the team on multiple projects. You will be responsible for the continued smooth running of the servers, maintenance, and development of queries both new and existing.
RESPONSIBILITIES
Managing database servers, MS-SQL, and related Windows technologies, to ensure data integrity and efficient data access.
Developing and optimising SQL queries and scripts to efficiently extract, transform, and load data.
Monitoring and optimising SQL Server performance, including query optimisation and index tuning.
Designing and implementing database maintenance plans, including database consistency checks, index rebuilds, and statistics updates.
Collaborating with cross-functional teams to identify and analyse business requirements.
Creating and maintaining documentation, including data dictionaries and database architecture diagrams.
Monitoring database performance and proactively identifying and resolving issues.
Reviewing existing queries and writing to gain performance advantages where possible.
Develop, implement and optimize stored procedures and functions using T-SQL
Conducting data analysis to provide insights and support decision-making processes.
Supporting data migration and integration projects, ensuring data quality and consistency.
Staying current with industry trends, best practices, and emerging technologies in database management and administration.
REQUIREMENTS
Commercial SQL Server database development experience, with strong T-SQL dev experience on 2016 and 2019 onwards.
Knowledge of SQL Server performance monitoring and fine-tuning queries to best advantage.
Experience with SQL SSRS, SQL SSAS and SQL SSIS. Knowledge of an ERP system such as Sage 200 is an advantage.
Experience of archiving data.
SQL Replication knowledge and experience with configuration and management.
Ability to meet deadlines in a fast paced, continually changing landscape.
Develop and optimise SQL queries and scripts to support data-driven solutions
Experience with high availability and database clustering (with Always on Availability Groups).
Analyse and troubleshoot data issues to ensure data integrity and accuracy.
Assist in the design and maintenance of databases, ensuring scalability and performance
Capability of working under your own steam, identifying improvements to be made.
Proven experience working in a similar role, and experience with SQL server 2016 and 2019.
Microsoft Certified Solutions Associate (MSCA) certification in SQL Server desirable but not necessary
Role tech stack
Boohoo
SQL DBA DEVELOPER
Manchester
This role has expired