SQL Database Developer

Role Overview: As a Software Engineer / Sr. Software Engineer at our company, your primary responsibility will be working with the development team to develop, implement, and manage database models for core product development. You will play a crucial role in writing SQL database views, tables, and stored procedures to support engineering product development. Additionally, you will be designing and maintaining SSIS, T-SQL, and SQL jobs, as well as developing and maintaining complex stored procedures for loading data into staging tables from OLTP and other intermediary systems. Your role will involve designing the partitioning of the database for Archive data and ensuring that best practices and standards are incorporated into Data Analytics solutions design. It will also be your responsibility to document complex processes, business requirements, and specifications. Key Responsibilities: - Work with the 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 - Design the partitioning of the database for Archive data - Ensure that best practices and standards are incorporated into Data Analytics solutions design - Document complex processes, business requirements, and specifications Qualifications Required: - Experience in database design, normalization, query design, and performance tuning - Proficiency in writing complex Transact SQL code - Proficiency 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, and Query execution plan - Ability to provide authentication and authorizations for the Database - Development of best practices for database design and development activities - Experience in database migration activities - Strong analytical, multi-tasking, and problem-solving skills Please note that the education qualification required for this position is any Graduate, with a minimum of 5 years of experience. The type of employment is permanent, and the location is Mumbai. The requirement for this position is immediate or within 15 days.,