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
Java
Spring BootJOB DESCRIPTION
Experience: 3-5 years
Wissen Technology is now hiring for a Senior Java Developer - Bangalore with hands-on experience in Core Java, algorithms, data structures, multithreading and SQL. We are solving complex technical problems in the industry and need talented software engineers to join our mission and be a part of a global software development team. A brilliant opportunity to become a part of a highly motivated and expert team which has made a mark as a high-end technical consulting.
Required Skills:
- Exp. - 3-5 years
- Experience in Core Java and Spring Boot.
- Extensive experience in developing enterprise-scale applications and systems. Should possess good architectural knowledge and be aware of enterprise application design patterns.
- Should have the ability to analyze, design, develop and test complex, low-latency client- facing applications.
- Good development experience with RDBMS.
- Good knowledge of multi-threading and high-performance server-side development.
- Basic working knowledge of Unix/Linux.
- Excellent problem solving and coding skills.
- Strong interpersonal, communication and analytical skills.
- Should have the ability to express their design ideas and thoughts
PythonJavaDescription
Join company as a Backend Developer and become a pivotal force in building the robust, scalable services that power our innovative platforms. In this role, you will design, develop, and maintain server‑side applications, ensuring high performance and reliability for millions of users. You’ll collaborate closely with cross‑functional product, front‑end, and DevOps teams to translate business requirements into clean, efficient code, while participating in code reviews and architectural discussions. Our dynamic environment encourages continuous learning, offering opportunities to work with cutting‑edge technologies, cloud infrastructures, and modern development practices. As a key contributor, your work will directly impact product quality, user satisfaction, and the overall success of company's mission to streamline hiring solutions.
Requirements:
- 1–15 years of professional experience in backend development, with a strong focus on building APIs and microservices.
- Proficiency in server‑side languages such as Python, Java, Node.js, or Go, and solid understanding of object‑oriented and functional programming paradigms.
- Extensive experience with relational (e.g., PostgreSQL, MySQL) and NoSQL databases (e.g., MongoDB, Redis), including schema design and query optimization.
- Familiarity with cloud platforms (AWS, GCP, Azure) and containerization technologies like Docker and Kubernetes.
- Hands‑on experience with version control (Git), CI/CD pipelines, and automated testing frameworks.
- Strong problem‑solving abilities, effective communication skills, and a collaborative mindset for working within multidisciplinary teams.
Roles and Responsibilities:
- Design, develop, and maintain high‑throughput backend services and RESTful APIs that support core product features.
- Implement data models and storage solutions, ensuring data integrity, security, and optimal performance.
- Collaborate with front‑end engineers, product managers, and designers to define technical requirements and deliver end‑to‑end solutions.
- Participate in code reviews, provide constructive feedback, and uphold coding standards and best practices.
- Monitor, troubleshoot, and optimize production systems, implementing robust logging, alerting, and performance tuning.
- Contribute to the continuous improvement of development workflows, including CI/CD automation, testing strategies, and deployment processes.
- Stay current with emerging technologies and industry trends, proposing innovative approaches to enhance system architecture.
Budget:
- Job Type: payroll
- Experience Range: 1–15 years
NodeJS (Node.js)
MongoDB
HTML/CSSHi,
I am having an ajob opportunity for the role of "Node Js developer" permanent work from home.
Please find the below JD
Responsibilities:
We are looking for a candidate who possesses a passion for pushing technologies to the limits and will work with our team of talented engineers to design and build the next generation applications.
- You will work closely with our product and design teams to build the backend engine and implement web services using the latest principles.
- Candidates should have working knowledge of NodeJS latest versions. Candidates with additional knowledge of technologies like JAVA, CAKEPHP will be preferred more.
Skills Required :
NodeJS, REST API, JSON Data Format, Integrating Third Party Libraries, MYSQL/MONGODB Databases and similar.
- Affinity for backend technologies.
- Experience in writing modular/reusable code using node frameworks
- Deep technical Knowledge and Good problem solving abilities.
- Good communication skills and solid interpersonal skills.
- Team Management skills is must
-Qualification Required : MCA/B.Tech Candidate Only
Javasoftware products.
● Degree in Computer Science, Maths, or equivalent.
● Experience with AWS or Google Cloud or Azure.
● Experience with RDBMS and NoSQL: MySQL/MariaDB or PostgreSQL,
DynamoDB or MongoDB.
● Fluent in common design patterns, modular architecture, microservices, and a
demonstrated web and polyglot development experience.
● Passionate about distributed computing and building applications that are
robust, scalable, and keep the customers happy.
● Proficiency in programming languages such as Java, Scala; a strong foundation
in data structures, algorithms, understanding of threads, synchronization, and
concurrent programming.
● Experience with deployment, configuration, automation tools, and DevOps
methodologies.
● Understanding of Internet security models, REST API, and application
integration.
● Good to have some understanding of Serverless.
.NET
C#
jQuery- Designs, develops, modifies, debugs, and evaluates programs for functional areas
- Analyzes existing programs or formulates logic for new systems
- Devises logic procedures
- Prepare Flowcharting
- Performs coding and tests/debugs programs.
- Develops Conversion and System implementation plans
- Prepares and obtains approval of system and programming of documentation
- Recommends changes in development, maintenance, and system standards
- Train users in conversion and implementation of system
- Communicate with end users and understands the requirements in clearly.
Skills & Qualifications:
- Bachelor’s or master’s degree in engineering / MCA with 5+ years of solid software development experience using .Net environment using C#, VB.NET, ASP.NET, ADO.NET.
- Experience working with Manufacturing Execution System (Camstar) is a plus.
- Experience working with Web services and XML/ XSLT.
- In Depth knowledge of MS-SQL 2005/2008 including coding of SPs.
- Has a Solid background of Object-Oriented Analysis and Design and the use of UML views and diagrams.
- Has the ability to design and document software applications with minimal supervision.
- Experience in multi-platform software Development (DOS, Windows).
- Experience in developing software applications in a multi-tier architecture.
- Experience in presentation layer development using JavaScript, HTML, DHTML, Ajax and CSS.
- Experience in WCF / MVC is a plus.
- Experience is in Source Controls like SVN / TFS.
- Able to handle all phases of SDLC.
C#.NET Design, Develop and Test applications running in the cloud.
Work in sprints, within a highly motivated, self-organizing team to produce quality software
according to the priorities laid down by the application stakeholders.
Design innovative solutions to problems faced by our internal and external customers and
implement them on continuously evolving applications.
Write Unit tests to ensure code is proven to work before being deployed to Test environments.
Use defensive coding to ensure software is developed with a secure approach.
Provide input on best practices and innovations across all aspects of our software development.
Provide our customers with Applications that can satisfy their needs, working as part of the team
to address issues that customers may encounter as they go about their business.
Required Experience and Skills :
A minimum of 6 years of software development experience
In-depth knowledge of C#
Hands-on experience with ASP. NET MVC Framework
Strong knowledge and experience in designing and developing Web solutions using ASP.
NET MVC Framework
Rich experience in creating REST-based web-services using ASP. NET Web API or ASP.
NET Core
Working experience of Relational Databases (MS SQL, Oracle nice to have), ORM (Entity
Framework, EF Core)
Affinity with unit and integration testing frameworks and TDD
Knowledge of Azure cloud and DevOps pipeline nice to have
Analyze, plan and estimate requirements as well as identify risks involved and provide
solutions
Understanding of design principles behind scalable and testable applications
Continuous improvement and innovative mind-set.
Ability to take a lead role and take ownership of complex data integration deliveries.
A degree in Computer Science and/or a business related degree; or equivalent work experience.
.NETC#Company Profile
Prescinto is a VC funded SaaS company in the renewable energy space enabling digital transformation for customers across the globe.
Prescinto provides solutions to improve power generation for Renewable energy power plants by identifying areas of underperformance and lost generation opportunities through patent pending methodologies; systematically addressing these through an automated workflow system to improve power generation for our customers.
This is achieved by leveraging the IoT and Analytics platform built to collect high frequency data from distributed renewable energy assets and the comprehensive data lake.
Roles & Responsibilities
You are responsible for understanding the product architecture and Design laid out by the Architect and Develop product features in alignment with the architecture.
Product is built on Microsoft stack with Angular 11, .NET and data residing in MS SQL Server and InfluxDB, mobile application built on Flutter and data lake deployed on Azure environment. It extensively uses multi-threading for parallel processing, stored procedures for data access and leverages time-series database for storing high frequency equipment data.
In this role, you should be able to work independently as well as work with vendor and junior members to collaboratively build the features and take them to production. You need to be both a big picture thinker and in-depth problem solver, your knowledge and skills are both broad and deep.
Do you take pride in building customer centric functionalities with an eye on performance? Are you remembered for the quality of your code? This position is for you.
Desired Skills & Experience
- 8+ years of Product development experience of which at least 2 years should comprise of working independently with minimal supervision and guidance
- Experience with at least one full cycle development of product features from requirements to Production deployment to Post production support is critical
- Excellent Programming Skills using C#, WPF, MVVM, Winforms, .NET Framework, Windows Communication Foundation (WCF), ASP.net web api, SQL Server, Store Procedure, Triggers
- Solid Understanding of Multi-Threading and Parallel Programming
- Excellent understanding of Windows Operating System Internals (Process, Threads, Memory Management).
- Clear understanding of OOP and OOAD
- Excellent application debugging skills using Visual Studio Debugger
- Strong knowledge in design patterns, data structures and algorithms
- Experienced in developing Windows desktop applications
- Ability to work independently and be self-driven
- Should have knowledge on code repositories like SVN, GitHub etc and Agile tools like JIRA
- Should have excellent communication skills, excellent analytical and problem-solving skills
- Have working experience in Test-driven Development and Test Automation experience in third party control like DevExpress, Telerik WPF controls
- Experience building a SaaS product preferable
- Startup experience preferable
C#.NET- Bachelors degree in Computer Science, Software Engineering, or a related discipline
- Experience working in an IT environment
- Experience developing with C#, C++, or other object-oriented platforms
- 2+ years of web application development
- Skill for writing reusable libraries
- Hands-on experience in ASP.Net, MVC, Restful services, Web API
- Experience in .Net Web API
- Strong understanding of object-oriented programming
- Strong knowledge of C# programming
- Ability to troubleshoot problems independently. Good analytical and problem-solving skills
- Familiar with various design and architectural patterns
- Strong Knowledge in Microsoft SQL Server scripts and Stored procedures
- Exposure to Agile Software Development Life Cycle
- Experience implementing automated testing platforms and unit tests
- Proficient understanding of code versioning tools such as GIT
- Experience in Service-based architecture
JavascriptPython
Go Programming (Golang)- Strong programming skills in Javascript/TypeScript, Python or Go.
- Hands-on experience in API development and frameworks such Express, Loopback, Hapi.
- Good Understanding of SQL and NoSQL database.
- Experience in test driven development. (writing unit test and API test).
- Understanding of basic cloud computing concepts and experience in using any of the major cloud service providers(AWS/GCP/Azure).
- Ability to build and deploy the application in a containerized environment.
- Understanding of application logging and monitoring systems like Prometheus or Kibana.
Qualification:
- B.E/B.Tech/M.E./M.Tech/M.S. from a reputed university with a good academic record.
- Curiosity to explore the cutting edge technologies and bake them in the products.
- Zeal and drive to take end to end ownership.
Python
DjangoHTML/CSS
SASSMinimum 3+ Years of hands-on experience in developing Python Applications.
Excellent knowledge of Python and experience in or in-depth understanding of core Python
Knowledge in Lists, Tuples, and Dictionaries
Excellent knowledge of Python Constructor- Parameterized and Non-Parameterized
Must have experience in core python concepts about data structure, OOPS concepts, XML parsing, XML to JSON, optimizations
Developers should have developed Web Based applications., back end, SQL
Agile and scrum methodology
Should not be test automation, Application development frame work
Excellent Communication Skill
Good to Have
Django/ Flask
Strong Hands-on experience in HTML, CSS, DTL(Django Template Language), SASS.
knowledge of SQL
Follow CutshortShubham Vishwakarma
Full Stack Developer - Averlon