Job Description
- 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...