Advanced DBA

Morgan Law; City Of London; Hybrid; GBP 60,000 - 80,000; Full time

Job summary

A leading recruitment consultancy is seeking a SQL DBA to manage SQL Server databases across development to production environments. The role offers a hybrid work model, requiring 2 days onsite in London. Ideal candidates will possess over 5 years of advanced SQL experience and skills in Power BI dashboard creation, focusing on high-performance database management. Competitive pay structure is included.

Qualifications

• Over 5 years of advanced SQL experience.
• Experience with multi-terabyte, high-throughput databases.
• Knowledge of business continuity for SQL failover.

Responsibilities

• Configure and maintain database servers for performance and availability.
• Automate processes and provide technical mentorship.
• Conduct user training and resolve issues.

Skills

Advanced SQL experience

SQL Server databases management

Power BI dashboard creation

Database performance tuning

Problem resolution

Tools

Power BI

SQL Server

Fibre and iSCSI storage solutions

Job description

An NHS Trust are seeking a SQL DBA to build and manage SQL Server databases through multiple product lifecycle environments, from development to mission‑critical production systems for an Always on SQL Farm. The role is based in London, 2 days a week onsite and paying around £(Apply online only)pd (outside IR35).

Responsibilities:

• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
• Apply data modelling techniques to ensure development and implementation support efforts meet integration and performance expectations.
• Independently analyse, solve, and correct issues in real time, providing problem resolution end‑to‑end.
• Refine and automate regular processes, track issues, and document changes.
• Assist developers with complex query tuning and schema refinement.
• Share domain and technical expertise, providing technical mentorship and cross‑training to other peers and team members.
• Recommend solutions by defining database physical structure and functional capabilities, database security, data back‑up, and recovery specifications.
• Install revised or new systems by proposing specifications and flowcharts; recommending optimum access techniques; coordinating installation requirements.
• Maintain database performance by calculating optimum values for database parameters, implementing new releases, completing maintenance requirements, and evaluating computer operating systems and hardware products.
• Prepare users by conducting training, providing information, and resolving problems.
• Maintain quality service by establishing and enforcing organisational standards.

Experience:

• Advanced SQL experience (over 5 years).
• Configuring and creating dashboards with Power BI – dealing with multi‑terabyte, high‑throughput, highly available databases will stretch your knowledge of SQL.
• Storage fabric experience (Fibre and iSCSI).
• Business continuity fail‑over experience for SQL failover.
• Support project team members during the analysis and planning stages of project/programme delivery and/or software development with a view to using change management.
• Writing reports, instructions, and specifications.