
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
Role Overview
We are looking for a Saviynt-focused IAM professional at an architecture/engineering level with deep expertise in Identity Governance and Administration (IGA). The candidate will drive end-to-end Saviynt solution design, implementation, and optimization, ensuring scalable, secure, and compliant identity ecosystems across enterprise environments.
Key Responsibilities
- Saviynt Architecture & Platform Engineering:
- Design and implement scalable Saviynt architecture, including tenant setup, data model design, and performance optimization
- Develop and manage advanced rules, workflows, and business logic within Saviynt
- Drive platform customization, plugin development, and REST/API-based integrations
- IGA Solution Design:
- Architect and implement end-to-end IGA solutions including Access Request System (ARS), SoD (Segregation of Duties), and Certification/Recertification frameworks
- Define RBAC models, entitlement governance strategies, and lifecycle management processes
- Identity Integration & Ecosystem:
- Lead integrations with enterprise applications, directories, and cloud platforms using connectors, APIs, and event-driven mechanisms
- Work closely with cross-functional teams to enable application onboarding and automated provisioning
- AD / Azure AD / Multi-Tenant Expertise:
- Architect identity models across Active Directory (AD) and Azure Active Directory (AAD) environments
- Design group structures, OU strategies, and identity lifecycle flows
- Leverage Multi-Tenant Organization (MTO) capabilities for cross-tenant identity governance
- Governance, Risk & Compliance:
- Implement and optimize SoD policies, access certifications, and audit controls
- Ensure compliance with security standards and regulatory frameworks
- Automation & Optimization:
- Enhance self-service capabilities, workflow automation, and access request efficiencies
- Continuously improve performance, scalability, and operational stability of the Saviynt platform
- Code Quality & Delivery Excellence:
- Maintain high-quality code standards, documentation, and deployment practices
- Support production environments, troubleshoot issues, and ensure platform reliability
Required Skills & Experience
- 8+ years of hands-on experience in Saviynt IGA implementation and engineering
- Strong expertise in: Saviynt EIC platform architecture & configuration; ARS, SoD, Recertification, RBAC; REST APIs, JSON, SQL, and scripting
- Deep understanding of: Active Directory (AD) & Azure AD (AAD); Identity lifecycle management & provisioning workflows
- Experience in enterprise integrations and large-scale deployments
- Exposure to Multi-Tenant Organization (MTO) is a strong plus
Good to Have
- Experience with other IAM tools (e.g., SailPoint, Okta)
- Knowledge of cloud platforms (Azure, AWS)
- Understanding of security frameworks (ISO, SOX, GDPR)
- 5+ years of experience
- FlaskAPI, RestAPI development experience
- Proficiency in Python programming.
- Basic knowledge of front-end development.
- Basic knowledge of Data manipulation and analysis libraries
- Code versioning and collaboration. (Git)
- Knowledge for Libraries for extracting data from websites.
- Knowledge of SQL and NoSQL databases
- Familiarity with RESTful APIs
- Familiarity with Cloud (Azure /AWS) technologies
What We’re Looking For:
- Strong experience in Python (5+ years).
- Hands-on experience with any database (SQL or NoSQL).
- Experience with frameworks like Flask, FastAPI, or Django.
- Knowledge of ORMs, API development, and unit testing.
- Familiarity with Git and Agile methodologies.
- Familiarity with the Kafka tool (Added Advantage)
Hiring For SDE II - Python (Remote)
The Impact you will create:
-
Build campaign generation services which can send app notifications at a speed of 10 million a minute
-
Dashboards to show Real time key performance indicators to clients
-
Develop complex user segmentation engines which creates segments on Terabytes of data within few seconds
-
Building highly available & horizontally scalable platform services for ever growing data
-
Use cloud based services like AWS Lambda for blazing fast throughput & auto scalability
-
Work on complex analytics on terabytes of data like building Cohorts, Funnels, User path analysis, Recency Frequency & Monetary analysis at blazing speed
-
You will build backend services and APIs to create scalable engineering systems.
-
As an individual contributor, you will tackle some of our broadest technical challenges that requires deep technical knowledge, hands-on software development and seamless collaboration with all functions.
-
You will envision and develop features that are highly reliable and fault tolerant to deliver a superior customer experience.
-
Collaborating various highly-functional teams in the company to meet deliverables throughout the software development lifecycle.
-
Identify and improvise areas of improvement through data insights and research.
Primary Responsibilities
-
End-to-end ownership of product development, from design, through implementation, testing, deployment, and maintenance
-
Translating high-level requirements and end-user use cases into design proposals, decomposing complex features into smaller, short-term deliverable tasks
-
Maintaining constant focus on scalability, performance and robustness of architecture
-
Designing and implementing logging, monitoring and alerting systems for existing and new infrastructure
-
Documenting API's and architecture design
-
Mentor and guide juniors on their path to become solid developers
What we look for?
-
4+ of industry experience in technical leadership roles
-
Solid knowledge of Python, SQL, NoSQL, shell scripting and Linux operating environment
-
End-to-end experience in design and development of highly scalable enterprise and cloud data products
-
Ability to challenge and redefine existing architecture to create robust, scalable and reliable products
-
Hands-on experience with design and troubleshooting of scalable web services, queue based systems, distributed databases and streaming services
-
Experience with modern DevOps technologies such as kOps, Kubernetes and Docker, CI/CD, monitoring and autoscaling
- Deployment and production support.
- Strong knowledge of SQL database and experience in writing queries with and without ORM.
- Designing and creating RESTful APIs for internal and partner consumption
- Experience of code versioning tools, such as Git, Bitbucket, Github
About Beyondskool:
BeyondSkool aims to be the No.1 destination for BeyondSkool courses for kids aged 4-15yrs by building knowledge and skills in areas that are not typically covered by school to constantly expand learning and stay ahead. We do this through our programs, which are designed by experts covering both breadth and depth of expertise, delivered by certified and trained teachers through LIVE online classes on our engaging and interactive platform. Mission of BeyondSkool is that just like a school, to build a community of highly motivated BeyondSkoolers who have an infinite hunger of learning, which goes beyond school curriculum for continuously expanding knowledge and skills to excel and stay ahead.
Founded by experienced professionals and alumni of prestigious institutes namely Kellogg and MDI with 20+ years of experience in various industries handling leadership roles across business functions. We are at a stage of hiring our core team members who are young, passionate individuals with keen interest in making a difference in the education sector.
Role and Responsibilities
- Research, design and build highly reliable, available, and scalable platforms.
- Explore design implications and work towards an appropriate balance between functionality, performance, and maintainability.
- Lead by example, mentor, and guide team members on everything from structured problem solving to development of best practices.
- Own large technical deliverables and execute in an exemplary way
- Be able to conceptualize and develop prototype quickly
- Working with a cross-discipline team (Design, Product, Engineer, Operations, Sales, Marketing).
- Active participation in the hiring process to bring quality engineers in the team.
- Lead-out team meetings, stand-ups, and architecture/design discussions
- Writing bug-free code, participating in code reviews, designing/architecting systems of varying complexity and scope, and creating high-quality documentation supporting the design/coding tasks
- Identify areas of improvement in our frameworks, tools, processes and strive to make them better.
- Researching new technologies and adapting them to BeyondSkool’s requirements
- Own and commit to all your work, and be accountable for your results
- Using and understanding code from Open-Source projects
- Participate in a culture of code reviews, writing tech specs, and collaborating closely with other people
- Produce highly reliable systems that are thoroughly tested and benchmarked.
- Develop multi-tier scalable, high-volume performing, and reliable user-centric infrastructure that operates 24x7
- Scale distributed applications, make architectural trade-offs applying synchronous and asynchronous design patterns, and deliver with speediness and quality.
Qualifications and Education Requirements
- Bachelor's degree in Computer Science or any other relevant field.
- Experience of 5 - 7 years as a back-end engineer preferably in a microservice environment.
- Strong proficiency of Node.js and frameworks available for it such as Express.js
- Strong proficiency in Javascript and TypeScript
Preferred Skills
- Must have worked building 2+ backend system using node.js and Express.js
- Strong understanding and experience of creating highly scalable and complex database design.
- Good understanding of Data Modeling using RDBMS and NoSQL (Cassandra, MongoDB, ElasticSearch, Redis) data stores
- Strong problem-solving skills with a good understanding of data structures and algorithms
- Strong understanding of front-end technologies, such as HTML5, and CSS3
- User authentication and authorization between multiple systems, servers, and environments
- Experience of creating highly scalable, fault tolerant, resilient distributed systems
- Strong knowledge of creating scalable system design and good understanding of microservice based architectures
- Understanding of caching enabled, PubSub and event driven architectures
- Hands on experience and good knowledge of AWS services
- Understanding automated testing platforms like selenium and unit tests like Chai, Mocha, Jasmine etc
- Proficient understanding of code versioning tools, such as Git
- Curiosity to explore the cutting-edge technologies and bake them in the products.
- Zeal and drive to take end to end ownership.
Node JS Developer
Position Type: Full time
Job Description:
We are looking for a Node.js Developer responsible for managing the interchange of data between the server and the users. Primary focus will be the development of all server-side logic, definition and maintenance of the databases, and ensuring high performance and responsiveness to requests from the front-end. Will also be responsible for integrating the front-end elements built by the UI team into the application. Therefore, a basic understanding of front-end technologies is a bonus.
Responsibilities:
- Integration of user-facing elements developed by front-end developers with server-side logic
- Writing reusable, testable, and efficient code
- Design and implementation of low-latency, high-availability, and performant applications
- Implementation of security and data protection
- Integration of data storage solutions
Skills and Qualifications:
- Strong proficiency with JavaScript
- Knowledge of Node.js and frameworks available for it such as Express
- Understanding the nature of asynchronous programming and its quirks and workarounds
- Basic understanding of front-end technologies, such as HTML5, and CSS3
- Understanding security compliance
- User authentication and authorization between multiple systems, servers, and environments
- Integration of multiple data sources and databases into one system
- Understanding fundamental design principles behind a scalable application
- Understanding of Relational Databases
- Creating database schemas that represent and support business processes
- Implementing automated testing platforms and unit tests
- Proficient understanding of code versioning tools, such as Git
- 8-15 years relevant progressive experience.
Are you passionate in coding and blockchain? Do you wish to face challenges ahead, develop and deliver features that will be extraordinary towards users? We are looking for experienced talents (React JS / Node JS / MongoDB / Web3.js / Solidity developers) to join our team and start a revolution!
Key Responsibilities and Scope
- Framework development and integration
- Prototype and Proof of concept development
- Creation, configuration, and monitoring Shards sets. Architecture and capacity planning for MongoDB clusters.
- Assisting senior developers in detecting performance issues in the system by deploying MMS and MongoDB profilers
- Implementation of MongoDB advanced concepts like locking, transactions, indexes, Sharding, replication, schema design.
- Maintain MongoDB replication with replica set factors, arbiters, voting, priority, server distribution, slave delays.
Technical Skills
- Database & Languages: MongoDB, B-tree, MongoDB Profiler, Javascript, MongoDB Compass, Mongo Booster
- Others: Elastic Stack, MMS, MongoDB Management service
Qualifications and Experience location GMT+8 or GMT+5:30
- Ability to work remotely or on-site (if Malaysia)
- Executing elastic stack in production scale Passion for best design, developing, and coding practices
- Creating servers and databases for functionality
- Maximizing application performance, uptime, and scalability, maintaining high standards of code quality and thoughtful application design
- Excellent debugging and optimization skills
- Unit/integration testing experience
- Experience in analyzing and visualizing the data along with data modeling
- Experience in upgrading different databases and also migration of data among multiple databases.
- Experience in MongoDB installation, patching, troubleshooting, performance, tracking/tuning, backup, and recovery in dynamic environments.
- Experience in managing the life cycle of MongoDB including sizing, automation, monitoring, and tuning
- Experience in working with MongoDB ops Manager, Cloud Manager, and Atlas Manager
- Experience in analyzing chunk migrations, splitting, and balancing across the clusters.
Product Development
At E2open, you will be an integral member of a dynamic organization, working on cutting-edge technology that transforms the way companies do business with their trading partners in complex, multi-tier supply chains. Currently, E2open is seeking an energetic Application Engineer to join our Research & Development Group. This position involves the development of leading-edge Software-as-a-Service (SaaS) supply chain management applications that drive complex multi-company supply chain management dashboards, workflows, and business-to-business supply chain data interchanges.
Technical Requirements
- Strong experience in Core Java 8 and above, Collections and Data structures.
- Develop solutions using core java, Spring / Spring Boot, JSON, Rest API and other web technologies.
- Ability to design and develop UIs like Javascript, HTML5, Angular and end to end integration.
- Object oriented analysis and design using common design patterns.
- Enforcing and Writing code following good standards (well documented with good code coverage and properly tested code).
- Excellent knowledge of Relational Databases, SQL and ORM technologies (Hibernate and Mybatis). Ability to model & design databases for high availability and high volume.








