At a Glance
- Tasks: Design and maintain T-SQL stored procedures while troubleshooting database performance issues.
- Company: Join a growing legal software consultancy in London with a collaborative culture.
- Benefits: Permanent position with opportunities for professional growth and impactful work.
- Other info: Great chance to work with Azure SQL Database and develop your skills.
- Why this job: Make a real impact in a dynamic environment where your ideas are valued.
- Qualifications: Advanced SQL Server knowledge and experience in a regulated environment preferred.
The predicted salary is between 40500 - 49500 £ per year.
A new opportunity has come up for a SQL Server Developer to join a growing legal software consultancy. This is a permanent position based in London.
This is a hands-on development and troubleshooting role requiring somebody that has worked across a range of database environments and can get up to speed quickly.
Main duties
- Designing and maintaining T-SQL stored procedures.
- Providing troubleshooting support across a range of priorities.
- Investigating and resolving database performance issues.
- Working across several Azure SQL Database estates.
- Indexing strategy, query optimisation and locking and blocking.
- Reading and interpreting execution plans to identify and resolve performance plans.
Skills and experience required
- Advanced working knowledge of SQL Server.
- Demonstrable experience working inside a large, mature schema.
- Proven experience of becoming productive and getting up to speed quickly.
- A background in legal or another highly regulated environment would be beneficial.
- Hands-on development and tuning on Azure SQL Database.
- Strong communication skills.
This a fantastic chance to work in an environment where your ideas are welcomed and you can really make an impact.
You will work collaboratively and play a part in how the company grows and evolves.
For a confidential chat about this role please get in touch with Jane Eren.
Please note that where a level of preferred experience or qualification is indicated, this is a guideline only and does not preclude applications from candidates with more or less experience.
Our consultants will review your application and assess your suitability.
We endeavour to respond to all applications within 72 hours, however due to the volume of applications we receive we may not be able to respond to every candidate individually and would advise that if you do not hear from us you should assume you are not successful in your application.
#J-18808-Ljbffr
SQL Server Developer employer: Jameson Legal
As a leading commercial law firm in London, we pride ourselves on fostering a collaborative and supportive work culture that empowers our solicitors to take ownership of their projects while contributing to the growth of the practice. Our comprehensive benefits package and flexible working arrangements reflect our commitment to employee well-being, while the opportunity for professional development and mentorship ensures that our team members can build a rewarding and sustainable career in real estate law. Join us to be part of a close-knit team that values your expertise and encourages meaningful contributions across a diverse range of high-profile transactions.
StudySmarter Expert Advice🤫
We think this is how you could land SQL Server Developer
✨Tap into Local Tech Meetups
Get yourself to local tech meetups or database management conferences. It's a really great way to meet industry professionals and potentially uncover unadvertised full-time roles. When chatting with people, mention your skills and interests in database management; you never know who might be looking for someone just like you!
✨Contribute to Open Source Projects
Diving into open-source projects can not only sharpen your database skills but also get you noticed by employers. Many companies look for candidates who actively contribute to projects – it shows initiative and a real passion for the field. Plus, it's a perfect excuse to connect with other developers and expand your professional network.
✨Utilise Professional Bodies
Sign up for professional bodies related to database management, like the British Computer Society. They often host events and networking opportunities that can lead directly to job openings in the full-time market. Plus, it adds a nice touch to your professional profile!
✨Showcase Your Skills in a Public Portfolio
As you’re on the hunt for that full-time role, make sure to have a public portfolio that displays your best database projects. This can easily set you apart from the competition. And when you apply for roles, definitely mention it – it shows employers you mean business and are proud of your work!
We think you need these skills to ace SQL Server Developer
Some tips for your application 🫡
Show off your database skills:When applying for a full-time role in database management, it’s super important to highlight your skills with specific database technologies like SQL, NoSQL, or any relevant data visualisation tools. We want to see how you've used these tools in real projects, so don't shy away from detailing your hands-on experience!
Tailor your CV for data:Make sure your CV is structured clearly, focusing on your previous experience in database management. Use specific metrics to demonstrate your impact, like how you improved data retrieval times or reduced errors. This isn't just about what you've done; it’s about what you’ve achieved with your skills!
Craft a compelling cover letter:In your cover letter, share what excites you about database management and how you can contribute to Jameson Legal. Mention any relevant projects where you tackled challenges or implemented new solutions. Let us know why you want to join our team and how your passion aligns with our goals.
Document your projects:If you've worked on interesting database projects—maybe during your studies or in previous roles—be sure to include those in your application. If you can, link to a portfolio or GitHub repo where we can see examples of your work. Having a tangible showcase of your skills will really make your application stand out!
How to prepare for a job interview at Jameson Legal
✨Brush Up on Database Tools
Make sure you're well-versed with popular database management systems like MySQL, PostgreSQL, or MongoDB. Incorporating real-world examples of how you've used these tools in past projects will show that you can put theory into practice, which is something Jameson Legal will definitely appreciate.
✨Know Your SQL Inside Out
Get ready for some technical questions focused on SQL queries and database design. We should anticipate coding challenges where you might need to optimise queries or design a database schema on the spot. Practising these problems will build our confidence to impress in the interview.
✨Demonstrate Problem-Solving Skills
Besides just technical know-how, be prepared to answer scenario-based questions that test your critical thinking and problem-solving abilities. Think about how you would approach data integrity issues or handle performance bottlenecks — Jameson Legal will want to see your analytical side!
✨Show Your Collaboration Spirit
Since this is a full-time role, it's crucial to highlight how you've collaborated with cross-functional teams or contributed to team projects in the past. Emphasising our interpersonal skills will demonstrate that you’re not just a tech wizard, but also a team player who fits well with Jameson Legal's culture.
