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

Requiremen...