Skip to content
Back to open jobs

Database Administrator (DBA)

  • To be confirmed
  • Contract
  • Remote
  • Data and Analytics
  • Data Architecture
  • SQL

The employer is confidential. We will discuss the organization and employment arrangement during the recruitment process.

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

A question about the role?

Include the role title when you contact us.

theteam@truffle.global

Apply for this role

Send your resume and contact details to the Truffle recruitment team.

Register

PDF or Word document, up to 10 MB.

Your details are used for recruitment. Read our privacy notice.