
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
• 3+ years of hands-on experience developing and testing highly scalable software.
• Excellent coding skills in Java 17 or above.
• Very good understanding of any RDBMS and/or messaging queues
• Proficient in Core java, Solid foundation in object-oriented development and design patterns.
• Excellent problem-solving skills and attention to detail.
• Ability to engineer complex features/systems from scratch and drive it to completion.
• Good knowledge of multiple data storage systems.
• Prior experience in micro services and event driven architecture.
• Experience with Spring boot and Spring Security Framework
• Spring web-flux understanding is desirable
• Understand OWASP Top 10/CWE, DAST and SAST
Java Developer – Job Description
Wissen Technology is now hiring for a 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. - 5 to 12 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. About Wissen Technology: Wissen Technology is a niche global consulting and solutions company that brings unparalleled domain expertise in Banking and Finance, Telecom and Startups. Wissen Technology is a part of Wissen Group and was established in the year 2015. Wissen has offices in the US, India, UK, Australia, Mexico, and Canada, with best-in-class infrastructure and development facilities. Wissen has successfully delivered projects worth $1 Billion for more than 25 of the Fortune 500 companies. The Wissen Group overall includes more than 4000 highly skilled professionals. Wissen Technology provides exceptional value in mission critical projects for its clients, through thought leadership, ownership, and assured on-time deliveries that are always ‘first time right’. Our team consists of 1200+ highly skilled professionals, with leadership and senior management executives who have graduated from Ivy League Universities like Wharton, MIT, IITs, IIMs, and NITs and with rich work experience in some of the biggest companies in the world. Wissen Technology offers an array of services including Application Development, Artificial Intelligence & Machine Learning, Big Data & Analytics, Visualization & Business Intelligence, Robotic Process Automation, Cloud, Mobility, Agile & DevOps, Quality Assurance & Test Automation. We have been certified as a Great Place to Work® for two consecutive years (2020-2022) and voted as the Top 20 AI/ML vendor by CIO Insider.
Java Developer – Job Description Wissen Technology is now hiring for a 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. - 4 to 7 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. About Wissen Technology: Wissen Technology is a niche global consulting and solutions company that brings unparalleled domain expertise in Banking and Finance, Telecom and Startups. Wissen Technology is a part of Wissen Group and was established in the year 2015. Wissen has offices in the US, India, UK, Australia, Mexico, and Canada, with best-in-class infrastructure and development facilities. Wissen has successfully delivered projects worth $1 Billion for more than 25 of the Fortune 500 companies. The Wissen Group overall includes more than 4000 highly skilled professionals. Wissen Technology provides exceptional value in mission critical projects for its clients, through thought leadership, ownership, and assured on-time deliveries that are always ‘first time right’. Our team consists of 1200+ highly skilled professionals, with leadership and senior management executives who have graduated from Ivy League Universities like Wharton, MIT, IITs, IIMs, and NITs and with rich work experience in some of the biggest companies in the world. Wissen Technology offers an array of services including Application Development, Artificial Intelligence & Machine Learning, Big Data & Analytics, Visualization & Business Intelligence, Robotic Process Automation, Cloud, Mobility, Agile & DevOps, Quality Assurance & Test Automation. We have been certified as a Great Place to Work® for two consecutive years (2020-2022) and voted as the Top 20 AI/ML vendor by CIO Insider.
Profile: AWS Data Engineer
Mode- Hybrid
Experience- 5+7 years
Locations - Bengaluru, Pune, Chennai, Mumbai, Gurugram
Roles and Responsibilities
- Design and maintain ETL pipelines using AWS Glue and Python/PySpark
- Optimize SQL queries for Redshift and Athena
- Develop Lambda functions for serverless data processing
- Configure AWS DMS for database migration and replication
- Implement infrastructure as code with CloudFormation
- Build optimized data models for performance
- Manage RDS databases and AWS service integrations
- Troubleshoot and improve data processing efficiency
- Gather requirements from business stakeholders
- Implement data quality checks and validation
- Document data pipelines and architecture
- Monitor workflows and implement alerting
- Keep current with AWS services and best practices
Required Technical Expertise:
- Python/PySpark for data processing
- AWS Glue for ETL operations
- Redshift and Athena for data querying
- AWS Lambda and serverless architecture
- AWS DMS and RDS management
- CloudFormation for infrastructure
- SQL optimization and performance tuning
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.
Job Title: Odoo Developer
Job Summary:
We are seeking an experienced Odoo Developer to join our dynamic team. The ideal candidate will be responsible for customizing, developing, and implementing Odoo ERP solutions. You will work closely with clients to understand their business needs and create tailored solutions to enhance business processes and improve efficiency.
Key Responsibilities:
- Odoo Customization & Development: Customize and develop Odoo modules based on client requirements.
- Module Creation: Design, implement, and maintain custom Odoo modules for various business functions (e.g., sales, inventory, accounting).
- Integration: Integrate Odoo with third-party applications and external systems through APIs.
- Database Management: Manage and optimize PostgreSQL databases associated with Odoo.
- Bug Fixing & Troubleshooting: Identify, diagnose, and resolve issues in Odoo systems to ensure smooth operations.
- Odoo Upgrades: Perform Odoo version upgrades and ensure compatibility of modules across different versions.
- User Support: Provide technical support to users and assist in troubleshooting issues.
- Documentation: Maintain proper documentation of all customizations and development work.
- Collaboration: Work closely with project managers, business analysts, and clients to deliver the best solutions.
Skills & Qualifications:
- Strong proficiency in Python and experience with the Odoo framework.
- Experience in developing and customizing Odoo modules and reports (Qweb).
- Solid understanding of SQL, PostgreSQL, and database management.
- Knowledge of JavaScript, XML, HTML, and CSS for front-end customization.
- Familiarity with API integration and third-party system integration.
- Strong problem-solving and debugging skills.
- Experience with version control systems like Git.
- Ability to work on multiple projects and meet deadlines in a fast-paced environment.
- Good communication skills and ability to collaborate with clients and team members.
- Bachelor’s degree in Computer Science, Information Technology, or a related field (or equivalent experience).
Preferred Skills:
- Experience in Odoo eCommerce and Odoo Studio.
- Knowledge of project management methodologies (e.g., Agile).
- Familiarity with Odoo security best practices and performance optimization.
Why Join Us?
- Opportunity to work on exciting Odoo projects across different industries.
- Collaborative and supportive work environment.
- Competitive salary and benefits.
Technical Experience :
- Net development work experience.
- Proficiency in NET Development with Asp.net and MVC.
- Strong object-oriented programming OOPS design skills, SOLID principles and proficiency in software design patterns.
- Experience in database MS SQL Server.
- Experience with version control systems GitHub and Bitbucket.
Professional Attributes :
1. Should have good communication Skills.
2. Should be a good team player.
3. Should be able to work independently and under pressure.
4. Should have good logical and analytical thinking.
About Us:
Developed in formal collaboration with the University of Cambridge in May 2000, HeyMath! is an Ed-Tech company whose mission is to Raise the Game in Maths for school systems around the world. We do this using technology to deliver engaging teaching methodologies and personalised learning paths for students. HeyMath! has been successfully adopted by CBSE schools since 2004, with positive outcomes for the entire ecosystem.
Check us out at www.heymath.com
We plan to work mainly from home in 2022 and the virtual office atmosphere is collegiate, informal and friendly, with small high-impact teams making a difference to customers.
What we are looking for:
Experience in building and re-engineering cloud based solutions on AWS.
Strong knowledge of Object Oriented Programming(OOPS) and design patterns is a must. Hands-on development on Spring MVC framework.
Experience working on Java 8 or above.
Must have very good knowledge of RDBMS such as MySQL and performance tuning of the same.
Exposure to server-side and client-side caching mechanisms. Ability to debug the applications and provide instant workable solutions.
Experience working on Elastic Search / Kafka / Kubernetes or all is a nice to have.
The candidate will be responsible for working on .NET based projects for our clients in USA. The candidate must be self-motivated and quick learner. The candidate should also be able to communicate with the client on a regular basis and gather requirements from the client, provide updates. The work would be in ASP.NET / VB.NET and C# with SQL Server databases. The candidate will be responsible for maintaining existing web applications as well as implement new applications based on client requirements.
Required Experience, Skills and Qualifications
- Must have 3+ years experience in ASP.Net with C# and VB.NET
- Must have at least 2 years experience in SQL Server
- Must have experience working with SOAP and REST Web Services
- Must have experience with SSRS and SSIS
- Must have some experience with MVC framework and Angular JS
- Must be able to work with basic CSS and HTML
- Must be able to work with jQuery and Javascript
- Experience with Reporting Services, WCF, etc would be a strong positive
Ecperience- Minimum 3 years
Location - Ahmedabad










