
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 Title: PHP – Laravel Developer (2+ Years Experience)
Location: Ghatkopar (On-Site)
Experience: 3+ Years
Salary: ₹4,50,000.00 - ₹6,00,000.00 Per Annum (depending on experience & skill set)
Employment Type: Full-time
Job Description:
We are looking for a motivated PHP – Laravel Developer to join our onsite team in Mumbai. The ideal candidate should have hands-on experience in Laravel development along with frontend knowledge and should be comfortable using modern AI development tools to improve productivity and build efficient solutions. The candidate should be tech-savvy, adaptable, and quick to learn new technologies, especially AI-assisted development tools.
Key Responsibilities:
- Develop, maintain, and enhance web applications using PHP and Laravel
- Build and integrate RESTful APIs
- Work with Laravel (10+ preferred) for backend development
- Implement frontend components using JavaScript and modern UI frameworks
- Utilize AI-assisted development tools to improve development efficiency
- Collaborate with clients and internal teams to understand requirements
- Write clean, optimized, and reusable code
- Debug, test, and troubleshoot application issues
- Work with cross-functional teams including frontend, QA, and project managers
- Track and manage tasks using project management tools
- Stay updated with new technologies, frameworks, and AI tools
Required Skills & Qualifications:
- 2+ years of hands-on experience in PHP development
- Good experience with Laravel framework
- Understanding of MVC architecture
- Strong knowledge of JavaScript
- Basic exposure to React.js
- Good understanding of HTML, CSS, and frontend development
- Experience using Tailwind CSS
- Experience working with MySQL
- Hands-on experience with REST APIs
- Familiarity with Git / version control
- Experience working in Linux environments
AI & Technology Adaptability (Important):
- Comfortable using AI development tools such as Windsurf, Google AntiGravity, Gemini, GitHub Co-pilot, OpenAI tools, or AI IDE
- Ability to integrate AI tools into development workflows
- Quick learner who can adapt to new technologies and frameworks
- Interest in using AI for coding assistance, debugging, and productivity improvement
Additional Requirements
- Good communication and collaboration skills
- Ability to understand requirements and translate them into technical tasks
- Experience using project management tools (Jira, Trello, ClickUp, etc.)
- Ability to work independently and take ownership of assigned modules
Good to Have (Preferred Skills)
- Basic understanding of TypeScript
- Exposure to CI/CD pipelines
- Basic knowledge of application security practices
- Experience working in Agile/Scrum environments
What We Offer
- Competitive salary based on skills and experience
- Onsite role with a collaborative team environment
- Opportunity to work with modern development tools and AI-assisted workflows
- Growth opportunities and exposure to evolving technologies
We are looking for a skilled Node.js Developer with Rect Native experience to build, enhance, and maintain ERP and EdTech platforms. The role involves developing scalable backend services, integrating ERP modules, and supporting education-focused systems such as LMS, student management, exams, and fee management.
Key Responsibilities
Develop and maintain backend services using Node.js,Rect Native,PHP.
Build and integrate ERP modules for EdTech platforms (Admissions, Students, Exams, Attendance, Fees, Reports).
Design and consume RESTful APIs and third-party integrations (payment gateway, SMS, email).
Work with databases (MySQL / MongoDB / PostgreSQL) for high-volume education data.
Optimize application performance, scalability, and security.
Collaborate with frontend, QA, and product teams.
Debug, troubleshoot, and provide production support.
Required Skills
Strong experience in Node.js (Express.js / NestJS).
Working experience in PHP (Core PHP / Laravel / CodeIgniter).
Hands-on experience with ERP systems.
Domain experience in EdTech / Education ERP / LMS.
Strong knowledge of MySQL and database design.
Experience with authentication, role-based access, and reporting.
Familiarity with Git, APIs, and server environments.
Preferred Skills
Experience with online examination systems.
Knowledge of cloud platforms (AWS / Azure).
Understanding of security best practices (CSRF, XSS, SQL Injection).
Exposure to microservices or modular architecture.
Qualification
Bachelor’s degree in Computer Science or equivalent experience.
3–6 years of relevant experience in Node.js & PHP development
Skills:- NodeJS (Node.js), PHP, ERP management, EdTech, MySQL, API and Amazon Web Services (AWS)
Job Details
- Job Title: Senior Backend Engineer
- Industry: SAAS
- Function – Information Technology
- Experience Required: 5-8 years
- Working Days: 6 days a week, (5 days-in-office, Saturdays WFH)
- Employment Type: Full Time
- Job Location: Bangalore
- CTC Range: Best in Industry
Preferred Skills: AWS, NodeJS, RESTful APIs, NoSQL
Criteria
· Minimum 5+ years in backend engineering with strong system design expertise
· Experience building scalable systems from scratch
· Expert-level proficiency in Node.js
· Deep understanding of distributed systems
· Strong NoSQL design skills
· Hands-on AWS cloud experience
· Proven leadership and mentoring capability
· Preferred candidates from SAAS/Software/IT Services based startups or scaleup companies
Job Description
The Role:
What You’ll Build:
1. System Architecture & Design
● Architect highly scalable backend systems from the ground up
● Define technology choices: frameworks, databases, queues, caching layers
● Evaluate microservices vs monoliths based on product stage
● Design REST, GraphQL, and real-time WebSocket APIs
● Build event-driven systems for asynchronous processing
● Architect multi-tenant systems with strict data isolation
● Maintain architectural documentation and technical specs
2. Core Backend Services
● Build high-performance APIs for 3D content, XR experiences, analytics, and user interactions
● Create 3D asset processing pipelines for uploads, conversions, and optimization
● Develop distributed job workers for CPU/GPU-intensive tasks
● Build authentication/authorization systems (RBAC)
● Implement billing, subscription, and usage metering
● Build secure webhook systems and third-party integration APIs
● Create real-time collaboration features via WebSockets/SSE
3. Data Architecture & Databases
● Design scalable schemas for 3D metadata, XR sessions, and analytics
● Model complex product catalogs with variants and hierarchies
● Implement Redis-based caching strategies
● Build search and indexing systems (Elasticsearch/Algolia)
● Architect ETL pipelines and data warehouses
● Implement sharding, partitioning, and replication strategies
● Design backup, restore, and disaster recovery workflows
4. Scalability & Performance
● Build systems designed for 10x–100x traffic growth
● Implement load balancing, autoscaling, and distributed processing
● Optimize API response times and database performance
● Implement global CDN delivery for heavy 3D assets
● Build rate limiting, throttling, and backpressure mechanisms
● Optimize storage and retrieval of large 3D files
● Profile and improve CPU, memory, and network performance
5. Infrastructure & DevOps
● Architect AWS infrastructure (EC2, S3, Lambda, RDS, ElastiCache)
● Build CI/CD pipelines for automated deployments and rollbacks
● Use IaC tools (Terraform/CloudFormation) for infra provisioning
● Set up monitoring, logging, and alerting systems
● Use Docker + Kubernetes for container orchestration
● Implement security best practices for data, networks, and secrets
● Define disaster recovery and business continuity plans
6. Integration & APIs
● Build integrations with Shopify, WooCommerce, Magento
● Design webhook systems for real-time events
● Build SDKs, client libraries, and developer tools
● Integrate payment gateways (Stripe, Razorpay)
● Implement SSO and OAuth for enterprise customers
● Define API versioning and lifecycle/deprecation strategies
7. Data Processing & Analytics
● Build analytics pipelines for engagement, conversions, and XR performance
● Process high-volume event streams at scale
● Build data warehouses for BI and reporting
● Develop real-time dashboards and insights systems
● Implement analytics export pipelines and platform integrations
● Enable A/B testing and experimentation frameworks
● Build personalization and recommendation systems
Technical Stack:
1. Backend Languages & Frameworks
● Primary: Node.js (Express, NestJS), Python (FastAPI, Django)
● Secondary: Go, Java/Kotlin (Spring)
● APIs: REST, GraphQL, gRPC
2. Databases & Storage
● SQL: PostgreSQL, MySQL
● NoSQL: MongoDB, DynamoDB
● Caching: Redis, Memcached
● Search: Elasticsearch, Algolia
● Storage/CDN: AWS S3, CloudFront
● Queues: Kafka, RabbitMQ, AWS SQS
3. Cloud & Infrastructure:
● Cloud: AWS (primary), GCP/Azure (nice to have)
● Compute: EC2, Lambda, ECS, EKS
● Infrastructure: Terraform, CloudFormation
● CI/CD: GitHub Actions, Jenkins, CircleCI
● Containers: Docker, Kubernetes
4. Monitoring & Operations
● Monitoring: Datadog, New Relic, CloudWatch
● Logging: ELK Stack, CloudWatch Logs
● Error Tracking: Sentry, Rollbar
● APM tools
5. Security & Auth
● Auth: JWT, OAuth 2.0, SAML
● Secrets: AWS Secrets Manager, Vault
● Security: Encryption (at rest/in transit), TLS/SSL, IAM
What We’re Looking For:
1. Must-Haves
● 5+ years in backend engineering with strong system design expertise
● Experience building scalable systems from scratch
● Expert-level proficiency in at least one backend stack (Node, Python, Go, Java)
● Deep understanding of distributed systems and microservices
● Strong SQL/NoSQL design skills with performance optimization
● Hands-on AWS cloud experience
● Ability to write high-quality production code daily
● Experience building and scaling RESTful APIs
● Strong understanding of caching, sharding, horizontal scaling
● Solid security and best-practice implementation experience
● Proven leadership and mentoring capability
2. Highly Desirable
● Experience with large file processing (3D, video, images)
● Background in SaaS, multi-tenancy, or e-commerce
● Experience with real-time systems (WebSockets, streams)
● Knowledge of ML/AI infrastructure
● Experience with HA systems, DR planning
● Familiarity with GraphQL, gRPC, event-driven systems
● DevOps/infrastructure engineering background
● Experience with XR/AR/VR backend systems
● Open-source contributions or technical writing
● Prior senior technical leadership experience
Technical Challenges You’ll Solve:
● Designing large-scale 3D asset processing pipelines
● Serving XR content globally with ultra-low latency
● Scaling from thousands to millions of daily requests
● Efficiently handling CPU/GPU-heavy workloads
● Architecting multi-tenancy with complete data isolation
● Managing billions of analytics events at scale
● Building future-proof APIs with backward compatibility
Why company:
● Architectural Ownership: Build foundational systems from scratch
● Deep Technical Work: Solve distributed systems and scaling challenges
● Hands-On Impact: Design and code mission-critical infrastructure
● Diverse Problems: APIs, infra, data, ML, XR, asset processing
● Massive Scale Opportunity: Build systems for exponential growth
● Modern Stack and best practices
● Product Impact: Your architecture directly powers millions of users
● Leadership Opportunity: Shape engineering culture and direction
● Learning Environment: Stay at the forefront of backend engineering
● Backed by AWS, Microsoft, Google
Location & Work Culture:
● Location: Bengaluru
● Schedule: 6 days a week, (5 days-in-office, Saturdays WFH)
● Culture: Builder mindset, strong ownership, technical excellence
● Team: Small, highly skilled backend and infra team
● Resources: AWS credits, latest tooling, learning budget
Greetings from Wissen Technology!
We are hiring Java Developers for Mumbai location.
Exp - 4 - 8 years
Location - Mumbai (Goregaon) - Hybrid
Notice Period - immediate or serving notice period only
Interview Process - Initial rounds virtual + Final round F2F
Software Engineer/Senior Software Engineer/Lead Engineer-Java
· Experience in Core Java 5.0 and above, Data Structures, OOPS, Multithreading, Algorithms, Collections, Unix/Linux
· Possess good architectural knowledge and be aware of enterprise application design patterns.
· Should have the ability to analyse, design, develop and test complex, low-latency client-facing applications.
· Good development experience with RDBMS
· Good knowledge of multi-threading and high volume server side development
Basic working knowledge of Unix/Linux
· Excellent problem solving and coding skills in Java
· Strong interpersonal, communication and analytical skills.
· Should have the ability to express their design ideas and thoughts.
Job Brief-
· Understand product requirements and come up with solution approaches
· Build and enhance large scale domain centric applications
· Deploy high quality deliverables into production adhering to the security, compliance and SDLC guidelines
WHO YOU ARE
To be successful in this role, you’ll need to have the following skills:
· Love for coding: A fanatic about writing beautiful and scalable code.
· A sense of analytics: Strong analytical and troubleshooting skills. Should be resourceful, innovative and inventive.
· Dynamic: Should be comfortable in dealing with lots of moving pieces. Have exquisite attention to detail, and are comfortable learning new technologies and systems.
· Team player: Knack for influencing without being authoritative. Pitch in wherever the team needs help, from writing blog posts to supporting customers.
· Accountability: High sense of ownership for your code and relentlessness to deliver projects with high business impact.
KEY QUALIFICATIONS
· BE/BTech in Computer Science or related field.
· 5+ years of professional production and development experience with leading-edge server and database technologies (e.g., Python, Java, Node.js, Scala, Spring Boot, MySQL, and NoSQL databases).
KEY SKILLS
· Strong computer system analysis and design skills in current methodologies and patterns Experience with professional production cloud (AWS preferred).
· Experience with RESTful Services and APIs.
- Design & build a highly scalable, robust backend architecture for our cloud services
- You will be part of a software development team for developing and enhancing SaaS applications.
- Take responsibility of entire module/feature set and develop, test, debug and maintain the application software throughout the product lifecycle
- Working with the Product Management Team to validate and plan new features
- Working with cross-functional teams to deliver stellar end user experience
- Research new technologies and tools that help in building the next generation of our services
- Test, debug and maintain the application software throughout the product lifecycle
Desired Candidate Profile
- Must have experience with web development in Java 8+, Spring/J2EE or similar frameworks and technologies. (Mandatory)
- Must have worked on REST API (Mandatory)
- Should be an enthusiast for writing clean, reusable code, willing to learn new things as a self-starter person
- 2+ years of strong relevant experience in developing Object-oriented technologies.
- Strong working experience with any of the following DBs - Postgres / MySQL / Oracle or MSSQL
What you'll do
Technology is at the heart of our organization. We have a strong engineering team and we're looking for an experienced engineer to lead our backend engineering team. As part of the tech team, you will Understand product requirements and brainstorm ways to address them
- Lead large initiatives and be responsible for it
- Mentor teammates
- Set and enforce standards for writing and maintaining efficient code
- Influence team decisions in the overall architecture and practices of the company
- Contribute to company growth by participating in hiring activities
What you'll need
Must-haves
- At least 4 years experience in a product based company
- Experience working with distributed environments at scale
- Strong command on at least one Object Oriented Programming language
- Experience leading developers for large scale products
- Demonstrated capability to design and architect products built for scale
- Deep knowledge of multiple AWS services
- Experience with Docker and Kubernetes
Good to have
- Experience with at least one among C++, Java
- Experience with Linux file systems
- Familiarity with agile development methodologies
Why us
We're hiring a set of highly skilled, enthusiastic, and passionate people who thrive in a high-growth environment. We believe the best way to grow is to give everyone the opportunity to pursue their interests. At Lucidity, you have complete freedom to work on projects that interest you. Plus, with benefits like flexible hours, company offsites, unlimited leaves, we ensure you enjoy the journey as much as we do. We are also offering healthy founding team ESOP's.
- Creating Rest based Backend for both Web & Mobile Apps
- Standard Code Quality
- Can work on both SQL and NoSQL DB
- Familier with GraphQL
Required Candidate profile
- Experience creating backend using Node.JS- Hands on experience with JavaScript Development on both client and server-side
- Experience with modern frameworks and design pattern
Perks and Benefits
Overtime Incentives and Flexible Office HoursJob description:
Job Title/Designation/Position: Dotnet Developer / Sr. Dotnet Developer
Total Experience: 4-8 years
Relevant Experience: 4-8 years
Job Location: Pune/Hyderabad/Bangalore & Hyderabad
Skills/Qualifications:
Primary Skills (Must have):
- C# with good understanding of OOPS, design patterns and multi-threading
- ASP.Net MVC, WEBAPI, RESTful services, JavaScript, jQuery
- .Net Framework
- Advanced knowledge of Microsoft SQL Server
- Knowledge of Unit Testing and Automated tests (nUnit)
- Knowledge of SQL Server/Oracle database and able to write Store-Procedures
- Strong analytical and problem-solving skills
- Good analytical skills along with Excellent written and verbal communication skills in English
- Bachelor’s Degree in Engineering /Technology / MCA
Secondary Skills (Nice to have):
- HTML5
- CSS3
- Node JS
Dot Net Developer( US Shifts)
Position – Dot Net Developer
Location – Permanent WFH Opportunity
Experience – 4-8 years
Education – B.E. / B. Tech / MCA / BCA
Salary – Negotiable
Open positions- 2
Looking for Dot Net Developer for developing desktop applications and backend services.
Job Description
- Design implement and support highly scalable applications and web services using Microsoft technologies (ASP.NET, C#, MVC, WCF, SQL Server, Windows Forms, Web API/Rest API)
- Candidate should have some experience towards experience in Angular/React and typescript also.
- Candidates should have the ability to train and work along with development teams to ensure timelines and quality deliveries.
- Lead project estimations, system architecture and performance engineering of
Desired Candidate Profile
- Minimum 4+ years’ experience in designing and developing applications on the .NET platform.
- More than 2+ year of experience with MVC, WCF framework is needed.
- Experience in web application Architecture and Development with hands on expertise in delivering solutions based on/customizing ASP.Net 4.0 / MVC and above.
- Expert-level knowledge of SQL Server programming.
- Strong understanding of OOPS fundamentals, Entity Framework, LINQ and REST APIs.
- Candidate should be ready for US shifts (4pm-1AM)
- Candidates who can join early and working with international clients will be preferred.
.











