Database Administrator

The Division:

Founded in 1978 as Midland Cash Registers, MCR Systems has nearly 50 years of experience in electronic point of sale. We’ve evolved from traditional tills to today’s AI-ready, cloud-based technology. We’ve grown far beyond simple EPOS, delivering complete Enterprise Management solutions but our focus has always been the same – giving you systems that are flexible, reliable and easy to use.

We were the first UK company to bring SaaS to the EPOS market. Our Symphony suite still powers everything we do. It brings sales, payments, stock, loyalty and reporting into one seamless system. Because it’s modular, it grows with your business and works with the tools already in use.

Over the years, we’ve supported hospitality, retail, sport, and education across the UK and the world. From single coffee shops to multi-site venues, we design technology to work for our customers.

The Position

MCR Systems Limited are seeking an experienced Database Administrator to take ownership of our SQL Server estate. This role is responsible for the administration, performance, security and evolution of a large and business-critical SQL environment, including operational databases, data warehouses and reporting platforms.

You will be the technical authority for SQL Server across the business, covering on-prem and hosted environments, and will play a key role in modernising our reporting capabilities. This includes maintaining and enhancing SSRS, SSIS and OLAP cubes, and supporting an ongoing push towards PowerBI and AI-enabled reporting.

Working closely with Development, Test, Product and Leadership teams, you will ensure data is reliable, performant and accessible, while helping shape the future of analytics and insight at MCR Systems.

Key Responsibilities:

• Administration, maintenance and optimisation of a large SQL Server estate

• Ownership of performance tuning, indexing strategies and query optimisation

• Backup, recovery, DR planning and regular restore testing

• Security management: permissions, roles, auditing and compliance

• Management of data warehouses, OLAP cubes and reporting databases

• Development, maintenance and monitoring of SSIS packages

• Support and enhancement of SSRS reports

• Working with developers to design efficient schemas and queries

• Capacity planning and proactive monitoring of SQL environments

• Supporting the move towards Power BI, including dataset design and data models

• Contributing to AI-enabled reporting, forecasting or insight initiatives

• Documentation of SQL standards, processes and best practices

• Acting as the escalation point for database-related issues

Experience, Knowledge & Skills:

• Strong experience administering Microsoft SQL Server in production

• Advanced T-SQL (performance tuning, complex queries, stored procedures)

• Experience with SQL Server data warehousing concepts

• Hands-on with SSIS, SSRS and SQL Server Analysis Services (SSAS/Cubes)

• Backup, restore and disaster recovery experience

• SQL security and permissions management

• Ability to diagnose and resolve performance and blocking issues

• Comfortable working independently as the SQL authority

Desirable:

• Power BI (datasets, models, gateways, optimisation)

• Exposure to AI-assisted reporting, forecasting or analytics

• Azure SQL/Azure Data Services

• Experience supporting high-transaction EPOS systems

• Familiarity with DevOps pipelines for database deployment

• Relevant Microsoft certifications (DBA/Data/BI)

Personal Characteristics:

• Takes clear ownership of critical systems and sees issues through to resolution

• Methodical and disciplined, particularly around change, security and data integrity

• Calm and decisive when dealing with live incidents or performance issues

• Pragmatic problem-solver with strong analytical thinking

• Comfortable challenging poor practices and driving improvement

• Able to communicate technical issues clearly to non-technical stakeholders

• Detail-focused without losing sight of business impact

• Self-motivated, with a strong sense of accountability and reliability

• Curious and forward-looking, particularly around analytics, AI and reporting evolution