Experience in supporting thousands of SQL Server databases running on all versions (from 6.0 to 2016) for hundreds of organizations on a 24x7 basis. Very strong in administration, installation & configuration, development, version upgrades, data migration, backup and recovery, clustering, replication, disaster recovery, performance monitoring & tuning, DTS, SSIS, SSAS, SSRS, T-SQL, index optimization, database development, writing stored procedures & triggers. Perform a variety of SQL Server tasks related to problem resolution and monitoring, administration, availability, performance, security and corporate strategy.
|SQL Server Versions||SQL Server 6.5, 7.0, 2000, 2005, 2008, 2008R2, 2012, 2014, 2016|
|Database Features||Database Mirroring, Log Shipping, Clustering, Backup Compression, Database Snapshots, Replication (Merge, Transactional, Snapshot, Heterogeneous Subscribers), Change Data Capture(CDC), Table/Index Paritioning, Data Compression, SQL Auditing, Transparent Database Encryption, Extensible Key Management, Role-based Security, Sliding Window Partitioning, Always-On Availability Groups, Contained Databases, Master Data Services, Data Quality Services, Encryption|
|Applications||Microsoft SSAS, SSIS, IIS, Reporting Services, Report Manager, Data Mining, Spatial|