At a Glance
- Tasks: Administer and optimise SQL databases while ensuring security and performance.
- Company: Dynamic organisation offering a hybrid working environment.
- Benefits: Competitive daily rate, flexible work schedule, and inclusive culture.
- Other info: Supportive employer committed to inclusivity and career growth.
- Why this job: Join a team where your skills will directly impact database efficiency and security.
- Qualifications: 10 years of SQL DBA experience and proficiency in PowerShell scripting.
Contract Daily Rate: 450 - 575 (inside IR35 via umbrella)
Contract Length: 12 months
Location: Hybrid Working – Chester 3 days per week and remote 2 days per week
Our client is a dynamic organisation seeking an experienced SQL Database Administrator to join their team. This role is pivotal in maintaining the security, integrity, and performance of the company's database systems.
Key Responsibilities
- Administer, maintain, develop, and implement policies and procedures for database security and integrity.
- Design and implement data models, database designs, and table maintenance codes.
- Resolve database performance, capacity, replication, and distributed data issues.
- Manage SQL Server Integrated Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS) effectively.
- Implement high availability and disaster recovery solutions using clustering, database mirroring, log shipping, and AlwaysOn replication.
- Perform database performance tuning and diagnostics using SQL Profiler, Extended Events, and Database Engine Tuning Advisor.
- Write and optimise T‑SQL code, including views, functions, stored procedures, and triggers.
- Handle backup recovery, index design, and analysis.
- Upgrade and migrate SQL Server instances/databases as needed.
- Monitor system health and performance, ensuring high levels of availability and security.
- Analyse, troubleshoot, and correct database issues in real-time.
- Collaborate with developers for query tuning and schema refinement.
- Document changes and automate regular processes for efficiency.
- Work in a controlled access environment, adhering to industry baselines.
- Familiarity with ITIL service management processes (Change, Release, Problem, and Incident Management) is a plus.
- Engage with various teams and stakeholders, showcasing strong communication skills.
Required Skills and Experience
- 10 years of relevant industry experience as a SQL DBA.
- Proficient in PowerShell scripting and Windows Operating System Administration (Windows 2014+).
- Familiarity with BMC Remedy IT Service Management and different storage systems.
- Proven ability to manage large databases effectively.
- Excellent team player with the ability to work in a focused environment, responsive to urgent issues.
Adecco is a disability‑confident employer. It is important to us that we run an inclusive and accessible recruitment process to support candidates of all backgrounds and all abilities to apply. Adecco is committed to building a supportive environment for you to explore the next steps in your career. If you require reasonable adjustments at any stage, please let us know and we will be happy to support you.
SQL Server DBA employer: Adecco
Contact Detail:
Adecco Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land SQL Server DBA
✨Network Like a Pro
Get out there and connect with people in the industry! Attend meetups, webinars, or even local tech events. You never know who might have a lead on that perfect SQL DBA role.
✨Show Off Your Skills
Don’t just talk about your experience; demonstrate it! Consider creating a portfolio of projects or contributions to open-source databases. This can really set you apart from the crowd.
✨Ace the Interview
Prepare for those tricky interview questions by practising your responses. Focus on your problem-solving skills and how you've tackled database issues in the past. Confidence is key!
✨Apply Through Us
Make sure to apply through our website for the best chance at landing that SQL DBA gig. We’re here to help you every step of the way, so don’t hesitate to reach out if you need any support!
We think you need these skills to ace SQL Server DBA
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the SQL DBA role. Highlight your experience with database security, performance tuning, and any relevant technologies like SSIS, SSRS, and SSAS. We want to see how your skills match what we're looking for!
Showcase Your Experience: In your application, don’t just list your responsibilities; showcase your achievements! Talk about specific projects where you improved database performance or implemented high availability solutions. This helps us see the impact you've made in previous roles.
Be Clear and Concise: When writing your application, keep it clear and concise. Use bullet points for easy reading and make sure to get straight to the point. We appreciate a well-structured application that’s easy to digest!
Apply Through Our Website: We encourage you to apply through our website for the best chance of getting noticed. It’s super easy and ensures your application goes directly to us. Plus, we love seeing candidates who take the initiative to apply directly!
How to prepare for a job interview at Adecco
✨Know Your SQL Inside Out
Make sure you brush up on your SQL skills before the interview. Be prepared to discuss your experience with T-SQL, SSIS, SSRS, and SSAS. Practise writing queries and optimising them, as you might be asked to demonstrate your problem-solving skills on the spot.
✨Showcase Your Experience with High Availability
Since this role involves implementing high availability and disaster recovery solutions, be ready to share specific examples from your past work. Discuss the methods you've used, like clustering or AlwaysOn replication, and how they benefited the organisation.
✨Communicate Effectively
Strong communication skills are key for this position. Prepare to explain complex database concepts in simple terms, especially when discussing collaboration with developers. Think of examples where your communication made a difference in resolving issues or improving processes.
✨Be Ready for Real-Time Problem Solving
Expect to face some real-time troubleshooting scenarios during the interview. Brush up on your diagnostic skills using tools like SQL Profiler and Database Engine Tuning Advisor. Practise explaining your thought process as you work through potential solutions.