Job
Description
Role Overview: As a SQL Server Developer, you will be responsible for working with the development team to develop, implement, and manage database models for core product development. You will also be involved in writing SQL database views, tables, and stored procedures to support engineering product development. Additionally, you will design and maintain SSIS, T-SQL, and SQL jobs, and develop complex stored procedures for loading data into staging tables from OLTP and other intermediary systems. Your role will also involve designing partitioning of the database for Archive data and ensuring that best practices and standards are incorporated into Data Analytics solutions design. Moreover, you will be required 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 partitioning of the database for Archive data. - Ensure best practices and standards are incorporated into Data Analytics solutions design. - Document complex processes, business requirements, and specifications. Qualification Required: - Education Qualification: Any Graduate - Minimum Years of Experience: 2-3 Years - Technical Skills: - 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 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 (Note: Details regarding the company were not provided in the job description.) Role Overview: As a SQL Server Developer, you will be responsible for working with the development team to develop, implement, and manage database models for core product development. You will also be involved in writing SQL database views, tables, and stored procedures to support engineering product development. Additionally, you will design and maintain SSIS, T-SQL, and SQL jobs, and develop complex stored procedures for loading data into staging tables from OLTP and other intermediary systems. Your role will also involve designing partitioning of the database for Archive data and ensuring that best practices and standards are incorporated into Data Analytics solutions design. Moreover, you will be required 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 partitioning of the database for Archive data. - Ensure best practices and standards are incorporated into Data Analytics solutions design. - Document complex processes, business requirements, and specifications. Qualification Required: - Education Qualification: Any Graduate - Minimum Years of Experience: 2-3 Years - Technical Skills: - 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 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 (Note: Details regarding the company were not provided in the job description.)
