SQL Server Developer (MSSQL) – Production & Performance Focus

About the job : SQL Server Developer (MSSQL) – Production & Performance Focus Company: Pradha Solutions Location: Whitefield, Bangalore (On-site) Role Overview Pradha Solutions is hiring a hands-on SQL Server Developer with strong expertise in T-SQL, performance tuning, and SSIS. The role involves working on high-volume OLTP systems, optimizing queries, and supporting production environments. Key Responsibilities • Design, develop, and maintain SQL Server database objects (SPs, functions, views, triggers) • Write and optimize complex T-SQL queries (joins, CTEs, window functions, subqueries) • Develop and maintain SSIS packages for ETL and data migration • Analyze and resolve slow queries using execution plans, DMVs, and Extended Events • Design indexing strategies and partitioning for large datasets (1M–10M rows) • Monitor SQL Agent jobs, troubleshoot failures, blocking, and deadlocks • Support production incidents and ensure database performance and stability • Implement data integrit...