AYAN InfoTech is looking for SSIS Technical Architect to join an exciting project based in Melbourne. The role offers you the opportunity to contribute towards an extremely well structured and mature environment, working on sophisticated enhancement projects.Role: SSIS Technical Architect
Location: Melbourne
Contract Duration: 6 Months with high possible extensions
Experience: 7+ YearsTo ensure success as a Technical Architect, you should have extensive knowledge of enterprise networking systems, advanced problem-solving skills, and the ability to project manage. A top-class Technical Architect can design and implement any size system to perfectly meet the needs of the client.Required Skills & Experience:
- Design and develop complex ETL packages using Full/Incremental Load strategy Using Microsoft integrated services.
- Creating design Document/ Development of Framework and implementation checks in SSIS packages.
- Extensive knowledge and experience developing stored procedures, views and functions using Microsoft SQL Server.
- Troubleshoot issues related to package debugging, SQL performance, configuration.
- Azure DEVOPS Implementation for deploying SSIS Packages.
- Extensive knowledge in Azure Data factory Pipelines, Triggers, and configurations.
- Must have hands on experience in developing ADF pipelines , blob storage, link services , azure logs.
- Must have hands on experience in azure portal.
- Good Knowledge in Azure concepts like storage accounts, Key Vault, azure functions, Log analytics, Azure File storage concepts.
- Good experience in Azure SQL MI Management and configuration of failover Groups
- Knowledge on Database concepts (data base creation, data base restore using storage accounts etc., Backups)
- Knowledge on Database security Roles.
- Knowledge of DB Health check and performance tools.
- Should be able to analyse and optimize SQL queries and provide tuning recommendations time/CPU consuming queries if situation arises.
- Should interface with third party providers, plan and execute releases and hot fixes.
- Establish system administration processes for production support activities.
- System Integration testing and Support to user acceptance testing.
- Experience in development of c#.NET.
- Knowledge on Kingsway soft adaptor with Dynamics CRM is additional.
- Proficiency in git and source control systems.
- Able to provide Estimates and review development tasks based on the requirement.