At a Glance
- Tasks: Lead a data compliance project and design deletion strategies for legacy SQL databases.
- Company: Join a forward-thinking consultancy focused on data integrity and compliance.
- Benefits: Competitive daily rate, hybrid work model, and opportunity to make a real impact.
- Other info: Opportunity for professional growth in a dynamic, collaborative environment.
- Why this job: Tackle complex challenges in legacy systems while shaping future compliance processes.
- Qualifications: Extensive SQL Server experience and strong analytical skills required.
- Senior SQL Database Consultant (Data Compliance / Legacy Systems) – 6 Month Contract –
- Birmingham / Hybrid – Outside IR35
About the job
Our client is looking for an experienced Senior SQL Database Consultant to lead a critical data compliance project across a complex legacy SQL Server environment.
This is a true consultancy engagement where you'll assess an undocumented database landscape, identify compliance‑related data, design a robust deletion strategy and implement a sustainable solution that can be used by the business going forward.
The environment consists of legacy systems that have evolved over more than 15 years, with bespoke applications sitting over the SQL database.
As no existing documentation or established deletion process exists, you'll play a key role in understanding the underlying data structures, ensuring data integrity and delivering a compliant, repeatable approach to data removal.
This is an Outside IR35 contract with occasional travel to the client's Birmingham office (approximately one or two visits during the engagement).
Key Responsibilities
- Analyse complex legacy SQL Server databases to understand data structures, relationships and dependencies.
- Reverse engineer undocumented database schemas and identify where compliance-related data resides.
- Design and implement a robust, repeatable data deletion strategy aligned with the client's compliance requirements.
- Develop, test and execute advanced T‑SQL scripts for identifying, validating and securely deleting data.
- Ensure referential integrity and minimise risk throughout all deletion activities.
- Carry out impact analysis to understand the effect of data removal across interconnected systems.
- Produce technical documentation covering database structures, deletion logic, dependencies and operational processes.
- Implement appropriate validation, reconciliation and audit processes to evidence successful data removal.
- Work collaboratively with business stakeholders and technical teams to translate compliance requirements into practical technical solutions.
- Leave behind a documented framework and repeatable process that enables future compliance requests to be managed efficiently.
Skills & Experience
Essential
- Extensive commercial experience working with Microsoft SQL Server.
- Advanced T‑SQL development and scripting skills.
- Proven experience working with complex legacy database environments.
- Experience reverse engineering undocumented databases.
- Strong understanding of relational database design and referential integrity.
- Experience delivering data remediation, data cleansing or compliance‑related database projects.
- Ability to analyse complex data relationships and assess the impact of data changes.
- Experience creating technical documentation and operational procedures.
- Excellent analytical and problem‑solving skills.
- Strong stakeholder communication skills with the ability to work independently.
Desirable
- Experience delivering GDPR or wider data compliance initiatives.
- SQL Server performance tuning and database administration experience.
- Experience working with bespoke or highly customised legacy business systems.
- Knowledge of data governance, retention policies and information lifecycle management.
- Experience working within regulated industries.
- The Ideal Consultant
You’ll be an experienced SQL consultant who enjoys solving complex technical challenges within legacy environments.
You’ll be comfortable working with minimal documentation, quickly understanding existing database structures and designing practical solutions that balance compliance requirements with operational risk.
This role requires someone who can combine deep SQL expertise with a consultancy mindset, someone capable of defining the approach, delivering the technical solution and leaving behind a sustainable process for the business to adopt.
If you’re an experienced SQL Database Consultant with a background in legacy systems, data remediation and compliance‑driven projects, we’d love to hear from you.
Apply today with your latest CV and I’ll be in touch to discuss the opportunity in more detail.
#J-18808-Ljbffr
StudySmarter Expert Advice🤫
We think this is how you could land Database Consultant in Birmingham
✨Get Social in the Data World
Join online communities like Stack Overflow or Reddit's r/Database to connect with others in database management. Share your insights and ask questions to get noticed by industry insiders who might know of temporary roles!
✨Showcase Your Skills
Create a small project using the database software you’re familiar with—maybe something fun like a personal book or music database. Having a project to demonstrate will make you stand out to companies like LGBT Great when they see your hands-on approach!
✨Utilise Temporary Staffing Agencies
Many temp positions in database management are filled through staffing agencies. Get in touch with agencies that focus on tech roles, and let them know you're on the lookout for short-term opportunities. They can be a great bridge to finding your next gig.
✨Direct Applications are Key!
Don’t shy away from applying directly to LGBT Great through our website. Temporary roles often get posted without fanfare, so check back frequently, and don’t hesitate to reach out if you see a position that fits your skills!
We think you need these skills to ace Database Consultant in Birmingham
Some tips for your application 🫡
Highlight Your Technical Skills:In the world of database management, it’s essential to showcase your technical skills upfront. Make sure your CV includes relevant programming languages, database systems you’ve worked with, and any data modelling tools you’re familiar with. We want to see how your skills align with the needs of LGBT Great.
Document Your Projects:If you have completed any database projects, don’t forget to mention them! Include specific examples that demonstrate your problem-solving abilities and your experience with data migration or optimisation. Having a portfolio or a section on your CV detailing these projects can really set you apart in a temporary role.
Express Your Flexibility:Since this is a temporary position, it’s key to highlight your adaptability in your cover letter. Let us know that you’re ready to jump into different tasks and tackle challenges as they arise at LGBT Great. This shows that you’re not just looking for another job, but you’re excited about contributing to our team.
Keep it Concise:For a temporary role like this, keep your application concise and focused. Use bullet points to list your relevant experience and skills, making it easier for us to absorb the info quickly. Your aim should be to grab attention without overwhelming us with unnecessary details. And remember, submit your application through our website!
How to prepare for a job interview at LGBT Great
✨Get Hands-On with Tools
In database management, it’s crucial to be familiar with the tools of the trade like SQL, NoSQL, or even data visualisation software. Make sure you’ve got some practical examples ready to discuss how you’ve used these tools, and maybe even try to whip up a sample database to share in a discussion. This shows you're not just theory, but can get stuck in.
✨Brush Up on Technical Questions
Expect some technical questions that dive deep into your problem-solving skills. Be prepared to tackle scenarios where you might need to optimise a database query or explain data normalisation. This is a key area for database management roles, and demonstrating your understanding here can set you apart from other candidates.
✨Show Your Flexibility and Adaptability
Since this is a temporary role, showcasing your flexibility is key. Be ready to discuss past experiences where you quickly adapted to new systems or tasks. Emphasise your eagerness to hit the ground running and how easily you can familiarise yourself with the company’s database systems. Companies love a candidate who can dive right in without unnecessary handholding!
✨Pitching Yourself and Your Availability
In a temporary role, your availability is crucial. Be upfront about your schedule and how you can commit to the temporary demands of the job. Plus, don’t forget to express your keen interest in learning and contributing to LGBT Great—they’ll appreciate your enthusiasm for both the role and their team!
