• Worked on migration and maintenance of data using various utilities like DTS, Export, Import and Attach/Detach Data Migration tools.
• Created & maintained databases, users, Logins, tables, indexes, stored procedures, roles, permissions and other schema objects.
• Monitoring SQL server performance using profiler to find performance, dead locks, blockings
– more... and Capturing long running SQL queries for fine-tuning SQL statements that better result in efficient SQL statements processing.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies
• Rebuilding the indexes at regular intervals for better performance.
• Responsible for Stored Procedures optimization, Performance tuning & index tuning.
• Worked on Fail over Clustering for SQL Server databases for mission critical applications.
• Provided necessary data validation checks against the data entry.
• Frequently ran DBCC checks to maintain consistency.
• Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers. – less