At a Glance
- Tasks: Modernise legacy databases and design high-performance SQL Server architectures.
- Company: Join a thriving tech company in Warrington with a collaborative culture.
- Benefits: Competitive salary, hybrid work model, and opportunities for professional growth.
- Other info: Dynamic environment with excellent career advancement opportunities.
- Why this job: Make a real impact by optimising data systems and supporting innovative projects.
- Qualifications: Experience with SQL Server, T-SQL, and ETL processes required.
The predicted salary is between 45000 - 50000 € per year.
Salary: £45,000 - £50,000 depending on experience.
Technology: SQL, ETL, SQL Server
Location: Warrington
Working Pattern: Hybrid - 3 days a week in the office.
The Role:
In the short term, the successful candidate will take ownership of modernising legacy application databases. This will involve designing and implementing scalable, high-performance database architectures to replace existing MySQL backends supporting application services. They will lead the migration of data from legacy platforms into new Microsoft SQL Server environments, ensuring data integrity, optimal performance and minimal disruption to live systems.
The role will also be responsible for configuring SQL Server security and access controls, including the creation and management of developer roles and permissions to support application connectivity and deployment. Over time, the focus will shift to the ongoing operational health of the database estate. This includes improving scalability and efficiency through indexing strategies, performance tuning, and the implementation of data archiving and lifecycle management processes. The candidate will proactively monitor SQL Server performance, identify bottlenecks or conflicting workloads, and resolve issues to ensure reliable and efficient data access as application usage grows. In parallel, they will continue to deliver database environments that support both analyst and developer workflows.
Please note: this is not a remote position, it is hybrid in the office - the first week would be full-time in the office to get to know the team and processes.
Responsibilities:
- You will play a key role in maintaining and evolving our Microsoft SQL Server-based environment, supporting data migrations, building and optimizing ETL processes, and ensuring data is reliable, secure, and performant for downstream analytics, software and reporting.
- Lead and support database migrations, upgrades, and schema changes with minimal downtime.
- Design, build, and maintain robust ETL/ELT pipelines to ingest, transform, and load data from multiple sources.
- Perform database maintenance activities, including restores, indexing, patching, monitoring, replication, migrations, and performance tuning.
- Maintain and Support SSRS reporting solutions and infrastructure.
- Maintain and Support Power BI datasets, gateways, refresh schedules, and security models.
- Document data flows, schemas, transformations, and operational processes.
- Collaborate with engineering and product teams to support evolving data requirements.
Requirements:
- SQL Server
- T-SQL
- DBA Skills
- Power BI
- ETL (SSIS or other, such as Airflow)
- MySQL would be useful but certainly not essential.
If you have a range of experience in Data Engineering and you are looking to progress with an organisation that has a fantastic approach to work in a thriving and ambitious environment, then look no further - this is the role for you!
Please note: this role does not offer sponsorship.
Locations
SQL Database Developer in Cheshire, Warrington employer: Oscar Associates (UK) Limited
At Oscar Associates, we pride ourselves on fostering a dynamic and inclusive work culture that empowers our employees to thrive. As a SQL Database Developer in Warrington, you will benefit from a hybrid working model, competitive salary, and opportunities for professional growth within a supportive team environment. Join us to be part of an ambitious organisation that values innovation and collaboration, ensuring your contributions make a meaningful impact.
Contact Detail:
Oscar Associates (UK) Limited Recruiting Team
StudySmarter Expert Advice🤫
We think this is how you could land SQL Database Developer in Cheshire, Warrington
✨Tip Number 1
Get to know the company before your interview! Research their projects, values, and culture. This will help you tailor your answers and show that you're genuinely interested in being part of their team.
✨Tip Number 2
Practice your SQL skills! Brush up on your T-SQL and ETL processes, as these are crucial for the role. You might even want to run through some common database scenarios to demonstrate your problem-solving abilities during the interview.
✨Tip Number 3
Network with current employees or alumni who work there. They can provide insider tips on what the interviewers are looking for and what it's like to work in the company. Plus, it shows initiative!
✨Tip Number 4
Apply through our website! It’s the best way to ensure your application gets seen. Plus, we love seeing candidates who take that extra step to connect directly with us.
We think you need these skills to ace SQL Database Developer in Cheshire, Warrington
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the SQL Database Developer role. Highlight your experience with SQL Server, ETL processes, and any relevant projects you've worked on. We want to see how your skills match what we're looking for!
Showcase Your Achievements:Don’t just list your responsibilities; showcase your achievements! Use metrics where possible to demonstrate how you’ve improved database performance or streamlined processes. This helps us see the impact you've made in previous roles.
Keep It Clear and Concise:When writing your application, keep it clear and concise. Avoid jargon unless it's relevant to the role. We appreciate straightforward communication that gets to the point without fluff!
Apply Through Our Website:We encourage you to apply through our website for a smoother process. This way, we can easily track your application and get back to you quicker. Plus, it shows you're keen on joining our team!
How to prepare for a job interview at Oscar Associates (UK) Limited
✨Know Your SQL Inside Out
Make sure you brush up on your SQL Server skills, especially T-SQL. Be prepared to discuss your experience with database migrations and performance tuning, as these are key aspects of the role.
✨Showcase Your ETL Expertise
Be ready to talk about your experience with ETL processes, particularly if you've worked with SSIS or similar tools. Highlight any specific projects where you designed or optimised ETL pipelines.
✨Demonstrate Problem-Solving Skills
Prepare examples of how you've identified and resolved database performance issues in the past. This could involve discussing indexing strategies or how you’ve handled conflicting workloads.
✨Understand the Company’s Needs
Research the company and its current database environment. Knowing their tech stack and challenges will help you tailor your answers and show that you're genuinely interested in the role.
