IT SQL Developer in London

IT SQL Developer in London

London Full-Time 36000 - 60000 £ / year (est.) Hybrid
P

At a Glance

  • Tasks: Join our Solutions Engineering team as an IT SQL Developer, enhancing database integrations and data warehouse capabilities.
  • Company: Proactive Appointments Limited is a dynamic employment agency focused on equal opportunities.
  • Benefits: Enjoy flexible working options and a collaborative environment with innovative projects.
  • Other info: Ideal for those with a passion for data and a desire to make an impact.
  • Why this job: Be part of a team driving corporate strategy through data, while developing your SQL expertise.
  • Qualifications: Expertise in Microsoft SQL Server and experience in database architecture are essential.

The predicted salary is between 36000 - 60000 £ per year.

IT SQL Developer

Our client is looking for an experienced SQL Developer to work in the Solutions Engineering team within their IT department. The role will work alongside the existing development and change management teams to continue to develop and enhance our operational database integrations, and data warehouse capabilities.

Working with the Head of Development, this exciting role will consult with key stakeholders and the Head of Data Transformation on their business intelligence requirements – together developing appropriate data structures to feed our visualisation platforms and drive innovative corporate strategy.

Increasingly, they are seeking to enrich and enhance our data capabilities by consuming external data feeds. Experience of harnessing public or commercially available datasets and APIs to augment corporate data, would be beneficial.

As a SQL expert, you will assist in the development and maintenance of data integrations between operational data platforms. In addition, supporting our Application Support and Application Production teams to troubleshoot production issues where required.

Necessary Skills/Experience

• Expert in Microsoft SQL Server.

• Proficient in writing complex SQL queries to retrieve and manipulate data.

• Experience in creating and maintaining stored procedures and functions to optimize database performance.

• Experience with SSIS for data integration and ETL (Extract, Transform, Load) processes.

• Background in reporting and business intelligence tools, including SSRS.

• Experience of working within a development environment.

• Understanding of relational and dimensional data modelling.

• Familiarity with consuming external data feeds and APIs.

• Strong mathematical and statistical knowledge.

• Excellent written and verbal communication skills.

• Impeccable attention to detail.

• Strong troubleshooting skills for production issues.

• Adept at working with all types of stakeholders.

Further Desirable Skills

• Other database technologies (Oracle, MySQL, PostgreSQL, MongoDB)

• REST APIs, Web Services

• Simego / Ouvvi – data automation

• .Net

• Data visualisation tools (e.g. Tableau, Power BI)

• Python

• Dataiku

Desirable Experience

• Experience of supporting software tools such as Jira, and Service Now.

• Formal IT qualification (A Level, HND/HNC/BTEC or degree).

• Bachelor’s degree in computer science or a related field.

• 5+ years of experience in database architecture, or a related field.

• MCSE/MCSA certifications preferred.

Due to the volume of applications received for positions, it will not be possible to respond to all applications and only applicants who are considered suitable for interview will be contacted.

Proactive Appointments Limited operates as an employment agency and employment business and is an equal opportunities organisation

We take our obligations to protect your personal data very seriously. Any information provided to us will be processed as detailed in our Privacy Notice, a copy of which can be found on our website http://proactive.it/privacy-notice/

IT SQL Developer in London employer: Proactive Appointments

Proactive Appointments is an excellent employer, offering a dynamic work culture that prioritises collaboration and innovation. With a focus on employee growth, you will have the opportunity to lead significant projects like the Procentia IntelliPen implementation, while enjoying the flexibility of hybrid working arrangements in vibrant locations such as London or Yorkshire. Join us to make a meaningful impact in the pensions sector and advance your career in a supportive environment.

P

Contact Details:

Proactive Appointments Recruitment Team

StudySmarter Expert Advice🤫

We think this is how you could land IT SQL Developer in London

✨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 IT SQL Developer in London

Expert in Microsoft SQL Server
Proficient in writing complex SQL queries
Experience in creating and maintaining stored procedures and functions
Experience with SSIS for data integration and ETL processes
Background in reporting and business intelligence tools, including SSRS
Understanding of relational and dimensional data modelling
Familiarity with consuming external data feeds and APIs

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 Proactive Appointments. 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 Proactive Appointments

✨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 Proactive Appointments 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 — Proactive Appointments 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 Proactive Appointments's culture.