Responsibilities:• Performed database backups for production, test, and development servers and restore backups onto test servers to ensure that we had good backups.• Installing and testing a new version of DBMS• Developing, managing, and testing backup and recovery plans.• Installed service packs and security fixes on production, test, and development servers.• Performed Migration of data from SQL Server 2016 to SQL Server 2019 edition.• Configure multiple node failover clusters.• SQL server High Availability and Disaster Recovery solutions- AlwaysOn high availability groups, Failover Clustering, Mirroring, Log Shipping, and Replication.• Perform daily, weekly, and monthly Database Maintenance tasks.• Control and monitor users access and maintain system security.• Monitor and resolve blocking and deadlock issues using profiler, extend event, and database tuning advisor.• Setup automation with SQL server agent and database mail.• Deployed SSIS packages for maintenance plan task.• Monitored database size and disk space in a production environment.• Creation and management of a database maintenance plan for various database consistency checks.• Administrated and managed the SQL Server 2019, 2016 production and No-production servers.• Installed and configured the SQL Server Reporting Services (SSRS) and maintenance of the Reporting Servers.• Created Active Directory with Security group with permissions• Third party software Redgate (SQL backup, SQL monitor, SQL Data compare, SQL compare SQL search, SQL prompt)• Power shell scripts

Responsibilities:• Install, configure, and maintain all SQL Server instances across testing, development, and production environments.• Create database and schedule backups (Full backup, Differential backup, Transaction log backup) with recovery sessions (Simple or Full)• Resolving blockings, locks, deadlocks, and isolation levels.• Set up and maintain Replication for Production servers to provide high availability and monitor using Replication Monitor.• Setup Alerts, Notifications, Jobs, and job steps with an automated response solution schedule.• Automated data clean-up and migration efforts.• Apply patches to production databases as required by the business• Involved in the migration of SQL Server 2016 to SQL Server 2019• Reviews and optimized SQL queries, stored procedures, functions, indexes, views, and Triggers.• Ensuring that storage and archiving procedures are functioning correctly• Working closely with the IT project manager, database programmers, and report developers.

Responsibilities:• Managing day-to-day SQL Server operation in SQL Servers 2014/2016• Installed necessary Service Packs on SQL server 2014/2016• Administering the MS SQL Server by creating users logins with appropriate roles, monitoring the user accounts, creating groups, granting privileges to users and groups• Write T-SQL scripts for database backup jobs and daily/weekly jobs.• Created jobs to monitor resources on various servers to mail Alerts when the threshold reached• Performed backups, and DBCC utilities, updated index statics, monitored database and disk space, security issues, and scheduled tasks.