Overview

We empower you to be innovative and solve complex problems. Take ownership, make an impact, and thrive in our scaling and agile environment. This is a Hybrid role, 2 days per week in our London office. Capital on Tap

What You'll Be Doing

• Proactively hunt down, analyse, and eliminate inefficient queries and database operations to ensure our systems run at peak performance.
• Own the delivery of reliable and scalable database solutions, from crafting indexing strategies to fine-tuning configurations.
• Be an active voice in sprint cycles, assisting with the planning and estimation of all data-related tasks.
• Design, build, and maintain robust and scalable database schemas for our critical OLTP systems.
• Play a key role in architectural decisions, bringing your expert perspective on data storage, access patterns, and security.
• Act as a forward-thinker, evaluating and championing modern design patterns for our data tier to ensure its long-term health and integrity.
• Establish and champion the standards for high-quality, efficient data access, becoming the trusted guide for engineering best practices.
• Review SQL generated by ORMs like Entity Framework, partnering with engineers to provide constructive feedback that prevents performance bottlenecks before they start.
• Identify and passionately advocate for refactoring data-related technical debt, making a clear case for improvement.
• Serve as a dedicated database expert and partner for our Software Engineers, empowering them to build applications that interact with data flawlessly.
• Be a master communicator, capable of translating complex database concepts and performance trade-offs to both technical and non-technical stakeholders across Product, QA, and SRE teams.
• Work across teams to ensure all data-tier requirements are understood, prioritized, and effectively met.

Qualifications & Skills

• Excellent T-SQL - complex queries, stored procedures, views, triggers, service broker.
• Experience in an imperative programming or scripting language such as C# and PowerShell.
• Performance tuning - Query Store, Extended Events, Server Audit, execution plans.
• Database design - PDM, LDM, CDM. Relational and non-relational data structures.
• Experience of a cloud environment.
• NET, Entity Framework or other ORM.
• PowerShell. Virtually all of our automation scripts and tooling are written in PS.
• Terraform.
• YAML.
• Other database technologies (NoSQL).
• DataDog or equivalent.
• Azure.

Why Join Us?

Capital on Tap was founded with the mission to help small business owners and make their lives easier. Today, we provide an all-in-one business credit card & spend management platform that helps business owners save time and money. Capital on Tap proudly serves over 200,000 businesses across the world and our goal is to help 1 million small businesses by 2030.

We welcome, consider and encourage applications from anyone who shares our commitment to inclusivity. Join us in creating a space where authenticity thrives, and everyone can do their best work.

Benefits

• Private Healthcare including dental and opticians services through Vitality
• Worldwide travel insurance through Vitality
• Anniversary Rewards
• Salary Sacrifice Pension Scheme up to 7% match
• Octopus EV Salary Sacrifice Scheme
• 28 days holiday (plus bank holidays)
• Annual Learning and Wellbeing Budget
• Enhanced Parental Leave
• Cycle to Work Scheme
• Season Ticket Loan
• 6 free therapy sessions per year
• Dog Friendly Offices
• Free drinks and snacks in our offices

Interview Process

1. First stage: 30 minute intro and values call with Talent Partner (Video call)
2. Second stage: 45 minute CV overview with Team Manager (Video call)
3. Final stage: 60 minute technical assessment with Head of Department (In person)

Other Info

Check out our Keep updated on new job opportunities by following us. Email if you have any questions.