SQL Server DBA • November-2022 to December-2023
Description: Providing 24/7 SQL Server DBA production support with On-call support. • Installing, configuring & monitoring SQL 2005, 2008R2, 2012, 2014, 2016, 2017 & 2019. • Involved installing service pack, cumulative updates and hot fixes. • Experience on Installing SQL Server using unattended and slipstream method. • Experience in upgrading SQL Server 2005-2008/R2 and 2008R2-2012. 2012-2017. • Migrate logins through sp_help_rev_login stored procedure and fixing orphan users. • Instance & DB security, creating logins-users and granting permissions to logins/users • Checking the status of backups and troubleshooting the failed backups. • Checking the backup reports and ensuring that all the backups are proper. • Schedule and maintain routine jobs, alerts and maintenance plans. • Restoring the backups (users and system DB’s) as needed. • Technical troubleshooting gives consultation to development teams. • Tracking the locking issues, including deadlocks, blocking and lock timeouts. • Monitoring disk space of all the servers and freeing up the space as per the requirement. • Experience on monitoring SQL Server Performance using Perfmon and Profiler Tools. • Reviewing SQL Server Error log and Event viewer • Performing disaster recovery (DR) test on a Quarterly basis. • Ensuring process documentation is updated on regular basis. • Experienced on piecemeal restore and restorations to STOP AT MARK. • Experience on configuring database mail, jobs, maintenance plans and alerts. • Implementing and troubleshooting log shipping, DB mirroring and clustering. • Experience on configuring and troubleshooting Always On AG in SQL Server. • Configuring and troubleshooting snapshot, transactional, merge & peer-to-peer. • Creating, rebuilding and reorganizing different types of indexes. • Using stored procedures, views, functions, T-SQL codes, queries, DMV’s and DBCC. • Follow SLAs & ITIL process for changes and all tickets, Service Requests from clients. • Experience on Installing and configuring SSAS, SSIS and SSRS, • Experience on collection data using PSSDIAG tool. • Experience on automation using PowerShell. • Experience on taking backup and restore using Litespeed and Commvault tool. • Experience on monitoring SQL performance using SQLDM.
SQL Server DBA • June-2022 to November-2022
LTIMindtree
Description: Installation and configuration of SQL Server 2019. • Configured Publisher, Distributor, Subscriber in AlwaysOn Availability Groups. • Upgraded the SQL server 2019 developer to enterprise edition. • Worked on Implementation and troubleshooting log shipping and DB mirroring. • Worked on configuring and troubleshooting AlwaysOn AG in SQL Server. • Migrated older version of SQL Server to latest version. • Technical troubleshooting gives consultation to development teams. • Migrated On-prem SQL Server to Azure cloud VM, SQL databases and SQL MI. • Effectively managed and reduced cost by effectively monitoring databases elastic pool. • Configured Azure site recovery for DR and Azure backup on-premises/Azure Environment. • Migrate SQL Server Databases to Microsoft Azure hosted DBs, Managed Instances, Configured High Availability Solutions; AlwaysOn, Log Shipping, patching, troubleshooting, optimization, maintenance. • Configured Transparent Data Encryption (TDE) using AE256 Algorithm to make sure that all databases are fully encrypted. • Configured Geo replication with availability group in Azure SQL DB • Involved on Installing and configuring SSAS, SSIS and SSRS.
SQL Server DBA • October-2016 to June-2022
Kyndrl india
Description: Installation and configuration of SQL Server 2019. • Configured Publisher, Distributor, Subscriber in AlwaysOn Availability Groups. • Upgraded the SQL server 2019 developer to enterprise edition. • Worked on Implementation and troubleshooting log shipping and DB mirroring. • Worked on configuring and troubleshooting AlwaysOn AG in SQL Server. • Migrated older version of SQL Server to latest version. • Technical troubleshooting gives consultation to development teams. • Migrated On-prem SQL Server to Azure cloud VM, SQL databases and SQL MI. • Effectively managed and reduced cost by effectively monitoring databases elastic pool. • Configured Azure site recovery for DR and Azure backup on-premises/Azure Environment. • Migrate SQL Server Databases to Microsoft Azure hosted DBs, Managed Instances, Configured High Availability Solutions; AlwaysOn, Log Shipping, patching, troubleshooting, optimization, maintenance. • Configured Transparent Data Encryption (TDE) using AE256 Algorithm to make sure that all databases are fully encrypted. • Configured Geo replication with availability group in Azure SQL DB • Involved on Installing and configuring SSAS, SSIS and SSRS.
SQL Server DBA • May-2015 to September-2016
Congnizant
Description: Involved in installing SQL Server 2008, 2008R2, 2012, 2014 and 2016. • Involved installing service pack, cumulative updates and hot fixes. • Creating logins and mapping logins to DB and granting permissions at server and object level. • Checking the status of backups and troubleshooting the failed backups. • Checking the backup reports and ensuring that all the backups are proper. • Schedule and maintain routine jobs, alerts and maintenance plans. • Restoring the backups (users and system DB’s) as needed. • Implemented HADR options such as log shipping, clustering, mirroring and AlwaysOn AG. • Configuring and troubleshooting snapshot, transactional and merge replication. • Creating indexes on tables to improve the performance as per the Dev/App team request. • Migrated SQL Server 2012 to SQL Server 2016. • Performing disaster recovery (DR) test on a Quarterly basis.