Database Administrator

Location: UK, Brazil or Toronto (Remote/Hybrid) 
Reporting to:
Regional Development Manager 

Type: Full-Time, Permanent 
Start Date: ASAP 

About LemonEdge 

LemonEdge is a next-generation accounting platform built specifically for private capital markets. Our technology powers fund administrators, private equity firms, and asset managers with a flexible, scalable solution that automates complex calculations, enhances transparency, and accelerates operational efficiency. 

Since launch in 2020, we have grown to 75+ employees across six continents, backed by leading investors including Blackstone Strategic Innovations and Sidekick Partners. Our fund and portfolio accounting solution supports some of the most complex and largest global clients, with a combined asset base of over $1.4 trillion. 

Our culture prioritises speed, ownership, and collaboration. As a scaling business, you will join a fast-paced, entrepreneurial team with the opportunity to make a direct impact on our product, clients, and future growth. 

The Opportunity 

We are hiring a Senior Database Administrator to support and optimise the SQL Server environments that power our global client base. Our customers operate both self-hosted and SaaS deployments, each with different performance profiles, scale requirements, and operational constraints. You will support the health, performance, and consistency of our databases across all these environments, ensuring reliability, speed, and predictable behaviour at scale. 

This is a hands-on, high-impact role supporting complex financial workloads, large datasets, and auto-generated code that requires careful optimisation, monitoring, and proactive maintenance. 

Key Responsibilities 

• Manage and optimise SQL Server instances across SaaS and client-hosted environments. 

• Analyse and improve performance of auto-generated queries and ORM-driven SQL. 

• Lead indexing, statistics, and query-tuning strategies for high-volume workloads. 

• Maintain database hygiene: fragmentation, archiving, growth plans, and maintenance jobs. 

• Diagnose client issues, query analysis, and recommend configuration improvements. 

• Implement and refine DB monitoring, alerting, and performance baselines. 

• Review schema changes and advise Engineering on efficient data access patterns. 

• Produce clear guidance for client DB configuration, scaling, and operational practices. 

• Support incident response and lead RCAs for database-related issues.  

About You – Ideal Profile 

• 7+ years as a SQL Server DBA supporting large-scale or enterprise systems. 

• Deep expertise in T-SQL, execution plans, indexing, and SQL Server internals. 

• Experience with Azure SQL, Managed Instance, VM-hosted, and client-managed installs. 

• Strong capability in tuning auto-generated SQL and identifying structural bottlenecks. 

• Comfortable working directly with clients to diagnose issues and promote best-practice. 

• Experienced with monitoring and observability tools (Azure Monitor, etc.). 

• Strong grounding in security, backups, HA/DR, and resilience for mission-critical systems. 

• Proactive, analytical, calm under pressure, and highly attentive to detail. 

What Success Looks Like (KPIs & Metrics) 

• Faster query execution, reduced slow-running operations, and improved throughput. 

• Stable, predictable performance across all hosting models. 

• Improved index health, lower fragmentation, and consistent database hygiene. 

• Positive client feedback on support quality and performance recommendations. 

• Fewer DB-related incidents with root cause and preventative measures adopted. 

• Engineering alignment to recommended schema, SQL, and operational standards. 

What We Offer 

• A central role in the performance and stability of a mission-critical financial data platform. 

• Exposure to diverse SQL Server environments across many clients and configurations. 

• Opportunity to solve challenging performance problems at scale. 

• Hybrid working culture. 

• Competitive salary, equity, and benefits.