Develop and optimize complex T-SQL queries to extract and manipulate data from multiple databases using joins and grouping techniques.
Design, create, and maintain complex, parameterized SSIS packages, including managing transactions and generating configuration scripts for deployments.
Develop and maintain SSRS reports using stored procedures, ensuring proper formatting and delivery through standard and data-driven subscriptions.
Utilize source control systems for code versioning, including branching, merging, and shelving strategies.
Create and maintain documentation for database objects, processes, packages, and reports in accordance with internal standards.
Apply SQL Server cumulative updates and ensure compliance with project plans and industry standards.
Adhere to internal policies, procedures, and best practices.