We are supporting Azure SQL data servers which include Prod/Dev/QA environment.Created database maintenance plans, and regularly scheduled DBA tasks for enhancing the performance of SQL Server, some of these tasks included Database integrity checks and re-indexing.Solved several issues that came from the Azure DevOps ticketing system and were responsible for closing the User Stories and Bugs.Managed the ETL jobs checked the failures and executed them manually.Monitoring and managing SQL server’s performance while doing Load tests.Checking Database Health by using DBCC Commands and DMVS.Good knowledge of SQL sentry one tool application and Azure Data Studio.Monitored and modified Performance using execution plans and Index tuning.Good knowledge of Azure Portal and Azure Data Studio applications.Responsible for reviewing, optimizing, and deploying database scripts requested by the Application Development Team.

• We are supporting nearly 250+ servers which include Prod/Dev/QA environment.• Closing the tickets within the SLA time and Monitoring the SLA.• Creation of user databases and ensuring file group creations and also ideally placing files in appropriate locations.• Managing daily sync-up calls to understand the issues /upcoming changes and implementation. • Analyze various applications and understand the space requirements and segregate the disk space under the categories of perm, spool, and temp space.• Created new user accounts, profiles, and roles and assigned them to different users and enabled auditing to monitor the system privileges and roles granted.• Provided High availability through Clustering (Active/Active and Active/Passive), Mirroring.• Log shipping configuring and monitoring.• SQL Setup, Trouble Shooting, Maintenance & Upgrade.• Daily monitoring of the Database Space Management parameters, allocating the required space to databases, and suitably managing database growth.• Solve database-related issues like taking care of different processes consuming high CPU resources, blocking, and long-running queries.• Monitoring SQL Server Backups, upgrades to the new version, applying service packs to correct server bugs, and troubleshooting SQL Server issues.• Monitor the status of Scheduled jobs - on daily and on weekend tasks like rebuilding indexes, defragmenting Databases, Shrink databases, and Database complete backup.• Experience in SQL Server migration activities.• Communicating regularly with all teams to ensure database integrity and security.• Experience in configuring and monitoring AllwaysOn

• We are supporting nearly 18 servers which include Prod/Dev/QA environment.• Installation and configuration of MS-SQL Servers.• Closing the tickets within the SLA time and Monitoring the SLA.• Creation of user databases and ensuring file group creations and also ideally placing files in appropriate locations.• Patching activity on servers on a Monthly and weekly basis• Managing replication in SQL Server 2008/2008R2/2012 and monitoring replication server• SQL Setup, Trouble Shooting, Maintenance & Upgrade.• Daily monitoring of the Database Space Management parameters, allocating the required space to databases and suitably managing database growth.• Migrated from SQL server 2012 to 2016 by using a side-by-side upgrade process and documented the Upgrade Process. • Good knowledge of Always On, Windows Server, SCOM monitoring, SSMS, and Application Insight.• Provided 24x7 production supports to the clients and application groups

• To protect databases took Full backups, Transaction Log Backups, and differential Backups daily and weekly basis.• Grant access to users on resources as per requirement. • Created new user accounts, profiles, and roles and assigned them to different users and enabled auditing to monitor the system privileges and roles granted.• Managing replication in SQL Server 2008/2008R2/2012 and monitoring replication server• SQL Setup, Trouble Shooting, Maintenance & Upgrade• Solving different database-related issues like taking care of different processes consuming high CPU resources, blocking, and long-running queries.• Monitoring SQL Server Backups, upgrades to the new version, applying service packs to correct server bugs, and troubleshooting SQL Server issues.• Have created Jobs, Alerts.