We are currently looking for an experienced Senior SQL Developer for our client in the travel tech industry. The ideal candidate will possess exceptional SQL development skills, coupled with strong communication and problem-solving abilities. This role requires experience in maintaining and optimizing large SQL codebases, writing complex queries, and ensuring optimal database performance.

Role Objectives

SQL Development:

Design, develop, optimize and maintain complex SQL queries, stored procedures, user defined functions (scalar, inline, table-valued, CLR), Triggers, Views, and Columnstore tables/indexes to support business applications and reporting requirements
Write and optimize complex queries on large datasets using Recursive CTEs, subqueries, and window functions

Data Management, Performance Monitoring and Optimization:

Ensure data integrity, consistency, and security across various databases
Perform regular data maintenance, optimization, and troubleshooting
Perform patch management. Knowledge of a patch orchestration tool and Zero Downtime Patching (ZDP) is required
Perform index and statistics maintenance
Utilize query hints (LOOP/HASH/MERGE joins, FORCESEEK, etc.)
Conduct execution plan analysis and Query Store analysis
Benchmark different implementations for performance improvements

Requirements

Proven experience in maintaining large SQL codebases
Expertise in writing complex queries on large datasets
Strong knowledge of performance monitoring and optimization techniques
Experience in zero downtime patching
Proficiency with SQL Server (T-SQL) is a significant advantage
Superior problem-solving abilities, with a logical and analytical approach
Highly collaborative, with excellent communication skills in English with the ability to convey technical concepts to non-technical stakeholders
Strong organizational skills, with the ability to manage multiple priorities in a fast-paced environment

BSc. in Computer Science, Information Systems or related field is required

Benefits

Remote-first company culture
Competitive compensation package
Professional growth and development opportunities
Working in exciting projects for the world’s largest companies and organizations

undefinedundefined

Logicea remote jobs

Senior SQL Developer