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.
Top Skills
What We Do
“LemonEdge is the next generation solution for managing private markets fund and portfolio accounting at scale with user experience centre-stage - user friendly and fast!“ said Lauren Iaslovits, co-founder of Investran, and a LemonEdge investor/strategic advisor. LemonEdge launched in 2020, backed by Sidekick Partners, Lauren Iaslovits and Tikhon Bernstam. Out of the box, our private capital solution offers a low-code platform for financial services supported by advanced cloud-native and API technologies. Complex fund and portfolio accounting requirements are delivered at scale with our unique Path Allocation Engine - saving hours of lost time in legacy processes, such as Equity Pick Up. LemonEdge supports full look-through capability, fast powerful reporting, and scenario planning delivers insights in real-time with our canvas technology. The portfolio management suite handles wide-ranging complex calculations from IRRs, waterfalls and valuations to deliver high operational efficiency. Our no-code and low-code tools allow you to fully customise the existing platform or develop custom applications on top of the platform 10x faster. LemonEdge building blocks for financial services can give your solution the edge it needs – from multi-currency general ledger, auditing, risk management and reporting to complex data handling at scale.
