Perl Developer (On Contract)

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.

We are looking for a Software Developer to design, develop, test, and maintain reliable software applications. The ideal candidate should have strong programming fundamentals, problem-solving skills, and an interest in building scalable technology solutions.

Key Responsibilities

• Develop, test, debug, and maintain software applications.
• Write clean, efficient, and reusable code.
• Work with frontend, backend, databases, and APIs as required.
• Identify and resolve technical issues and software bugs.
• Collaborate with developers, designers, and other team members.
• Participate in code reviews and software testing.
• Maintain technical documentation.
• Learn and implement new technologies based on project requirements.

Required Skills

• Programming knowledge in Java, Python, JavaScript, C++, C#, or similar languages.
• Understanding of Data Structures, Algorithms, OOP, and DBMS.
• Familiarity with SQL and databases.
• Basic understanding of REST APIs, Git/GitHub, and software development practices.
• Strong analytical and problem-solving skills.
• Good communication and teamwork abilities.