SQL Server Developer

You will collaborate closely with the development team to develop, implement, and manage database models for core product development. Your responsibilities will include writing SQL views, tables, and stored procedures to support product engineering. You will also design and maintain SSIS, T-SQL, and SQL jobs, as well as develop complex stored procedures to load data into staging tables from OLTP and intermediary systems. Additionally, you will be responsible for database analysis, design, implementation, and maintenance, including designing partitioning strategies for archiving data. It will be crucial for you to ensure adherence to best practices for tools like SQL Server, SSIS, SSRS, and Excel Power Pivot/View/Map in data analytics. Furthermore, documenting complex processes, business requirements, and technical specifications will be an essential part of your role. As for the required technical skills, you should be proficient in database design, query design, and performance tuning. Expertise in complex Transact-SQL code, stored procedures, functions, views, and triggers will be necessary. You should also be skilled in indexes, query execution plans, and database migration. Strong analytical, multitasking, and problem-solving abilities will also be beneficial for this role. In summary, the ideal candidate for this position should possess a strong background in SQL, indexes, stored procedures, Transact-SQL, SQL Server, performance tuning, SSRS, data analytics, database design, SSIS, functions, triggers, query execution plans, query design, and database migration.,