Writing complex queries, testing and maintaining triggers, optimizing stored-procedures, views & functions. Performance Tuning, Capacity Planning & Monitoring. Migration a legacy system to SQL Server. Pervasive data integration for data ETL processes, Failover Clustering, Always On, Replication. Database backup, restore, data security, SQL server agent job management, DTS, linked servers, replication, Reporting & Integration Services, Define Business Continuity Processes.