| Roles and Responsibilities |
-
Database Development:
Design, develop, and maintain SQL Server databases, ensuring best practices in normalization, data integrity, and schema design. Write complex SQL queries, stored procedures, functions, and views to meet application requirements. Develop and optimize T-SQL queries for performance, ensuring scalability and responsiveness of applications.
-
Query Optimization & Performance Tuning:
Analyze query performance and optimize slow-running queries using techniques such as indexing, query rewriting, and execution plan analysis. Monitor and optimize database performance to reduce resource usage and improve response times.
-
Data Integration & ETL Development:
Develop and manage ETL (Extract, Transform, Load) processes using SQL Server Integration Services (SSIS). Integrate data from various sources into SQL Server databases, ensuring data consistency and quality. Create and optimize complex data transformation workflows.
-
Database Reporting & Data Extraction:
Develop and manage SSRS (SQL Server Reporting Services) reports and dashboards for internal stakeholders. Create ad-hoc reports and query outputs to support decision-making and operational requirements.
|
