LazyBuzz News

Supporting more than 600 SQL SERVER 2000/2005 Production and Non-production servers.
Installation of SQL SERVER 2000/2005 and service packs on windows.
Create and monitor daily maintenance jobs such as Full and Transaction Log backups and Weekly optimization jobs such as DBCC CheckDB, DBReindex and Update statistics etc.
Assigning Tickets and resolving as per defined SLA.
Implementing and monitoring Log shipping and Database Mirroring for Disaster recovery and High availability.
Implementing Snapshot Replication for Reporting and Transaction Replication for continuous updating the data to the subscribers.
Resolving space management issues like Database and log space issues.
Identifying and resolving Blocking and Deadlocking issues by using Activity Monitor, System stored procedures etc.
Monitoring server performance such as CPU, Memory, Disk, Network using Performance Monitor/Rocksolid.
Finding Query Performance using Profiler, Execution Plan, Tuning Advisor, DBCC commands and System views etc.
Improving Database and Query performance by resolving fragmentation issues by using DBCC Show contig, DBCC Reorganize and DBCC Reindex.
Migrating databases from SQL server 2000 to SQL Server 2005.
Moving data using Import & Export wizard, Database copy wizard, Attach & Detach methods.
Preparing and sending a report to Line manager regarding resolved tickets by end of the week

			
						

			
	
				Leave a Reply
				 127 views, 1 so far today | 			
			

				Tags: it careers, IT Jobs, JOBS