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.
Shubham Vishwakarma
Full Stack Developer - Averlon
About NovacisDigital
About
Company social profiles
Similar jobs
JavaShift timings : Afternoon
Job Summary
We are seeking an experienced Senior Java Developer with strong expertise in legacy system migration, server management, and deployment. The candidate will be responsible for maintaining, enhancing, and migrating an existing Java/JSF (PrimeFaces), EJB, REST API, and SQL Server-based application to a modern Spring Boot architecture. The role involves ensuring smooth production deployments, troubleshooting server issues, and optimizing the existing infrastructure.
Key Responsibilities
● Maintain & Enhance the existing Java, JSF (PrimeFaces), EJB, REST API, andSQL Server application.
● Migrate the legacy system to Spring Boot while ensuring minimal downtime.
● Manage deployments using Ansible, GlassFish/Payara, and deployer.sh scripts.
● Optimize and troubleshoot server performance (Apache, Payara, GlassFish).
● Handle XML file generation, email integrations, and REST API maintenance.
● Database management (SQL Server) including query optimization and schema updates.
● Collaborate with teams to ensure smooth transitions during migration.
● Automate CI/CD pipelines using Maven, Ansible, and shell scripts.
● Document migration steps, deployment processes, and system architecture.
Required Skills & Qualifications
● 8+ years of hands-on experience with Java, JSF (PrimeFaces), EJB, and REST APIs.
● Strong expertise in Spring Boot (migration experience from legacy Java is a must).
● Experience with Payara/GlassFish server management and deployment.
● Proficient in Apache, Ansible, and shell scripting (deployer.sh).
● Solid knowledge of SQL Server (queries, stored procedures, optimization).
● Familiarity with XML processing, email integrations, and Maven builds.
● Experience in production deployments, server troubleshooting, and performance tuning.
● Ability to work independently and lead migration efforts.
Preferred Skills
● Knowledge of microservices architecture (helpful for modernization).
● Familiarity with cloud platforms (AWS/Azure) is a plus.
NodeJS (Node.js)
HTML/CSS
JavascriptGood understanding and experience of HTML / CSS / JavaScript.
Hands-on experience with ES6 / ES7 / ES8 features.
Thorough understanding of the Request Lifecycle (including Event Queue, Event Loop,
Worker Threads, etc).
Familiarity with security principles including SSL protocols, data encryption, XSS, CSRF.
Expertise in Web Services / REST APIs will be beneficial.
Proficiency in Linux and deployment on Linux are valuable.
Knowledge about ORM like Sequelize and ODM like Mongoose and the ability to handle
DB transactions is a necessity.
Experience with Angular JS / React JS will be an added advantage.
Expertise with RDBMS like MySQL / PostgreSQL will be a plus.
Knowledge of AWS services like S3, EC2 will be helpful.
Understanding of Agile and CI/CD will be of value.
NodeJS (Node.js)
MongoDB
Flutter🚀 We're Hiring! 🚀
opportunity 🌟
Looking for Backend + Flutter Developers proficient in Node, MongoDB, SQL, Google Cloud, Flutter, MVVM, Provider. Interested?
Fill this Google form for this Opportunity 🔥
https://forms.gle/1hLJ5g55TtvyJwnG8
salary = 5k to 20k
Remote work
Join WhatsApp group for furthur hiring task
Given in Google form.
PythonAzure DE
Primary Responsibilities -
- Create and maintain data storage solutions including Azure SQL Database, Azure Data Lake, and Azure Blob Storage.
- Design, implement, and maintain data pipelines for data ingestion, processing, and transformation in Azure Create data models for analytics purposes
- Utilizing Azure Data Factory or comparable technologies, create and maintain ETL (Extract, Transform, Load) operations
- Use Azure Data Factory and Databricks to assemble large, complex data sets
- Implementing data validation and cleansing procedures will ensure the quality, integrity, and dependability of the data.
- Ensure data security and compliance
- Collaborate with data engineers, and other stakeholders to understand requirements and translate them into scalable and reliable data platform architectures
Required skills:
- Blend of technical expertise, analytical problem-solving, and collaboration with cross-functional teams
- Azure DevOps
- Apache Spark, Python
- SQL proficiency
- Azure Databricks knowledge
- Big data technologies
The DEs should be well versed in coding, spark core and data ingestion using Azure. Moreover, they need to be decent in terms of communication skills. They should also have core Azure DE skills and coding skills (pyspark, python and SQL).
Out of the 7 open demands, 5 of The Azure Data Engineers should have minimum 5 years of relevant Data Engineering experience.
Java
Spring BootMust-Have Technology Skills:
- OOP Concept, Java 8+, Spring Boot, API development, Agile Scrum knowledge, Strong Databases design concepts of RDBMS, and capable of writing and optimizing complex queries.
Good understanding of any Database tool e.g. Postgres, MySQL, etc., - DevOps basic knowledge e.g. implementation of logging in the code, Application Performance Management.
- Basic API & Application security, and Basics of tuning application performance.
- Basic Understanding of DevOps concepts e.g. CI & CD, Deployment lifecycle, Basic understanding of unit testing concepts e.g. TDD (test-driven development).
- A basic understanding of Microservices patterns
- A basic understanding of Java scripting.
- Good understanding of UI Frameworks like Angular 8+
Must-Have Soft Skills:
- Verbal & Written English communication, Good Problem-solving skills,
- Good Planning skills,
- Team Player,
- Good leadership skills
- Good written and verbal communication
Job Description
- Good experience as a full-stack developer in DB-centric applications and should be able to write and optimize complex database queries
- Requirement gathering & understanding, effort estimation, technical design, project planning, and monitoring in an Agile environment.
- Work proactively & independently to address project requirements, and articulate issues/challenges with enough lead time to address project delivery risks.
- Providing expertise in technical analysis and solving technical issues during project delivery.
- Customer interfacing - understand customer requirements, and propose technical solutions.
- Full Software Development Lifecycle (Agile).
- Code reviews, test case reviews and ensure code developed meets the requirements.
- Component Design/ Coding/ Unit Testing/ Debugging / Test Driven Development / Continuous Integration.
- Carry out adaptive changes necessitated by changes in Business Requirements and Technology
.NETGood experience in programming Microsoft C# (preferred) and/or Visual Basic.NET, ADO.Net, and ASP.Net 2.0, .Net 4.5 framework or .net core 2.1 and above
Must have experience In SQL and Agile/Scrum
Nice to have experience in AWS or Azure
.NET
C#Responsibilities
Design, code, test and manage various applications
Collaborate with the engineering team and product team to establish the best products
Follow outlined standards of quality related to code and systems
Qualifications
Bachelor's degree in Computer Science or relevant field
2+ years of experience working with .NET C#
Experience developing web-based & desktop based applications in C#, HTML, JavaScript, VBScript/ASP, or .NET
Experience working with MS SQL Server and MySQL Knowledge of practices and procedures for full software design life cycle
Experience working in an agile development environment
NodeJS (Node.js)MongoDB
Express
React.js• Experience in design and development of Full Stack applications using one or
more JS frameworks like ReactJS
• Good architectural & design skills.
• Strong coding, data structures, and algorithms skills
• The ability to own end-to-end responsibility - right from the requirement to
release.
• The ability to produce bug-free and production-grade code.
Key Deliverables:
• Lead the team by example.
• Help design and code highly scalable and secure systems
• Work with a performance-oriented team driven by ownership and open to
experiments.
• Build stable and scalable applications that are unit and integration tested.
• Learn & Develop Leadership skills
• Understanding of CI/CD process and using Docker
TECHNICAL COMPETENCIES REQUIRED:
• Node.js, ReactJS. Experience building microservices (REST APIs) using
Node.js
• AWS experience integrating technologies like SQS, SNS, SES, Lambda, API
Gateway, Cognito
• Experience with one or more RDBMS databases like MySql, PostgreSQL
• Experience with one or more NoSQL databases like MongoDB, Cassandra,
DynamoDB, Aerospike, Elastic Search, Redis, neo4j, etc.
• Caching technologies like: Redis, Elastic cache,
• Cloud Providers like AWS/ Google Cloud / Azure
• CI / CD: Jenkins, Docker, Kubernetes
Best Opportunity for Experienced Professionals
Role/Position - SQL DB Dev Analyst
Job Description
Proven work experience of 8+ years as a database developer.
In depth understanding of data management (e.g. permissions, recovery, security and monitoring)
Hands on experience with MS SQL Server.
Developed and maintained various T-SQL stored procedures for different applications, reports and agent jobs.
Worked with DB administrator to provide overall performance tuning of Database System which include applying Indexes and refining stored procedure.
Completed the conversion of various legacy DB applications.
Design, code, test and debug business logic for software applications using T-SQL per defined technical specifications.
Excellent analytical and organization skills.
Knowledge of software development and user interface web applications.
An ability to understand front-end user requirements and problem-solving attitude.
Should have excellent analytical and communication skills.
Qualifications
· B.E. / B.Tech. /MSC in Computer Science or IT.
Additional information Responsibilities:
· Maximize system efficiency by regularly tuning and optimizing stored procedures.
· Able to perform data analysis to clean up data, creating queries and automation routines.
· Translate use cases into functional applications
· Ensure the best possible performance, quality and responsiveness of applications.
· Help maintain code quality
· Able to work well in a team setting.
Notice Period - 15 days
Salary Package - Open
.NET
Angular (2+)C#Dot Net Developer( US Shifts)
Position – Dot Net Developer
Location – Permanent WFH Opportunity
Experience – 4-8 years
Education – B.E. / B. Tech / MCA / BCA
Salary – Negotiable
Open positions- 2
Looking for Dot Net Developer for developing desktop applications and backend services.
Job Description
- Design implement and support highly scalable applications and web services using Microsoft technologies (ASP.NET, C#, MVC, WCF, SQL Server, Windows Forms, Web API/Rest API)
- Candidate should have some experience towards experience in Angular/React and typescript also.
- Candidates should have the ability to train and work along with development teams to ensure timelines and quality deliveries.
- Lead project estimations, system architecture and performance engineering of
Desired Candidate Profile
- Minimum 4+ years’ experience in designing and developing applications on the .NET platform.
- More than 2+ year of experience with MVC, WCF framework is needed.
- Experience in web application Architecture and Development with hands on expertise in delivering solutions based on/customizing ASP.Net 4.0 / MVC and above.
- Expert-level knowledge of SQL Server programming.
- Strong understanding of OOPS fundamentals, Entity Framework, LINQ and REST APIs.
- Candidate should be ready for US shifts (4pm-1AM)
- Candidates who can join early and working with international clients will be preferred.
.
Follow CutshortShubham Vishwakarma
Full Stack Developer - Averlon