SQL Server Developer/ Lead

As a Database 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. Additionally, you will design and maintain SSIS, T-SQL, and SQL jobs while developing complex stored procedures to load data into staging tables from OLTP and intermediary systems. Your role will involve database analysis, design, implementation, and maintenance. You will be expected to design partitioning strategies for archiving data and ensure adherence to best practices for tools like SQL Server, SSIS, SSRS, and Excel Power Pivot/View/Map in data analytics. It will also be part of your duties to document complex processes, business requirements, and technical specifications. In terms of 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 is essential. You should also be skilled in indexes, query execution plans, and database migration. Strong analytical, multitasking, and problem-solving abilities are highly valued in this role. Key Skills: performance tuning, stored procedures, triggers, SQL, Transact-SQL (T-SQL), data analytics, SSIS, query execution plans.,