Having more than 18 years of experience in MS SQL Server , Big Data, Amazon Redshift Columnar Database designing, data/application architecting, data modeling, analysis, design, development, implementation, testing, and maintenance of Enterprise application systems and Data-warehouse systems.
Rich Experience in solving for Performance issues, Concurrency issues, replication and SSIS.
Designed and Implemented SSIS/ETL package for Data warehouse.
Rich Experience in MSS SQL server Administration, DBCC, Backup, Restore, Log shipping, Full-text Search and replication
Implementation of Industry standards.
I can help you with some the new SQL 2016 features including hybrid database
Columnstore Indexes
Database Scoped Configurations
In-Memory OLTP
Query Optimizer
Live Query Statistics
Query Store
Temporal Tables
Striped Backups to Microsoft Azure Blob Storage
File-Snapshot Backups to Microsoft Azure Blob Storage
Managed Backup
TempDB Database
Built-in JSON Support
Stretch Database
Support for UTF-8
Hire me, will not disappoint you!