SQL & database query optimization specialist

4 days ago

Tallinn, Harjumaa, Estonia ERPLY Retail Software Full time

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 s

omeone 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).

  • Database Engineer

    2 weeks ago

    Tallinn, Harjumaa, Estonia Monese Full time €60,000 - €120,000 per year

    About Pockit + MonesePockit and Monese are the all-in-one money apps that make it easy for people to access and manage the financial tools that put them in control of their money. We provide vital financial services, from e-money accounts through to income advance products to over three million customers across the UK and Europe. In October 2024, Pockit...

  • Data Warehouse Specialist

    2 weeks ago

    Tallinn, Harjumaa, Estonia HCLTech Full time

    HCLTech is a global technology company, home to 219,000+ people across 54 countries, delivering industry-leading capabilities centered on digital, engineering and cloud, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life...

  • Database Administrator

    2 weeks ago

    Tallinn, Harjumaa, Estonia Coolbet Full time €40,000 - €80,000 per year

    The Job in a Nutshell As a Database Administrator, your mission is to keep our data systems running like a well-oiled machine - fast, secure, and reliable. Your mission is to ensure the optimal performance, security, and reliability of our data systems. You'll work closely with cross-functional teams to fine-tune our databases and cook up innovative...

  • Senior Database administrator for Progress

    2 weeks ago

    Tallinn, Harjumaa, Estonia SEB Eesti Full time €60,000 - €90,000 per year

    Are you passionate about technology and making a difference? Join our forces todaySEB is not just a bank. We are modern technology company with many talented IT professionals. There are more than 200 applications created and maintained by our dedicated technical teams. If you join our IT services organization, you will be able to shape and drive innovation...

  • Infrastructure Engineer MS SQL

    2 weeks ago

    Tallinn, Harjumaa, Estonia Swedbank Estonia Full time €100,000 - €120,000 per year

    Are you ready to take on a key role delivering the MS SQL database platform for internal customers, directly shaping modernization projects like our Oracle-to-SQL migration and upcoming cloud journeyIn Swedbank you have the opportunity to:Engage in exciting projects related to the migration from Oracle to MS SQL and an upcoming cloud journey.Work with large...

  • Infrastructure Engineer MS SQL

    2 days ago

    Tallinn, Harjumaa, Estonia Swedbank Full time €3,500 - €5,300

    Are you ready to take on a key role delivering the MS SQL database platform for internal customers, directly shaping modernization projects like our Oracle-to-SQL migration and upcoming cloud journeyIn Swedbank you have the opportunity to:Engage in exciting projects related to the migration from Oracle to MS SQL and an upcoming cloud journey.Work with large...

  • Database Administrator

    2 weeks ago

    Tallinn, Harjumaa, Estonia Luminor Group Full time €80,000 - €120,000 per year

    Join our team as a Database Administrator Yes, you can That's our attitude towards our work, ambitions, ideas, and relationships. We at Luminor believe that anyone has the potential to achieve big things and encourage everyone to achieve them, professionally and personally. Whoever you are and whatever your role is, with Luminor, you will get a...

  • Database Administrator

    2 weeks ago

    Tallinn, Harjumaa, Estonia Luminor Group Full time €3,400 - €5,800

    Join our team as a Database AdministratorYes, you can That's our attitude towards our work, ambitions, ideas, and relationships. We at Luminor believe that anyone has the potential to achieve big things and encourage everyone to achieve them, professionally and personally. Whoever you are and whatever your role is, with Luminor, you will get a...

  • Back-End Developer

    2 weeks ago

    Tallinn, Harjumaa, Estonia Müller`s Solutions Full time €40,000 - €80,000 per year

    As a Back-End Developer (.NET) at Müller's Solutions, you will be integral in the development of high-quality back-end systems that power our applications. You will work with a talented team to design robust APIs and services, ensuring that our software is efficient, scalable, and secure. Your expertise in .NET technologies will be key as we push the...

  • Operations Digitalization Specialist

    6 days ago

    Tallinn, Harjumaa, Estonia Marabu Airlines Full time

    Marabu Airlines is on a mission to build a modern, efficient, and digitally empowered Operations environment, and we believe the right tools, data, and smart automation are essential to achieving this. We are now looking for a highly driven and innovativeOperations Digitalization Specialistto shape the future of our operational technologies and digital...