Position: Data Warehouse/BI Architect
Company: TEAM International
Experience required: 5y
English level: upper

Job Duties:
●	Broad technical background, a strong DB Architect track record, and expert knowledge of Microsoft SQL Server including SQL 2008/R2, 2014 and 2016.
●	Perform performance optimization and tuning on new and/or existing data warehouse implementations
●	Development of automated database maintenance utilities
●	Ability to write SQL scripts, procedures, functions
●	Develop methods for integrating different products so they work properly together to fit specifications.
●	Collaborate with system architects, software architects
●	Demonstrate database technical functionality, such as performance tuning, backup, and recovery, monitoring.
●	Design databases for business solutions, scalability, security, compliance, performance, and reliability.
●	Strong problem solving, organizational, and communication skill
●	Database troubleshooting, database architecture, capacity.
●	SQL Scripting with complex SQL queries.
●	Prepare a design for all metadata according to various ETL processes
●	Designing Architecture for ETL/SSIS packages, SSISDB, and Designing SSIS packages with different data sources (SQL, Flat files and XMLs etc.) and loaded the data into target source by performing different kinds of transformations.
●	Experience with large tables over 50M-100M rows.
●	Experience with source control using SVN for SSIS projects
●	Development and Deploying of the SSRS reports using reporting services.
●	Maintain Alerts, notifications, Jobs, Job schedules. Monitor connections and locks and performance of SQL server to track historical peak load on servers and proactively manage them.
●	Creating and maintaining Audits, stored procedures and user-defined functions as per client requirements and creating database triggers for automation.
●	Knowledge/experience with No SQL databases, Power BI, Azure/AWS cloud

This position requires a minimum of a Bachelor’s degree in computer science, computer information systems, information technology. 5 years of experience in a data architecture role.