- 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.
4o
functions,analytical skills,triggers,problem-solving,stored procedures,t-sql,multitasking,sql,excel power pivot/view/map,performance tuning,indexes,ssrs,views,transact-sql (t-sql),database migration,transact-sql,query plans,database design,query design,ssis