Responsibilities
Collaborate 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 packages, T-SQL scripts, and SQL Server Agent 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 databases.
Design database partitioning strategies for archiving data.
Ensure best practices and standards for tools like SQL Server, SSIS, SSRS, Excel Power Pivot/View/Map are incorporated into data analytics solution design.
Document complex processes, business requirements, and technical specifications.
Technical Skills
Experience in database design, normalization, query design, and performance tuning.
Proficient in writing complex Transact-SQL (T-SQL) code.
Skilled in MS SQL Server query tuning.
Experience writing stored procedures, functions, views, and triggers.
Knowledge of indexes, columnstore indexes, SQL Server column storage, and query execution plans.
Experience providing authentication and authorization for databases.
Ability to develop best practices for database design and development activities.
Experience in database migration activities.
Strong analytical, multitasking, and problem-solving skills.
or continue with email
Collaborate 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 packages, T-SQL scripts, and SQL Server Agent 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 databases.
Design database partitioning strategies for archiving data.
Ensure best practices and standards for tools like SQL Server, SSIS, SSRS, Excel Power Pivot/View/Map are incorporated into data analytics solution design.
Document complex processes, business requirements, and technical specifications.
Technical Skills
Experience in database design, normalization, query design, and performance tuning.
Proficient in writing complex Transact-SQL (T-SQL) code.
Skilled in MS SQL Server query tuning.
Experience writing stored procedures, functions, views, and triggers.
Knowledge of indexes, columnstore indexes, SQL Server column storage, and query execution plans.
Experience providing authentication and authorization for databases.
Ability to develop best practices for database design and development activities.
Experience in database migration activities.
Strong analytical, multitasking, and problem-solving skills.
Sign in
To continue your applicationor continue with email
By continuing you agree to our Terms & Privacy Policy.
Similar jobs
Show more
