At a Glance
- Tasks: Modernise legacy databases and design high-performance SQL architectures.
- Company: Join a thriving tech company with a collaborative and ambitious culture.
- Benefits: Competitive salary, hybrid work model, and opportunities for professional growth.
- Other info: Exciting career progression in a dynamic environment awaits you!
- Why this job: Make a real impact by optimising data systems and supporting innovative projects.
- Qualifications: Experience in SQL Server, T-SQL, and ETL processes required.
The predicted salary is between 45000 - 50000 £ per year.
While professional experience and qualifications are key for this role, make sure to check you have the preferable soft skills before applying if required.
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.
SQL Database Developer in Warrington employer: Oscar Technology
Contact Detail:
Oscar Technology Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land SQL Database Developer in 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 technical skills! Since this role focuses on SQL and ETL processes, brush up on your T-SQL and database management techniques. You might even want to run through some common interview questions related to these topics.
✨Tip Number 3
Network with current employees or alumni who work there. They can provide insider tips on the interview process and what the team is really like. Plus, it shows initiative and can give you a leg up!
✨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 Warrington
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your SQL and ETL experience. We want to see how your skills match the role, so don’t be shy about showcasing relevant projects or achievements!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you’re excited about the SQL Database Developer role and how you can contribute to our team. Keep it concise but impactful!
Showcase Your Soft Skills: While technical skills are crucial, we also value soft skills like teamwork and problem-solving. Mention any experiences that demonstrate these abilities in your application.
Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role without any hiccups!
How to prepare for a job interview at Oscar Technology
✨Know Your SQL Inside Out
Make sure you brush up on your SQL skills before the interview. Be prepared to discuss your experience with SQL Server, T-SQL, and any ETL processes you've worked on. Practising common SQL queries and understanding database design principles will help you impress the interviewers.
✨Showcase Your Problem-Solving Skills
Since the role involves optimising performance and resolving issues, be ready to share examples of how you've tackled similar challenges in the past. Think about specific instances where you improved database efficiency or resolved bottlenecks, and explain your thought process during those situations.
✨Familiarise Yourself with the Company’s Tech Stack
Research the technologies mentioned in the job description, especially Microsoft SQL Server and Power BI. Understanding how these tools are used within the company can give you an edge. If possible, try to relate your previous experiences with these technologies to the role you're applying for.
✨Prepare Questions for the Interviewers
Interviews are a two-way street, so come prepared with thoughtful questions. Ask about the team dynamics, ongoing projects, or how they measure success in this role. This shows your genuine interest in the position and helps you assess if the company is the right fit for you.