Power BI with Dynamics

Key Responsibilities:
• Develop, optimize, and maintain stored procedures, views, functions, and other SQL Server database objects.
• Analyze and troubleshoot slow-running queries and implement performance tuning techniques (e.g., indexing, query refactoring, statistics updates).
• Collaborate with developers, data analysts, and stakeholders to gather requirements and build scalable database solutions.
• Monitor and ensure database performance, security, and reliability.
• Support ETL processes and data workflows as needed.
• [If applicable:] Participate in database design and architecture planning for new applications or enhancements.
• Nice to have: Assist with Power BI data modeling, DAX optimization, and report performance tuning.
________________________________________
Requirements:
• Strong proficiency in SQL Server (T-SQL) and query performance tuning.
• Solid understanding of database indexing, execution plans, and normalization/denormalization strategies.
• Experience working with large datasets in a high-performance environment.
• Ability to troubleshoot and resolve complex database issues independently.
• Excellent problem-solving skills and attention to detail.
• Strong communication skills and a collaborative mindset.
________________________________________
Nice to Have:
• Experience with Power BI dashboards and DAX queries.
• Familiarity with Power BI dataset optimization and gateway configuration.
• Knowledge of data warehousing concepts and dimensional modeling.
• Experience with version control tools (e.g., Git) in a database context