Nagaraju Chakkera

About Nagaraju Chakkera

Having 5.4 years of experience as a SQL server DBA In production environment and good…

Experience

1. Database Administrator

   Capgemini

   Jan 2023 — Present · Hyderabad, IN

   Installation & Configuration of SQL Server 2016, 2017 and 2019. Migrating databases from SQL Server 2012 to SQL Server 2016 and SQL Server 2014 to SQL Server2019. Fixing the Orphaned users Good experience in configuring the Log Shipping and Mirroring in Production environment. Good experience in configuring the AlwaysOn and SQL Clustering. Refresh of Databases from Production to Test Environment on need basis. Performing Health checks of the Production servers. Creation backup jobs, maintenance plans, Alerts, and configuring DB mail. Resolving the issues on Blocking and Deadlocks. Good experience in applying the Service Packs and Cumulative Updates on Standalone servers andClusters. Monitoring of Disk space where physical databases are stored. Configured Replication with Snapshot Replication and Transactional Replication Planning the backup strategies for system and user database and scheduling Full, Differential and logbackups as per the need. Experience in DR activities such as recovering databases from suspect mode. 24 X 7 Production support and during weekends On Call Support. Good knowledge on Azure Cloud (Azure SQL, Azure Managed Instance and IAAS) Good Experience on Azure Cloud Backups, Restores, and Security. Good Experience on Azure Cloud Backups, configuration database backup retention policies. Good knowledge on Azure Geo Replication process.