Taio Connect
Responsibilities • and Duties • Data Warehouse & Architecture • • Design, build, and maintain SQL-based data warehouses on-premises (SQL Server) and • in the cloud (Azure SQL / Azure SQL Managed Instance) • • Develop and manage dimensional models, star/snowflake schemas, and metadata to • support enterprise reporting • • Define data architecture standards and ensure alignment with business intelligence Requirements • ETL / Integration Pipeline Development • • Design, develop, and maintain ETL pipelines using Azure Data Factory (ADF) and SQL • Server Integration Services (SSIS) via Visual Studio • • Manage data ingestion from multiple source systems, ensuring reliability, scheduling, • and error handling • • Collaborate with engineering teams to integrate new data sources and evolve existing • Database Administration & Performance • • Create, maintain, and monitor highly available, high-performance database • environments • • Write and optimize complex T-SQL queries, stored procedures, views, and functions • • Approve and manage database schema and procedure changes; enforce change control • • Minimize downtime through proactive monitoring, tuning, and parameter management • • Implement backup strategies and high-speed transaction recovery procedures • • 5+ years of hands-on experience as a DBA or Data Engineer in Microsoft environments • • Expert-level proficiency in Microsoft SQL Server (on-premises) and Azure SQL • • Advanced T-SQL skills: complex query writing, stored procedures, indexing strategy, • and query optimization • • Proven experience designing and building data warehouses (star/snowflake schemas, • dimensional modelling) • • Hands-on experience with Azure Data Factory (ADF): pipeline design, triggers, linked • services, data flows • • Experience developing and deploying SSIS packages using Visual Studio • • Strong understanding of database security, access control, and compliance best • • Track record of proactive performance monitoring, tuning, and incident management • Nice-to-Haves • • Experience with Azure SQL Managed Instance, including security configuration and • feature management • • Familiarity with Microsoft Automatic Tuning and Query Store • • Exposure to Azure Synapse Analytics or other Azure analytics services • • Experience with source control for database objects (e.g., Git-based DevOps workflows) • • Knowledge of enterprise reporting tools such as Power BI or SSRS
Taio Connect
