
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 Details
- Job Title: SDE-3
- Industry: Technology
- Domain - Information technology (IT)
- Experience Required: 5-8 years
- Employment Type: Full Time
- Job Location: Bengaluru
- CTC Range: Best in Industry
Role & Responsibilities
As a Software Development Engineer - 3, Backend Engineer at company, you will play a critical role in architecting, designing, and delivering robust backend systems that power our platform. You will lead by example, driving technical excellence and mentoring peers while solving complex engineering problems. This position offers the opportunity to work with a highly motivated team in a fast-paced and innovative environment.
Key Responsibilities:
Technical Leadership-
- Design and develop highly scalable, fault-tolerant, and maintainable backend systems using Java and related frameworks.
- Provide technical guidance and mentorship to junior developers, fostering a culture of learning and growth.
- Review code and ensure adherence to best practices, coding standards, and security guidelines.
System Architecture and Design-
- Collaborate with cross-functional teams, including product managers and frontend engineers, to translate business requirements into efficient technical solutions.
- Own the architecture of core modules and contribute to overall platform scalability and reliability.
- Advocate for and implement microservices architecture, ensuring modularity and reusability.
Problem Solving and Optimization-
- Analyze and resolve complex system issues, ensuring high availability and performance of the platform.
- Optimize database queries and design scalable data storage solutions.
- Implement robust logging, monitoring, and alerting systems to proactively identify and mitigate issues.
Innovation and Continuous Improvement-
- Stay updated on emerging backend technologies and incorporate relevant advancements into our systems.
- Identify and drive initiatives to improve codebase quality, deployment processes, and team productivity.
- Contribute to an advocate for a DevOps culture, supporting CI/CD pipelines and automated testing.
Collaboration and Communication-
- Act as a liaison between the backend team and other technical and non-technical teams, ensuring smooth communication and alignment.
- Document system designs, APIs, and workflows to maintain clarity and knowledge transfer across the team.
Ideal Candidate
- Strong Java Backend Engineer.
- Must have 5+ years of backend development with strong focus on Java (Spring / Spring Boot)
- Must have been SDE-2 for at least 2.5 years
- Hands-on experience with RESTful APIs and microservices architecture
- Strong understanding of distributed systems, multithreading, and async programming
- Experience with relational and NoSQL databases
- Exposure to Kafka/RabbitMQ and Redis/Memcached
- Experience with AWS / GCP / Azure, Docker, and Kubernetes
- Familiar with CI/CD pipelines and modern DevOps practices
- Product companies (B2B SAAS preferred)
- have stayed for at least 2 years with each of the previous companies
- (Education): B.Tech in computer science from Tier 1, Tier 2 colleges
Oracle Functional
Job Description
Oracle EBS Techno Function with 4+ years' of experience
Excellent functional knowledge of Financial modules (Specially GL, FA)
Expertise in Oracle EBS Financial, Project, Purchasing module
Able to understand the accounting concepts
Few technical skills like PLSQL, personalization, XML reports
Worked on Oracle EBS 12.2+ implementation and support
Qualifications
Graduate specially with accounts
Additional information
Excellent verbal and written communication skills.
Good to have Winform experience
Looking for Immediate joiners.
- Experience in designing & developing systems/software for large business environments (Java, J2EE).
- Strong design and coding skills in Enterprise Java, REST & SOAP web services, ORM (JPA/Hibernate), Spring, Maven, JMS (ActiveMQ), Caching, XML, JSON.
- Experience with multiple integration technologies / frameworks.
- Must have good experience in Unix/Oracle/SQL.
- Experience in Agile Development, Scrum, and Iterative approaches.
- Experience and exposure to AWS Cloud Services and DevOps mindset and expertise is a plus Experience with Mule or any ESB (Enterprise Service Bus) is a plus.
Be a part of IOT Product portfolio and execute towards Digital Transformational initiatives.
Prepare design documents in collaboration with product managers and engineering squads
in development of use cases for new features.
Hands on product lead developer expertise in designing solutions running on hybrid cloud
environments.
Work as a Software Lead in application development using Java, JavaScript, Python, SQL and
other latest technologies running on AWS environments.
Drive Engineering activities in Microservices and Cloud based Architecture by leveraging
DevOps efficiencies and adopting new technology stack in AWS.
Drive communication and consistently report accurate product status for stakeholders
Able to lead a team of engineers, help them with technical issues. (80% self-work and 20%
influencing scrum engineers).
Balance time on development projects including Technical Design, Code Reviews, Mentoring,
and training. Able to break down requirements and build traceability in design and
implementation details.
Work with developers to define unit & automated tests and closely monitor development
milestones. Collaborate with scrum team to identify functional, system and end to end
integration of products leading to deployment.
Understand end to end flow in product development and able to prepare design documents
and present to Engineering and Product Leadership team.
Full stack product development experience.
Skills Required :
Bachelor’s/Master’s degree equivalent with strong knowledge methodology and tools.
8+ years working Experience in designing data, keyword driven or hybrid strategies; Ability
to troubleshoot and think out of the box
Experience in CICD pipeline configuration, creation, and maintenance – from build to deploy
to integration.
Experience in writing clear, concise and comprehensive design documents covering
functional and non-functional requirements.
Hands-on experience in large enterprise development in a multi-cloud environment.
Strong expertise over Java, Python language, Databases, experience in web Frameworks like
Django required for backend development.
Experience of working in AWS (S3, Lambda, RDS, Security, ILM and AWS Services).
Experience with Docker and Kubernetes for Container Management and Orchestration by
setting CI/CD Pipelines using Jenkins / Ansible.
Experience with API (REST/SOAP). Experienced in PowerBI, RDBMS, DB Architecture design
and good control over SQL queries.
Experience with any NoSQL Database, Caching and Messaging is a plus. Experience with
Messaging Tool and Caching Frameworks
Strong Understanding of fundamental concepts: Data Structures, Algorithms, OOPs
concepts, Design patterns and Architectures. Experience with Agile programming techniques
such as test-driven development. Design applications to optimize for performance and
usability.

Senior .NET Cloud (Azure) Practitioner
Job Description Experience: 5-12 years (approx.)
Education: B-Tech/MCA
Mandatory Skills
- Strong Restful API, Micro-services development experience using ASP.NET CORE Web APIs (C#);
- Must have exceptionally good software design and programming skills in .Net Core (.NET 3.X, .NET 6) Platform, C#, ASP.net MVC, ASP.net Web API (RESTful), Entity Framework & LINQ
- Good working knowledge on Azure Functions, Docker, and containers
- Expertise in Microsoft Azure Platform - Azure Functions, Application Gateway, API Management, Redis Cache, App Services, Azure Kubernetes, CosmosDB, Azure Search, Azure Service Bus, Function Apps, Azure Storage Accounts, Azure KeyVault, Azure Log Analytics, Azure Active Directory, Application Insights, Azure SQL Database, Azure IoT, Azure Event Hubs, Azure Data Factory, Virtual Networks and networking.
- Strong SQL Server expertise and familiarity with Azure Cosmos DB, Azure (Blob, Table, queue) storage, Azure SQL etc
- Experienced in Test-Driven Development, unit testing libraries, testing frameworks.
- Good knowledge of Object Oriented programming, including Design Patterns
- Cloud Architecture - Technical knowledge and implementation experience using common cloud architecture, enabling components, and deployment platforms.
- Excellent written and oral communication skills, along with the proven ability to work as a team with other disciplines outside of engineering are a must
- Solid analytical, problem-solving and troubleshooting skills
Desirable Skills:
- Certified Azure Solution Architect Expert
- https://ind01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fcloudacademy.com%2Flearning-paths%2Faz-900-exam-preparation-microsoft-azure-fundamentals-524%2F&data=05%7C01%7C%7Ce2e481ab8ccc4c589ba408dad36c9f29%7Ce9cb3c8041564c39a7fe68fe427a3d46%7C1%7C0%7C638054760717910671%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=TmO1fonUFFgb8LzUJHbL8IyOdQeUKdw6xHMM2asosiw%3D&reserved=0" target="_blank">Microsoft Certified: Azure – Fundamentals Exam AZ-900
- https://ind01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fcloudacademy.com%2Flearning-paths%2Faz-104-exam-preparation-microsoft-azure-administrator-1-1332%2F&data=05%7C01%7C%7Ce2e481ab8ccc4c589ba408dad36c9f29%7Ce9cb3c8041564c39a7fe68fe427a3d46%7C1%7C0%7C638054760718066923%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=EQPg%2FXxTdiYUCKCAvItXy6TY89udGTIehQ0m9irkGRk%3D&reserved=0" target="_blank">Microsoft Certified: Azure Administrator – Associate Exam AZ-104
- https://ind01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fcloudacademy.com%2Flearning-paths%2Faz-204-exam-preparation-developing-solutions-for-microsoft-azure-1208%2F&data=05%7C01%7C%7Ce2e481ab8ccc4c589ba408dad36c9f29%7Ce9cb3c8041564c39a7fe68fe427a3d46%7C1%7C0%7C638054760718066923%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=%2BnosXa4TdBUG4jrqP%2B0%2FOikDbQMBNqzuDpvGoUk0IE8%3D&reserved=0" target="_blank">Microsoft Certified: Azure Developer – Associate Exam AZ-204
- https://ind01.safelinks.protection.outlook.com/?url=https%3A%2F%2Facloudguru.com%2Fblog%2Fengineering%2Fwhich-azure-certification-is-right-for-me%23devops-engineer&data=05%7C01%7C%7Ce2e481ab8ccc4c589ba408dad36c9f29%7Ce9cb3c8041564c39a7fe68fe427a3d46%7C1%7C0%7C638054760718066923%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=NZyP%2F3Euh1SkHfB7896ovm0HDt0vA8UgfHUvTBN4SPM%3D&reserved=0" target="_blank">Microsoft Certified: DevOps Engineer Expert (AZ-400)
- https://ind01.safelinks.protection.outlook.com/?url=https%3A%2F%2Facloudguru.com%2Fblog%2Fengineering%2Fwhich-azure-certification-is-right-for-me%23solutions-architect&data=05%7C01%7C%7Ce2e481ab8ccc4c589ba408dad36c9f29%7Ce9cb3c8041564c39a7fe68fe427a3d46%7C1%7C0%7C638054760718066923%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=0infaLzjjPThGGkzwu50jJXikppcC8trnsLGtAoB7S4%3D&reserved=0" target="_blank">Microsoft Certified: Azure Solutions Architect Expert (AZ-305)
- Good understanding of software architecture, scalability, resilience, performance;
- Working knowledge of automation tools such as Azure DevOps, Azure Pipeline or Jenkins or similar
Roles & Responsibilities
- Defining best practices & standards for usage of libraries, frameworks and other tools being used;
- Architecture, design, and implementation of software from development, delivery, and releases.
- Breakdown complex requirements into independent architectural components, modules, tasks and strategies and collaborate with peer leadership through the full software development lifecycle to deliver top quality, on time and within budget.
- Demonstrate excellent communications with stakeholders regarding delivery goals, objectives, deliverables, plans and status throughout the software development lifecycle.
- Should be able to work with various stakeholders (Architects/Product Owners/Leadership) as well as team - Lead/ Principal/ Individual Contributor for Web UI/ Front End Development;
- Should be able to work in an agile, dynamic team environment;
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
standing of Java and the different frameworks like Spring, etc., and have experience working on Cloud and Containers.
The Developer will perform duties and tasks to support a complete life cycle management (example: Analysis, Technical
Requirements, Design, Coding, Testing and implementation of Systems, etc.).
The Developer will work closely with the Product and Technical teams across different regions primarily Europe and will
be part of an Agile Team. The role includes research and Continuous Development of new Products based on new Tech-
nologies. This position collaborates with the operations team routinely and henceforth excellent English communication
skills (bothwritten and verbal) are essential.
A clean coder who will always leave the code in better shape than they found it.
A curious person who never stops learning and loves to try new things, even when theydon’t succeed on the
first try
A team-oriented developer with the motivation to bring out the best in others
A person who shares our appreciation for transparency and is willing to share theirexperience and knowledge
for the benefit of the team
Someone who is willing to take a stand for something they believe in.
Somebody that takes pride in their work and knows that development is a craftsmanship
Duties & Responsibilities
Conducts systems and requirements analysis, creates and contributes to task lists, cost and time analysis
Performs assigned functions and tasks to meet project plan and quality review requirements.
Raises issues as appropriate to support effective resolutions.
Analyzes specifications and user requirements to perform assigned applications development work.
Assists with system and componentdesigns to meet requirements.
Participates and documents design and code reviews to improve quality.
Analyzes, designs, codes, tests, and documents to develop application software.
Develops unit tests and unit test plans to deliver quality code.
Performs applications maintenance and support functions to support problem resolution.
Qualifications:
• Bachelor’s degree in Computer Science or IT related field
• 4-7 years of experience working across different product domains in a product development/engineering role
• Good communication skills necessary to manage business requests and work with different teams across differ-
ent geographies and time-zones; experience working with remote and distributed teams will be an added ad-
vantage
• Hands-on working knowledge and experience is requiredin:
a. Java (Spring, Spring Boot, etc.)
b. Experience working in GCP or AWS or Azure
c. Experience working in Containers & Unix Platforms
d. Relational Databases (PostgreSQL, MySQL, SQL, etc.)
e. Messaging (RabbitMQ, ActiveMQ, Kafka etc.)
f. Agile Methodologies (Scrum, TDD, BDD, etc.)
g. Understanding of Microservices Architecture, Domain Driver Design, Test Driven Development and
Secure Design patterns and architecture is a must
h. Data Structures and Algorithms using Java or other Programing Languages
i. Strong organizational skills
j. Agile Methodologies (Scrum, TDD, BDD, etc.)
• Experience with several of the following tools/technologies is desirable:
a. GIT (Bit Bucket, Gitlab, etc.), Jira, Gradle, Maven, Jenkins, SharePoint, Eclipse/IntelliJ.
b. Multiple Java technologies around Spring, Spring Bootetc.
c. Design Patterns and implementing the Design Patterns
d. Development of Complex Application and System Architectures
e. NoSQL Databases (Redis, Mongo, etc.)
f. Experience working with CI/CD pipelines with for example GitHub Actions.
• Knowledge of the following technologies is a plus:
a. Other Programming Languages (NodeJS, etc.)
b. Continuous Integration and Continuous Delivery Tools like Jenkins, Git, etc.
c. Application Servers like Tomcat, etc.
d. HTML5, CSS, AJAX, React
e. Full stack development
f. Secure Development based on OWASP standards
Job Description-
Backend Developer- Senior
Experience - 3-6 years
Location: Pune/Kota
Minimum Qualifications:
- BE/B.Tech or ME/M.Tech in Computer Science.
- Must have “Can Do Attitude” towards work
- Must have work exp of 3-6 years
- Must have programming exp of 1-2 years in any of Python/Golang/Java languages
- Must have worked in product based company
- Ready to work in a startup and adaptable to a dynamic environment
- Ready to accept ad-hoc requirements and track them till they get implemented
- Ready to learn new technologies like Andriod, Angular, etc.
- Good at HTTP basics, OOPs concepts, data structures, algorithms, networking and
security aspects
- Ability to write clean code and maintain it
- Good at SQL/No-SQL databases
Preferred Qualifications:
- Experience in any good product based startup
- Experience in working with the team and managing a small team of 2-5 associates
- Experience in being a mentor for co-developers
- Experience in design/developing scalable systems.
- Experience in public cloud platforms services/APIs of AWS, Google Cloud, etc.
- Experience in data engineering
- Experience in SOA/Microservice architecture development
Responsibilities:
- Design and develop scalable services and APIs in Python/Golang
- Always maintain the services secure
- Should optimize APIs for mobile data and apps
- Use off-the-shelf and state-of-the-art services for faster development of product
- Guide team members with designs
- Take the end to end ownership of features and resolve customer issues on priority
- Mentor/guide/monitor junior developer
- Expertise Android/Angular to the required extent and guide app developers while
designing APIs
Opportunities in the role:
- LearnAngular, Python, Node.js, Golang, ELK stack, MEAN/MERN
- Work on AWS, Azure, Google Cloud Platform
- Work on databases like RDS, MongoDB, Big Table & DynamoDB, Redis, Aerospike
- Experience with SQL/ NoSQL Databases (RDS, DynamoDB, Google Datastore, Redis)
- Experience with ELK stack.
- Fast prototyping of proof-of concept features/application based on a brief
- Work on data engineering







