Senior Software Engineer - SQL

Esyasoft Technologies Private Limited; Thiruvananthapuram; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Esyasoft Technologies Private Limited is seeking a Senior Software Engineer - SQL in Trivandrum to join the data engineering team. The role focuses on building and optimizing database models for core product development, with emphasis on SQL Server, SSIS, and SSRS.

You will write complex Transact SQL, develop stored procedures, and ensure robust data loading into staging areas from OLTP systems. The position requires 2+ years of relevant experience and a relevant graduate degree.

Qualifications

• Graduate degree in a technical field (e.g., BE/B.Tech, BSc, MCA).
• 2+ years of experience in SQL-based data engineering or database development.
• Strong SQL Server knowledge, including T-SQL, SSIS, and SSRS.

Responsibilities

• Develop, implement, and manage database models for core product development.
• Write complex SQL queries, views, and stored procedures to support engineering products.
• Design and maintain SSIS packages, T-SQL scripts, and SQL jobs.
• Develop and maintain stored procedures for loading data into staging areas from OLTP systems.
• Document complex processes, business requirements, and specifications.
• Ensure best practices in database design, development, and security.
• Collaborate with development teams to support data analytics initiatives.

Skills

SQL

Analytical thinking

Education

BE/B.Tech/B.Sc/M.Tech/MCA/BCA

Tools

MS SQL Server

SSIS

SSRS

T-SQL

Job description

Esyasoft Technologies Private Limited | Full time

Senior Software Engineer - SQL

Trivendrum, India | Posted on 10/26/2026

Education Qualification: Graduate (BE/B.Tech/B.Sc/M.Tech/MCA/BCA)

Minimum Years of Experience: 2+ Years

Key Skills: MS SQL Server

Requirement: Immediate or Max 15 days

Job Responsibilities:

• Responsible to work with development team to develop, implement, and manage data base models for core product development.
  
• Responsible to write SQL database views, tables, and stored procedures to support engineering product development.
  
• Responsible for designing and maintaining SSIS, T-SQL, and SQL jobs.
  
• Responsible for developing and maintaining complex stored procedures for loading data into staging tables from OLTP, and other intermediary systems.
  
• Responsible for analysis, design specifications, development, implementation, and maintenance of DB.
  
• Responsible for designing partitioning of DB for Archive data.
  
• Responsible to ensure that the best practices and standards established for the use of tools like SQL Server, SSIS, SSRS, Excel Power Pivot/View/Map are incorporated in Data Analytics solutions design.
  
• Responsible for documenting complex processes, business requirements and specifications.
  

Requirements

• Proficient in writing complex Transact SQL code.
  
• Proficient in MS SQL Server query tuning.
  
• Experience in writing stored procedures, functions, views and triggers.
  
• Experience in Indexes, column store index, SQL server column storage, Query execution plan.
  
• Provide authentication and authorizations for Database.
  
• Develop best practices for database design and development activities.
  
• Experience in database migration activities.
  
• Strong analytical, multi-tasking and problem-solving skills.