POSITION SUMMARY
Responsible for overseeing the Azure SQL Power BI database to ensure that it runs both effectively and efficiently. As well as managing installation, configuration, and maintenance of all relational database instances across development, staging, and production environments.
ESSENTIAL DUTIES AND RESPONSIBILITIES include the following. Other duties may be assigned.
- Create and maintain Power BI Workspaces, Security, Content and Datasets for all areas of the organization using various data sources. (SQL, SharePoint, Excel and others)
- Confirm SQL configuration and maintenance meet SLA goals when designed and executed.
- Provide guidance and adjustments on database design, tuning options, and other possible issues.
- Completing such tasks as: Baseline system performance, monitoring for deviation, and recommend and implement improvements to slow running queries.
