Advanced DBA

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

Job summary

A healthcare organization is seeking a SQL DBA to manage SQL Server databases across development to production environments. The role is based in London with a hybrid work model, requiring 2 days onsite each week. Candidates must have over 5 years of advanced SQL experience, be skilled in creating dashboards using Power BI, and have experience with business continuity for SQL failover. This role offers a competitive salary.

Qualifications

• Over 5 years of advanced SQL experience.
• Experience with multi-Terabyte, high throughput databases.
• Able to configure and create dashboards with Power BI.

Responsibilities

• Configure and maintain database servers and processes.
• Independently analyze and solve real-time issues.
• Refine and automate regular processes.
• Assist developers with complex query tuning.
• Conduct user training and provide support.

Skills

Advanced SQL experience

Dashboard creation with Power BI

Storage fabric experience

Business Continuity failover experience

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.
• Recommends solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications.
• Installs revised or new systems by proposing specifications and flowcharts; recommending optimum access techniques; coordinating installation requirements.
• Maintains database performance by calculating optimum values for database parameters; implementing new releases; completing maintenance requirements; evaluating computer operating systems and hardware products.
• Prepares users by conducting training; providing information; resolving problems.
• Maintains quality service by establishing and enforcing organization 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 failover 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.