T-SQL/SSIS Expert (Hybrid 2 days)

Job Description:

We are in search of a seasoned Senior T-SQL and SSIS Specialist, possessing a minimum of 10 years of experience in T-SQL. The candidate will play a pivotal role in designing, developing, and maintaining advanced SQL Server solutions, contributing significantly to our business goals.

Key Responsibilities:

1. Develop, optimize, and maintain advanced T-SQL queries, stored procedures, functions, and views for complex data manipulation and retrieval.
2. Design and implement sophisticated data integration and ETL processes using SQL Server Integration Services (SSIS).
3. Ensure optimal performance and efficiency of SQL queries and SSIS packages.
4. Collaborate effectively with cross-functional teams to translate business needs into technical solutions.
5. Conduct advanced database tuning and query optimization.
6. Maintain comprehensive documentation for all database designs, coding, and maintenance processes.
7. Provide expert-level support and troubleshooting for SQL Server and SSIS-related issues.
8. Stay abreast of the latest developments in SQL Server technologies and best practices.

Qualifications:

1. Bachelor’s degree in Computer Science, Information Technology, or related field.
2. A minimum of 10 years of experience in T-SQL programming.
3. Extensive experience with SQL Server Integration Services (SSIS).
4. Strong understanding of SQL Server database architecture and performance tuning.
5. Demonstrated analytical and problem-solving abilities.
6. Excellent communication skills and ability to work collaboratively.
7. SSRS is a plus