At a Glance
- Tasks: Modernise legacy databases and design high-performance SQL Server architectures.
- Company: Join a thriving tech company in Wigan with a hybrid work culture.
- Benefits: Competitive salary, flexible working, and opportunities for professional growth.
- 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 is essential.
- Other info: Exciting career progression in a dynamic and ambitious environment.
The predicted salary is between 36000 - 60000 Β£ per year.
Location: Wigan
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.
Referrals
If this role isnβt right for you, do you know someone that might be interested? You could earn Β£500 of retail vouchers if you refer a successful candidate to Oscar. Email: mark.whales@oscar-tech.com to recommend someone for this role.
Interviews for this role will be held imminently. To be considered, please send your CV to me now to avoid disappointment.
Database Administrator / Data Engineer in Wigan employer: Oscar
Contact Detail:
Oscar Recruiting Team
StudySmarter Expert Advice π€«
We think this is how you could land Database Administrator / Data Engineer in Wigan
β¨Tip Number 1
Get to know the company culture before your interview. Check out their social media and website to see what they're all about. 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 involves SQL Server and ETL processes, brush up on your T-SQL and database management. You might even want to run through some common interview questions related to these topics to feel more confident.
β¨Tip Number 3
Network like a pro! Reach out to current or former employees on LinkedIn to get insights about the role and the team. They might share tips that could give you an edge during the interview process.
β¨Tip Number 4
Donβt forget to apply through our website! Itβs the best way to ensure your application gets seen by the right people. Plus, it shows that youβre serious about joining the team.
We think you need these skills to ace Database Administrator / Data Engineer in Wigan
Some tips for your application π«‘
Tailor Your CV: Make sure your CV reflects the skills and experiences that match the job description. Highlight your SQL Server expertise and any relevant database migration projects you've worked on. We want to see how you can contribute to modernising our legacy systems!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about this role and how your background in data engineering aligns with our needs. Let us know what excites you about working with us at StudySmarter.
Showcase Your Projects: If you've worked on any relevant projects, whether it's building ETL pipelines or optimising database performance, make sure to mention them. We love seeing real-world examples of your work that demonstrate your skills and problem-solving abilities.
Apply Through Our Website: Don't forget to apply through our website! Itβs the best way for us to receive your application and ensures youβre considered for the role. Plus, it shows us youβre keen to join the StudySmarter team!
How to prepare for a job interview at Oscar
β¨Know Your Databases Inside Out
Make sure you brush up on your SQL Server and T-SQL skills before the interview. Be ready to discuss your experience with database migrations, performance tuning, and ETL processes. Having specific examples of past projects will show that youβre not just familiar with the concepts but have hands-on experience.
β¨Understand the Role's Responsibilities
Familiarise yourself with the key responsibilities outlined in the job description. Be prepared to talk about how you would approach modernising legacy databases and ensuring data integrity during migrations. This shows that youβve done your homework and are genuinely interested in the role.
β¨Prepare for Technical Questions
Expect technical questions related to database architecture, indexing strategies, and security configurations. Practise explaining complex concepts in simple terms, as this demonstrates your understanding and ability to communicate effectively with both technical and non-technical team members.
β¨Show Your Collaborative Spirit
Since the role involves working closely with engineering and product teams, be ready to discuss your experience in collaboration. Share examples of how youβve worked with others to meet evolving data requirements, and highlight your ability to adapt to changing needs within a team environment.