Having started in 2006 with just three team members, we've evolved into a multi-brand, ecommerce giant with offices worldwide and a passionate team of over 4,000.  In the past year alone, we've achieved remarkable milestones including automating our Sheffield distribution centre, launching our US warehouse, and initiating our tech re-platforming.

In Tech, we’re proud to support every function.  We’re a digital-first company that is totally cloud native.  We embrace change and future-proof the business, delivering critical customer facing and internal stakeholder facing systems.  Everything from colleague tech to frontend websites and apps, buying and merchandising tooling, and all that’s in-between, we take care of it.  Our ideas support and drive the Group’s agenda.

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.

• 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

Benefits

Why join us

We know that as a company we are only as good as the people that we employ. We know our employees work tirelessly to make PLT the success it is today and in turn, we offer them some amazing benefits:

• 25 days holiday plus bank holidays
• Discretionary bonus scheme
• Employer pension contribution
• Company share scheme
• Flexible working hours
• Late start, early Friday finish
• Life assurance
• Free gym membership
• Employee assistance programme including 24-hour confidential helpline
• 40% discount across 8 brands, 20% discount on Debenhams
• Discount portal
• Learning and development support and opportunities both internally and externally
• Payday drinks monthly and ad hoc events throughout the year

As well as the great perks and benefits listed above upon joining you will also have access to several flexible benefits on our Reward Platform “Beyond” such as cycle to work, healthcare cash plan and technology

#Tech #LI-GS1 #LI-ONSITE