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)
Position : SQL Database Developer
Experience : 10+ Years
Domain : Mutual Fund / Capital Markets
Location : Noida
Work Mode : Hybrid
Role Overview :
We are looking for a Senior SQL Developer with 10+ years of experience in SQL Server and T-SQL development, preferably with experience in the Mutual Fund / Capital Markets / Financial Services domain.
Mandatory Skills :
- SQL Server & T-SQL
- Stored Procedures, Functions, Triggers, Views & SQL Jobs
- Complex SQL Queries & Data Manipulation
- Query Performance Tuning & Optimization
- Indexing, Execution Plans & Partitioning
- Data Migration, Porting, Transformation & Validation
- Database Troubleshooting
- SQL Server Performance Monitoring
- Version Control / Git
- Database Security & Data Integrity
Domain Knowledge :
- Mutual Fund / Capital Markets experience preferred.
- Understanding of financial transactions, reporting, reconciliation, and business processes.
Key Responsibilities :
- Develop and optimize T-SQL queries, stored procedures, views, functions, and triggers.
- Perform query tuning, indexing, execution plan analysis, and performance optimization.
- Handle data migration, transformation, porting, validation, and reconciliation.
- Troubleshoot database and production/UAT issues.
- Ensure data accuracy, integrity, consistency, and security.
- Work with developers, BAs, QA teams, and business stakeholders.
- Independently own database development and optimization activities.
- Education: Bachelor's degree in Computer Science, IT, Engineering, or related field.
Strong Senior Developer – PL/SQL, SQL & ETL (Microsoft SSIS) Profile
2
Mandatory (Experience 1) – Must have minimum 5+ years of strong hands-on experience in PL/SQL and SQL development, including complex stored procedures, functions, queries, joins, data manipulation, and query/performance optimization.
3
Mandatory (Experience 2) – Must have strong hands-on experience in ETL development using Microsoft SSIS, including building, maintaining, optimizing, and troubleshooting SSIS packages for large-volume data movement and transformation.
4
Mandatory (Experience 3) – Must have solid experience working with Data Warehousing concepts and architectures, including data models, fact/dimension structures, ETL data flows, and enterprise reporting/data warehouse environments.
5
Mandatory (Experience 4) – Must have experience managing batch jobs, scheduling, and data pipelines, ensuring timely and reliable execution of enterprise ETL workflows.
6
Mandatory (Experience 5) – Must have hands-on experience in production support for SSIS/ETL and data warehouse jobs, including monitoring job execution, troubleshooting failures, performing root cause analysis, and implementing preventive fixes.
7
Mandatory (Experience 6) – Must have experience with data quality, validation, and troubleshooting, including identifying and resolving data discrepancies/issues affecting downstream reports, dashboards, and analytics.
8
Mandatory (Experience 7) – Must have experience with unit, integration, and regression testing of SQL, PL/SQL, and ETL components, along with strong documentation of technical designs, data mappings, data flows, and deployment processes.
9
Mandatory (Location) – Must be willing to work in a hybrid model from a city where Cognizant has an office.
10
Mandatory (Notice Period) – Immediate joiners or candidates who can join within 2–4 weeks.
Hiring for Data Analyst
Exp : 5 - 7 yrs
Edu : BE/B.Tech
Work Location : Noida WFO
Skills :
Expertise in SQL Server, including database design, performance tuning, query optimization, and security.
Hands-on experience developing ETL solutions using SSIS, Azure Data Factory (ADF), and Python.
Location - Remote (India)
Key Responsibilities
• Design, develop, and maintain database schemas, stored procedures, views, and queries in SQL Server and MySQL.
• Identify and resolve query performance bottlenecks using execution plans, indexing strategies, and tuning techniques.
• Conduct regular database health checks and performance reviews to ensure optimal operation.
• Collaborate with development and operations teams to support application data requirements.
• Write and optimize complex SQL scripts to meet business and operational needs.
• Support the DBA Team Lead with day-to-day database operations and incident resolution.
• Assist in monitoring database availability, integrity, and backups.
• Document database structures, procedures, and changes in a clear and organized manner.
• Implement best practices for data storage, retrieval, and processing efficiency.
• Contribute to the continuous improvement of database standards and internal processes.
• Identify and effectively prioritize situations requiring urgent attention.
• Stay current with system information, database technologies, changes, and updates.
• Experience with cloud-managed databases (e.g., Microsoft Azure SQL Database, Amazon RDS) and understanding of scaling, cost optimization, and high availability in cloud environments.
• Hands-on exposure to database automation and CI/CD practices (schema versioning, deployment pipelines, Infrastructure as Code).
• Strong knowledge of high availability and disaster recovery design, including replication, failover, and defined RPO/RTO ownership.
• Familiarity with database security best practices (encryption, access control, auditing, and protection of sensitive/regulated data).
• Experience with monitoring and observability tools, with a proactive approach to performance tuning and alerting.
• Scripting ability (PowerShell, Python, or Bash) to automate routine database operations and reduce manual effort.
• Experience with database migrations, version upgrades, or modernization initiatives (on-prem to cloud or legacy to current platforms).
• Ability to operate in a DevOps-oriented environment, partnering closely with engineering teams and owning database performance tied to application SLA.
• Proficiency in T-SQL and/or standard SQL.
• Ability to multi-task and adjust priorities quickly in a fast-paced environment.
• Ability to research and implement solutions using available technical resources.
• Strong analytical and problem-solving skills with attention to detail.
• Ability to clearly communicate technical concepts to non-technical stakeholders.
• Advanced knowledge of database performance tuning and query optimization.
• Familiarity with cloud database platforms such as Microsoft Azure SQL, AWS RDS, or equivalent.
• Experience with database deployment automation and CI/CD pipelines.
• Understanding of high availability, disaster recovery, and data protection strategies.
• Working knowledge of database monitoring and performance management tools.
• Basic scripting skills (PowerShell, Python, or Bash) for automation.
• Awareness of data security and compliance considerations in regulated environments.
Required Skills
• Proven working experience as a Database Administrator or in a similar role.
• Working knowledge of Microsoft SQL Server (SSIS, T-SQL, DDL, SML)
• Working knowledge of MySQL or MariaDB.
• A minimum of 5 years of experience in database administration.
• Understanding of database normalization and data modeling principles.
Nice to Have
• MacOS, iOS, Android, Linux OS beneficial but not required.
• ETL processes or data warehouse experience beneficial but not required.
• Microsoft Certified: Azure Database Administrator Associate or equivalent SQL Server certification preferred but not required.
• MySQL certification preferred but not required.
About Us
We believe the future of software development is AI-native — where engineers operate at a higher level of abstraction and quality remains non-negotiable.
Incubyte is a software craft consultancy where the “how” of building software matters as much as the “what”.
We partner with companies of all sizes, from helping enterprises build, scale, and modernize to early-stage founders bring their ideas to life.
Our engineers operate in an AI-native development model, using AI as a collaborator across the SDLC to accelerate development while upholding the discipline of software craftsmanship. Guided by Software Craftsmanship and Extreme Programming practices, we build reliable, maintainable, and scalable systems with speed, without compromising quality. If this way of building software resonates with you, we’d like to talk.
Our Guiding Principles
These principles define how we work at Incubyte. They are non-negotiable.
Relentless Pursuit of Quality with Pragmatism
We build high-quality systems without losing sight of delivery.
Extreme Ownership
We take responsibility end-to-end for decisions, execution, and outcomes.
Proactive Collaboration
We collaborate closely, challenge each other, and solve problems together.
Active Pursuit of Mastery
We continuously improve our craft and raise our bar.
Invite, Give, and Act on Feedback
We seek, give, and act on feedback to get better every day.
Ensuring Client Success
We act as trusted partners and focus on real outcomes, not just output.
Job Description
This is a remote position.
Experience Level
2+ years of experience in SQL, Python, and Snowflake (or equivalent cloud data warehouse), Azure Cloud services.
Role Overview
If you're a Data Craftsperson who takes pride in clean, well-tested data solutions and believes in the principles of Extreme Programming, we'd love to meet you. At Incubyte, we're a DevOps organization where developers own the entire release cycle — you'll get hands-on experience across data engineering, analytics, cloud infrastructure, and direct client communication. This role sits primarily in data engineering (80%) with a meaningful analytics component (20%), supporting our client's data systems end-to-end.
What You'll Do
- Design, build, and maintain data pipelines and infrastructure using SQL and Python
- Work within Snowflake to build and optimize data models supporting business use cases
- Parse and process structured and semi-structured data (JSON, XML) from varied sources
- Diagnose issues across raw, intermediate, and summary tables
- Build SQL queries to support repeatable analytics use cases based on stakeholder requirements
- Investigate and resolve data quality issues, including time-sensitive or urgent ones
- Identify opportunities to consolidate models and maintain a single source of truth (SSOT)
Requirements
What We're Looking For
- 2+ years of experience with SQL and relational databases, with the ability to understand complex data relationships and transformations (required)
- 2+ years of experience with Python for data engineering tasks (required)
- Experience with Snowflake or an equivalent cloud data warehouse (required)
- Experience parsing JSON and XML data (a plus)
- A strong eye for data quality and attention to detail
- Knowledge of Git (required)
- Knowledge of Azure cloud services such as Azure Data Factory, Azure Blob Storage, and Azure SQL Database (required)
- Knowledge of data infrastructure/modeling tools like DBT, Fivetran (a plus)
- Experience with BI tools like Power BI(a plus, not core to this role)
- Knowledge of Docker, Linux, Shell/Bash, and virtualization technologies (a plus)
- Knowledge of SSIS packages (a plus)
- Familiarity with CI/CD methodologies
Benefits
Life at Incubyte
We are a remote-first company with structured flexibility. Teams commit to shared rhythms during core hours, ensuring smooth collaboration while maintaining autonomy. Twice a year, we come together in person for a co-working sprint and once a year for a retreat - with all travel expenses covered.
Our environment is built for crafters: pairing, refactoring, experimenting with AI, and pushing the boundaries of software excellence. We are all lifelong learners, and our work is our passion.
Perks
- Dedicated learning & development budget.
- Sponsorship for conference talks.
- Comprehensive medical & term insurance.
- Employee-friendly leave policies.
- Home Office fund
- Medical Insurance
Job Description
Actosoft is a software development and digital marketing company that offers complete IT solutions. We are a part of the digitally-fluent force that’s improving economies, increasing businesses, and creating success stories, just like ours.
We are a collective of focused, energetic, talented, and hardworking professionals who believe in getting things done at the highest level. Our team aims to innovate, be authentic and grow in everything that we do.
The ideal candidate should be familiar with the complete software design life cycle. In addition, they should have experience in designing, coding, testing and consistently managing applications. They should be comfortable coding in multiple languages and be able to test codes to maintain high-quality coding.
Job details:
Job Location: Actosoft, Gajera Rd, beside Avalon Business Hub, Katargam, Surat, Gujarat 395004
Experience: 0 to 1 years of experience
Salary: 15,000 to 20,000 (per month)
Job Type: Full-time – Work from the Office
Working Schedule:
9:00 am to 6:00 pm (Monday to Friday)
Alternate Saturdays Off.
Job Responsibilities:
● Design, code, test, and manage various applications
● Collaborate with the engineering team and product team to establish the best products
● Follow outlined standards of quality related to coding and systems
● Develop automated tests and conduct performance tuning
● Ability to create and support documentation for all new applications
● Willing to work as a team member
Qualifications:
● Bachelor's degree in Computer Science or relevant field, like MCA, BCA, or BE
● Experience developing web-based applications in C#, HTML, VBScript/ASP, and .NET
● Experience working with MS SQL Server and MySQL Knowledge of practices and procedures for full software design life cycle
● Experience in working with an agile development company
Required Skills:
● .NET Framework
● C#
● Microsoft SQL Server
● JavaScript
● jQuery
● ASP.NET MVC
● ASP.NET Web API
● HTML
● WCF Services
● PL/SQL
● Anqular
● Entity Framework
● CSS
● Ajax
● XML
Perks and Benefits:
1. Promotion every year.
2. Incredible opportunity to diversify your writing skills by working with experts on unique projects.
3. Paid sick leaves.
Website:
The recruiter has not been active on this job recently. You may apply but please expect a delayed response.
Job Summary
We are seeking a motivated Data Engineer with strong skills in SQL, Python, and Linux to design, build, and maintain scalable data pipelines and support data-driven decision-making. The ideal candidate should have experience working with large datasets, ETL processes, and relational databases while ensuring data quality and performance.
Key Responsibilities
- Design, develop, and maintain ETL/ELT data pipelines.
- Write optimized SQL queries, stored procedures, and database objects.
- Develop Python scripts for data extraction, transformation, and automation.
- Work in Linux environments to manage scripts, cron jobs, and system processes.
- Monitor and troubleshoot data pipeline failures.
- Ensure data integrity, consistency, and quality across systems.
- Collaborate with data analysts, software engineers, and business stakeholders.
- Optimize database performance and query execution.
- Participate in code reviews and follow best engineering practices.
Required Skills
- Strong proficiency in SQL (joins, subqueries, window functions, CTEs, indexing, query optimization).
- Good programming experience in Python.
- Hands-on experience with Linux commands and shell scripting.
- Understanding of ETL/ELT concepts and data warehousing.
- Knowledge of relational databases such as PostgreSQL, MySQL, Oracle, or SQL Server.
- Familiarity with Git for version control.
- Strong problem-solving and analytical skills.
Designation SQL Database Administrator
LocationMohali, Chandigarh,
Job Description & Responsibilities
- Provide database monitoring and support of multiple 24/7 enterprise SQL Server always on availability groups.
- Troubleshoot issues as they occur, working with the Operations team during incidents, and resolving problems quickly and to a high standard.
- Maintain database performance by identifying and resolving production and application development problems, calculating optimum parameter values, evaluating
- new release code, answering developer questions and advising on code changes.
- Develop and configure database solutions, configuration of new systems, defining database structure, improving security, ensuring back-ups and restores meet audit requirements.
- Ensure all database systems meet RPO & RTO policies.
- Work with the Engineering Team to design and optimize SQL solutions.
- Work with the Operations Team to manage, install and configure servers in multiple data centres around the world.
- Update job knowledge by participating in educational opportunities, reading professional publications, maintaining personal networks, and participating in professional organizations.
- Ability to work closely with developers to resolve issues and improve systems.
- High level knowledge of Windows and Windows security and how they affect SQL Server.
- Knowledge of PowerShell scripting.
- Excellent analytical and problem-solving skills.
- Excellent written and verbal communication skills.
Education
- BE, B. Tech, M. Tech in Computer Science or equivalent.
Certifications
- Knowledge of Clustering.
- Knowledge of Database Migration.
- Knowledge of Database Mirroring.
- Knowledge of Log Shipping.
- Knowledge of Mirroring.
- Knowledge of Replication.
- Knowledge of SQL DBA.
Work Experience
- 05 to 08 years of experience as a SQL Database Administrator.
- Experience in Airlines or travel domain is a plus.
Skills
- Responsible for installation and configuration of SQL Server 2016/2017/2019.
- Scheduling jobs and job monitoring.
- Performing SQL Server upgrades, applying patches, and monitoring status.
- Manage user and role level security.
- Understanding and modifying existing stored procedures.
- Configured always On, log shipping and replication.
- Creating databases and logins with permissions in SQL Servers as developer's request.
- Implemented database standards and naming conventions for the database objects.
- Monitoring the databases as per the daily schedule tasks to check the health of databases using DBCC commands.
- Monitoring jobs like backup and restore check the error log for daily running batch jobs.
- Performance tuning high-level understanding.
- Troubleshooting issues high-level understanding.
Job Description
We are looking for an experienced Azure Synapse Data Engineer with strong hands-on expertise in Azure data engineering, data warehousing, ETL/ELT, and SQL performance optimization.
Key Responsibilities
- Design, develop, and optimize solutions using Azure Synapse Analytics.
- Build and maintain data integration pipelines using Azure Data Factory (ADF) and Synapse Pipelines.
- Design and implement scalable Azure Data Lake Storage Gen2 (ADLS Gen2) architectures.
- Develop robust and high-performance ETL/ELT frameworks for enterprise data platforms.
- Monitor and troubleshoot large-scale data ingestion, transformation, and processing workloads.
- Identify and resolve performance bottlenecks across data movement and transformation processes.
- Ensure data quality, availability, reliability, and consistency across analytics platforms.
- Perform advanced SQL query analysis and optimization.
- Analyze execution plans and optimize complex analytical workloads.
- Configure and tune Synapse Dedicated SQL Pools.
- Design efficient partitioning strategies for large datasets.
- Optimize indexing, statistics, and workload distribution to improve query performance.
Mandatory Skills
- Azure Synapse Analytics
- Azure Data Factory (ADF)
- Synapse Pipelines
- ADLS Gen2
- ETL/ELT
- Strong SQL
- Synapse Dedicated SQL Pool
- SQL query/execution plan optimization
- Partitioning, indexing, and statistics
- Azure data warehouse / data lake architecture
- Performance tuning and troubleshooting
Ideal Candidate
A strong Azure Data Engineer with hands-on experience in Synapse + ADF + ADLS Gen2 + Advanced SQL + Dedicated SQL Pool performance tuning.
Key Responsibilities
Design, develop, and maintain scalable applications using .NET Framework / .NET Core
Work with databases using MS SQL Server, Entity Framework, and Dapper
Build and consume RESTful APIs using ASP.NET MVC / Web API
Collaborate with front-end teams using HTML, CSS, JavaScript, Angular/React
Implement cloud solutions using Microsoft Azure (App Services, Azure SQL, Web Jobs, Automation)
Conduct code reviews and mentor junior developers
Ensure application performance, security, and scalability
Follow best practices for coding, testing, and deployment
Required Skills
Strong experience in C#, .NET Framework, .NET Core
Hands-on experience with MS SQL Server
Expertise in ASP.NET MVC, Web API
Proficiency in Entity Framework / Dapper
Experience with Git or similar version control systems
Front-end experience with Angular
Experience in project leadership or team handling






