4+ Stored Procedures Jobs in Chennai | Stored Procedures Job openings in Chennai

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.

JD For PL/SQL

·      Minimum 4+ years of experience in PL/SQL

·      Exposure to create and maintain large database with complex requirement

·      Deep understanding on procedures, functions and collections

·      Hands on experience in analytical and aggregate functions

·      Ability to create and manage triggers

·      Experience in database transaction management

·      Provide support to java developers on need.

·      Understanding on Agile methodologies

·      Good written and oral communication skills

Interview: Direct walk-in Interview only

Location: Chennai & Madurai

Must Have:

1. Strong proficiency with .Net Core API development
2. Experience with caching approaches for API
3. Hands on with SQL Server and its variation among popular databases
4. Well versed with stored procedures, query plans, altering the indexes, and troubleshooting the performance holdups
5. Skilled at performance optimization of .NET APIs
6. Experience & Knowledge on Open API specification & swagger documentation
7. Experience in building Cloud Native Applications
8. Experience in Microservices architecture
9. Has worked on the deployment of applications using Docker
10. Has Knowledge of Kubernetes
11. Has Experience with Cache systems like Redis.

Nice to Have:

1. Familiar with .NET design patterns
2. Performance tuning of SQL Stored Procedures

Note: We looking for immediate joiners. We expect the offered candidate should join within 15 days. Buyout reimbursement is available for 30 to 60 days notice period applicants who can ready join within 15 days.