SQL server admin for operations and development. Design (normalized/denormalized, analysis services cube, creation of tables, clustered/non clustered indexes, users/logins/schemas, agent jobs, stored procedures, sp_who/3rd party monitors, service broker, mirroring/log shipping/replication, ssis, ssrs. Maintenance (transaction log arrangement, incremental/differential backup, profiler/tracing/3rd party tools for OLTP code view, migration,Installation,Ssis,memory optimization, database object enumeration), development (t-SQL, stored procedures).