At a Glance
- Tasks: Support and maintain SQL Server databases, ensuring optimal performance and security.
- Company: Join a leading financial services firm providing outsourced investment solutions.
- Benefits: Enjoy hybrid working, competitive salary, and opportunities for professional growth.
- Why this job: Gain hands-on experience in database administration while collaborating with a dynamic IT team.
- Qualifications: Must have advanced SQL Server knowledge and at least 3 years of relevant experience.
- Other info: This is a 12-month fixed-term contract based in Edinburgh or Glasgow.
The predicted salary is between 36000 - 48000 £ per year.
Head Resourcing are pleased to be working with our financial services client as they look to recruit a talented SQL Server DBA on a 12-month fixed term contract. Our client provides a range of outsourced investment services to private banks, advisory businesses, and wealth managers and have offices in both Edinburgh and Glasgow.
In this role you will work with colleagues from across the IT department to support and maintain our client’s suite of development, test, and live databases. You will have exposure to all aspects of database administration such as installation/upgrades/patching, backup and recovery, performance and tuning, security, data loads, database copies and troubleshooting.
Responsibilities:- Manage installation, configuration, and maintenance of SQL Server environments, ensuring optimal performance, availability, and security.
- Monitor systems, troubleshoot real-time issues, and support after-hours maintenance and deployments.
- Automate routine processes, maintain documentation, and drive operational improvements.
- Support developers with query tuning, schema design, and adherence to technical standards.
- Collaborate on project delivery, testing strategies, and business requirements to design effective solutions.
- Advanced knowledge of SQL Server (2012 onwards).
- At least 3 years’ experience in installing, configuring and maintaining SQL Server instances.
- Experience optimising indexes, queries, and database structures.
- Experience in capacity management and data archiving.
- Experience with High Availability and Disaster Recovery solutions.
- Experience using database management tools (SQL Profiler, Extended Events).
If this is of interest, please apply now for a confidential chat to find out more.
Contact Detail:
Head Resourcing Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land SQL Database Administrator
✨Tip Number 1
Familiarise yourself with the latest SQL Server features and updates, especially those from 2012 onwards. This will not only boost your confidence during interviews but also demonstrate your commitment to staying current in the field.
✨Tip Number 2
Network with professionals in the financial services sector, particularly those who work with SQL databases. Attend industry meetups or online forums to gain insights and potentially get referrals that could help you land the job.
✨Tip Number 3
Prepare for technical interviews by practising common SQL queries and troubleshooting scenarios. Being able to showcase your problem-solving skills in real-time can set you apart from other candidates.
✨Tip Number 4
Research the company’s specific database environment and any recent projects they’ve undertaken. Tailoring your discussions around their needs and how your experience aligns can make a strong impression during interviews.
We think you need these skills to ace SQL Database Administrator
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with SQL Server, particularly your skills in installation, configuration, and maintenance. Use specific examples from your past roles to demonstrate your expertise.
Craft a Strong Cover Letter: In your cover letter, express your enthusiasm for the role and the company. Mention how your background aligns with the responsibilities listed, such as troubleshooting and performance tuning, and why you are a good fit for their team.
Highlight Relevant Skills: Clearly outline your advanced knowledge of SQL Server (2012 onwards) and any experience with High Availability and Disaster Recovery solutions. This will show that you meet the key skills required for the position.
Proofread Your Application: Before submitting, carefully proofread your application for any spelling or grammatical errors. A polished application reflects your attention to detail, which is crucial for a Database Administrator role.
How to prepare for a job interview at Head Resourcing
✨Showcase Your SQL Expertise
Be prepared to discuss your advanced knowledge of SQL Server, especially versions from 2012 onwards. Highlight specific projects where you installed, configured, or maintained SQL Server instances, and be ready to explain the challenges you faced and how you overcame them.
✨Demonstrate Problem-Solving Skills
Since troubleshooting is a key part of the role, think of examples where you successfully resolved real-time issues. Discuss your approach to monitoring systems and how you handled after-hours maintenance or deployments, as this will show your commitment and reliability.
✨Discuss Automation and Documentation
Talk about any experience you have with automating routine processes and maintaining documentation. This is crucial for driving operational improvements, so share specific tools or methods you've used to streamline database management tasks.
✨Collaborate and Communicate
Emphasise your ability to work collaboratively with developers and other IT colleagues. Provide examples of how you've supported query tuning, schema design, or contributed to project delivery, as effective communication is vital in this role.