Senior Software Engineer – SQL
Senior Software Engineer – SQL
Refined job description
ROLE
– Responsible to work with development team to develop, implement, and manage database 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.
– Perform analysis, design specifications, development, implementation, and maintenance of DB.
– Design partitioning of DB for archive data.
– Ensure best practices and standards for tools like SQL Server, SSIS, SSRS, Excel Power Pivot/View/Map are incorporated in Data Analytics solutions design.
– Document complex processes, business requirements and specifications.
REQUIREMENTS
– Minimum 2+ years of experience.
– Proficiency in MS SQL Server.
– Experience in database design, normalization, query design, and performance tuning.
– Proficient in writing complex Transact‑SQL code.
– Proficient in MS SQL Server query tuning.
– Experience writing stored procedures, functions, views, and triggers.
– Knowledge of indexes, columnstore index, SQL Server column storage, and query execution plans.
– Ability to provide authentication and authorizations for databases.
– Experience developing best practices for database design and development activities.
– Experience in database migration activities.
– Strong analytical, multi‑tasking, and problem‑solving skills.
Full 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.
I'm interested