Good knowledge in Installation, database maintenance, replication, backup & recovery, clustering and log shipping. MS SQL Server installation, configuration and administration of various SQL Server Products like SQL Server Database Server 2008 R2, 2012,2014 & 2016 (Stand alone and Always On Clusters) Knowledge in Database Creation, Database Configuration, Space management, and User management, Backup and Recovery, Database Maintenance. Knowledge on deploying SSRS reports, creating data sources, assigning permissions. Knowledge on deploying and executing the SSIS packages. Setting up Mirroring, Log shipping and Transactional Replication Extensive Knowledge on setting up and Implementing MS SQL Always ON. Good Knowledge on T sql Install patch or service pack for SQL 2008 R2 , SQL 2012/2014/2016 Disk space Planning and Management in all the servers. Backup and Restoration of Databases to different environments as per the user requirement. Implement and maintain database security, Knowledge on Database and Server roles and access levels. Creating Users and assigning right permissions to them. Having experience on Scheduling Jobs and assign Jobs. Prepare SQL server for High Availability environment and support for the BCP activities. Developing successful Backup strategies based on recovery model of the databases. Configuring the DB mail with the help of SMTP servers. Good knowledge to update more new techniques by Microsoft and developing the standard of supporting the SQL servers. Good knowledge on setting up linked servers and assigning access. Strong Knowledge on DBCC commands. Running Trace Profiler and knowledge on extended events. Resolve incident, service call and work order ticket based on SLA. Effective Knowledge on Monitoring tools like SPOTLIGHT and SCOM. Knowledge on Service Now tool.