Sr Database Developer

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 dont 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 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: 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, wed like to talk. 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 dont 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 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: 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, wed like to talk.