Senior Database Administrator

N P Associates
London, UK
6 days ago
Apply on www.adzuna.co.uk
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Compensation
£80,000.0 - £95,000.0
Working hours
Regular working hours

Tech stack

Databases Relational Databases Database Queries Database Theory Linux Elasticsearch PostgreSQL MySQL Performance Tuning Query Optimization Role-Based Access Control Redis
+11 more
SQL Databases Backup and Restore Freeform SQL System Availability Grafana Database Optimization Indexer Git Patch Management User Administration User Accounts

Job description

Database Administrator (DBA) required to join the Infrastructure team and take ownership of our database estate. This is a hands-on technical role covering day-to-day administration, reliability, design and support across a varied stack that includes MySQL, Redis, QuestDB (a high-performance time-series database used for market data and operational metrics), Dolt (a version-controlled, Git-for-data SQL database), and Elasticsearch. The successful candidate will be comfortable with mature relational database tooling and open to learning newer, specialist technologies.

The role provides critical support to our Engineering and Operations teams, who rely on performant, well-managed databases to deliver and operate our exchange technology products.

Responsibilities and Duties

  • Primary resource responsible to administer, monitor, and maintain the database estate, ensuring high availability, performance, and reliability.
  • Plan and execute database upgrades, patch management, and version migrations with minimal disruption to production systems.
  • Design, implement, and routinely test backup and restore procedures, ensuring recovery objectives (RPO/RTO) are documented and met.
  • Monitor database health, capacity, and performance; identify and resolve bottlenecks proactively before they impact services.
  • Review and advise on proposed schema changes, working with developers to ensure changes are safe, performant, and aligned with best practices before deployment.
  • Support developers and operations staff with query optimisation, index design, and database access patterns.
  • Act as the primary point of escalation for database-related issues raised by the Engineering and Operations teams.
  • Collaborate with developers on integration between application code and database layers, assisting with connectivity, driver configuration, and troubleshooting.
  • Write and optimise SQL queries for use in Grafana dashboards and reporting front-ends, surfacing operational and business metrics from QuestDB and MySQL.
  • Work with the Engineering team to ensure database metrics and logs are integrated into monitoring and alerting infrastructure.
  • Manage database user accounts, roles, and permissions in line with the principle of least privilege.
  • Ensure database configurations comply with internal security policies

Requirements

  • Proven hands-on experience as a DBA or in a database-focused infrastructure/engineering role, ideally in a fast-paced, production environment.
  • Strong working knowledge of MySQL, including installation, configuration, replication, performance tuning, and user management.
  • Hands-on experience with QuestDB is strongly preferred, however candidates with a solid PostgreSQL background and an interest in high-performance time-series workloads are encouraged to apply since QuestDB uses the PostgreSQL wire protocol for queries.
  • Strong working knowledge of PostgreSQL, including query planning, indexing strategies, roles, and connection management.
  • Practical experience with backup and restore strategies across both MySQL and PostgreSQL environments, including point-in-time recovery.
  • Solid understanding of relational database concepts: normalisation, indexing, query execution plans, transactions, and locking.
  • Ability to write complex SQL queries, both for operational and reporting purposes.
  • Experience writing and integrating database queries with Grafana or similar observability and dashboarding tools is desirable.
  • Experience with or interest in version-controlled or branching database systems (e.g. Dolt).
  • Familiarity with Redis and Elasticsearch administration is advantageous.
  • Comfortable working in a Linux-based server environment and with command-line tooling.
  • Experience in a regulated financial services or compliance-driven environment is advantageous, with an understanding of audit and change control requirements.
  • Strong analytical and problem-solving skills, with a methodical approach to diagnosing and resolving incidents.
  • Excellent communication skills-able to translate database concepts clearly for non-specialist colleagues in development and operations teams.
  • Self-motivated and capable of managing competing priorities in a dynamic, high-throughput environment.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.adzuna.co.uk
Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

2:18 min

Comparing PostgreSQL and DynamoDB for read-heavy storage

George Asafev · World Congress 2023

6:21 min

Investigating push inefficiencies with upstream Git experts

Jonathan Creamer · Coffee With Developers

3:55 min

Demonstrating semantic routing thresholds with the Redis vector library

52 sec

Running persistent Linux environments directly on Windows

Ben Breard Ben Breard · World Congress 2025

2:40 min

Evolving through early developer roles and technology stacks

Liam Hurrel +1 · World Congress 2021

56 sec

Favorite git commands and the importance of patch commits

Eileen Uchitelle Eileen Uchitelle +1 · Coffee With Developers

Videos

See all

Related articles

See all