At a Glance
- Tasks: Modernise legacy databases and design high-performance SQL Server architectures.
- Company: Join a thriving tech company in Wigan with a collaborative culture.
- Benefits: Competitive salary, hybrid work model, 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, ETL processes, and database administration skills.
- Other info: Exciting career progression in a dynamic environment.
The predicted salary is between 45000 - 50000 £ per year.
Salary: £45,000 - £50,000 depending on experience.
Technology: SQL, ETL, SQL Server
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.
Interviews for this role will be held imminently. To be considered, please send your CV to me now to avoid disappointment.
Data Engineer / Database Administrator in Wigan employer: Oscar Associates (UK) Limited
Contact Detail:
Oscar Associates (UK) Limited Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Engineer / Database Administrator in Wigan
✨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 involves SQL Server and ETL processes, brush up on your knowledge and be ready to discuss specific scenarios or challenges you've faced in previous roles.
✨Tip Number 3
Network with current employees if possible. Reach out on LinkedIn or through mutual connections to get insights about the team and the work environment. This can give you an edge during the interview!
✨Tip Number 4
Apply through our website! It’s the best way to ensure your application gets noticed. Plus, it shows that you’re proactive and serious about landing the job with us.
We think you need these skills to ace Data Engineer / Database Administrator in Wigan
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with SQL Server, ETL processes, and any relevant database migrations. We want to see how your skills match the role, so don’t be shy about showcasing your achievements!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you’re excited about the Data Engineer / Database Administrator role and how your background makes you a perfect fit. We love seeing genuine enthusiasm!
Showcase Your Technical Skills: Be specific about your technical skills in your application. Mention your experience with T-SQL, Power BI, and any ETL tools you've used. We’re looking for candidates who can hit the ground running, so let us know what you bring to the table!
Apply Through Our Website: Don’t forget to apply through our website! It’s the best way to ensure your application gets into the right hands. Plus, it shows us you’re serious about joining our team at StudySmarter!
How to prepare for a job interview at Oscar Associates (UK) Limited
✨Know Your Tech Inside Out
Make sure you brush up on your SQL Server, T-SQL, and ETL processes. Be ready to discuss how you've used these technologies in past projects, especially any experience with data migrations or performance tuning.
✨Showcase Your Problem-Solving Skills
Prepare examples of how you've tackled database issues in the past. Whether it was optimising a slow query or resolving a data integrity problem, having specific scenarios ready will demonstrate your hands-on experience.
✨Understand the Company’s Needs
Research the company and its current database environment. Knowing their challenges and how you can contribute to modernising their legacy systems will show that you're genuinely interested and proactive.
✨Ask Insightful Questions
Prepare thoughtful questions about the role and the team dynamics. Inquire about their current database architecture or how they handle data security. This not only shows your interest but also helps you gauge if the company is the right fit for you.