Sr Database Developer at NovacisDigital · Chennai · 3 - 8 years · ₹5L - ₹16L / yr · Bootstrapped · Posted 1 Sep 2026

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 (10)
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
Required Core Tech Stack:
We're looking for engineers with hands-on experience across most of the following technologies:
- Python Backend Development (3+ years)
- FastAPI (2+ years of production experience required)
- PostgreSQL
- MongoDB
- Redis
- Docker
- Celery or equivalent async task queues
- REST APIs & Microservices
- AWS/GCP
- GitLab CI/CD
The selected Sr. Backend engineer will ship the backbone that powers 4 million + learners in 64 countries—owning APIs that crunch 1 billion learning events & the AI that supports it with <200 ms latency.
What You'll Do:
At LearnTube, we’re pushing the boundaries to revolutionize how the world learns. As a Senior Backend Engineer, your roles and responsibilities will include:
- Shipping Micro-services – Build FastAPI services that handle ≈ 800 req/s today and will triple within a year (sub-200 ms p95).
- Power Real-Time Learning – Drive the quiz-scoring & AI-tutor engines that crunch millions of events daily.
- Design for Scale & Safety – Model data (Postgres, Mongo, Redis, SQS) and craft modular, secure back-end components from scratch.
- Deploy Globally – Roll out Dockerised services behind NGINX on AWS (EC2, S3, SQS) and GCP (GKE) via Kubernetes.
- Automate Releases – GitLab CI/CD + blue-green / canary = multiple safe prod deploys each week.
- Own Reliability – Instrument with Prometheus / Grafana, chase 99.9 % uptime, trim infra spend.
- Expose Gen-AI at Scale – Publish LLM inference & vector-search endpoints in partnership with the AI team.
- Ship Fast, Learn Fast – Work with founders, PMs, and designers in weekly ship rooms; take a feature from Figma to prod in < 2 weeks.
What makes you a great fit?
Must-Haves (Applicants without these skills are unlikely to move forward):
- 3+ yrs Python back-end experience (FastAPI)
- Strong with Docker & container orchestration
- Hands-on with GitLab CI/CD, AWS (EC2, S3, SQS) or GCP (GKE / Compute) in production
- SQL/NoSQL (Postgres, MongoDB) + You’ve built systems from scratch & have solid system-design fundamentals
Nice-to-Haves
- k8s at scale, Terraform,
- Experience with AI/ML inference services (LLMs, vector DBs)
- Observability: Prometheus, Grafana, OpenTelemetry
Why LearnTube?
- Build AI products at global scale – Your work will power learning experiences for 4M+ learners across 64 countries.
- Work directly with experienced founders – Collaborate closely with founders who are deeply involved in product and engineering decisions, giving you ownership and a direct impact on the product roadmap.
- Learn fast – Join a high-performing team where you'll own features end-to-end and solve challenging backend and distributed systems problems.
- Recognized AI startup – LearnTube is a Google Top 20 AI Startup and part of Google's AI First Startup Accelerator, with access to cutting-edge AI technology and mentorship.
Why Work With Us?
At LearnTube, we believe in creating a work environment that’s as transformative as the products we build. Here’s why this role is an incredible opportunity:
- Cutting-Edge Technology: You’ll work on state-of-the-art generative AI applications, leveraging the latest advancements in LLMs, multimodal AI, and real-time systems.
- Autonomy and Ownership: Experience unparalleled flexibility and independence in a role where you’ll own high-impact projects from ideation to deployment.
- Rapid Growth: Accelerate your career by working on impactful projects that pack three years of learning and growth into one.
- Founder and Advisor Access: Collaborate directly with founders and industry experts, including the CTO of Inflection AI, to build transformative solutions.
- Team Culture: Join a close-knit team of high-performing engineers and innovators, where every voice matters, and Monday morning meetings are something to look forward to.
- Mission-Driven Impact: Be part of a company that’s redefining education for millions of learners and making AI accessible to everyone.
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
Java Tech Lead (5–6 Years Experience)
About the Role
We are seeking a highly skilled Java Tech Lead with 5–6 years of hands-on experience in backend engineering, architecture design, and leading development teams.
The ideal candidate will combine strong technical expertise in Java frameworks with a deep understanding of system design, scalability, and performance optimization.
This role involves technical leadership, code reviews, and architectural decision-making for complex enterprise systems — with occasional exposure to analytics-driven and Python-based components.
Key Responsibilities
- Architect, design, and develop scalable backend systems using Java (Quarkus, Spring Boot, Spring, Java EE).
- Own the architecture — ensure modular, extensible, and high-performance service design.
- Lead and mentor a team of developers; conduct code reviews, enforce best practices, and ensure high code quality.
- Collaborate with cross-functional teams (frontend, DevOps, product, data) to deliver integrated, end-to-end solutions.
- Design and optimize database schemas (MySQL, PostgreSQL) and ensure efficient query performance.
- Implement and maintain microservices and distributed systems with strong fault tolerance and observability.
- Drive the adoption of modern development workflows — Git branching strategy, CI/CD, and code quality automation.
- Analyze system performance bottlenecks, implement monitoring, and ensure smooth production deployments.
- Contribute to architecture reviews, technical documentation, and design discussions.
- Occasionally contribute to Python-based analytics modules or automation scripts.
- Work with AWS cloud services (EC2, S3, RDS, Lambda) for deployment, scaling, and infrastructure automation.
Required Skills & Qualifications
- 5–6 years of professional experience in backend application development using Java.
- Strong proficiency in Java frameworks: Quarkus, Spring Boot, Spring, Java EE.
- Proven experience in architecture design, system decomposition, and microservices design principles.
- Solid understanding of object-oriented design (OOD), design patterns, and SOLID principles.
- Strong experience with relational databases (MySQL, PostgreSQL) and query optimization.
- Good understanding of event-driven systems, RESTful APIs, and asynchronous processing.
- Proficiency in Git for version control and team collaboration.
- Strong analytical and debugging skills; ability to diagnose complex production issues.
Good to Have
- Hands-on experience with Python for data processing or analytics integrations.
- Familiarity with AWS cloud architecture and cost optimization practices.
- Experience with CI/CD pipelines (GitHub Actions, Jenkins, GitLab CI).
- Knowledge of Docker/Kubernetes for containerized deployments.
- Exposure to NoSQL databases (MongoDB, DynamoDB, Cassandra).
- Experience with message queues (Kafka, RabbitMQ, or AWS SQS).
- Understanding of system scalability, caching (Redis/Memcached), and observability stacks (Prometheus, Grafana, ELK).
Soft Skills
- Strong leadership, mentoring, and communication skills.
- Proven ability to drive technical decisions and balance short-term delivery with long-term architectural health.
- Collaborative mindset — works closely with product, design, and operations teams.
- Passion for clean architecture, high performance, and continuous improvement.
- Self-driven with a strong sense of ownership and accountability.
Elocity is a cleantech start-up striving to make the world a better place through technology innovations. We are building a global infrastructure for making the transition to electric vehicles viable, affordable, and sustainable by working closely with the utilities, governments, and public.
Headquartered out of Canada, we are a team of highly specialized domain experts and problem solvers enabling utilities, public and private sector entities to successfully manage the demands of electric vehicle charging and its infrastructure needs to pave the way for electromobility in future.
To know more visit https://elocitytech.com/
Responsibilities:
- Determines technical feasibility of features or solutions by evaluating problem, customer requirements, possible solutions and technology requirements.
- Exercises judgement in prioritizing tasks and selecting methods and techniques for obtaining solutions.
- Create low-level design of modules of a software application through proper documentation and
- diagrams.
- Develops software solutions by studying requirements, clarifying customer/user needs, analysing data
- and processes and following established software development practices and processes.
- Develops proof of concepts for technical evaluation and early customer feedback
- Updates and shares knowledge by studying state-of-the-art development tools, programming
- techniques, and computing technology; reading professional publications
- Networks with internal and external personnel in own area of expertise.
- Skills:
- Good command in JavaScript/TypeScript. Knowledge of Java/Python will be a plus.
- Experience in Debugging/troubleshooting TypeScript code.
- Experience in API development (REST/GraphQL etc)
- Experience in development of Web and Mobile(android/iOS) applications
- Exposure of Parallel and Asynchronous programming
- Experience in writing Unit tests (Jest or any similar framework)
- Should be proficient in relational Database concepts (Postgres etc.)
- Knowledge of Non-relational Databases would be a plus.
- Good Understanding of Object-Oriented Programming Concepts.
- Good Understanding of Design Patterns.
- Good command of Data structures, Algorithms and Complexity.
- Good at problem solving and analytical skills.
- Experience with Source Code Versioning systems (Git etc)
- Understanding of Micro services Architecture would be a plus
About Simpl
The thrill of working at a start-up that is starting to scale massively is something else. Simpl (FinTech startup of the year - 2020) was formed in 2015 by Nitya Sharma, an investment banker from Wall Street and Chaitra Chidanand, a tech executive from the Valley, when they teamed up with a very clear mission - to make money simple, so that people can live well and do amazing things. Simpl is the payment platform for the mobile-first world, and we’re backed by some of the best names in fintech globally (folks who have invested in Visa, Square and Transferwise), and has Joe Saunders, Ex Chairman and CEO of Visa as a board member.
Everyone at Simpl is an internal entrepreneur who is given a lot of bandwidth and resources to create the next breakthrough towards the long term vision of “making money Simpl”. Our first product is a payment platform that lets people buy instantly, anywhere online, and pay later. In the background, Simpl uses big data for credit underwriting, risk and fraud modelling, all without any paperwork, and enables Banks and Non-Bank Financial Companies to access a whole new consumer market.
In place of traditional forms of identification and authentication, Simpl integrates deeply into merchant apps via SDKs and APIs. This allows for more sophisticated forms of authentication that take full advantage of smartphone data and processing power.
--------
We’re looking for polyglot developers who love to code. You should have >3 years of experience building high-quality products. You should have the ability to write clean code and must’ve worked on one of Ruby, NodeJS, Golang or Python
Responsibilities
- Develop new features - build POCs, get feedback, and scale is our default mode
- Building reusable and platform specific components
- Translating designs and wireframes into high-quality code
- Optimizing services for maximum performance
- Ensure faster release cycles by managing distribution over the cloud
Requirements
- Hands-on experience in all aspects of software development - analysis, coding, writing tests, deployment, the works.
- Knowledge of relational databases, SQL, ACID and distributed locking
- Solid OOPS understanding.
- Good exposure to building distributed systems, micro-services architecture.
- Continuous delivery experience
- Exposure to building platforms (not just products) would be a plus
JOB DESCRIPTION
DYT - Do Your Thng, is an app, where all social media users can share brands they love with their followers and earn money while doing so! We believe everyone is an influencer. Our aim is to democratise social media and allow people to be rewarded for the content they post. How does DYT help you? It accelerates your career through collaboration opportunities with top brands and gives you access to a community full of experts in the influencer space.
RESPONSIBILITIES
- Expert in Python with knowledge of Python best practices (PEP8)
- Strong knowledge of python web frameworks such as Django, Flask • Strong knowledge of building RESTful APIs using Django Rest Framework • Good Understanding of Django ORM Libraries
- Able to integrate multiple data sources and databases into one system • Strong experience on Linux
- Solid database skills in a relational database (i.e. PostgresSQL,MYSql) • Able to create database schemas that represent and support business processes • Strong unit test and debugging skills
- Proficient understanding of code versioning tools (git)
- Experience deploying on AWS is desirable
- Experience with Docker,Test Drive Development will be a plus
- Excellent interpersonal, leadership, influence and communication skills • Experience in designing scalable micro-services is desirable
QUALIFICATIONS
- 0-1 years of experience as a backend developer
- At least one product build and published
- SKILLS Contribute in all phases of the development lifecycle
- Write well designed, testable, efficient code
- Work well under pressure and meet deadlines without sacrificing quality • Work with distributed development teams
- 5+ years of software development experience in Java 8+ and Microservices.
- Experience in developing micro services. Experience in developing High Cohesion & Loosely Coupled Micro Services.
- Experienced in skills of requirement, analysis, design, develop, Java, springboot, microservices, rest api, AWS, lambda, EC2, Jenkins, design pattern, spring security, splunk, auth, docker, SOLID
- Hands on experience on Microservices Architecture.
- Should have excellent acumen in Data Structures, algorithms, problem-solving and Logical/Analytical skills. Thorough understanding of OOPS concepts, Design principles and implementation of different type of Design patterns.
- Experience with Multithreading, Concurrent Package and Concurrent APIs
- Basic understanding of Java Memory Management (JMM) including garbage collections concepts.
- Experience in RDBMS or NO SQL databases and writing SQL queries (Joins, group by, aggregate functions, etc.)
- Hands-on experience with Message Broker like Kafka/Rabbitmq or other. Hands-on experience in creating RESTful webservices and consuming web services. Hands-on experience with spring Cloud/Spring Boot.
- Hands-on experience with any of the logging frameworks (SLF4J/LogBack/Log4j)
- Experience of writing Junit test cases using Mockito / Powermock frameworks. Should have practical experience with Maven/Gradle and knowledge of version control systems like Git/SVN etc.
- Hands on experience on Cloud deployment/development like AWS/Azure/GCP.
- Good communication skills and ability to work with global teams to define and deliver on projects. Sound understanding/experience in software development process, test-driven development.
Benefits of Working Here:
- Gender Neutral /Diversified Culture
- 51 Leaves annually
- Insurance covered for family
- Incentives, Bonus
- Permanent WFH Option
- Generous parental leave and new parent transition program
- Flexible work arrangements
Roles & Responsibilities:
Build efficient, testable, and reusable PHP modules.
Solve complex performance problems and architectural challenges.
Integration of data storage solutions (may include databases, key-value stores, etc.).
Integration of User Interfaces developed by front end developers.
Skills and Qualifications:
· Must have a bachelor’s degree or above in Computer Science or in similar field.
· Minimum 4 years of experience in PHP web development.
· Strong knowledge of front-end technologies, such as JavaScript, HTML5, and CSS3
· Strong knowledge of PHP web frameworks (CodeIgniter, NodeJS)
· Experience in creating custom modules and themes.
· Expert knowledge in web architecture.
· Strong understanding of MVC design patterns and oops concept.
· Strong understanding of full synchronous behaviour of PHP.
· Experience with modern UI frameworks such as React, Angular or Vue.js
· Experience in MySQL and the ability to write SQL queries.
· Proficient understanding of source control management such as Git, SVN.
· Proficient understanding fundamental design principles behind a scalable application.
· Familiarity with limitations of PHP as a platform and its workarounds.
· Ability to create database schemes that represent and support business processes.
· Experience with Edu Tech companies will be preferred.
. Immediate Joiner Preferred.
SENIOR SOFTWARE DEVELOPER (BACKEND DEVELOPMENT):
We are looking for a Java Developer with experience in building high-performing, scalable, enterprise-grade web applications.
You will be part of a talented software team that works on mission-critical applications. Java developer roles and responsibilities include managing Java/Java EE application development while providing expertise in the full software development lifecycle, from concept and design to testing.
Responsibilities
• Java developer responsibilities include designing and developing high-volume, low-latency applications for mission-critical systems and delivering high-availability and performance
• Contribute in all phases of the development lifecycle
• Write well designed, testable, efficient code
• Ensure designs are in compliance with specifications
• Prepare and produce releases of software components
• Support continuous improvement by investigating alternatives and technologies and presenting these for
architectural review
Requirements
• BS/MS degree in Computer Science, Engineering or a related subject from renowned (IITs, NITs, BITS etc) colleges
• Excellent aptitude, algorithmic and puzzle solving skills
• Proven hands-on Software Development experience
• Proven working experience of 2+ years in Java development
• Hands on experience in designing and developing applications using Java EE platforms
• Object Oriented analysis and design using common design patterns.
• Profound insight of Java and JEE internals (Classloading, Memory Management, Transaction management, Multi-Threading etc)
• Good knowledge of Relational Databases, SQL and ORM technologies (JPA2, Hibernate)
• Experience in the Spring Framework
• Experience in developing web applications using at least one popular web framework (JSF, Wicket, GWT,
Spring MVC)
• Experience with agile development











