SQL Developer (OLTP)

Trinetix Madrid, Community of Madrid, Spain

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
• Collabor...