Sr Database Developer

Senior Software Engineer – SQL Server / T-SQLChennai | 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  Viewso  Functionso  Triggers·      Strong experience with:o  Dynamic SQL best practices and secure execution patternso  Indexing strategies and query plan optimizationo  Handling parameter sniffing and plan instability·      Strong knowledge of:o  Temp tables vs table variableso  Cardinality estimationo  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.