Skills:
SQL Server 2008 R2 Transact-SQL/T-SQL development
Database architecture and analysis of projects based on requirements
Database development, design, normalization (3NF)
Query show plans, compilation, optimization
relational and multidimensional OLAP
Business Intelligence stacks
SSAS, SSIS packages, SSRS reports
dimensions, measures, cube development
data quality analysis
data warehousing
data marts
Partitioning and I/O optimization
Full life-cycle development
C#, VSS, Visual Studio 2010, .Net Framework 4.0
technical specifications, design documents, user interactions
Security analysis, investment instruments
ETL data transfer
SSRS report development and deployment
SQL Server database/CPU/memory/disk IO performance tuning
logical and physical data modeling, schemas, security
ACID database transactions
DML, DDL, DCL, TCL, DMVs, DMFs
Simple and correlated subqueries
Online and offline indexing