About the role
Introduction
A leading global professional services firm is seeking a hands-on Database Administrator (DBA) to own and maintain a business-critical SQL Server operational data store, with a strong focus on database operations, SQL Agent jobs and application data integration. This is a long-term contract role within a mature, collaborative software team, not a sink-or-swim environment, where you will partner with highly experienced incumbents and take ownership of a busy operational data ecosystem that is central to the programme's success.
Role Responsibilities
As the Database Administrator (DBA), you will own and maintain the central operational data store that dozens of applications depend on. This is a application-focused SQL Server DBA role, not an analytics position. You will build and maintain integration pipelines that source data from many applications, land it, transform and standardise it in SQL, and consolidate it for downstream consumption. Day-to-day, you will respond to constant change, schema updates from vendors, new data requirements from developers, and newly acquired applications needing fresh pipelines.
Own and maintain a central Operational Data Store (ODS) supplying standardised, accurate and timely data to operational applications
Monitor SQL Agent job health and ODS data freshness, improve alerts and failure detection, and investigate failed loads before they disrupt downstream applications
Write and maintain T-SQL stored procedures and SQL Agent jobs for data transformation, merging, joining, pivoting and standardisation; manage scheduled runs and investigate failures
Build and maintain SQL Server integration pipelines across 30+ source applications, moving API and JSON data through source-specific cache databases into the ODS
Handle the landing of unstructured and semi-structured data (e.g., parsing large JSON payloads from APIs into tabular form)
Adapt pipelines in response to schema drift and change from external vendors and internal development teams
Liaise with product owners, development teams, and vendor partners to understand API documentation, source schemas, and business requirements
Work alongside two highly experienced incumbents, gradually taking full ownership of an under-resourced integration ecosystem
Experience Requirements
7–10 years' experience in data integration, database administration, or a related role
Strong, hands-on SQL expertise, schema architecture, stored procedures, ETL logic, joins, deriving columns, and pivoting. SQL is your daily bread.
Proven data integration experience, moving data between disparate applications and standardising differing source structures into a common target
DBA mindset, with hands-on ownership of an on-prem SQL Server ODS and SQL Agent scheduling, job history and troubleshooting
Experience with linked servers and cross-server database operations
Ability to handle schema drift and change with a metadata-driven approach to ETL
Data governance, quality, and health monitoring, auditability, record counts, volume checks, and proactive failure detection
Self-sufficiency in stakeholder collaboration, able to work directly with product owners, vendors, and development teams
C# experience for building and maintaining data landing and parsing layers is strongly desirable
Experience in a full Microsoft technology stack environment is advantageous
Experience in a co-development or multi-supplier environment is a plus
Education Requirements
A degree in Computer Science, Information Systems, or a related field is preferred
Relevant certifications (Microsoft SQL Server, data management) are advantageous
Equivalent practical experience and demonstrated capability will be considered