Dataverse Specialist

HCA Healthcare UK; Greater London; On-site; GBP 50,000 - 70,000; Full time

Job summary

A leading healthcare provider in the UK is seeking a Dataverse Specialist to manage and optimize their data infrastructure. This pivotal role requires deep expertise in Microsoft SQL Server and Dataverse, ensuring the performance and availability of critical data. The ideal candidate will have 3+ years of database administration experience, a strong understanding of cloud-based data models, and proficiency in T-SQL and PowerShell. Flexible benefits, including private healthcare and generous holiday allowance, are offered.

Benefits

25 days holiday plus bank holidays

Private Healthcare Insurance

Private pension contribution

Season Ticket Loan

Group Life Assurance

Critical illness cover

Enhanced Maternity and Paternity pay

Corporate staff discount

Flexible health and lifestyle benefits

Qualifications

• 3+ years of experience in database administration with Microsoft SQL Server.
• Hands-on experience with Microsoft Dataverse and Power Platform architecture.
• Proficiency in T-SQL, PowerShell, and data migration tools.

Responsibilities

• Administer and maintain Microsoft SQL Server databases related to Dynamics CRM solutions.
• Implement and enforce data security policies and access controls.
• Collaborate with developers to integrate databases with Power Apps.

Skills

Database Administration with Microsoft SQL Server

Azure SQL

Microsoft Dataverse

Power Platform Architecture

T-SQL

PowerShell

Education

Microsoft certifications (e.g., Azure Database Administrator Associate)

Tools

Azure Data Factory

SSIS

Job description

Dataverse Specialist

2 Cavendish Square, 2 days on-site per week

Full-Time, 37.5 hours per week

Contract: Fixed Term - 6 months from start date

Job Overview

We are seeking a skilled and proactive individual with deep expertise in Microsoft SQL Server (On Premises and Cloud) and Dataverse to manage, optimize, and secure our data infrastructure. This role is pivotal in supporting our cloud‑first strategy, ensuring availability, performance, and scalability of our business‑critical data.

Key Responsibilities

• Database Management & Optimization

  • Administer and maintain Microsoft SQL Server databases that are related to our Dynamics CRM solutions (on‑premises and Azure‑based)
  • Design and manage Dataverse environments for Power Platform and Dynamics 365 applications
  • Monitor database performance and implement tuning strategies to ensure optimal efficiency
  • Perform regular backups, recovery testing and disaster recovery planning

• Data Governance & Security

  • Implement and enforce data security policies, access controls and compliance standards
  • Ensure data integrity and consistency across integrated systems

• Integration & Automation

  • Collaborate with developers to integrate databases with Power Apps, Power Automate and other Microsoft services
  • Develop and maintain ETL processes using Azure Data Factory, SSIS, or custom scripts
  • Support API‑based integrations between Dataverse and external systems

• Monitoring & Support

  • Proactively monitor database health and resolve issues before they impact operations
  • Provide Tier 2/3 support for database‑related incidents and service requests
  • Document procedures, configurations, and troubleshooting guides

Required Skills & Qualifications

• 3+ years of experience in database administration with Microsoft SQL Server
• Familiarity with Azure SQL, Azure DevOps and Dynamics 365 environments
• Must have hands‑on experience with Microsoft Dataverse and Power Platform architecture
• Strong understanding of relational and cloud‑based data models
• Proficiency in T‑SQL, PowerShell, and data migration tools
• Microsoft certifications (e.g., Azure Database Administrator Associate, Power Platform Functional Consultant) are a plus

Preferred Attributes

• Analytical mindset with excellent problem‑solving skills
• Strong communication and documentation abilities
• Ability to work independently and collaboratively in cross‑functional teams
• Passion for continuous learning and staying current with Microsoft technologies

Why HCA UK?

Originally founded over 50 years ago by Dr Thomas Frist, HCA has gone on to become one of the world’s leading healthcare providers. In the UK, we’re one of the largest providers of privately funded healthcare and have invested over £500 million in the latest treatments, technology, techniques, medication and facilities. Being part of a large multisite, established healthcare group we can offer you unrivalled opportunities for career progression through internal and external courses, as well as working conditions that prioritise both your mental and physical wellbeing.

By caring for our employees, we empower them to provide exceptional care for our patients. That’s why we offer a host of flexible benefits that reflect the invaluable contribution they make every day. You’ll be eligible for:

• 25 days holiday each year (plus bank holidays) increasing with service, with option to buy or sell leave to suit you.
• Private Healthcare Insurance for treatment at our leading hospitals.
• Private pension contribution which increases with length of service.
• Season Ticket Loan and Cycle to Work scheme.
• Group Life Assurance from day one.
• Critical illness cover.
• Enhanced Maternity and Paternity pay.
• Corporate staff discount for all facilities including Maternity packages at The Portland.
• Comprehensive range of flexible health, protection and lifestyle benefits to suit you.
• Discounts with over 800 major retailers.

Culture and values

At HCA UK we believe exceptional care starts with our people. We celebrate the unique perspectives and different experiences each of us bring as we know that when you feel seen, heard and supported you can be at your best for our patients, and each other.

Our mission is simple, above all else we’re committed to the care and improvement of human life, a clear statement that extends to both our patients and colleagues. To achieve this, we live and breathe four core values:

• Unique and Individual: We recognise and value everyone as unique and individual
• Kindness and compassion: We treat people with kindness and compassion
• Honesty, integrity and fairness: We act with absolute honesty, integrity and fairness
• Loyalty, respect, and dignity: We trust and treat one another as valued members of the HCA UK family with loyalty, respect and dignity

Reasonable adjustments

We believe everyone should feel comfortable to bring their full self to work and be afforded the same opportunities. As a Disability Confident committed organisation, we’re happy to discuss flexible working arrangements to suit your needs as well as offer reasonable adjustments throughout our recruitment process, and in the workplace, to anyone that needs them.