Location
Trinetix Madrid, Community of Madrid, Spain
Overview
Trinetix is looking for an experienced SQL Developer with deep, practical expertise in MS SQL Server, focusing on query optimization, performance tuning, and the design of efficient database schemas. This role involves reviewing, analyzing, and improving existing SQL and schema structures in production OLTP systems, as well as building new schemas from scratch based on business requirements.
Key Responsibilities
Analyze and optimize slow SQL queries in MS SQL Server (joins, subqueries, window functions, etc.)
Review and improve existing database schemas used in production systems
Design and build new database schemas from scratch, ensuring performance and scalability
Work with execution plans, indexes, statistics, and partitioning to enhance performance
Diagnose bottlenecks and issues in production OLTP systems using monitoring and profiling tools
Collaborate with developers to ensure efficient SQL and schema use across the platform
Propose structural, architectural, and performance‑oriented improvements
Required Experience
3+ years of hands‑on experience with MS SQL Server as a SQL Developer
Demonstrated practical experience in SQL query optimization in production environments
Strong skills in analyzing execution plans, designing indexing strategies, and tuning performance
Experience building new, 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 you have implemented
Nice to Have
Familiarity with SQL Server tools for performance monitoring (SQL Profiler, Extended Events, DMVs, etc.)
What We Offer
Continuous learning and career growth opportunities
Professional training and English/Spanish language classes
Comprehensive medical insurance
Mental health support
Specialized benefits program with compensation for fitness activities, hobbies, pet care, and more
Flexible working hours
Inclusive and supportive culture
Job Details
Senior level: Mid‑Senior level
Employment type: Full‑time
Job function: Other
Industries: IT Services and IT Consulting
#J-18808-Ljbffr
or continue with email
Trinetix Madrid, Community of Madrid, Spain
Overview
Trinetix is looking for an experienced SQL Developer with deep, practical expertise in MS SQL Server, focusing on query optimization, performance tuning, and the design of efficient database schemas. This role involves reviewing, analyzing, and improving existing SQL and schema structures in production OLTP systems, as well as building new schemas from scratch based on business requirements.
Key Responsibilities
Analyze and optimize slow SQL queries in MS SQL Server (joins, subqueries, window functions, etc.)
Review and improve existing database schemas used in production systems
Design and build new database schemas from scratch, ensuring performance and scalability
Work with execution plans, indexes, statistics, and partitioning to enhance performance
Diagnose bottlenecks and issues in production OLTP systems using monitoring and profiling tools
Collaborate with developers to ensure efficient SQL and schema use across the platform
Propose structural, architectural, and performance‑oriented improvements
Required Experience
3+ years of hands‑on experience with MS SQL Server as a SQL Developer
Demonstrated practical experience in SQL query optimization in production environments
Strong skills in analyzing execution plans, designing indexing strategies, and tuning performance
Experience building new, 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 you have implemented
Nice to Have
Familiarity with SQL Server tools for performance monitoring (SQL Profiler, Extended Events, DMVs, etc.)
What We Offer
Continuous learning and career growth opportunities
Professional training and English/Spanish language classes
Comprehensive medical insurance
Mental health support
Specialized benefits program with compensation for fitness activities, hobbies, pet care, and more
Flexible working hours
Inclusive and supportive culture
Job Details
Senior level: Mid‑Senior level
Employment type: Full‑time
Job function: Other
Industries: IT Services and IT Consulting
#J-18808-Ljbffr
Sign in
To continue your applicationor continue with email
By continuing you agree to our Terms & Privacy Policy.
Similar jobs
