Senior Software Engineer - SQL

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

Job summary

Esyasoft is seeking a SSE to design and optimize database solutions. The role focuses on SQL Server-based data models, stored procedures, and ETL processes supporting core product development. You will work closely with the development team to ensure scalable, well-documented data architecture.

The ideal candidate has 2+ years of experience and a strong foundation in T-SQL, SSIS, and database performance tuning. Immediate or near-term joining is preferred.

Qualifications

• Experience in database design, normalization, query design, performance tuning.
• 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.

Responsibilities

• Work with development team to develop, implement, and manage data base models for core product development.
• Write SQL database views, tables, and stored procedures to support engineering product development.
• Design and maintain SSIS, T-SQL, and SQL jobs.
• Develop and maintain complex stored procedures for loading data into staging tables from OLTP and other intermediary systems.
• Analyze, design specifications, development, implementation, and maintenance of DB.
• Design partitioning of DB for Archive data.
• Ensure best practices and standards for SQL Server, SSIS, SSRS, Excel Power Pivot/View/Map in analytics solutions.
• Document complex processes, business requirements and specifications.

Education

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

Tools

MS SQL Server

Job description

Job Description:

Position: SSE

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

• Experience in database design, normalization, query design, performance tuning
• 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.