Responsibilities:
· Currently, the DEQ enterprise is a complex, multi-platform data environment.
· Technologies in use include Oracle, DB2, MySQL, and SQL Server, as well as desktop-based applications such as MS Access and MS Excel.
· DEQ aims to establish an enterprise data model with a primary goal of standardizing shared data entities and attributes and a secondary goal of standardizing database management systems and tools.
· Related transactional databases and data warehouses will be hosted in Azure.
· The Database Analyst will provide subject matter expertise on Microsoft Dataverse and SQL Server, as well as Microsoft ADF and SSIS.
· You will provide operational insights to other data analysts/architects and application developers on issues related to implementing and administering relational databases in the Azure environment.
Required:
· Hands on experience with database administration with Azure SQL server and Microsoft Dataverse.
· Hands on experience with Azure Data Factory and Microsoft SSIS ETL tools.