
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
🔥 High Priority – Senior Lead Java Developer (10+ Years) | Bangalore – Onsite
Summary :
We are hiring Senior Lead Java Developers with 10+ years of experience for an onsite role in Bangalore.
If you're a hands-on expert with a strong background in Java, Spring Boot, Microservices, and Kubernetes, this is your opportunity to lead, mentor, and deliver high-quality solutions in a fast-paced environment.
🔹 Position : Senior Lead Java Developer
🔹 Experience : 10+ Years (12+ preferred)
🔹 Location : Bangalore (Onsite)
🔹 Openings : 6+
✅ Must-Have Skills :
- 8+ years of hands-on experience with Core Java & Spring Boot
- Expertise in Multithreading, Dependency Injection, and AOP
- Strong in Microservices Architecture and RESTful services
- Good exposure to SQL & NoSQL databases
- Proficient with Git (GitLab preferred)
- Experience with Kubernetes deployments and APM tools (New Relic preferred)
- Solid understanding of distributed tracing and log analysis
- Proven debugging and performance optimization skills
💼 Responsibilities :
- Design and develop high-quality, scalable microservices
- Act as SME for multiple services or subsystems
- Own service performance, SLAs, and incident resolutions
- Mentor junior developers and conduct technical interviews
- Participate in production war rooms and troubleshooting
- Lead development efforts and drive code quality
🎓 Qualification :
- BE/B.Tech or equivalent degree
Company Overview:
Euphoric Thought Technologies is a technology-driven firm focused on building scalable software solutions for complex enterprise challenges. Operating at the intersection of data-intensive platforms and cloud-native infrastructure, the company partners with global clients to modernize their digital ecosystems. With a culture rooted in engineering excellence and pragmatic problem-solving, Euphoric Thought Technologies empowers its teams to deploy high-impact applications that serve millions of end-users across diverse industry verticals.
Role Overview:
As a Senior Python Developer based in Bangalore, you will serve as a technical anchor for our core product development initiatives. You will work closely with cross-functional teams, including product managers, frontend engineers, and DevOps specialists, to architect robust backend services that drive our platform's performance. Your daily contributions will involve translating complex business requirements into clean, maintainable code, ensuring that our systems remain resilient and efficient as we scale to meet growing user demand.
Key Responsibilities:
- Design and implement high-performance backend services using Python to ensure seamless data processing and system reliability for our enterprise clients.
- Develop and maintain RESTful APIs that facilitate smooth integration between internal microservices and external third-party platforms.
- Optimize database queries and schema designs in SQL to improve application latency and support high-concurrency environments.
- Architect and deploy cloud-native solutions on AWS, ensuring that our infrastructure remains scalable, secure, and cost-effective.
- Implement comprehensive unit and integration testing using PyTest to maintain high code quality and minimize production defects.
- Collaborate with stakeholders to refine technical specifications and mentor junior developers to foster a culture of continuous technical improvement.
Required Skillset:
- Demonstrated expertise in building and scaling production-grade applications using Python, with a deep understanding of Django and Flask frameworks.
- Proven ability to design and document RESTful APIs that adhere to industry standards for security and performance.
- Proficient in managing and optimizing complex SQL databases to support data-heavy application requirements.
- Hands-on experience in configuring and managing AWS services to support deployment pipelines and cloud infrastructure.
- Strong commitment to test-driven development, evidenced by a track record of using PyTest to ensure system stability.
- Excellent communication skills with the ability to articulate technical concepts to non-technical stakeholders and work effectively in a collaborative, office-based environment in Bangalore.
- Possess 6 to 9 years of professional software development experience, showcasing a consistent ability to deliver high-quality code in fast-paced environments.
We are looking for a Senior Software Developer to produce and implement functional software solutions. You will work with upper management to define software requirements and take the lead on operational and technical projects.
In this role, you should be able to work independently with little supervision. You should have excellent organization and problem-solving skills. If you also have hands-on experience in software development and agile methodologies, we’d like to meet you.
Your goal will be to develop high-quality software that is aligned with user needs and business goals.
Responsibilities
- Develop high-quality software design and architecture
- Identify, prioritize and execute tasks in the software development life cycle
- Develop tools and applications by producing clean, efficient code
- Automate tasks through appropriate tools and scripting
- Review and debug code
- Perform validation and verification testing
- Collaborate with internal teams and vendors to fix and improve products
- Document development phases and monitor systems
- Ensure software is up-to-date with the latest technologies.
Requirements and skills
- Proven experience as a Senior Software Engineer
- Extensive experience in software development, scripting and project management
- Knowledge of selected programming languages (e.g. Django, Python, C++) and the elastic search.
- Analytical mind with problem-solving aptitude
- Ability to work independently
- Excellent organizational and https://resources.workable.com/leadership-interview-questions" target="_blank">leadership skills
- BSc/BA in Computer Science or a related degree
Key Responsibilities
• Analyze and understand business processes and requirements to develop effective technical solutions.
• Assist in the planning, designing, development, of new applications and enhancements to existing applications.
• Collaborate with IT team members, decision makers, systems owners, and end users to define business requirements and systems goals, and identify and resolve business systems issues.
• Prepare functional specification documents in accordance to new business requirements.
• Ensure compatibility and interoperability of business software applications.
• Review and analyze the effectiveness and efficiency of existing systems and develop strategies for improving or further leveraging these systems.
• Assist in the deployment of new applications and enhancements to existing applications.
• Identify, assess, and recommend software solutions and implementation partners to management.
• Perform cost-benefit and return on investment analyses for proposed systems to aid management in making implementation decisions.
• Participate and sometimes drive IT projects to ensure that system requirements and data engineering needs are addressed throughout the project life cycle.
• Create systems models including integration points, specifications, diagrams, and charts to provide direction to internal stakeholders and third parties.
• Coordinate and perform in-depth tests, including end-user reviews, for modified and new systems.
• Provide orientation and training to end users for all modified and new systems.
Qualifications & Experience
• Minimum Bachelor’s degree in Information Technology, Computer Science, or related field.
• Minimum of 5 years of experience in related fields with 3 to 4 years in systems and/or functional analysis.
• Proven experience in analysing, designing, and implementing information systems.
• Strong understanding of business processes and technical systems.
• Hands-on skills in SQL and databases (e.g. Oracle, SQL Server).
Other Prerequisites
• Excellent problem-solving skills and the ability to work under pressure. • Good project management skills.
• Excellent written and oral communication and interpersonal skills.
• Ability to conduct research into systems issues and products as required.
• Ability to communicate ideas in both technical and user-friendly language.
• Highly self motivated and directed.
• Keen attention to detail.
• Proven analytical and creative problem-solving abilities.
• Strong customer service orientation.
• Experience working in a team-oriented, collaborative environment
About the Role
We are actively seeking talented Senior Python Developers to join our ambitious team dedicated to pushing the frontiers of AI technology. This opportunity is tailored for professionals who thrive on developing innovative solutions and who aspire to be at the forefront of AI advancements. You will work with different companies in the US who are looking to develop both commercial and research AI solutions.
Required Skills:
- Write effective Python code to tackle complex issues
- Use business sense and analytical abilities to glean valuable insights from public databases
- Clearly express the reasoning and logic when writing code in Jupyter notebooks or other suitable mediums
- Extensive experience working with Python
- Proficiency with the language's syntax and conventions
- Previous experience tackling algorithmic problems
- Nice to have some prior Software Quality Assurance and Test Planning experience
- Excellent spoken and written English communication skills
The ideal candidates should be able to
- Clearly explain their strategies for problem-solving.
- Design practical solutions in code.
- Develop test cases to validate their solutions.
- Debug and refine their solutions for improvement.
- Designs, develops, modifies, debugs, and evaluates programs for functional areas
- Analyzes existing programs or formulates logic for new systems
- Devises logic procedures
- Prepare Flowcharting
- Performs coding and tests/debugs programs.
- Develops Conversion and System implementation plans
- Prepares and obtains approval of system and programming of documentation
- Recommends changes in development, maintenance, and system standards
- Train users in conversion and implementation of system
- Communicate with end users and understands the requirements in clearly.
Skills & Qualifications:
- Bachelor’s or master’s degree in engineering / MCA with 5+ years of solid software development experience using .Net environment using C#, VB.NET, ASP.NET, ADO.NET.
- Experience working with Manufacturing Execution System (Camstar) is a plus.
- Experience working with Web services and XML/ XSLT.
- In Depth knowledge of MS-SQL 2005/2008 including coding of SPs.
- Has a Solid background of Object-Oriented Analysis and Design and the use of UML views and diagrams.
- Has the ability to design and document software applications with minimal supervision.
- Experience in multi-platform software Development (DOS, Windows).
- Experience in developing software applications in a multi-tier architecture.
- Experience in presentation layer development using JavaScript, HTML, DHTML, Ajax and CSS.
- Experience in WCF / MVC is a plus.
- Experience is in Source Controls like SVN / TFS.
- Able to handle all phases of SDLC.
- 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
Responsibilities:
As a backend developer you would be responsible for:
- Executing full lifecycle software development
- Architect and conceptualise the solution from initiation to completion meeting client requirements
- Work with customer and their integration partners to ensure the product is well integrated
- Programming well-designed, testable and efficient code
- Develop flowcharts, layouts and documentation to identify requirements and solutions
- Work with cross-functional teams (Product, Engineering and ML team) to craft custom solutions
- Ensure clients change requests are addressed effectively in a timely manner
Requirements:
- 2+ years of experience in architecture and developing high performance web applications
- In-depth understanding of the entire web development process (design, development, and deployment)
- Strong NoSQL and/or SQL database design and query writing skills with a commitment to performance and efficiency
- Knowledge of RESTful API and SOAP Webservices paradigms
- Experience with CRM/ERPs like systems SAP, Oracle, SalesForce, Servicenow, Workday, etc. would be a huge plus
- Ability to operate in a highly ambiguous and fast-paced environment
- Superior verbal and written communication skills
Our Technology Stacks:
- Demonstrated experience in our tech stack will be a big plus as it lets you get up and running with our product that much sooner
- Node.js back-end with typescript
- MongoDB as database
- React to power our user interfaces (don't worry, we don't expect it for back-end)
- NGINX as our web server
- RabbitMQ
- Redis
- Elasticsearch
- Docker
• You will work on a disruptive product that’s still in its early stages
• Lead development of features within your technical focus area (backend)
• Design and develop secure, clean, clear, scalable, and well-documented
codebase
• Translate objectives into step by step, evaluate, and then refactor into a
scalable and extensible design
• Exercise high end-to-end ownership and initiative of their tasks
• Design, develop, ship, and maintain medium or high complexity features
with little guidance from a more experienced engineer
• Research on new technologies and tools to improve products
• Mentoring other engineers, defining our technical culture, and helping to
build a fast-growing team.
Qualifications
• 2-4 years of experience of building backend services
• Familiar with REST and event driven constructs
• Well-versed in one of the following languages: Java, Go-lang, or Python
• Data modelling experience in Relational and NoSQL databases
• Proficiency in OOP, SQL, Design Patterns, and software best practices
• Well-versed in standard web frameworks such as Spring Boot / Django
• A supportive and highly collaborative attitude to work with cross-
functional teams on a daily basis
• A passion for learning new stacks and taking on new challenges
• Ability to break-down larger/fuzzier problems into smaller ones in the
scope of the product
Week off: Friday & Saurday
Day Shift.
Key responsibilities:
- Creating, designing and developing data models
- Prepare plans for all ETL (Extract/Transformation/Load) procedures and architectures
- Validating results and creating business reports
- Monitoring and tuning data loads and queries
- Develop and prepare a schedule for a new data warehouse
- Analyze large databases and recommend appropriate optimization for the same
- Administer all requirements and design various functional specifications for data
- Provide support to the Software Development Life cycle
- Prepare various code designs and ensure efficient implementation of the same
- Evaluate all codes and ensure the quality of all project deliverables
- Monitor data warehouse work and provide subject matter expertise
- Hands-on BI practices, data structures, data modeling, SQL skills
Hard Skills for a Data Warehouse Developer:
- Hands-on experience with ETL tools e.g., DataStage, Informatica, Pentaho, Talend
- Sound knowledge of https://www.freelancermap.com/it-projects/sql-1084" target="_blank">SQL
- Experience with SQL databases such as Oracle, DB2, and SQL
- Experience using Data Warehouse platforms e.g., SAP, Birst
- Experience designing, developing, and implementing Data Warehouse solutions
- Project management and system development methodology
- Ability to proactively research solutions and best practices
Soft Skills for Data Warehouse Developers:
- Excellent Analytical skills
- Excellent verbal and written communications
- Strong organization skills
- Ability to work on a team, as well as independently












