
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.

About NovacisDigital
About
Similar jobs
Job Description
We are looking for motivated IT professionals with at least one year of industry experience. The ideal candidate should have hands-on experience in AWS, Azure, AI, or Cloud technologies, or should be enthusiastic and ready to upskill and shift to new and emerging technologies. This role is primarily remote; however, candidates may be required to visit the office occasionally for meetings or project needs.
Key Requirements
- Minimum 1 year of experience in the IT industry
- Exposure to AWS / Azure / AI / Cloud platforms (any one or more)
- Willingness to learn and adapt to new technologies
- Strong problem-solving and communication skills
- Ability to work independently in a remote setup
- Must have a proper work-from-home environment (laptop, stable internet, quiet workspace)
Education Qualification
- B.Tech / BE / MCA / M.Sc (IT) / equivalent
• Ruby
• Rails framework
• MySQL
• API development
• Design Patterns
Develop, test, and maintain all APIs
• Manage and maintain SQL and No-SQL tables, data, and stored procedures within all databases
• Compile and analyze data, processes, and codes to troubleshoot problems and identify areas for improvement
• Collaborating with the front-end developers and other team members to establish objectives and design more functional, cohesive code to enhance the user experience and support analytical products
• Troubleshoot and diagnose production issues
Dot Net Developer
Location: Remote
Experience required: 2-15 years
Roles and Responsibilities:
In this role, you will be responsible for designing and developing enterprise-grade applications. As a member of the team, you will be expected to take ownership of individual platform components.
Key responsibilities include:
-
Developing back-end web app applications.
-
Creating servers and databases for functionality.
-
Test and debug various applications
-
Review and refactor code
-
Designing and developing APIs.
-
Strong understanding of relational databases
Basic Technical Qualifications
-
2+ years experience in building out enterprise-grade applications
Must have strong hands-on development experience in the following:
-
.net framework (c#)
-
.net core
-
Exposing and consuming JSON-based RESTful services
-
MongoDB, SQL
-
Oops Concepts
-
Troubleshooting abilities
-
Experience with unit testing
-
Familiarity with Agile methodologies
-
Experience in the end-to-end release of highly reliable applications including development
-
and testing
-
Bachelor’s degree or equivalent in Computer Science/Software Engineering (or related fields).
Soft Skills
-
Strong work ethic and dedication
-
An aptitude and interest in both technology and business
-
Excellent written and verbal communication skills are a must.
-
Highly motivated and interested in following up on detailed business or technical issues
-
and understanding the functional and technical impact of any change
-
Willingness to take initiative and work independently
Requirements
Architect, develop and maintain highly scalable, reliable and secure distributed backend
systems on Cloud (AWS or Azure) or on-premises environments for Mihup, its customers
and partners.
Work closely with your fellow engineers to develop systems capable of concurrently
processing massive amounts of voice data both in online real-time as well as offline
environments.
Drive accountability for test driven development, delivery of high-quality features and
resilient enterprise class solutions.
Lead a culture of team ownership and direct individual and team accountability to
continuously improve how they work to achieve results.
Work in a startup environment, pushing boundaries with deep involvement with business.
BE//BTech/ME/MTech in Computer Science or a related field from a Tier I or Tier II
University.
6-8 years of hands-on software development and deployment experience (experience of
working in a consumer product startup during its growth phase will be a plus) of which 1 – 2
years of experience would be in leading a team of software developers.
Expertise in Java 8+ and Spring Boot is a must
Good experience in messaging platforms like RabbitMQ/Kafka
Good experience in distributed systems and relational & NoSQL databases like PostgreSQL,
MySQL, Redis, MongoDB, etc.
Expertise in one or more of: Python, NodeJS, GoLang would be preferred
Must have hands on experience in products which handle multiple concurrent calls (API),
handle CPU intensive jobs, consist of multiple asynchronous system calls.
Worked on microservices based architecture and design
Managed/ Owned infrastructure on AWS/Microsoft Azure/private clouds and setup high
availability systems
Knowledge of Docker and Kubernetes
Knowledge of RESTful APIs, caching concepts, the HTTP protocol and general web
architecture
Pluses
1. Anything that will let us know more about who you are that you would like to share such as
Blogs, Twitter, Medium, GitHub etc.
We are hiring for Dot Net Full stack developer profile.
Skills: Dot Net Core, Angular, SQL
Experience: 3.5 yrs+
Location: Okhla Industrial Area, Delhi
Interested candidates kindly share cv at jyoti.kaur(at)programming.com
What’s the job? Dot Net Developer
Where do I work? GyanMatrix
Experience 8-11 Yrs
Why are we here?
Mandatory skills
to have:
We are looking for a Dotnet Developer, who is motivated to combine the art of design
with the art of programming. Responsibilities will include implementing visual
elements and their behaviors with user interactions. You will work on Fullstack
developers to build all client-side logic. You will also be bridging the gap between the
visual elements and the server-side infrastructure, taking an active role on both sides,
and defining how the application looks and functions.
5+ years of experience in Classic ASP and JSP.
Should have 2+ years of experience in Tomcat Administration.
Should have 3 years of experience in SQL Server.
Good Coding and Designing Skills. Good Application Troubleshooting skills.
SQL Server 2019 – SQL Queries, procedures and functions.
Ability to interpret business requirements and translate into working software.
Web and UX proficiency.
| Python |
| FastAPI / Django Framework |
| Database concept, API & SQL's |
| SSO, Oauth2, JWT, Microservices |
| MVC, ORM |
| 1) Write effective, scalable code |
| 2) Develop back-end components to improve responsiveness and overall performance Integrate user-facing elements into applications. |
| 3) Test and debug programs. |
| 4) Improve functionality of existing systems. |
| 5) Implement security and data protection solutions. |
| 6) Assess and prioritize feature requests. |
| 7) Coordinate with internal teams to understand user requirements and provide technical solutions |
| 8) Debugging programs and integrating applications with third-party web services. |
o Strong Python development skills, with 7+ yrs. experience with SQL.
o A bachelor or master’s degree in Computer Science or related areas
o8+ years of experience in data integration and pipeline development
o Experience in Implementing Databricks Delta lake and data lake
o Expertise designing and implementing data pipelines using modern data engineering approach and tools: SQL, Python, Delta Lake, Databricks, Snowflake Spark
o Experience in working with multiple file formats (Parque, Avro, Delta Lake) & API
o experience with AWS Cloud on data integration with S3.
o Hands on Development experience with Python and/or Scala.
o Experience with SQL and NoSQL databases.
o Experience in using data modeling techniques and tools (focused on Dimensional design)
o Experience with micro-service architecture using Docker and Kubernetes
o Have experience working with one or more of the public cloud providers i.e. AWS, Azure or GCP
o Experience in effectively presenting and summarizing complex data to diverse audiences through visualizations and other means
o Excellent verbal and written communications skills and strong leadership capabilities
Skills:
Python
Company: Product based Industry in Gurgaon - with offices in CANADA
Backed by intelligence and research, we assist your business perfect a greater outreach on the right audience. We are , your partner in professional growth. Offering bespoke consulting across varied segments, Trancis’ assistance is sure to set your business apart and ahead of your competition. With strong beliefs in detailed work approach, Trancis leaves nothing to chance. Meticulously going through each and every aspect of your business, we ensure that you have a well-oiled, and smooth- running venture. Appropriate business planning, correct legal and financial consulting, the right technical assistance, and more, experience an all- dimensional cooperation at . Company which stands for omnidirectional Now we are the leading IT based Industry in Gurgaon - with offices in Delhi NCR, Canada and France.We are specialized in Web Development & Digital Marketing with a proven track record of developing successful online store.Our overall client rating is 4.9 out of 5
Online test -> Final tech round
Product based / service based company
Role - Sr. Software Engineer - Java
Employment Type - Full Time, Permanent
Exp. - 5+ Years
Joining time - Immediately
work from home permanently
Knowledge and Skills:
- Strong experience in Advance Java, Spring,
- Enterprise-grade cloud applications on Java EE platforms
- Hands-on experience in designing and developing high-performing, scalable,
- Object Oriented analysis and Design patterns.
- Run the simulator against it for verifying the baseline.
- Trigger scripts that need to get the logs from the server
- Profound insight of Java and JEE internals (Memory Management, Transaction management)
- Excellent knowledge of Relational Databases SQL and ORM technologies
- Experience in developing RESTful web services
- Good experience in Spring, Spring Boot, REST APIs, Protocol Buffers
- Solid experience in creating and deploying micro services is very important.
- Working knowledge with AWS Lamda, Dockers
- Good to Have Skills: Shell script, MySQL
- Creating database schemas that represent and support business processes
- Implementing automated testing platforms and unit test
Proficient understanding of code versioning tools, such as GIT
Familiarity with build tools such as Ant, Maven, and Gradle
Familiarity with continuous integration
Mandatory skills: Advanced Java, Sprint Boot








