Database Engineer

**We’re Capital on Tap 👋
**💳 Capital on Tap started because small businesses were underserved. Big banks were slow, their products weren't fit for purpose, and small business owners often couldn't access what they needed. We set out to fix that.

Today we're a financial platform - not just a credit card company. We offer a best-in-class business credit card, SME-focused spend management platform, a savings product that hit £1 billion in funds within its first year, and a growing suite of tools and financial products that make running a small business easier. 

1,000+ employees, £20bn in annual card spend, 200,000+ customers, 17,000+ Trustpilot reviews averaging 4.7 stars, and we're profitable. We’ve done a pretty good job so far, but we’re just getting started! 

📍London, Old Street | 🏢 2 Days in Office

Database Engineering at Capital on Tap 🌞

Our platform runs on .NET and SQL Server on Azure, and it has grown a long way past what it was originally designed for. We are hiring our first dedicated database performance engineer to own performance and scale: to make the fast paths fast, to keep them fast as volume grows, and to give every engineer here the tooling and the judgement to write data access that holds up in production. You will join a small agile team comprising DBAs and site reliability engineers in a hands-on senior individual contributor role. You will not be a ticket queue. You will pick the work that moves latency, cost and reliability, and you will be trusted to say what needs re-architecting.

What You'll Do

• Own query and index performance across our transactional SQL Server estate, using execution plans, Query Store, wait statistics, real production telemetry or other data driven measures.
• Investigate and implement horizontal scaling techniques such as multi-cluster architecture, contained availability groups, sharding, etc, to ensure Capital on Tap’s distributed software estate can continue to support a fast growing customer base and increasing service count.
• Find and remove the bottlenecks on our latency critical paths, starting with card authorisation and ledger read/writes, and hold them to an agreed p99 budget.
• Own high availability and disaster recovery. Availability groups, failover, backup and restore testing against real RTO and RPO targets, and the runbooks that go with them.
• Build and enhance self serve tooling to enable development teams to identify query plan regressions along with self service diagnostic tools to allow teams to debug their own query performance.
• Automate what is currently manual, using PowerShell, Python, or Terraform, and treat database configuration as code.