SSIS Administrator/Developer

We are seeking a highly motivated and experienced SQL Server Administrator with a strong understanding of data integration and DevOps principles. The ideal candidate will have a deep knowledge of SQL Server Administration, SSIS, SSAS, SSRS, and Linux scripting, as well as a proven ability to design, develop, and maintain complex data integration solutions. They will also be responsible for implementing and managing DevOps practices to ensure the efficient and reliable delivery of data solutions.

Responsibilities:

• Experience with data warehousing and business intelligence.
• Design, develop, and maintain SSIS packages for data extraction, transformation, and loading (ETL) processes.
• Design and implement SSAS cubes and SSRS reports for data analysis and reporting.
• Manage and optimize SQL Server databases, including performance tuning and security.
• Implement and manage DevOps practices, including continuous integration and continuous delivery (CI/CD).
• Automate tasks using Linux scripting.
• Write complex SQL queries for data analysis and reporting.
• Troubleshoot and resolve data integration and database issues.
• Monitor and maintain data quality.
• Collaborate with other team members to develop and implement data solutions.
• Stay up-to-date on the latest data integration and DevOps technologies and trends.

Qualifications:

• 3+ years of experience as a SQL Server Administrator or in a similar role.
• Strong understanding of SQL Server, SSIS, SSAS, SSRS, and Linux scripting.
• Experience with designing, developing, and maintaining complex data integration solutions.
• Experience with implementing and managing DevOps practices.
• Strong understanding of SQL Server and T-SQL.
• Excellent communication and interpersonal skills.
• Ability to work independently and as part of a team.

Soft Skills:

• Excellent communication skills, both written and verbal.
• Strong interpersonal skills and the ability to build relationships with colleagues, clients, and stakeholders.
• Ability to work effectively in a team environment and collaborate with others to achieve common goals.
• Strong problem-solving skills and the ability to think critically and creatively to find solutions to complex problems.
• Ability to manage time effectively and prioritize tasks to meet deadlines.
• Ability to work independently and take initiative.
• Strong attention to detail and accuracy.
• Ability to adapt to change and learn new skills quickly.