Skip to content
Search jobs inside your AI agent. Claude, ChatGPT, Claude Code, Codex, Gemini, Cursor and Grok
Connect

NovacisDigital

Sr Database Developer

Posted Updated

Description

Senior Software Engineer – SQL Server / T-SQL

Chennai | IIT Madras Research Park | Full-Time

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:

o Stored Procedures (with Dynamic SQL)

o Views

o Functions

o Triggers

· Strong experience with:

o Dynamic SQL best practices and secure execution patterns

o Indexing strategies and query plan optimization

o Handling parameter sniffing and plan instability

· Strong knowledge of:

o Temp tables vs table variables

o Cardinality estimation

o 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

Apply Now

If you enjoy designing complex Dynamic SQL-powered stored procedures and tuning systems at scale, we’d like to talk.

Skills:- Relational Database (RDBMS), Microsoft SQL Server, SQL, dynamic SQL, Stored Procedures, Functional analysis and triggers

Skills

What Senior Software Engineering jobs ask for — and how much of it you have →
Apply

See also

Software Engineering jobs by country — openings, pay and top skills →