About Novacis Digital

Novacis Digital is a product-first technology company building AI-driven platforms and large-scale data systems. Our products process complex, high-volume data to power real-time analytics and GenAI-driven experiences. We don’t see SQL as “just a database layer” - we treat it as a core compute engine. If you love writing efficient SQL and solving performance problems, this is the role for you.

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 We’re Looking For

We’re 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 Developer (Chennai)
🏢 Novacis Innovations
📍 Chennai