MSBI SQL Developer / Admin
Roles & Responsibilities
· Develop complex store procedures, efficient triggers, required functions, creating indexes and indexed views for performance. Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
· Design and develop interactive reports and dashboards using SSRS (SQL Server Reporting Services) and Power BI.
· Ensure BI solutions are scalable, maintainable, and meet performance standards.
· Work closely with business stakeholders to gather and analyze requirements.
· Collaborate with cross-functional teams to ensure seamless integration of BI solutions with existing systems.
· Provide technical guidance and mentorship to junior developers and team members.
· Conduct code reviews and ensure adherence to best practices and coding standards.
Requirement:
· Experience in Database Design, Development, Implementation and Support using various Database technologies (SQL Server 2012/2016/2019 T - SQL, Azure Big Data) in OLTP, OLAP and data warehousing environments.
· Expertise in Microsoft Dynamics CRM Data Migration and performance tuning. In-depth knowledge of data mapping, warehousing tools, unit testing, process documentation and data mapping.
· Experience in managing Batch Jobs in Control M.
· Experience in Enterprise Resource Planning system using Microsoft Dynamics.
· Rich experience in Retail / Wholesale Banking Domain.
· Experience with Agile/Scrum methodologies is a plus.
Non-Technical Skills
· Flexible to support during off business hours as per client requirement.
· Excellent problem-solving skills and attention to detail.
· Strong communication and interpersonal skills, with the ability to work effectively in a team environment.