- Collaborate with the development team to develop implement and manage database models for core product development.
- Write SQL views tables and stored procedures to support product engineering.
- Design and maintain SSIS TSQL and SQL jobs.
- Develop complex stored procedures to load data into staging tables from OLTP and intermediary systems.
- Handle database analysis design implementation and maintenance.
- Design partitioning strategies for archiving data.
- Ensure adherence to best practices for tools like SQL Server SSIS SSRS and Excel Power Pivot/View/Map in data analytics.
- Document complex processes business requirements and technical specifications.
Technical Skills:
- Proficient in database design query design and performance tuning.
- Expertise in complex TransactSQL code stored procedures functions views and triggers.
- Skilled in indexes query plans and database migration.
- Strong analytical multitasking and problemsolving abilities.
performance tuning,stored procedures,triggers,sql,transact-sql (t-sql),t-sql,data analytics,ssis,query plans