Experience in supporting tens of 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 Business Intelligence administration, development, and architecture, including but not limited to DTS, SSIS, SSAS, SSRS, T-SQL, data warehousing, partitioning, database schema design, and ERD diagramming. Perform a variety of SQL Server BI tasks related to problem resolution and monitoring, administration, development, design, performance analysis, security, data mining 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|
|BI Features||SSIS Package Configurations, Dynamic SSIS Task Building, Third Party Tasks, SSRS Scale-Out Deployment, Time and Data Driven Subscriptions, Standard and Dynamic Cube Partitioning, MOLAP, ROLAP and HOLAP Cube Processing, XMLA Scripting, Attribute Hierarchies, KPIs, Calculated Measures, MDX, DAX|
|Applications||Visio, E/R Studio, Powerbuilder, Cognos, Crystal Reports, Tableau|
|Tools||Microsoft Database Migration Tools, SQL Server Management Studio, SQL Server Agent, Microsoft Database Tuning Advisor, Microsoft Visual Studio, Quest Benchmarking/Toad/SQL Navigator, Ingress, BMC Patrol, Quest Central, DB Artisan, ERwin Data Modeler, ER/Studio, Rational ClearCase, AutoSys, ITSM, Veritas Clustering, Veritas NetBackup, Polyserve, PowerPivot,PowerView, QlikView, RSScripter, R|