Senior SQL Server Developer - Performance & Optimization

Tringapps Research Labs; United States; Remote; USD 90,000 - 150,000; Full time

Job summary

Tringapps Research Labs in the United States is seeking a Full-time Freelancer/Contractor with extensive experience in Microsoft SQL Server and advanced T-SQL development to optimize complex database workloads.

You will analyze execution plans, optimize indexing, refactor queries, and reverse-engineer existing data models while coordinating with stakeholders to resolve production issues.

Qualifications

• Proven experience with Microsoft SQL Server and advanced T-SQL development.
• Deep understanding of relational database architecture, schema design and data modelling.
• Ability to analyze SQL Server Execution Plans and optimize queries.
• Experience addressing deadlocks, blocking and bottlenecks in production databases.
• Capable of reverse-engineering complex data models and extracting business logic.

Responsibilities

• Extensive experience in Microsoft SQL Server and advanced T-SQL development
• Strong expertise in stored procedures, CTEs, window functions and query optimization
• Deep understanding of relational database architecture, schema design and data modelling
• Hands-on experience with SQL Server Execution Plan analysis
• Proficient in indexing strategies and performance optimization
• Experience resolving deadlocks, blocking and bottlenecks in production databases
• Ability to reverse-engineer complex database structures and existing data models
• Demonstrated ability to understand business logic from databases and applications
• Manage requirements through development, testing and deployment with minimal supervision
• Communicate effectively with stakeholders and coordinate activities

Skills

MS SQL Server

T-SQL development

Stored Procedures

CTEs

Window Functions

Query Optimization

Database design

Data modelling

Execution Plan analysis

Indexing strategies

Performance tuning

Deadlocks resolution

Reverse-engineering databases

Job description

Employment type: Full-time Freelancer / Contractor

Role & responsibilities

• Extensive experience in Microsoft SQL Server and advanced T-SQL development
• Strong expertise in complex Stored Procedures, CTEs, Window Functions, Functions and Query Optimization
• Strong understanding of relational database architecture, schema design and data modelling
• Hands-on expertise in SQL Server Execution Plan analysis
• Advanced knowledge of indexing strategies, query refactoring and performance optimization
• Experience identifying and resolving deadlocks, blocking and database performance bottlenecks
• Ability to independently reverse-engineer complex database structures and existing data models
• Ability to quickly understand underlying functional/business logic from databases and existing applications
• Experience handling production database issues and performance troubleshooting with minimal supervision
• Capable of independently managing activities from requirement understanding through development, testing and production deployment
• Strong communication and stakeholder coordination skills