Description
Currently seeking a highly skilled SQL resource who will be responsible for maintaining and designing the SQL Back End for our clients solutions (schemas, stored procs, ETL, reports, etc.). The resource would also be reviewing the existing SSRS reports and provide recommendations based on possible consolidation of the existing reports, improving performance, etc. Datawarehouse schema(s) need to be designed to provide slice and dice capabilities for reporting. New reports and dashboards need to be created to provide operational versus actual numbers. The resource must be a self-starter and results-driven. They must be able to provide results with minimal supervision.
Skills:
Strong SQL skills using years + experience) [70 %]
Strong Transact SQL Skills (Stored procedures, functions, views, etc.)
Experienced with performance tuning (SQL Execution Plans, Partitioning a plus)
Experienced with SQL Server Reporting Services (SSRS)
Experienced creating data warehouses
Experience with BI presentation layer tools (ProClarity, etc.)
SSAS
SSIS
Also, includes some .NET Framework years + experience preferred) [30%]
ASP .NET
VB.NET
C#