SQL & database query optimization specialist

We are seeking an experienced SQL developer / query optimization specialist with a deep understanding of database systems and strong skills in improving query performance. This role is not about general software development - your primary focus will be on analyzing, designing, writing, and optimizing database queries to ensure maximum efficiency and stability across our data systems. We want someone who can explain why a certain query is slow, how it should be redesigned, and what the underlying database engine is actually doing.

Key responsibilities:

• Analyze existing SQL queries and identify performance bottlenecks;
• Write, restructure, and optimize complex SQL queries and stored procedures;
• Work with relational databases (and potentially vector databases) to improve query efficiency;
• Collaborate with engineering teams to advise on best practices for data modeling and indexing;
• Monitor query performance and implement tuning strategies;
• Ensure efficient use of database resources through indexing, partitioning, execution plan analysis, etc.

What we expect from you:

• Strong expertise in SQL and experience with query optimization;
• Ability to read and understand execution plans and database performance metrics;
• Solid understanding of relational database systems (e.g., PostgreSQL, MySQL, MSSQL, etc.)
• Experience with vector databases is a plus;
• Ability to diagnose performance issues and propose technical solutions;
• Analytical mindset and attention to detail - must understand not only how queries are written but also why they perform the way they do.

In this position, you will serve as the go-to expert for understanding how our data flows, performs, and scales. Your work will directly influence application speed, user experience, and system reliability.

Why Erply?

The business solutions developed by Erply, manages billions of transactions every year in more than 300,000 stores worldwide, supporting more than 15 different languages. We have been trusted by several retail leaders such as Disney, Victorinox, Decathlon, Elizabeth Arden, Birchbox, Porsche and The Athlete's Foot.

We have a friendly and mutually supportive team, we value each other and understand that everyone is different. Our teams consist of people with an international background who work on challenging and exciting projects every day. There's already 80+ people working in our Estonian offices.

We have many activities outside the office, the most popular of which are, for example, an Enduro and fatbike event, visits to the cinema with +1, in-office ping pong competitions, etc.

In addition, we give our employees the opportunity to grow and develop in the direction where the soul desires - for this we offer the opportunity to take courses worth €300 from Udemy every year, and if necessary, we also support other trainings.

We also value health and well-being, which is why we have a masseur coming in the office every other week. Plus, we offer sports compensation (€100 per quarter) and tennis/yoga training opportunities.

In order to ensure a safe working environment, we perform background checks on our employees (including a criminal record request).