MS SQL Server Developer

Job Title : Perl Developer

Experience : 6+ Years

Engagement Type : C2C (Contract)

Location : Remote

Shift Timing : General Shift

Job Summary :

We are seeking an experienced Perl Developer with strong scripting and database expertise to support an application modernization initiative.

The role involves code conversion for compatibility between Sybase and MS SQL, ensuring performance, reliability, and maintainability of mission-critical systems.

You will work closely with the engineering team to enhance, migrate, and optimize codebases written primarily in Perl, with partial transitions toward Python for long-term sustainability.

Mandatory Skills :

Perl, Python, T-SQL, SQL Server, ADO, Git, Release Management, Monitoring Tools, Automation Tools, CI/CD, Sybase-to-MSSQL Code Conversion

Key Responsibilities :

• Analyze and convert existing application code from Sybase to MS SQL for compatibility and optimization.
• Maintain and enhance existing Perl scripts and applications.
• Where feasible, refactor or rewrite legacy components into Python for improved scalability.
• Collaborate with development and release teams to ensure seamless integration and deployment.
• Follow established Git/ADO version control and release management practices.
• (Optional) Contribute to monitoring, alerting, and automation improvements.

Required Skills :

• Strong Perl development experience (primary requirement).
• Proficiency in Python for code conversion and sustainability initiatives.
• Hands-on experience with T-SQL / SQL Server for database interaction and optimization.
• Familiarity with ADO/Git and standard release management workflows.

Nice to Have :

• Experience with monitoring and alerting tools.
• Familiarity with automation tools and CI/CD pipelines.

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.

Primary Skills: Database Systems (SQL), Python Flask/Fast API/Django frameworks specifically
Requirements:

• Highly proficient in fundamentals of Python web development frameworks like Flask, Django and Fast API
• Demonstrated experience in developing APIs using Python frameworks
• Should have deep knowledge in PostgreSQL, MS SQL Server and other SQL based Databases
• Knowledge and proficiency in NoSQL is a bonus

Detailed JD: 

Responsibilities:

- Interface with product owners and software architects to review and finalize requirements

- Participate in the full SDLC including analysis, design, development, testing, deployment, and support

of new features and applications

- Actively lead and participate in agile ceremonies (Standups, Refinements, Retrospectives, Planning,

and Requirement discussions)

- Communicate effectively, clearly, and thoroughly with the Scrum Team and Stakeholders

- Provide innovative solutions to complex problems

- Design, develop and modify software applications/systems according to specifications

- Develop technical documentation including services, object, and data model

- Create high quality code and perform code reviews

- Create unit and integration tests to ensure the code quality and functionality

- Proactively learn and share knowledge of technology and compare advantages and disadvantages of

alternative solutions/technologies

- Identify areas needing process improvements and see them through to resolution

- Support and coach other Developers, provide technical guidance

- Help onboard new team members

Tech Stack:

C#, .NET Core, XUnit, Entity Framework Core, MS SQL Server, PostgreSQL, Git, JIRA, Web API

Technical Lead - .NET

Responsibilities:

• Develop and deliver technical systems
• Maintain adherence to architectural standards/principles, global product-specific guidelines, usability design standards, etc.
• Participate in the development and review of documents to comply with SDLC methodologies [e.g., Engineering Work Breakdown Structure (WBS), estimation, Solution Design Document (SDD) and Software Architecture Documents (SAD)]
• Provide support and documentation to assist in sustaining the project during the transition to production where necessary
• Adhere to Application Engineering methodologies, standards, code reviews
• Provide feedback regarding application engineering methodologies, standards, and leading practices when appropriate
• Identify potential points of contention for missed activities and notify project leadership of situation and remediation plan
• Minimize technical exposure and risk on projects
• Provide technical guidance to development team members
• Technical deliverables (i.e., code and documentation) on projects assigned
• Translate detailed Requirements and Design and Solution Architecture deliverables into detailed design specifications
• Maintain effective and consistent communication within the team, with peers, the leadership team, and the peers in other IT groups
• Proactively raise issues to Technical and Group Leads when necessary
• Produce high-quality application engineering deliverables in accordance with the project timeline
• Build and unit test a project to detailed design specifications
• Provide thought leadership and technical guidance to engineering staff
• Review of code completed
• Review performance of developers
• Proactively anticipate project issues before they occur; define the problem; identify possible causes; work with the team to identify solutions; select and implement the most appropriate solution
• Apply judgment in implementing Application Engineering methodologies, processes, and practices to specific requirements of projects/programs which may include product design engineering, information security, code maintainability and reliability

Requirements:

Must Have:

• Bachelor’s OR master’s degree in a technical field and/or equivalent work experience
• At least 3 years acting a senior architecture / technical lead role in a comparable organization
• Significant experience of deploying large, enterprise-wide implementations to significant user volumes
• At least 5 years of hands-on experience leading a team of developers - defining work breakdown structures/tasks, assigning the teamwork items, monitoring, and ensuring quality and adherence to standards etc.
• At least 8 years of relevant hands-on work experience building, integrating, and delivering enterprise-wide web and windows applications using Microsoft and other technologies for large organizations on complex projects
• 8+ years of ASP.Net MVC, ASP.Net experience
• 8+ years of experience of working with applications that have a SQL Server backend
• 5+ years of experience with Object-Relational Mappers such as Entity Framework, ADO.NET, Dapper
• Expert level knowledge of .NET Web API is required. .NET Core knowledge is preferred, but Web API experience with legacy .NET is ok
• 5+ years of experience with GIT
• 3+ years of experience of Azure Devops
• In-depth knowledge of object-oriented analysis and design (OOAD) principles, and familiarity with many design patterns for Software applications.
• Demonstrated expertise in application design and construction, work breakdown structure of items, design and code reviews, unit test and build activities, deployment and performance related activities, documentation, support, and training/mentoring
• Excellent communication skills, verbal and written

Nice to have:

• Ideally experience working with SSRS, SSIS
• Experience with MongoDB or another document database would be a plus
• Knowledge and experience with working on N-Tier applications.
• Demonstrated ability to build strong working relationships
• Experience working on projects following Agile methodologies would be ideal
• Experience working with Azure or other cloud providers would be ideal
• Ability to work within diverse, global, virtual teams.
• Proven ability to thrive under pressure
• Some experience with design and prototyping tools and diagramming is desired

We are looking for a Senior Microsoft SQL Developer to design, develop, test, plan, implement and maintain conceptual and logical database models.

For this role, you should know how to analyze system requirements and implement migration methods for existing data. Hands-on experience with SQL Server 2012 and above is also required. Ideally, you are familiar with database design, reviewing code, writing stored procedures, creating and modifying SQL agent jobs, making structural changes to tables and views.

Ultimately, you will develop database solutions to ensure project information is stored effectively and securely.

We’re a fast-growing company with clients in the United States, UK, and Australia. You will join a team of talented developers, quality engineers, product managers whose mission is to impact above 100 million people across the world with technological services by the year 2030.

Working as Senior Microsoft SQL Developer at Navtech, you will:

1. Design conceptual and logical data models and flowcharts.
2. Improve system performance by conducting tests, troubleshooting, and integrating new elements.
3. Design and Build database systems of high availability and quality depending on each end user’s specialized role.
4. Help write and optimize in-application SQL statements.
5. Handle common database procedures such as upgrade, backup, recovery, migration, etc.
6. Ensure performance, security, and availability of databases.
7. Use high-speed transaction recovery techniques and backup data.
8. Provide proactive and reactive data management support and training to users.
9. Determine, enforce and document database policies, procedures, and standards.
10. Perform tests and evaluations regularly to ensure data security, privacy, and integrity.
11. Monitor database performance, implement changes, and apply new patches and versions when required.

1. 5+ years of experience in SQL Server Development with at least 1 year of Lead experience.
2. Advanced experience in database monitoring, troubleshooting, performance tuning, and high availability strategies for SQL Server 2016, SQL Server in Cloud (AWS RDS preferred).
3. Advanced skills in resolving database locking conflicts/blocking and resource utilization.
4. Ability to work with other developers and engineers to analyze database performance and identify problems in areas such as execution plans, index coverage, and SQL server statistics.
5. A thorough understanding of Performance Monitoring, Tuning, and Optimization, using native and third-party monitoring and troubleshooting tools.
6. Advanced knowledge of SQL Server Disaster Recovery (DR) options, Always On availability groups, and experience administering Windows Server, including Active Directory, Failover clustering, database partitioning, security, and encryption (a plus).
7. Experience supporting SSIS, SSRS, replication, database mirroring (a plus).
8. PowerShell scripting experience with the ability to write automated scripts and strong knowledge of system tables and DMV’s is required. (a plus).
9. Administering Microsoft SQL Server databases in a high transaction, 24x7 database environment (a plus).
10. Experience in Postgres, No-SQL databases (a plus).
11. MCSA SQL Server 2012/2016 , MCSE or MCDBA (a plus).
12. Should have excellent logical, analytical, and communication skills with client interaction experience.

Benefits

• Working with industry giants while following your passion for technology.
• Competitive pay package with additional bonus and benefits.
• Performance review and Appraisal Twice a year.
• Family Health Insurance cover for self and family.
• Work with US, UK, and Europe-based industry-renowned clients for exponential technical growth.
• Work with a culturally diverse team from different geographies