DEPANDER BHARDWAJ

11+years of experience in SQL Server Database Administration in Production, QA, Dev, and Test environments on MS SQL Server 2019,2017,2016,2014,2012 2008R2,2008, 2005 versions in Domains like Finance, Insurance. Over 14 years of Experience IT, and more than 6 years of experience in Application Support Install/Upgrade SQL server build from SQL server 2008/2008R2 to SQL server 2012 or Higher Monitor SQL server performance through perfmon and SCOM. Worked on DR plan with Always on Group Worked on DR plan with Log shipping. Worked on DR plan with Replication Installation, Configuration, and maintenance of all Database Servers 2005/2008/2008R2/2012/2014/2016/2017/2019 Monitor space usage & prepare estimates to predict Database growth Monitor the Database Server's Health and Tune Database using Profiler whenever required. Monitor data activities (i.e., database status, logs, Tempdb size, space utilization, locks, and long transactions). Schedule Jobs in SQL server as per the database and Application requirements Deadlock and blocking issues for concurrent users Rebuild and Reorg Indexes Daily Maintenance of SQL Servers included reviewing SQL error logs, Event Viewer. Good Understanding & Knowledge on Cloud computing architecture, technical design and implementations including Infrastructure as a Service (IaaS), Platform as a Service (PaaS) and Software as a Service (SaaS) Conducted root cause analysis for database incidents and problems. Following Change management process for any changes on the servers

19c oracle installation

architecture oracle

Bankup and recovery

Utility Raman

User management

knowledge Dataguard

Knowledge ASM

Knowledge rac