Application Database Engineer

Capital on Tap; City of Westminster; Hybrid; GBP 55,000 - 75,000; Full time

Job summary

A dynamic financial services firm is seeking a Database Expert to drive the delivery of scalable database solutions in London. You will be key in performance optimization and design, collaborating with software engineers and engaging in agile practices. This role offers a hybrid working model, with two days weekly in the office, providing competitive perks including private healthcare and an extensive benefits package.

Benefits

Private Healthcare including dental and opticians services

Worldwide travel insurance

Anniversary Rewards

Salary Sacrifice Pension Scheme up to 7% match

28 days holiday (plus bank holidays)

Annual Learning and Wellbeing Budget

Enhanced Parental Leave

Cycle to Work Scheme

6 free therapy sessions per year

Dog Friendly Offices

Free drinks and snacks

Qualifications

• Proven experience in complex T-SQL queries and database management.
• Strong background in imperative programming, notably C# and PowerShell.
• Deep understanding of database performance tuning and optimization.

Responsibilities

• Own delivery of reliable and scalable database solutions.
• Design and maintain robust database schemas.
• Actively participate in sprint planning for data-related tasks.

Skills

Excellent T-SQL

C#

PowerShell

Performance tuning

Database design

Cloud environment experience

.NET

Terraform

YAML

NoSQL technologies

DataDog

Azure

Job description

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.