What You Will Do

- Design and build complex T-SQL stored procedures involving Dynamic SQL, along with views, functions, and triggers
- Implement flexible, metadata-driven query frameworks using sp_executesql and parameterized Dynamic SQL
- Engineer high-performance, set-based queries using CTEs, window functions, temp tables and table variables
- Optimize queries using execution plans, statistics and DMVs
- Refactor inefficient queries and redesign schemas for performance and scalability
- Solve real-world challenges related to locks, blocking, deadlocks and transaction isolation
- Collaborate with application engineers to build reliable, high-performance data access layers

What Were Looking For

Were looking for true SQL engineers people who think in execution flow, logic and data behavior rather than just syntax.

You should have:

- 4+ years of deep hands-on experience with Microsoft SQL Server & T-SQL




- Strong expertise in: Stored Procedures (with Dynamic SQL), Views, Functions, Triggers
- Robust experience with: Dynamic SQL best practices and secure execution patterns, Indexing strategies and query plan optimization, Handling parameter sniffing and plan instability
- Strong knowledge of: Temp tables vs table variables, Cardinality estimation, Cost-based optimization concepts

Nice to Have

- Exposure to GenAI data pipelines or analytical architectures
- Exposure to Graph, Vector and No SQL Databases

How We Work

- We write production-grade T-SQL
- We value performance, clarity, and correctness
- We invest heavily in query readability and maintainability
- Engineering quality is non-negotiable

📌 Database Lead (Chennai)
🏢 Novacis Digital
📍 Chennai