Database and Infrastructure Engineer

Administering and supporting the Microsoft SQL Server estate, including installation, configuration, patching, upgrades and day-to-day operational support

Maintaining our SQL Server high availability and disaster recovery configurations, including Always On availability groups and failover clustering

Monitoring and tuning database performance, including query optimisation, indexing, statistics and capacity planning

Managing database security, logins, roles and permissions in line with least-privilege principles and audit requirements

Designing, running and maintaining SQL Agent jobs, maintenance plans and database integrity checks

Testing and maintaining backups and DR processes (including invocation testing) so they meet contracted RPO/RTO obligations

Supporting database migrations and upgrades, including moving workloads towards Azure-native services where appropriate

Administering and maintaining Active Directory, including trusts, Kerberos delegation (including SQL Server SPNs and service accounts), certificate services and certificate lifecycle management

Administering the Windows Server and IIS infrastructure that hosts our platform, including routine patching and maintenance

Maintaining our software and associated components on Third Platform Services (TPS)

Working alongside group information security to make sure the database and server estate is configured and maintained in line with security policies, control frameworks and audit requirements, and helping to fix any risks and vulnerabilities found

Responding to IT audit and customer due-diligence information requests and providing supporting evidence

Managing relationships with third-party vendors and suppliers, including technical liaison, escalations and coordinating delivery of changes

Producing and maintaining clear technical documentation, runbooks and knowledgebase articles to support the team and meet audit requirements

Monitoring and responding to alerts from the database, infrastructure and monitoring platforms

Out-of-hours work for routine maintenance and occasional project work

Working on other IT projects relating to databases, infrastructure and security as required

Contributing to team planning

Proven experience in a similar technical role, with a significant focus on Microsoft SQL Server database administration

Experience in an environment providing and supporting B2B customer-facing technology

Experience working within a regulated or externally audited industry, with an understanding of contractual obligations and control frameworks such as ISO 27001, SOC 2 / ISAE 3402 / AAF, and CIS benchmarks/controls (or equivalents such as NIST)

Excellent communication and interpersonal skills

Self-motivated, and capable of tackling complex projects either on their own or as part of a team

Able to work collaboratively across different departments/teams with differing technical capabilities, and with external customers and vendors, to deliver effective solutions

Microsoft SQL Server administration in production environments, ideally SQL Server 2022: installation and patching, backup/restore and point-in-time recovery, security/permissions, SQL Agent job management, and performance tuning (query optimisation, indexing, execution plans)

Proficiency in T-SQL for writing, reviewing and troubleshooting queries, stored procedures and maintenance scripts

Strong Windows Server administration

Advanced Active Directory administration, including trusts, Kerberos delegation and certificate management

Knowledge of Windows-based IIS application administration

PowerShell scripting

Experience with backup and DR tools and processes

Strong documentation skills and experience managing third-party vendors/suppliers

SQL Server high availability and disaster recovery design: e.g. Always On availability groups, clustering, log shipping

Azure SQL experience: Azure SQL Database and/or Azure SQL Managed Instance, including migration from SQL Server on VMs

Basic Microsoft Azure administration: VMs, storage, networking fundamentals and resource management

Microsoft Dynamics CRM administration

ADFS administration

Redgate SQL Monitor (or similar SQL monitoring/tooling, e.g. the wider Redgate toolset)

PostgreSQL administration

Microsoft BizTalk Server administration

Microsoft SharePoint Server administration

Fortinet/FortiGate firewall administration

Experience with PRTG, Grafana, or similar monitoring platforms

Atlassian suite: Jira ticketing and project management, Confluence documentation

Industry-specific experience: payment/settlement gateways (e.g. CREST/Euroclear), trading interfaces, CASS, and similar financial-market infrastructure

Wealth management / stockbroking domain knowledge