Senior Technical MS SQL Engineer

Company Description

ThoughtVerve delivers comprehensive software and technology solutions, specializing in design, development, and deployment tailored to meet unique client needs worldwide. With a focus on future-proofing through robust design, scalability, and technological advancements, ThoughtVerve ensures solutions remain adaptable and maintainable over time. Committed to customer success, the company supports clients from the inception of projects through their continuous evolution, fostering strong, lasting partnerships.

Role Description

This is a full-time on-site role for a Senior Technical MS SQL Engineer based in Bengaluru. The role involves managing and optimizing Microsoft SQL Server databases, overseeing complex database structures, and ensuring robust performance and reliability. The engineer will participate in database design, query optimization, troubleshooting, and ensuring database security. Responsibilities also include collaborating with cross-functional teams, identifying opportunities for improvement, and implementing technical solutions.

Core SQL Development (Primary Focus)

Write, optimize, and maintain complex T-SQL queries, stored procedures, functions, and triggers

Develop efficient, scalable database logic to support business applications

Translate complex business requirements into high-performing SQL solutions

Refactor and improve existing SQL code for performance, readability, and maintainability

Query Performance & Optimization

Analyze execution plans and resolve performance bottlenecks in queries and procedures

Design and implement indexing strategies to improve query performance

Tune high-volume transactional queries for optimal efficiency

Troubleshooting & Production Support

Diagnose and fix issues related to SQL logic, data inconsistencies, and performance

Support production systems by resolving query-related issues quickly and effectively

Collaboration

Work closely with application developers to integrate SQL logic into applications

Participate in code reviews and enforce SQL development standards

Contribute to Agile development cycles and deliverables

Required Skills & Qualifications

10+ years of strong hands-on experience in SQL development (MS SQL Server preferred)

Expert-level proficiency in writing complex queries and stored procedures

Strong experience in query optimization, indexing, and execution plan analysis

Deep understanding of relational databases and data modeling

Proven ability to handle large datasets and high-volume transactions

Experience with ETL/data transformation using SQL

Strong debugging and problem-solving skills

Nice to Have

Experience with SSIS or similar ETL tools

Exposure to reporting tools (Power BI, SSRS, etc.)

Familiarity with Azure SQL or cloud-based data platforms

What This Role Is NOT

Not a DBA or infrastructure-heavy role

Not focused on server setup, patching, or hardware management

Purely focused on SQL development and data logic Develop and maintain SQL-based ETL processes and data transformations

Build data workflows to support reporting, analytics, and downstream systems

Ensure data accuracy, consistency, and integrity