Senior Database Engineer
Job Description
<div class="content-intro"><p><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;"><strong>We’re Capital on Tap 👋<br></strong></span><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">💳 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.</span></p> <p><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">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. </span></p> <p><span style="font-family: verdana, geneva, sans-serif; font-size: 12pt;">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! </span></p></div><p><span style="font-family: helvetica, arial, sans-serif;"><span style="font-size: 12pt;">🏡🏢This is a Hybrid role, the AI team work from our Moorgate (London) Offices 2 days per week.</span></span></p> <p> </p> <p><span style="font-family: helvetica, arial, sans-serif;"><strong>The Role</strong></span></p> <p><span style="font-family: helvetica, arial, sans-serif;">Our platform runs on .NET and SQL Server on Azure, and it has grown well beyond what it was originally designed for. We're hiring our first dedicated Database Performance Engineer to own performance and scale: to make the fast paths fast, keep them fast as volume grows, and give every engineer here the tooling and judgement to write data access that holds up in production.</span></p> <p><span style="font-family: helvetica, arial, sans-serif;">You'll join a small, agile team of DBAs and site reliability engineers in a hands-on, senior individual contributor role. You won't be working a ticket queue. You'll choose the work that moves the needle on latency, cost and reliability, and you'll be trusted to call out what needs re-architecting.</span></p> <p><br><br></p> <p><span style="font-family: helvetica, arial, sans-serif;"><strong>What You'll Do</strong></span></p> <ul> <li style="font-family: helvetica, arial, sans-serif;"><span style="font-family: helvetica, arial, sans-serif;">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.</span></li> <li style="font-family: helvetica, arial, sans-serif;"><span style="font-family: helvetica, arial, sans-serif;">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.</span></li> <li style="font-family: helvetica, arial, sans-serif;"><span style="font-family: helvetica, arial, sans-serif;">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.</span></li> <li style="font-family: helvetica, arial, sans-serif;"><span style="font-family: helvetica, arial, sans-serif;">Own high availability and disaster recovery. Availability groups, failove