At a Glance
- Tasks: Join us as a SQL Server DBA, optimising systems and ensuring database performance.
- Company: Be part of a growing financial services business based in Edinburgh with remote work flexibility.
- Benefits: Enjoy a competitive salary up to Β£60,000 plus benefits and remote working options.
- Why this job: This role offers a chance to collaborate with teams and make a real impact on system performance.
- Qualifications: You need 3+ years of SQL Server experience and skills in query optimisation and database maintenance.
- Other info: Familiarity with Linux and tools like Jira is a plus!
The predicted salary is between 43200 - 60000 Β£ per year.
Are you a detail-oriented SQL Server DBA who thrives on optimising systems, ensuring uptime, and collaborating with cross-functional teams? Weβre looking for someone just like you to join our growing financial services business based in Edinburgh β with flexibility for remote working across the UK.
Responsibilities:
- Install, configure, and maintain SQL Server instances across production and non-production environments
- Monitor database health and performance, ensuring availability, security, and scalability
- Troubleshoot and resolve issues in real-time, recommending long-term solutions
- Refine and automate regular processes and track issues through to resolution
- Support developers with query tuning and schema optimisation
- Perform routine maintenance and assist with out-of-hours release deployments
- Deliver project-based work to deadlines and contribute to testing strategies
- Work with business teams to help shape technical requirements and designs
- Promote adherence to standards through documentation and knowledge sharing
Requirements:
- 3+ years' experience with SQL Server (2012 onwards)
- Proven track record of installing, configuring, and maintaining SQL Server instances
- Skilled in query optimisation, indexing strategies, and database performance tuning
- Experience with capacity management and data archiving
- Strong knowledge of HA/DR solutions
- Comfortable using tools like SQL Profiler and Extended Events
- Confident collaborating with developers and stakeholders
Desirable:
- Familiarity with Linux shell scripting
- Exposure to other database platforms
- Experience using Jira or LogicMonitor
- Working knowledge of Windows or other operating systems
SQL Database Administrator employer: Job Traffic
Contact Detail:
Job Traffic Recruiting Team
StudySmarter Expert Advice π€«
We think this is how you could land SQL Database Administrator
β¨Tip Number 1
Familiarise yourself with the specific SQL Server versions mentioned in the job description, particularly 2012 onwards. This will not only help you understand the requirements better but also allow you to speak confidently about your experience during any discussions.
β¨Tip Number 2
Brush up on your knowledge of high availability and disaster recovery (HA/DR) solutions. Being able to discuss these concepts in detail will demonstrate your expertise and show that you're prepared to handle critical situations.
β¨Tip Number 3
Prepare examples of how you've collaborated with developers and stakeholders in the past. Highlighting your teamwork skills will be crucial, as this role involves working closely with various teams to shape technical requirements.
β¨Tip Number 4
If you have experience with tools like SQL Profiler or Extended Events, be ready to discuss specific instances where you've used them to troubleshoot or optimise database performance. This will showcase your hands-on experience and problem-solving abilities.
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 that demonstrate your expertise in query optimisation and database performance tuning.
Craft a Compelling Cover Letter: In your cover letter, express your enthusiasm for the role and the financial services sector. Mention how your background aligns with the job requirements, especially your experience with HA/DR solutions and collaboration with cross-functional teams.
Showcase Relevant Projects: If you have worked on specific projects that involved SQL Server, be sure to include these in your application. Detail your contributions, the challenges faced, and the outcomes achieved, particularly in relation to system optimisation and troubleshooting.
Proofread Your Application: Before submitting, carefully proofread your application materials. Look for any spelling or grammatical errors, and ensure that all information is clear and concise. A polished application reflects your attention to detail, which is crucial for a SQL Database Administrator.
How to prepare for a job interview at Job Traffic
β¨Showcase Your Technical Skills
Be prepared to discuss your experience with SQL Server in detail. Highlight specific instances where you've installed, configured, or maintained SQL Server instances, and be ready to explain your approach to query optimisation and performance tuning.
β¨Demonstrate Problem-Solving Abilities
Expect questions that assess your troubleshooting skills. Prepare examples of real-time issues you've resolved, focusing on the steps you took and the long-term solutions you recommended to prevent future occurrences.
β¨Emphasise Collaboration
Since the role involves working with cross-functional teams, be ready to discuss how you've collaborated with developers and stakeholders in the past. Share experiences where your input shaped technical requirements or designs.
β¨Prepare for Scenario-Based Questions
You might face scenario-based questions related to database health and performance. Think about how you would handle specific situations, such as a sudden drop in database performance or a need for capacity management, and articulate your thought process clearly.