Understanding of PowerBI dashboards and how to configure those datasets to leverage SQL queries and views.
- Must have experience developing Power BI DAX expressions for reporting and data analysis
-Â Develop and support reporting and ETL solutions using SSRS, SSIS, and Power BI.Â
- Develop, maintain, and enhance Power BI dashboards, reports, and semantic datasets to support enterprise reporting and analytics.
- Develop Power BI DAX measures, calculated columns, and data models to deliver business intelligence solutions.
-Â Connect SQL Server data sources to Power BI using optimized SQL queries, stored procedures, and views.
- Experience developing or supporting ETL processes, data integration, and enterprise reporting solutions.Â
Design, write, optimize, and maintain complex TSQL queries, stored procedures, views, and database scrips to support business applications and reporting needs.
Manage and monitor the performance of TSQL databases, seeking improvements through performance and query tuning
Create, manage, and continually improve TSQL Server maintenance plans through monitoring of queries, indexes, and TSQL statistics
Create, manage, maintain, and improve backup, restore, and replication schedules driven by end user events and processes
When required, manage and monitor the performance of cloud-based databases within AWS.
Support the deployment of new databases and schema objects as needed in the on-premises and cloud environment.
Monitor and maintain databases to ensure stability and optimal performance.
Ensure that databases are secure and adhere to industry standards.
Analyze and troubleshoot database issues and take necessary actions to resolve them.
Generate reports to measure database performance, utilization, and growth.
Plan and implement database activities including upgrades and patching.