About the job
- Database Design: Lead the design and implementation of relational database architectures, schemas, and tables, ensuring adherence to industry best practices for normalization and high performance.
- Advanced Development: Craft intricate stored procedures, triggers, views, and user-defined functions that enhance application functionality.
- Performance Tuning: Proactively identify performance bottlenecks and implement solutions through index optimization, query refactoring, and execution plan analysis.
- ETL & Integration: Design and oversee comprehensive Data Integration/ETL processes using SSIS (SQL Server Integration Services) to streamline data consolidation from various sources.
- Data Security: Establish and enforce security protocols, including encryption, data masking, and granular access controls, to safeguard sensitive data.
- Reporting & Analytics: Develop and enhance sophisticated reports using SSRS (SQL Server Reporting Services) or Power BI to deliver actionable business insights.
