At a Glance
- Tasks: Manage and support database solutions, ensuring performance and security.
- Company: Join a market-leading client in Manchester focused on innovative data solutions.
- Benefits: Enjoy flexible working, health cash plans, and extra days off for special occasions.
- Why this job: Be part of a dynamic team driving data transformation and innovation in Azure.
- Qualifications: Experience with MS-SQL, T-SQL, and performance tuning is essential.
- Other info: Opportunity to lead SQL Server projects and contribute to exciting data initiatives.
The predicted salary is between 36000 - 60000 Β£ per year.
On behalf of our market-leading client based in Manchester, we are recruiting for an experienced SQL Server DBA. As SQL Server DBA, you will be responsible for managing and providing support to all aspects of the database landscape, working closely with colleagues to design, build, and manage database solutions.
The SQL Server DBA will be responsible for:
- Implementing and managing coding standards, security, and auditing procedures.
- Implementing and managing monitoring/proactive alerting processes.
- Reporting to the DBA Lead within the Data Operations pillar and inside the DaaS team, working on the support of our core platform database estate and assisting with a move into Azure for a data transformation project.
- Conducting root cause analysis, database performance monitoring, and capacity planning.
- Ensuring all database systems meet business and performance requirements.
- Complying with the requirements, and acting in accordance with, the Group Code of Conduct and Fitness and Propriety policies always.
- SQL code reviews and optimisation suggestions.
The SQL Server DBA will have the following:
- Be confident in taking ownership and leading SQL Server-related projects.
- Possess experience working with MS-SQL and T-SQL from SQL 2008 through 2019.
- Be confident and enthusiastic, willing to offer innovative solutions that will assist with our continued success.
- Have expert-level knowledge and quantifiable hands-on experience in performance tuning.
- Have advanced T-SQL skills.
- Excellent analytical and problem-solving skills.
- Azure experience highly desirable.
Benefits:
- Health Cash Plan
- Flexible/Hybrid working
- An extra day off to celebrate a special day
- Company pension scheme and group life assurance
How to Apply if youβre interested in this Job: If this sounds like your perfect role, click Apply without delay!
Contact Detail:
Adria Solutions Recruiting Team
StudySmarter Expert Advice π€«
We think this is how you could land SQL Server DBA
β¨Tip Number 1
Network with professionals in the SQL Server community. Attend local meetups or online webinars to connect with others in the field. This can help you learn about job openings and get insider information on what employers are looking for.
β¨Tip Number 2
Showcase your hands-on experience with MS-SQL and T-SQL by working on personal projects or contributing to open-source projects. This practical experience can set you apart from other candidates and demonstrate your skills effectively.
β¨Tip Number 3
Familiarise yourself with Azure and its database services. Since the role involves a move into Azure, having a solid understanding of cloud databases will make you a more attractive candidate and show your commitment to staying current in the industry.
β¨Tip Number 4
Prepare for technical interviews by practising common SQL performance tuning scenarios. Being able to discuss your approach to optimising queries and managing database performance will demonstrate your expertise and problem-solving skills.
We think you need these skills to ace SQL Server DBA
Some tips for your application π«‘
Tailor Your CV: Make sure your CV highlights your experience with MS-SQL and T-SQL, especially versions from SQL 2008 to 2019. Emphasise any projects where you took ownership and led SQL Server-related initiatives.
Craft a Strong Cover Letter: In your cover letter, express your enthusiasm for the role and the company. Mention your expert-level knowledge in performance tuning and any innovative solutions you've implemented in past roles.
Showcase Relevant Skills: Clearly outline your analytical and problem-solving skills in your application. If you have Azure experience, make sure to highlight it as it's highly desirable for this position.
Proofread Your Application: Before submitting, double-check your application for any spelling or grammatical errors. A polished application reflects your attention to detail, which is crucial for a SQL Server DBA.
How to prepare for a job interview at Adria Solutions
β¨Showcase Your SQL Expertise
Be prepared to discuss your experience with MS-SQL and T-SQL, especially versions from 2008 to 2019. Highlight specific projects where you implemented coding standards or optimised SQL queries, as this will demonstrate your hands-on knowledge.
β¨Demonstrate Problem-Solving Skills
Expect questions that assess your analytical abilities. Prepare examples of how you've conducted root cause analysis or tackled database performance issues in the past. This will show your capability to handle challenges effectively.
β¨Familiarise Yourself with Azure
Since Azure experience is highly desirable, brush up on your knowledge of cloud database solutions. Be ready to discuss any relevant projects or experiences you have with Azure, particularly in relation to data transformation.
β¨Emphasise Team Collaboration
As the role involves working closely with colleagues, be prepared to talk about your teamwork experiences. Share instances where you led SQL Server-related projects or collaborated on database solutions, showcasing your leadership and communication skills.