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 versatile, 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
Strong 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 no

📌 Database Developer (Chennai)
🏢 Novacis Innovations
📍 Chennai