Senior Software Engineer – SQL

Growth For Impact; Bengaluru; On-site; INR 500,000 - 900,000; Full time

Job summary

Growth For Impact in Bengaluru, India, seeks a DB Developer to collaborate with the product team to design, implement, and manage database models for core product development. You will write SQL views, tables, and stored procedures to support engineering work.

You will also design and maintain SSIS, T-SQL, and SQL jobs, optimizing data flows across OLTP and staging areas. You will develop and maintain complex stored procedures for loading data, perform analysis, and ensure best practices for SQL

Qualifications

• 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 developing best practices for database design and development activities.
• Experience in database migration activities.
• Strong analytical, multi- tasking, and problem-solving skills.

Responsibilities

• 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.

Skills

Analytical thinking

Problem-solving

Multi-tasking

Strong analytical

Tools

MS SQL Server

T-SQL

SSIS

SSRS

Excel Power Pivot/View/Map

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.