Working Experience:
- Performed installation of SQL Enterprise 2008 64bit version on Windows 2008 servers on Enterprise systems of clustered and standalone HP servers in enterprise Data Centers. Patch applications.
- Experience in Setting up (HA) High Availability solutions like Log shipping, Databases Mirroring, Replication and Clustering as a part of Disaster Recovery (DR).
- Working Knowledge on DB Replication between with MS SQL Server 2005 and 2008 R2.
- Created DTS/SSIS packages to export & import data from SQL Server to Access, text and Excel files.
- Failover cluster testing and resolution on HP servers as well as monitoring and backup reporting setup with Microsoft Operations Manager and backup teams.
- Setup Database Security and maintain accounts and access levels by creating suitable Logins and Roles and assigning object level permissions.
- Manage Disk space, Memory, and User Connections.
- Extensively work on Performance Monitor, SQL Profiler, DMVs, DMFs and DTA to tune the Databases, servers and query tuning.
- Working Knowledge on DBCC Commands
- Schedule weekly jobs and Maintenance tasks for better performance and created alerts with Databases Mail SMTP.
- Reporting and resolving serious SQL Server alerts
- Backing up the databases (FULL, Differential and Transaction Log) and disaster Recovery of databases.
- Database backing online, backing data files, log files, documenting backup