Working on the Microsoft SQL Management Studio Version (2016, 2017 & 2019) Daily activities include monitoring the Database, checking error logs, checking the log file size and free space in the data drives, and connectivity of the databases.Knowledge about the Partitioning of tables. Setup and Support the Replication and Always on Availability tool. Always On AG failover & Failback.about the Always on Failover and Failback activity. Working on 24*7 ticketing system for company’s website. Setup the Maintenance plans like Update stats , Backup, Reorganize , Rebuild and Table PartitioningManually Reorganize Indexes/Update Stats as per the users request.Validation and creation of indexManaging Security (Creating users, logins, and roles, granting permissions).

Installation and configuration of SQL Server 2012, 2014, 2016, 2017, and 2019 on remote systems. Data Import and Export and Manage creation of SQL jobs.Experience in backup and restoring- protecting databases by taking different kind of backups such as Full, Differential and Transactional log backups..Experience in implementing server security and object permissions like maintain creation of users, permissions and assigning roles to users .Experience in creating maintenance jobs. Check for Blocked Processes And Data Archival. High availability of database servers using Replication, Log Shipping. Performing DB testing of tasks.Deployment using filezilla and server Deployment.Checking of space in DB and web and taking action to reduce the size.Manage extended events to collect data needed to monitor and troubleshoot problems in SQL server.