At a Glance
- Tasks: Administer and optimise SQL Server and Azure Cosmos DB environments for peak performance.
- Company: Join a leading Public Sector client with a focus on innovation.
- Benefits: Competitive pay up to £550 per day, remote work flexibility, and potential contract extension.
- Other info: Remote position with occasional on-site attendance in Edinburgh.
- Why this job: Make a real impact by modernising data platforms and enhancing database performance.
- Qualifications: Strong SQL Server DBA experience and expertise in performance tuning required.
The predicted salary is between 49500 - 66000 £ per year.
One of Lorien's leading Public Sector clients is looking for a Database Administrator (DBA) to join their team on an initial 12 month contract with a possible 12 month extension. PLEASE NOTE THIS IS A REMOTE POSITION WITH OCCASIONAL ON-SITE ATTENDANCE AS REQUIRED IN EDINBURGH.
Key Responsibilities:
- Administering and supporting SQL Server environments across development, test and production.
- Managing and optimising Azure Cosmos DB workloads for performance and scalability.
- Identifying and resolving database performance issues impacting legacy systems.
- Improving query performance, indexing strategies and reducing latency.
- Implementing monitoring, alerting and capacity planning improvements.
- Ensuring data security, access control and compliance with GDPR standards.
- Supporting modernisation of data platforms and ongoing service improvements.
Key Skills Experience:
- Strong SQL Server DBA experience within live production environments.
- Proven expertise in performance tuning and resolving database bottlenecks.
- Hands-on experience with Azure Cosmos DB (including indexing and partitioning).
- Understanding of HA/DR principles and database resilience.
DBA - Edinburgh (Remote) employer: Lorien
Join a forward-thinking public sector organisation that values innovation and collaboration, offering a dynamic work culture where your contributions as a Database Administrator will directly impact the efficiency of vital services. With competitive pay and the flexibility of remote work complemented by occasional on-site engagement in Edinburgh, you will have ample opportunities for professional growth and development while working alongside a dedicated team committed to excellence and continuous improvement.
StudySmarter Expert Advice🤫
We think this is how you could land DBA - Edinburgh (Remote)
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, especially those who work in public sector roles. A friendly chat can lead to insider info about job openings or even a referral.
✨Tip Number 2
Show off your skills! Prepare a portfolio or case studies showcasing your experience with SQL Server and Azure Cosmos DB. This will help you stand out during interviews and demonstrate your hands-on expertise.
✨Tip Number 3
Practice makes perfect! Brush up on common DBA interview questions and scenarios. Mock interviews with friends or mentors can help you feel more confident and ready to tackle any tricky questions.
✨Tip Number 4
Don’t forget to apply through our website! We’ve got loads of opportunities that might be just what you’re looking for. Plus, applying directly can sometimes give you an edge over other candidates.
We think you need these skills to ace DBA - Edinburgh (Remote)
Some tips for your application 🫡
Tailor Your CV:Make sure your CV highlights your SQL Server DBA experience and any relevant projects you've worked on. We want to see how your skills match the job description, so don’t be shy about showcasing your expertise in performance tuning and Azure Cosmos DB!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you're the perfect fit for this role. Mention specific experiences that relate to the key responsibilities, like managing database performance or ensuring data security.
Showcase Your Problem-Solving Skills:In your application, highlight instances where you've identified and resolved database performance issues. We love seeing how you tackle challenges, especially when it comes to optimising workloads and improving query performance.
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. Plus, it makes the whole process smoother for everyone involved!
How to prepare for a job interview at Lorien
✨Know Your SQL Inside Out
Make sure you brush up on your SQL Server knowledge. Be prepared to discuss your experience with live production environments and any performance tuning you've done. They’ll likely ask for specific examples, so have a couple of success stories ready to share.
✨Show Off Your Azure Cosmos DB Skills
Since this role involves managing Azure Cosmos DB workloads, it’s crucial to demonstrate your hands-on experience. Familiarise yourself with indexing and partitioning strategies, and be ready to explain how you've optimised performance in past projects.
✨Understand the Bigger Picture
Get a good grasp of HA/DR principles and database resilience. The interviewers will want to see that you can think strategically about database management, so be prepared to discuss how you’ve implemented these principles in your previous roles.
✨Prepare for Scenario-Based Questions
Expect questions that put you in real-world situations, like resolving database performance issues or implementing monitoring improvements. Think through some scenarios where you’ve had to troubleshoot or optimise databases, and be ready to walk them through your thought process.
