At a Glance
- Tasks: Design and optimise SQL Server databases for high-performance applications.
- Company: Join Sephora, a leader in the beauty retail industry with a focus on diversity.
- Benefits: Flexible remote work, growth opportunities, and a vibrant community.
- Other info: Be part of a culture that embraces authenticity and empowers your growth.
- Why this job: Make a real impact in a dynamic environment while celebrating beauty and inclusivity.
- Qualifications: Strong SQL Server development experience and T-SQL expertise required.
The predicted salary is between 50000 - 60000 £ per year.
At Sephora, beauty is about feeling seen, valued, and empowered, individually and collectively. It is connecting deeply with others, celebrating diversity and inclusivity, unlocking your potential and making a difference every day. Together, we belong to something beautiful.
Since its inception in 1969 in Limoges, France, and as part of the LVMH Group since 1997, Sephora has been disrupting the prestige beauty retail industry. Today, Sephora continues to break with convention to drive its mission: champion a world of inspiration and inclusion where everyone can celebrate their beauty.
With 56,000 employees in 35 countries, we connect customers and beauty brands within the world’s most passionate beauty community. With a curation of nearly 500 brands, and our own label, Sephora Collection, we offer the most unique and diverse range of products: fragrances, makeup, hair care, skincare... and much more.
The Opportunity
We’re seeking an experienced SQL Server Database Developer to design, optimise, and support the transactional SQL Server databases that power business-critical applications. This is a hands-on, application-focused role centred on advanced T-SQL development, query optimisation, and performance tuning, with secondary responsibility for production DBA activities.
The role involves writing T-SQL to support application performance and reliability, collaborating closely with software engineering teams, and supporting production SQL Server environments as needed.
What you’ll be doing…
- You’ll design, develop, and optimise high-performance SQL Server solutions, including:
- Designing and optimising database schemas for high-transaction application workloads.
- Developing and tuning complex T-SQL (stored procedures, views, functions, triggers).
- Analysing execution plans and resolving performance bottlenecks, blocking, and deadlocks.
- Optimising indexes, statistics, and query patterns, including ORM-generated SQL.
- Working with XML and JSON data structures within SQL Server.
- Partnering closely with software engineers to support application design, releases, and performance.
This role is open to candidates based in London or remote, based in the UK.
What you'll bring…
- You’ll bring strong experience as a SQL Server developer working in production OLTP environments, with the confidence to support core DBA responsibilities when needed.
- You will be able to demonstrate:
- Strong experience as a SQL Server Developer in production OLTP environments, with confidence to support core DBA responsibilities when required.
- Expert T-SQL skills with a focus on query optimisation and performance.
- Experience with high-volume, performance-critical application databases.
- Strong understanding of indexing, statistics, Query Store, and DMVs.
- Experience diagnosing SQL Server performance issues across database and OS layers.
- Working knowledge of HA/DR, backup, and recovery strategies.
- Familiarity with Agile delivery, GitHub, Redgate tools, and ORM-generated SQL.
- Experience with SSIS is beneficial but not a core focus.
Here, you will find:
- Community, in which authenticity is embraced, and the strength of our differences fuels our collective spirit.
- Culture of empowerment, learning & growth, that offers you the tools, space and opportunity to learn, innovate and lead.
- Work that brings fulfillment. From delighting clients every day, to inspiring our industry at large, every action makes a difference.
Join us and belong to something beautiful. At Sephora, we celebrate diversity and are committed to creating and fostering an inclusive environment for everyone.
Open Jobs SQL Server Database Developer in London employer: Sephora
Contact Detail:
Sephora Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Open Jobs SQL Server Database Developer in London
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, attend meetups, and engage with online communities. The more people you know, the better your chances of landing that SQL Server Developer role at Sephora.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your T-SQL projects and any performance tuning you've done. This will give potential employers a taste of what you can bring to their team.
✨Tip Number 3
Prepare for interviews by brushing up on common SQL Server questions and scenarios. Practice explaining your thought process when optimising queries or resolving performance issues – it’ll show you’re ready for the hands-on challenges at Sephora.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen. Plus, it shows you’re genuinely interested in being part of the Sephora community.
We think you need these skills to ace Open Jobs SQL Server Database Developer in London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the SQL Server Database Developer role. Highlight your T-SQL skills and any experience with performance tuning and optimisation. We want to see how your background aligns with what we’re looking for!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to express your passion for database development and how you can contribute to our mission at Sephora. Let us know why you’re excited about this opportunity and how you fit into our beautiful community.
Showcase Relevant Projects: If you've worked on any relevant projects, make sure to mention them! Whether it's optimising a high-transaction database or collaborating with software engineers, we love to see real examples of your work that demonstrate your skills.
Apply Through Our Website: We encourage you to apply through our website for a smoother application process. It’s the best way for us to receive your application and ensure it gets the attention it deserves. Plus, it shows you’re keen to join our team!
How to prepare for a job interview at Sephora
✨Know Your T-SQL Inside Out
Make sure you brush up on your T-SQL skills before the interview. Be ready to discuss complex queries, stored procedures, and performance tuning techniques. Practising real-world scenarios can help you articulate your thought process during the interview.
✨Understand Database Design Principles
Familiarise yourself with database schema design, especially for high-transaction workloads. Be prepared to explain how you would optimise schemas and what factors you consider when designing for performance. This shows you can think critically about the role's requirements.
✨Showcase Your Problem-Solving Skills
Prepare to discuss specific instances where you've diagnosed and resolved SQL Server performance issues. Use examples that highlight your analytical skills and ability to work under pressure. This will demonstrate your hands-on experience and confidence in tackling challenges.
✨Collaborate Like a Pro
Since this role involves working closely with software engineers, be ready to talk about your experience in collaborative environments. Share examples of how you've partnered with teams to support application design and releases, showcasing your teamwork and communication skills.