Senior T-SQL Performance Engineer

Project overview

Senior T-SQL Performance Engineer

Reference: *-ba3b-6d55a86d5647

Responsibilities

• Conception, implementation, review, and optimization of demanding Transact SQL solutions with a focus on stored procedures, triggers, set-based processing, temporary tables, and robust error handling.
• Systematic performance analysis using actual execution plans, and optimization of queries, indexing, statistics, and plan stability.
• Analysis and reduction of locking, blocking, deadlocks, and lock escalation in highly parallel multi-user scenarios.
• Performance-secure implementation of large insert, update, and delete operations through appropriate batch, transaction, restart, and rollback strategies.
• Further development of related data models and insert/delete pipelines, considering foreign keys, referential integrity, and cascade rules.
• Performance-oriented processing of hierarchical data and high-volume audit and change collectors.
• Adaptation of associated OLE DB connections in C++ together with the developers of the calling components.
• Securing changes through targeted tests, code reviews, measurable before/after comparisons, and CI/CD checks.
• Maintenance of traceable work tasks in Azure DevOps and structured knowledge transfer to the internal development team.
• Explicit and deterministic implementation with full schema qualification, defined column lists, explicit joins, and stable sorting.

Requirements

• Comprehensive, current project experience with Microsoft SQL Server and Transact-SQL in productive, business-critical systems.
• Strong T-SQL expertise in triggers, set-based processing, temporary tables, and robust error handling; secure processing of multi-row operations.
• Demonstrable expertise in performance tuning: analyzing actual execution plans, optimizing queries and indexes, and mastering locking, blocking, and large DML operations.
• Solid experience with related data, foreign keys, and cascade rules within complex insert/delete pipelines.
• Experience in performance-oriented processing of hierarchical data and high-volume audit or change collectors.
• Sufficient practical C++ experience to adapt associated OLE DB connections together with the developers of the calling parties.
• Confident use of SQL Server Management Studio, Git, Azure DevOps, and automated CI/CD checks.
• Practice with Query Store, Extended Events, Dynamic Management Views, and Wait Statistics for sound root cause analysis.
• Confident handling of transactions, referential integrity, isolation levels, transaction log, restart, and rollback.
• Experience with automated tests for database logic and with backward-compatible, idempotent deployment and migration scripts where possible.

Project details

asap

5 MM++

• Start: ab sofort
• Duration: 5 Monate
• Remote: onsite
• Location: Hannover, Deutschland, DE
• Languages: German

Source notes

With our many years of recruitment experience and our knowledge of the engineering personnel market, we offer specialists and managers from engineering and technical fields a strong partnership. Through our intensive relationships and networks across all industry sectors, we provide you as an engineering professional with exciting projects and attractive positions. Tailored to your interests and dependent on your experience and qualifications.

You benefit from professional support from the first contact to the start of your new project or position - and of course, completely free of charge.

Register and look forward to interesting and suitable positions and projects.

My contact at Hays:

My contact person:

Noel Shahim Schulz

Reference number:

*

Contact:

Email: *@*.de

• Option for extension
• Remote possibility