Senior Software Engineer - SQL

Esyasoft; Indore District; On-site; INR 450,000 - 850,000; Full time

Job summary

Esyasoft in Indore, Madhya Pradesh, invites a Graduate with 2+ years of experience to join as SSE. The role centers on database development, SQL server, complex queries, views, stored procedures, and data analytics oriented tasks.

The candidate will collaborate with the development team to design and implement database models, optimize performance, and ensure best practices for SQL Server, SSIS, and related tools in product development.

Qualifications

• Graduate with BE/B.Tech/BSc/MTech/MCA/BCA
• 2+ years of experience required
• Proficient in MS SQL Server and SQL development
• Experience with SSIS, T-SQL, and stored procedures
• Ability to design and maintain DB schemas and performance tuning

Responsibilities

• Develop, implement, and manage database models for core product development
• Write SQL views, tables, and stored procedures to support engineering tasks
• Design and maintain SSIS, T-SQL, and SQL jobs
• Develop and maintain complex stored procedures for loading data into staging tables
• Document complex processes, requirements and specifications
• Ensure best practices for SQL Server tools are followed

Skills

MS SQL Server

T-SQL

SSIS

Stored Procedures

Database Design

Performance Tuning

Education

BE/B.Tech/BSc/MTech/MCA/BCA

Tools

SSRS

Excel Power Pivot

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.