At a Glance
- Tasks: Lead the design and development of SQL Server solutions while mentoring fellow developers.
- Company: Advantis, a data-driven company focused on innovation and collaboration.
- Benefits: Hybrid work, up to 35 days holiday, and employee wellness support.
- Other info: Join a team that values continuous improvement and professional development.
- Why this job: Shape the future of data and influence technical strategy in a supportive environment.
- Qualifications: 5+ years of SQL Server experience and strong problem-solving skills.
The predicted salary is between 60000 - 75000 £ per year.
At Advantis, data sits at the heart of everything we do.
From supporting our operational teams to delivering great outcomes for our clients and customers, our systems process and manage vast amounts of critical information every day.
We're looking for an experienced Senior SQL Developer to become the technical lead for our SQL Server estate.
This is an opportunity to shape the future of our database environment, influence technical direction, mentor other developers, and deliver solutions that directly support the success of the business.
If you're passionate about database development, performance optimisation, technical leadership and building robust, scalable solutions, we'd love to hear from you.
What You'll Do
- Lead the design, development and continuous improvement of database solutions across the business
- Act as the technical authority for Microsoft SQL Server technologies, providing guidance and direction to the wider team
- Maintain and optimise business-critical SQL Server databases to ensure they remain secure, resilient and high performing
- Design, develop and review complex stored procedures, functions, views and database integrations
- Monitor database health and proactively identify opportunities to improve performance, scalability and reliability
- Troubleshoot and resolve complex database issues, including performance bottlenecks and data integrity concerns
- Support database backup, recovery and disaster recovery processes
- Collaborate with developers, analysts and business stakeholders to translate requirements into practical technical solutions
- Conduct code reviews and promote development standards and best practices
- Mentor and support less experienced developers, helping to grow technical capability across the team
- Contribute to project planning by providing technical expertise, estimates and recommendations
- Research emerging technologies and identify opportunities to improve our database platforms and development practices
Who You Are
- An experienced SQL professional with a strong track record of designing and developing Microsoft SQL Server solutions
- Passionate about technical excellence and delivering high-quality, maintainable solutions
- A natural problem solver who enjoys analysing complex issues and identifying effective solutions
- Comfortable leading technical discussions and influencing technical direction
- Able to explain complex technical concepts clearly to both technical and non-technical audiences
- A collaborative team player who enjoys supporting and mentoring others
- Organised, accountable and committed to delivering work to a high standard
- What You'll Bring
Experience
- 5+ years' experience designing and developing Microsoft SQL Server database solutions.
- Extensive experience administering and developing solutions using Microsoft SQL Server 2019 or later.
- Expert knowledge of T‑SQL development.
- Extensive experience writing and optimising complex stored procedures, functions, views and triggers.
- Strong experience designing relational database schemas and data models.
- Experience with ETL development using SSIS or equivalent technologies.
- Experience designing, supporting and optimising high‑volume transactional database environments.
- Database migration and upgrade experience.
- Technical Knowledge
- Expert knowledge of query optimisation, execution plan analysis and SQL performance troubleshooting.
- Locking, blocking and deadlock troubleshooting.
- Experience administering SQL Server Agent jobs, scheduling and automation.
- Experience designing and supporting SQL Server backup, restore and disaster recovery strategies.
- Strong understanding of SQL Server security, permissions and auditing.
- Experience with High Availability and Disaster Recovery technologies, including Always On Availability Groups, Log Shipping and Replication.
- Experience with Azure SQL Database and/or Azure SQL Managed Instance.
- Professional Skills
- Strong analytical skills with the ability to evaluate large volumes of data.
- Excellent communication skills with the ability to explain technical concepts to both technical and non-technical stakeholders.
- Strong problem-solving and critical thinking skills.
- Ability to work independently and collaboratively within a team.
- Excellent organisational and time management skills.
- Demonstrates ownership, accountability and a commitment to delivering high‑quality technical solutions.
- Experience using Git and/or Azure Dev Ops for source control.
- Experience with SQL monitoring and performance tools (e. g. Redgate SQL Monitor, Sentry One, SQL Monitor).
Why Advantis?
- Play a key role in shaping the technology that underpins our business operations
- Influence technical strategy and best practice across our development function
- Work on meaningful projects that have a direct impact on business performance
- Collaborate with talented colleagues across IT and the wider business
- Have the opportunity to mentor others and leave a lasting technical legacy
- Join a company that values innovation, continuous improvement and professional development
What We Offer
- Hybrid working opportunities
- Up to 35 days holiday per year (including bank holidays)
- Two paid volunteering days per year
- Employee Assistance Programme offering confidential support whenever you need it
- Enhanced family leave policies
- On‑site mental health first aiders
- Free access to on-demand dental services
- Long service awards
- Employee incentives, recognition schemes and social events
- Annual eye tests and contributions towards prescription glasses where required
- Free on‑site parking
- Free tea and coffee
- A supportive and collaborative working environment where your ideas are heard
Ready to make an impact?
If you're looking for an opportunity to combine hands‑on technical expertise with leadership, mentoring and strategic influence, we'd love to hear from you.
Apply today and help shape the future of data here at Advantis.
#J-18808-Ljbffr
SQL Senior Developer in Stoke-on-Trent employer: Advantis Credit Limited
At Advantis, we pride ourselves on being an exceptional employer that places data at the core of our operations. Our collaborative work culture fosters innovation and continuous improvement, providing ample opportunities for professional growth and mentorship. With a strong commitment to employee well-being, we offer generous benefits such as hybrid working, extensive holiday allowances, and a supportive environment where your contributions are valued.
