TL;DR

Sql Developer (Oltp): Developing and optimizing SQL queries and database schemas for production OLTP systems with an accent on query optimization, performance tuning, and schema design. Focus on diagnosing bottlenecks, improving existing structures, and building scalable database schemas from scratch.

Location: Hybrid in Madrid, Spain

Company

%hirify_global% is a global tech service provider headquartered in Nashville, Tennessee, with delivery centers across Europe, the US, and Argentina, delivering innovative digital solutions in Fintech, Professional Services, Logistics, Healthcare, and Agriculture.

What you will do

Analyze and optimize slow SQL queries in MS SQL Server using joins, subqueries, and window functions.
Review and improve existing database schemas in production OLTP systems.
Design and build new database schemas ensuring performance and scalability.
Work with execution plans, indexes, statistics, and partitioning to enhance performance.
Diagnose bottlenecks and issues using monitoring and profiling tools.
Collaborate with developers to ensure efficient SQL and schema use across the platform.

Requirements

Must have 3+ years of hands-on experience with MS SQL Server as a SQL Developer.
Practical experience in SQL query optimization in production environments.
Strong skills in analyzing execution plans, designing indexing strategies, and tuning performance.
Experience building production-ready database schemas from scratch.
Solid knowledge of OLTP database design principles and best practices.
Ability to present real examples of performance improvements or schema redesigns implemented.

Nice to have

Familiarity with SQL Server tools for performance monitoring such as SQL Profiler, Extended Events, and DMVs.

Culture & Benefits

Continuous learning and career growth opportunities.
Professional training and English/Spanish language classes.
Comprehensive medical insurance and mental health support.
Specialized benefits program including fitness, hobbies, and pet care compensation.
Flexible working hours and inclusive, supportive culture.