At a Glance
- Tasks: Administer and optimise SQL Server and Azure Cosmos DB for performance and reliability.
- Company: Join a forward-thinking engineering team in Edinburgh with a hybrid work model.
- Benefits: Competitive day rate, flexible working, and opportunities for skill development.
- Other info: Exciting opportunity to work on transformative projects in a dynamic environment.
- Why this job: Make a real impact by enhancing critical databases and supporting legacy systems.
- Qualifications: Strong SQL Server skills and experience with Azure Cosmos DB required.
We are seeking a skilled Database Administrator (DBA) with deep SQL Server expertise and hands-on experience with Cosmos DB to join the clients engineering team. The successful candidate will play a key role in optimising the performance, reliability, and scalability of our mission-critical databases that support a large legacy application currently experiencing latency challenges.
This role involves both strategic improvements and tactical performance tuning, ensuring that our data platform evolves while continuing to support existing business processes effectively.
Database Operations- Administer, configure, and support SQL Server environments across development, test, and production.
- Manage, optimise, and monitor Azure Cosmos DB workloads, ensuring cost-effective, scalable performance.
- Perform proactive capacity planning, patching, and upgrades to meet operational needs.
- Identify and resolve database performance issues impacting legacy systems.
- Introduce monitoring and alerting improvements aligned to operational SLAs and KPIs.
- Ensure compliance with data legislation and security standards, including GDPR and government policy.
- Manage access controls, auditing, and data protection measures.
- Support the evolution of data platforms with modern architectures where appropriate.
- Collaborate closely with engineering and delivery teams to support service transformation initiatives.
- Strong SQL Server administration experience in live service environments.
- Demonstrable expertise in performance tuning and troubleshooting database bottlenecks.
- Practical experience with Azure Cosmos DB, including throughput, indexing, and partitioning strategies.
- Commitment to secure, well-governed data management practices.
- Experience in public sector (Scotland) IT services and associated compliance standards.
- Familiarity with cloud-hosted operational databases and Azure infrastructure.
- Knowledge of automation (PowerShell, ARM/Bicep, Terraform, DevOps pipelines).
- Experience supporting legacy application transformation or migration projects.
Sql Database Administrator (Temporary) in Edinburgh employer: Harvey Nash
Join a forward-thinking team in Edinburgh as a SQL Database Administrator, where your expertise will directly contribute to optimising critical databases for a large legacy application. Our hybrid work culture promotes flexibility and collaboration, while our commitment to employee growth ensures you have access to continuous learning opportunities and the chance to work on innovative projects. With a focus on data governance and security, you'll be part of a mission-driven environment that values your contributions and supports your professional development.
StudySmarter Expert Advice🤫
We think this is how you could land Sql Database Administrator (Temporary) in Edinburgh
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, especially those who work with SQL Server or Azure Cosmos DB. A friendly chat can lead to insider info about job openings that aren't even advertised yet.
✨Tip Number 2
Show off your skills! If you’ve got a portfolio or examples of your work, don’t hesitate to share them during interviews. Demonstrating your hands-on experience with performance tuning and troubleshooting can really set you apart from the crowd.
✨Tip Number 3
Prepare for the technical questions! Brush up on your SQL Server administration and Azure Cosmos DB knowledge. Be ready to discuss how you've tackled database performance issues in the past – real-life examples will make your answers pop!
✨Tip Number 4
Apply through our website! We’re always on the lookout for talented individuals like you. By applying directly, you’ll ensure your application gets the attention it deserves, and you might just land that dream role with us!
We think you need these skills to ace Sql Database Administrator (Temporary) in Edinburgh
Some tips for your application 🫡
Tailor Your CV:Make sure your CV highlights your SQL Server and Cosmos DB experience. We want to see how your skills match the job description, so don’t be shy about showcasing your relevant achievements!
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. We love seeing enthusiasm and a clear understanding of the challenges we face with our databases.
Showcase Your Problem-Solving Skills:In your application, mention specific examples where you've tackled database performance issues or optimised systems. We’re looking for someone who can think on their feet and bring solutions to the table!
Apply Through Our Website:Don’t forget to submit your application through our website! It’s the best way for us to keep track of your application and ensure it gets the attention it deserves.
How to prepare for a job interview at Harvey Nash
✨Know Your SQL Inside Out
Make sure you brush up on your SQL Server skills before the interview. Be ready to discuss your hands-on experience with performance tuning and troubleshooting database bottlenecks. They’ll likely ask you about specific challenges you've faced, so have a couple of examples ready to share.
✨Familiarise Yourself with Cosmos DB
Since this role involves Azure Cosmos DB, it’s crucial to understand its features like throughput, indexing, and partitioning strategies. Prepare to talk about how you’ve managed and optimised workloads in the past, as well as any cost-effective solutions you've implemented.
✨Understand Data Governance and Security
Given the emphasis on compliance with data legislation and security standards, be prepared to discuss your experience with GDPR and data protection measures. Think about how you’ve managed access controls and auditing in previous roles, as this will show your commitment to secure data management.
✨Show Your Collaborative Spirit
This position requires close collaboration with engineering and delivery teams. Be ready to share examples of how you’ve worked with others to support service transformation initiatives. Highlight your communication skills and how you’ve contributed to team success in past projects.
