Database Design And Development
Architect and implement relational database models, schemas, and tables using industry best practices for normalization and performance.
Write complex stored procedures, triggers, views, and user-defined functions to support application logic.
Proactively identify and resolve performance bottlenecks through index optimization, query refactoring, and execution plan analysis.
Design and maintain robust Data Integration/ETL processes using SSIS (SQL Server Integration Services) to consolidate data from disparate sources.
Implement and manage security protocols, including encryption, data masking, and granular access controls, to protect sensitive information.
Develop and optimize complex reports using SSRS (SQL Server Reporting Services) or Power BI to provide actionable business insights.
