A very experienced database designer and developer, with over 20 years of high level Microsoft SQL focus. Skillset:MS SQL - Design and development. My long experience of developing systems for clients and through product development during my contract work has given me a strong and in-depth knowledge of database design, analysis. Azure Cloud Services - Data Factory (v1/v2), Data Lake (Gen 1/Gen 2), Azure SQL Server. Building enterprise level Pipelines to extract from multiple sources.T-SQL - Many years of experience in building complex SQL scripts for systems development, ETL processes and for data analysis. The contracting and Project work have ensured I have made use of some of the more up-to-date features of MS SQL. SSIS - Through my work in contracts and projects through existing clients, I have developed a good commercial understanding of SSIS package design, development and deployment. This work has ranged from simple loads to complex overnight ETL warehousing processes.MS ACCESS (VBA) - Many years designing and developing systems using Access and VBA. Particularly with links to SQL databases. Complex program design with project work that has linked Access to APIs and other web based services. Also, a lot of exposure to XML based development.I have also had good exposure to the Azure platform and have supported product development teams in creating processes for Azure Event hubs and Streaming Analytics.Contact me through LinkedIn.
Listed skills include Databases, Microsoft Sql Server, Database Design, Sql, and 42 others.