The Role
Develops and manages database models for core products, including SQL views, tables, stored procedures, SSIS packages, T-SQL, and SQL jobs. Designs staging and archival data solutions, performs database analysis, migration, normalization, indexing, query tuning, and performance optimization. Supports authentication and authorization, establishes database development best practices, documents technical processes, and collaborates with engineering teams on data analytics solutions.
Summary Generated by Built In
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.
Skills Required
- Graduate degree or equivalent qualification: BE, B.Tech, B.Sc, M.Tech, MCA, or BCA
- At least 2 years of professional experience
- Experience with database design, normalization, query design, and performance tuning
- Proficiency writing complex Transact-SQL code
- Proficiency with Microsoft SQL Server query tuning
- Experience writing stored procedures, functions, views, and triggers
- Experience with indexes, columnstore indexes, SQL Server column storage, and query execution plans
- Ability to provide database authentication and authorization
- Experience developing database design and development best practices
- Experience with database migration activities
- Strong analytical, multitasking, and problem-solving skills
- Immediate availability or availability within 15 days
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Esyasoft is a global energy-transition technology group delivering integrated smart-utility solutions across software, analytics and AI, e-mobility, battery energy storage, and digital infrastructure. Its offerings help utilities, governments, and businesses modernize electricity, water, and gas infrastructure, improve operational visibility, optimize resources, and support cleaner energy systems through smart metering, IoT-driven platforms, intelligent infrastructure, and energy services for connected, sustainable energy networks.
