Senior Software Engineer - SQL

Esyasoft Holding; Indor; On-site; INR 400,000 - 700,000; Full time

Job summary

Esyasoft Technologies Private Limited is seeking a SQL Database Developer with 2+ years of hands-on experience. You will design, implement, and optimize SQL Server-based data models, write advanced T-SQL, and maintain SSIS, SSRS, and related jobs to support product development.

Responsibilities include crafting complex stored procedures, ensuring performance, and documenting system requirements and processes. Immediate joiners preferred.

Qualifications

• Graduate degree in a relevant field and 2+ years of experience in DB development.
• Strong proficiency in MS SQL Server, complex T-SQL, and stored procedures.

Responsibilities

• Develop and manage database models for core product development.
• Write complex T-SQL, views, tables, and stored procedures to support engineering.
• Design and maintain SSIS/SSRS processes and SQL jobs.
• Analyze, design, and maintain database systems; ensure data integrity and performance.
• Document complex processes, requirements, and specifications.

Skills

MS SQL Server

Transact-SQL

Query tuning

Education

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

Tools

SSIS

SSRS

Power Pivot

Power View

Power Map

Job description

Esyasoft Technologies Private Limited | Full time

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.