TL;DR

Sql Developer (OLTP): Developing and optimizing MS SQL Server queries and database schemas for production OLTP systems with an accent on query optimization, performance tuning, and schema design. Focus on diagnosing bottlenecks, improving execution plans, and collaborating with developers to enhance platform efficiency.

Location: Hybrid in Sofia, Bulgaria

Company

%hirify_global% is a global tech service provider with over 1,000 professionals, delivering innovative digital solutions across 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, indexing strategies, and performance tuning.
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.

Nice to have

Familiarity with SQL Server performance monitoring tools like 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 culture.