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 Title : Senior Java Software Engineer
Experience : 5 to 10 Years
Location : Gurugram (Full-time)
Working Days : 5 Days (Monday to Friday)
Job Description :
- We are looking for a skilled and experienced Senior Java Software Engineer to join our dynamic team.
- The ideal candidate will have 5 to 10 Years of hands-on experience in Software Development, with a proven experience as Java Developer with a strong focus on Spring and Spring Boot, Relational Databases and AWS technologies.
- Strong understanding of monolithic & microservices architecture. You will play a crucial role in designing, developing, and maintaining our applications.
- Ensuring their performance, quality and responsiveness.
Key Responsibilities :
● Design, develop, and maintain scalable applications using Java, Spring and Spring Boot.
● Develop and manage relational databases. Should be able to write complex SQL queries.
● Ensure the best possible performance, quality, and responsiveness of the applications.
● Have strong debugging skills to identify bottlenecks and bugs, and devise solutions to mitigate and address these issues.
● Deploy, manage, and scale applications on AWS.
● Conduct code reviews and integration testing to ensure software quality and reliability.
● Collaborate with front-end developers to integrate user-facing elements with server-side logic.
● Collaborate with cross-functional teams to define, design, and ship new features.
● Stay updated with emerging technologies and industry trends.
Qualifications :
● Bachelor’s degree in Computer Science, Information Technology, or a related field.
● 5 to 10 Years of experience in Software Development.
● Proficient in Java 8+, Spring and Spring Boot.
● Experience with PostgreSQL, MySQL or other relational databases.
● Experience with microservices architecture.
● Understanding of Rest API design and development.
● Hands on experience with Unit Testing frameworks such as Junit, Mockito.
● Experience with version control systems such as Git.
● Solid understanding of object-oriented programming.
● Strong problem-solving skills and attention to detail.
● Excellent communication and teamwork skills.
Preferred Qualifications :
● Strong knowledge of AWS services and best practices.
● Knowledge of containerization technologies like Docker and Kubernetes.
● Familiarity with CI/CD pipelines and DevOps practices.
PythonHands-on experience with Spark and SQL
Good to have java knowledge
JavaPython- Drive development and delivery of top notch technology solutions to clients efficiently.
- Lead development of implementation plan, logic and modules to embed in client solutions and client discussion ready documents /presentations.
- Lead in designing, implementing, maintaining and updating applications that are often high-volume and low-latency, required for mission critical systems.
- Lead in refining and improving system stability by continuously refactoring and measuring performance.
- Drive development of actionable, clean, maintainable, testable, reusable, extensible codes, including standardization and automation of processes.
- Provide technical and functional guidance to team members through expert knowledge and hands-on support.
- Manage projects, resource utilization, time schedules and deliveries to clients.
- Proactively drive discussions with stakeholders to understand their business requirements, business context and guide team to provide robust actional solutions.
- Effectively engage with stakeholders – create and nurture and deepen relationships.
- Ensure positive & creative work-environment, culture of collaborations, speak-up, high level of energy & enthusiasm, curiosity to learn and continuous improvement.
- Inspire, engage, motivate and provide constructive feedback to team members to develop their technical & soft skills and fully support their development aspirations.
- Drive researching and conceptualizing solution approaches, new techniques or solution frameworks and author high quality discussion papers.
Qualifications, Skills and Experiences
- BE / BTech / ME / M Tech in engineering or MCA or similar relevant field.
- 2 to 17 years (Junior, Intermediate, Senior Role & we have multiple openings)of relevant hands-on experience and excellent knowledge of Java, Python, SQL, Relational Databases, DB schema or ORM technologies.
- Excellent knowledge and experience of building applications, platforms and services in Java, Python and MS SQL or at least two of them.
- 5 + years of experience of managing projects, team and stakeholders.
- Knowledge and experience of agile methodologies.
- Excellent communication and inter-personal skills.
- Experience of working in a fast-paced environment and make quality decisions in moderately to high ambiguous work environment.
- Previous work experience in financial services, especially, capital markets is preferred.
.NET
C#Responsibilities
- Develop quality software and web applications
- Analyse and maintain existing software applications
- Create and maintain SQL databases, tables, views, stored procedures etc. (Microsoft SQL Server 2008+)
- Design highly scalable, testable code
- Discover and fix programming bugs
- Monitor and maintain application security and integrity
- Communicate project status and identify technical risks
- Evaluate and recommend appropriate technologies based on product needs and industry trends
Desired Skills:
- Develop quality software and web applications
- Excellent communication and organisational skills, must be a team player
- Excellent analytical skills
- Ability to work in a fast-paced environment
- Ability to stay focused and deliver on time and on budget
- An up-to-date, working knowledge of current, past, and projected trends in the industry
- Knowledge of AI Techniques such as Neural Network Programming would be an asset
- Knowledge of Steering Behaviors Programming Techniques would be an asset
Qualifications
- Strong knowledge in .NET platform (ASP .NET) and C#
- Strong knowledge of Microsoft SQL Server 2008+ and T-SQL language
- Proficient in MS Visual Studio and TFS, including application build/deployment
- Knowledge and experience with creating and consuming web services
Educational Requirements:
Bachelor's degree diploma in computer science or software engineering
PostgreSQLDatabase Administrator Lead - PostgreSQL
ABOUT Ashnik
Established in 2009, Ashnik is a leading open-source solutions and consulting company in South East Asia and India, headquartered in Singapore. We enable digital transformation for large enterprises through our design, architecting, and solution skills. Over 100 large enterprises in the region have acknowledged our expertise in delivering solutions using key open-source technologies. Our offerings form critical part of Digital transformation, Big Data platform, Cloud and Web acceleration and IT modernization. We represent EDB, Pentaho, Docker, Couchbase, MongoDB, Elastic, NGINX, Sysdig, Redis Labs, Confluent, and HashiCorp as their key partners in the region. Our team members bring decades of experience in delivering confidence to enterprises in adopting open source software and are known for their thought leadership.
THE POSITION
Ashnik is looking for talented and passionate people to be part of the team for an upcoming project at client location.
RESPONSIBILITIES
· Monitoring database performance
· Optimizing Queries and handle escalations
· Analyse and assess the impact and risk of low to medium risk changes on high profile production databases
· Implement security features
· DR implementation and switch over
QUALIFICATION AND EXPERIENCE
· Preferably have a working experience of 4 Years and more , on production PostgreSQL DBs.
· Experience of working in a production support environment
· Engineering or Equivalent degree
· Passion for open-source technologies is desired
ADDITIONAL SKILLS
· Install & Configure PostgreSQL, Enterprise DB
· Technical capabilities PostgreSQL 9.x, 10.x, 11.x
· Server tuning
· Troubleshooting of Database issues
· Linux Shell Scripting
· Install, Configure and maintain Fail Over mechanism
· Backup - Restoration, Point in time database recovery
· A demonstrable ability to articulate and sell the benefits of modern platforms, software and technologies.
· A real passion for being curious and a continuous learner. You are someone that invests in yourself as much as you invest in your professional relationships.
LOCATION: Bangalore & Mumbai
Experience: 7 yrs plus
Package: upto 20 LPA
Python
Django
MongoDBWhat You'll Do
You will be part of our data platform & data engineering team. As part of this agile team, you will work in our cloud native environment and perform following activities to support core product development and client specific projects:
- You will develop the core engineering frameworks for an advanced self-service data analytics product.
- You will work with multiple types of data storage technologies such as relational, blobs, key-value stores, document databases and streaming data sources.
- You will work with latest technologies for data federation with MPP (Massive Parallel Processing) capabilities
- Your work will entail backend architecture to enable data modeling, data queries and API development for both back-end and front-end data interfaces.
- You will support client specific data processing needs using SQL and Python/Pyspark
- You will integrate our product with other data products through Django APIs
- You will partner with other team members in understanding the functional / non-functional business requirements, and translate them into software development tasks
- You will follow the software development best practices in ensuring that the code architecture and quality of code written by you is of high standard, as expected from an enterprise software
- You will be a proactive contributor to team and project discussions
Who you are
- Strong education track record - Bachelors or an advanced degree in Computer Science or a related engineering discipline from Indian Institute of Technology or equivalent premium institute.
- 2-3 years of experience in data queries, data processing and data modeling
- Excellent ANSI SQL skills to handle complex queries
- Excellent Python and Django programming skills.
- Strong knowledge and experience in modern and distributed data stack components such as the Spark, Hive, Airflow, Kubernetes, Docker etc.
- Experience with cloud environments (AWS, Azure) and native cloud technologies for data storage and data processing
- Experience with relational SQL and NoSQL databases, including Postgres, Blobs, MongoDB etc.
- Familiarity with ML models is highly preferred
- Experience with Big Data processing and performance optimization
- Should know how to write modular, optimized and documented code.
- Should have good knowledge around error handling.
- Experience in version control systems such as GIT
- Strong problem solving and communication skills.
- Self-starter, continuous learner.
Good to have some exposure to
- Start-up experience is highly preferred
- Exposure to any Business Intelligence (BI) tools like Tableau, Dundas, Power BI etc.
- Agile software development methodologies.
- Working in multi-functional, multi-location teams
What You'll Love About Us – Do ask us about these!
- Be an integral part of the founding team. You will work directly with the founder
- Work Life Balance. You can't do a good job if your job is all you do!
- Prepare for the Future. Academy – we are all learners; we are all teachers!
- Diversity & Inclusion. HeForShe!
- Internal Mobility. Grow with us!
- Business knowledge of multiple sectors
NodeJS (Node.js)MongoDB
Express
JavascriptBachelor's or Master's degree in Computer Science, Information Systems,
or equivalent.
EXPERIENCE – 2 to 5 years
CTC - UPTO 5.4L P.A.
JOB DESCRIPTION
We are looking for a backend developer who will be responsible for designing,
implementing, and supporting a distributed blockchain-based network. Your primary
responsibility will be analysing requirements, designing Blockchain technology around
a certain business model, and the building and launching of a blockchain network. You
will be asked to work on various blockchain technologies like Ethereum (Layer 1 & 2,
i.e Binance Smart Chain ).
● Analytical, results-driven Back-end Developer who will work with team members
to troubleshoot and improve current back-end applications and processes.
Focused on building a better, more efficient program and creating a better
end-user experience.
● Work closely with Frontend developers to integrate new web features into
our application
● Strong understanding of the web development cycle and programming
techniques and tools.
● Strong communication and presentation skills
● Ability to work in a fast-paced environment.
SKILLSET
● Experience with Smart contract development tools
● Strong background in Javascript, Python & Node JS, SQL
● Build new features and products using modern backend tools (Node.js, Mongo,
SQL, GraphQL)
● Hands-on technical exposure in implementing Blockchain technologies
(Ethereum and Hyperledger Familiarity with Hyperledger Fabric and Solidity )
Understanding of Distributed Ledger technology, Blockchain ecosystem and
structure.
● Experience working in an Agile and DevOps environment.
● Knowledge on Mining, Hashing, Elliptic Curve Cryptography(ECC) and P2P
networking Extensive experience with progression of major projects from the
planning stage through to implementation and completion Effective
communicator to all stakeholders and management during project consulting
and analysis. Strong Software development background.
● Experience on Smart contract and Solidity, development tools for Ethereum
(testrpc, geth, Web3, eth_lightwallet, etc.
● Experience in writing smart contracts.
● Good understanding of NFTs and tokens.
● Experience in wallet integration like MetaMask and Coinbase Wallet.
Experience working with decentralized application protocols like DeFi..
Working knowledge of at least one of the Blockchain frameworks such
as Hyperledger Fabric, R3 Corda, Ethereum (Solidity).
● Experience working with large code-bases.
● Proficiency in one or more of the following languages: C++, Go, Solidity,
Rust, Node.js, React.js.
● Strong knowledge of Algorithms and Data Structures.
● Familiarity with Cryptography.
● Familiarity with P2P networks
● Strong knowledge of bitcoin-like blockchains.
● Strong knowledge of concurrency and writing efficient and safe multithreaded
code
● Familiarity with code versioning tools such as Git
JavaSpring Boot- Design and develop Microservices with Java, Spring
- Communicate with the tech lead, to understand the technology thoroughly
- Perform unit and system testing
- Understand business requirements and create plans accordingly
- Work in an agile environment
- Perform threat and risk assessments
NodeJS (Node.js)MongoDBWe are looking for an experienced Back-end developer to join our IT team! As a Back-end Developer, you will be responsible for the server-side web application logic as well as for the integration of the front-end part.
- Be involved and participate in the overall application lifecycle
- Main focus on coding and debugging
- Collaborate with Front-end developers
- Define and communicate technical and design requirements
- Provide training, help and support to other team members
- Build high-quality reusable code that can be used in thew future
- Develop functional and sustainable web applications with clean codes
- Troubleshoot and debug applications
- Learn about new technologies
- Stay up to date with current best practices
- Conduct UI tests and optimize performance
- Manage cutting-edge technologies to improve applications
- Collaborate with multidisciplinary team of designers, developers and system administrators
- Follow new and emerging technologies
NodeJS (Node.js)CasaOne - CasaOne is a home furniture rental company that helps property managers, realtors, stagers and residents experience and access furniture, furnishings, decor, and equipment on demand. Our full-service offering includes a wide selection of products, affordable monthly rental plans, 3D visualizations, rent-to-own options and white-glove service in as early as 2-3 business days. www.casaone.com
BureauOne - BureauOne converts furniture into a utility for businesses. BureauOne is a furniture rental company that helps businesses experience and access furniture, fixtures, and equipment without going through the myriad challenges that are associated with buying office furniture. BureauOne offers a full-service product including white-glove storage, delivery, and installation on-site. www.bureauone.com.
We are backed by Accel Partners & other prominent investors and have offices in the SF Bay Area (HQ), LA, DC, NY, NJ,Chicago, Philadelphia, San Diego, Connecticut & Bangalore.
Our teams consist of high performing individuals who enable each other to bring their best to every concept, resulting in brands renowned in their markets for perfect insight, impeccable service & the constant ability to surprise with excellence. We onboard experts who inspire us in the way they design solutions, craft brands or simply add sense to our products & services.
We believe technology is only a tool for great engineering minds. Your understanding of core principles is of greater value to us than the tools used.
At CasaOne and BureauOne you will have an opportunity:
• to increase your rate of learning exponentially by defining hard problems and solving them
• to partake in a high-growth journey and increase revenues 5x+ Y-o-Y
• to be an early innovator in the shifting trend: ‘ownership economy’ -> ‘access economy’
• to build a category-defining platform for FF&E (Furniture, Fixture, and Equipment) leasing
• to build high-performance teams.
What you will work on:
Build a scalable API platform that will enhance our customer experience & propel our logistics. You will be part of our Bangalore
team of ambitious and talented engineers, who put their best together to build architecturally sound & scalable systems.
Requirements and Qualifications
• Bachelor’s or Master’s degree in engineering
• Good understanding of algorithms, data structures & design patterns
• A minimum of 4 years of work experience
• Building distributed systems & service-oriented architecture
• Asynchronous programming, Test Driven Development (TDD)
• Writing (delightful) APIs & integration patterns
• RDBMS & NoSql databases
• Continuous integration & deployment (CI/CD) tools like git, Jenkins
• Cloud computing platforms - AWS/ Azure/ Google Cloud
Good to know
CasaOne backend services are written in NodeJS. Experience in NodeJS is good to have, not a must. We believe technology is only a tool for great engineers. We value your understanding of core principles more than the tools used.
What happens next
You read this, you say ‘ah, that’s me, that’s what I would love to do in the near future!. Submit your resume and someone from our team will reach out to you.
CasaOne is an equal opportunity employer (EEO) & we value diversity in our teams.
Follow CutshortShubham Vishwakarma
Full Stack Developer - Averlon