Application Database Engineer

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 UsWe 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 PowershellPerformance tuning - Query Store Extended Events Server Audit execution plansDatabase design - PDM LDM CDM. Relational and non-relational data structuresExperience of a cloud environment.NET Entity Framework or other ORMPowershell. Virtually all of our automation scripts and tooling are written in PS.TerraformYAMLOther database technologies (NoSQL)DataDog or equivalentAzureDiversity & InclusionWe 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 PerksWe try not to take ourselves too seriously (all the time) so we make sure our office is decked out with a pool table arcade machine beer tap and a couple of office dogs thrown in for good measure. Check out our benefits: 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 officesCheck 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 InfoCheck 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 ApplyIf 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.) Key Skills Children Activity,EAM,Engineering Support,Maintenance Engineering,Accident Investigation,Branding Employment Type : Full Time Experience: years Vacancy: 1