The role
will consist of both proactive & reactive maintenance or development of the instances as required, you will effectively manage large volumes of data, providing a seamless flow of information throughout the company and driving insights to support critical business decisions.
Responsibilities
1. Managing database servers, MS-SQL, and related Windows technologies, to ensure data integrity and efficient data access.
2. Developing and optimising SQL queries and scripts to efficiently extract, transform, and load data.
3. Monitoring and optimising SQL Server performance, including query optimisation and index tuning.
4. Designing and implementing database maintenance plans, including database consistency checks, index rebuilds, and statistics updates.
5. Collaborating with cross-functional teams to identify and analyse business requirements.
6. Creating and maintaining documentation, including data dictionaries and database architecture diagrams.
7. Monitoring database performance and proactively identifying and resolving issues.
8. Reviewing existing queries and writing to gain performance advantages where possible.
9. Develop, implement and optimize stored procedures and functions using T-SQL
10. Conducting data analysis to provide insights and support decision-making processes.
11. Supporting data migration and integration projects, ensuring data quality and consistency.
12. Staying current with industry trends, best practices, and emerging technologies in database management and administration.
Requirements
13. Proven experience working in a similar role, and experience with SQL server 2016 and 2019.
14. Strong T-SQL Development experience
15. Ability to review existing code and rework where performance issues are discovered.
16. SQL SSRS, SQL SSAS and SQL SSIS.
17. Working knowledge and experience with an ERP system.
18. Previous experience with Sage200 preferred.
19. Extensive experience of database management in high throughput environments & databases of a large size (10’s of TB’s).
20. Experience of archiving SQL data, (cold and warm).
21. Proficiency in SQL Server performance monitoring and optimisation, including query optimisation and index tuning.
22. Experience with high availability and database clustering (with Always on Availability Groups).
23. Experience with SQL Replication.
24. Awareness of operating within the parameters of an ITIL infrastructure environment and adhering to processes such a raising a Change Request (CR) and accurately documenting your work.
25. Strong problem-solving skills and the ability to troubleshoot complex database issues quickly and effectively.
26. Excellent communication and interpersonal skills, with the ability to collaborate effectively with cross-functional teams and communicate technical concepts to non-technical stakeholders.
27. Microsoft Certified Solutions Associate (MSCA) certification in SQL Server desirable.
28. Experience supporting Internet Information Services (IIS) and working knowledge of other database technologies advantageous.
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:
29. 25 days holiday plus bank holidays
30. Discretionary bonus scheme
31. Employer pension contribution
32. Company share scheme
33. Flexible working hours
34. Late start, early Friday finish
35. Life assurance
36. Free parking
37. Free gym membership and classes on a daily basis including yoga, PT classes and sound relaxation
38. Employee assistance programme including 24-hour confidential helpline
39. 40% discount across 8 brands, 20% discount on Debenhams
40. Discount portal
41. Learning and development support and opportunities both internally and externally
42. 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