Application Database Engineer

Capital on Tap; City Of London; Hybrid; GBP 45,000 - 70,000; Full time

Job summary

A growing fintech company in the City of London is looking for a Database Engineer to optimize and enhance their core database systems. This role involves performance analysis, solution delivery, and collaboration with engineering teams. Ideal candidates will have expertise in T-SQL, cloud environments, and be skilled communicators keen to contribute in a hybrid workspace. Competitive perks and a supportive company culture await.

Benefits

Private Healthcare

Worldwide travel insurance

Anniversary Rewards

Salary Sacrifice Pension Scheme

28 days holiday plus bank holidays

Annual Learning and Wellbeing Budget

Enhanced Parental Leave

Cycle to Work Scheme

Season Ticket Loan

Free therapy sessions

Dog Friendly Offices

Free drinks and snacks

Qualifications

• Excellent T-SQL skills, including complex queries and stored procedures.
• Experience in imperative programming or scripting languages.
• Strong performance tuning capabilities.
• Experience with both relational and non-relational data structures.
• Familiarity with cloud environments and database technologies.

Responsibilities

• Analyze and eliminate inefficient queries to improve performance.
• Deliver reliable and scalable database solutions.
• Participate actively in sprint cycles for data-related tasks.
• Design and maintain robust database schemas.
• Evaluate modern design patterns for data tier integrity.

Skills

T-SQL

C#

Performance tuning

Database design

Cloud environment experience

.NET Entity Framework

Powershell

Terraform

YAML

NoSQL

DataDog

Azure

Job description

Were Capital on Tap

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 200000 businesses across the world and our goal is to help 1 million small businesses by 2030.

Why Join Us

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.

As a Database Engineer at Capital on Tap you will be more than just a technical expert; you will be a champion for data-tier excellence and a pivotal partner to our engineering teams. This role is for a specialist who is passionate about the performance scalability and integrity of our core database systems including SQL Server and is eager to expand their expertise into technologies like MongoDB and Azure. You will be the go-to ambassador for all things database-related using your exceptional communication skills to guide influence and elevate our approach to data across the entire technical organisation.

What Youll 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.

Were Looking For

• 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

Diversity & Inclusion

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.

Great Work Deserves Great Perks

• Private Healthcare including dental and opticians services through Vitality
• Worldwide travel insurance through Vitality
• Anniversary Rewards (-week fully paid sabbatical)
• 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

Check out more of our benefits values and mission here.

Interview Process

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

Other Info

Check out ourTop Tips for interviewing.

Keep updated on new job opportunities by following us on Linkedin.

Email if you have any questions.

Excited to work here Apply!

If youd like to progress your career within our fast growing profitable fintech then click apply and we will aim to get back to you within 3 working days (during busy periods this could take up to 5 working days.)

Employment Type : Full Time

Experience : years

Vacancy : 1