· Having experience on MATLAB and SSAS for Data Analysis task on 20+ Projects.
· Having experience to perform day to day DBA activities such as monitoring SQL Server health, job status, addressing user requirements, Database Mail, Database Configuration, Query Tuning and performance.
· Having experience to install and configured SQL 2016 clustered environment with availability groups.
· Having experience to install and configured a SQL 2016 clustered test environment.
· Configured and supported replication and log shipping in both SQL 2014 and 2016.
· Designed Contract Retention database using SQL Server 2016 technology
· Developed data mapping documentation to establish relationships between source and target tables including transformation processes
· Created complex SQL views and stored procedures to join multiple tables for contract data interface files.
· Having experience in optimize the SQL Query and SSIS packages (2016), migrate SSIS version from lower to latest version.
· Having experience to diagnosed job errors like deadlock and timeout issue.
· Experience in SSIS for bulk uploading data into Database, File