Senior SQL Server Developer

<p><strong><u>Senior SQL Server Developer</u></strong></p><p><br></p><p><strong>Salary - £75,000</strong></p><p><br></p><p><strong>Location: Fully remote - going into the Oxford office when required</strong></p><p><br></p><p><strong><u>The Role</u></strong></p><p><br></p><p>We are seeking an exceptional Senior SQL Server Developer with deep expertise in building high-performance, scalable, and mission-critical database solutions. This role is ideal for someone who lives and breathes SQL Server, understands data at a granular level, and can solve complex database challenges with elegance and precision whilst ensuring high level performance and best</p><p>practices.</p><p><br></p><p>While SQL Server mastery is the core requirement, experience with .NET (C#, ASP.NET, EF, or related frameworks) is a strong advantage. You will have the opportunity to work on large-scale, performance-heavy systems in a collaborative engineering culture where technical excellence is valued.</p><p><br></p><p>As an experienced developer you will have worked on a variety of highly available applications and have experience with high volume databases. You will be confident collaborating with engineering teams around the world to design and launch ground-breaking features. </p><p><br></p><p>You will have the experience and knowledge to make sound technology decisions and participate in architecture discussions, advocating best practices across the teams you work with. You will act as an example and data leader for less data experienced team members to learn from and have an ability to communicate at all levels with technical and non-technical stakeholders.</p><p><br></p><p>You will be a highly analytical and detail oriented individual comfortable with tools such as Elastic Search, Rollbar, Jira etc as well as having a propensity for learning and enhancing your skillset, with a mindset tuned to understand root-causes. As a database expert, you will have extensive experience in, and thrive in, designing, developing, and optimising complex T-SQL stored procedures, functions, views, and triggers. You will own the database performance, including indexing strategies, query tuning, execution plan analysis, statistics, partitioning etc. and so will take pride in producing clean, efficient and maintainable code.</p><p><br></p><p>You will collaborate with software developers, architects, and DevOps to deliver robust, efficient backend systems. You will be expected to have deep experience of conducting root-cause analysis on performance bottlenecks and database-related production issues, ensuring data integrity, security, compliance, and efficient resource utilisation. You will, as a part of the development team, participate in schema design, capacity planning, and database lifecycle management.</p><p><br></p><p>Your experience will mean that less experienced developers will look to you for guidance as a subject-matter expert for SQL Server.</p><p><br></p><p>Skills Required</p><p><br></p><ul><li>8+ years of hands-on SQL Server experience (SQL Server 2016 or later).</li><li>Strong and demonstrable experience writing and optimising advanced queries, stored procedures, functions, tables, etc.</li><li>Excellent experience in tuning and optimising performance to ensure all database code paths are optimal and performant.</li><li>Experience in using execution plans to understand and improve code execution.</li><li>Thorough comprehension of indexing strategies, concurrency and locking to ensure optimal performance.</li><li>Broad understanding and experience with SSIS</li><li>Understanding of service brokers and message queues (SSSB, Kafka etc)</li><li>Knowledge of database security and roles, as well as security and database best practices.</li><li>Working knowledge of CI/CD tools (TeamCity)</li><li>Solid experience working with source control platforms and tools such as GIT.</li><li>Experience with Cloudflare, AWS, Terraform (nice to have)</li><li>Writing database specific unit tests experience with .NET (C#, ASP.NET, EF, or related frameworks) (nice to have)</li><li>Experience with logging tools (Elasticsearch, Rollbar Sentry)</li><li>Great communication skills as a core member of an internationally-based team;</li><li>Passion for data and databases with a desire to remain up to date with the latest skills;</li><li>Experience working on high-traffic 24/7, performant data backed systems.</li><li>Experience with Agile methodologies (Sprints, Scrum, Stand-Ups)</li></ul>

Back to blog

Other Jobs To Apply

No other job posts for this day.

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...