Sambasiva Rao Karnati

WORK HISTORY

EDUCATION

ABOUT SAMBASIVA RAO KARNATI

SQL Server Database Administrator at HCL Technologies• Having 9+ years of experience in the IT industry as SQL Server Database Administrator.• Installing different versions of SQL server (2005, 2008, 2008R2, 2012, 2014,2016,2017 and 2019) and Installing SQL on Cluster environments.• Checking the backup status, troubleshooting the failed backups, and restoring databases.• Creating Logins and assigning permissions to the logins.• Automating tasks using Jobs and maintenance plans.• Ensuring that all databases are backed up regularly by monitoring full, differential, and transaction log backups, fixing backup failures and addressing and implementing resolutions.• Creation of database maintenance plans, rebuild/defrag indexes, and integrity checks. • Creation of TSQL scripts for full, differential, transaction log backups, optimizations, and integrity checks on some instances that have special requirements beyond maintenance plans.• Customer Support for database issues [Performance Related issues].• Hands-on experience in Upgradation, and Migration.• Involved in SQL Server Database Log shipping and Mirroring activities.• Worked on Replication – Snapshot, Transactional.• Had experience in configuring Always ON.• Deploying and scheduling SSIS packages and scheduling them as per user• Good experience in resolving Blockings by using SQL commands.• Worked on SSIS Packages (Catalog & File system)• Having Knowledge of Azure DBA.• Experienced in recovering database from suspect mode.• Troubleshooting any SQL-related issues in client Servers.• Providing consultation on SQL Server to our development teams.• As a part of the DBA team providing 24/7 production support to the clients.• Having Good Knowledge of the ITIL Process.