Database Developer
Administration of Microsoft SQL Server 2019 in a shared in-house hybrid environment with external Microsoft SQL Data Warehouse Azure servers. Responsible for running and maintaining scripts that check databases regarding client shifts and providing fixes for issues found. Ported functions from Microsoft CRM 2015 to Azure Data Warehouse architecture successfully in winter of 2020. Combined three database schemas in creating master "views" in the Data Warehouse. This currently allows for the reports team to access up-to-date information with ease in using Microsoft Power-Bi. Assisted with tax preparation, tax exclusions, tax adjustments using SQL scripts that are maintained and or created for the Microsoft Dynamics 365 / CRM databases as well as other in house databases, provided support on the relationship of information between these databases. Assisted with creation of databases, production servers, development databases, test and production setups and user access. Responsible for trimming database logs, cleaning up indexes, measuring database size and requesting space when anticipating overall database growth.