MCITP-Certified & Expert in MS SQL Server 2017/2016/2014/2012/2008 R2/2008 Database Administration Administration, Maintenance (24x7) of SQL Servers (100+) into Production, TEST, UAT, QA, DEV and Training. •Installation, Consolidation, Upgrade, Migration of SQL Server 2017/2016/2014, 2012 2008 R2 •Setup of SQL Server High Availability failover Cluster Active/Active & Active/Passive on WSFC •Setup of SQL Server High Availability using Always On, Mirroring, Log shipping and Replication •Designing and Implementation of DISASTER RECOVERY Servers, Processes, Procedures, Solutions •Setup of Maintenance jobs for BACKUP/RESTORE, re-indexing, Index defragmentation, update Statistics, integrity checks, transaction log growth monitoring and batch processes .Performance Tuning and Optimization – Memory, CPU, IO, Azure scaling up and down and AWS. •Performance Tuning – Database Engine Tuning Advisor using Trace and profiler • Installation and Maintenance of SSIS, SSRS,SSAS and database engine • Expert in SQL Server new features like Policy Based Management, Performance and Data Collector • Creation of Linked Server and setup database mail, SQL Audit • Cloud Platforms (AWS IaaS and platform services, Azure IaaS and PaaS services) • Deployment of SSIS project (2016/2014/2012) and Package ,SSIS job scheduling and Power BI • Performing Capacity Planning and pre-allocating space to databases • Use Data Collector to collect different sets of data with integration to SQL Agent and SSIS • Scaling out of report servers and configure and maintain MSSQL TDE encryption • Automation using power shell/Perl/Shell scripting • Involved Change management and Incident handling as per ITIL standards • Administer Multiple Servers Using Central Management Servers • Good working knowledge on CRM tools BMC Remedy, Salesforce, and Oracle CRMOD • Expert in using tools like SQL Profiler, Windows performance Counters and Troubleshooting with these Tools like MS SQL Server Performance Dashboard, PSSDIAG, DTA, SQLDIAG, SQLNUXS, Replay Markup Language (RML) Utilities, OStress, OStress Replay Control Agent (ORCA) and Performance Analysis of Logs (PAL), and System center Advisor, Azure SQL Database, Azure SQL Data Warehouse and Azure Data Factory • Aware of IT compliances -Sarbanes-Oxley (SOX), HIPAA and GAAP compliances • Physical and Logical Data Modeling, Implementing Data Integrity, Schemas • Certified MySQL, Sybase, Oracle Database Administrator with years of industry experience, all in Unix with RDBMS, like Sybase/MSSQL/MySQL/Oracle & Replication Servers (MSA), Stock Securities Allotment, Transfers, Merchant Banking Services, Project Advisory Services, Marketing of Financial Products, Retail Finance and other financial services like Fixed Deposits, Asset Finance and Custodial Services, Insurance etc. Experienced in entire system life Cycle including Shell Scripting, Power shell Scripting, Perl Scripting