Database Developer

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
• 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 non-negotiable