Senior System Engineer
Infosys BPO LTD
Total years of experience :10 years, 11 Months
• Installing and configuring SQL Server 2012 for stand alone.
• Configure Transactional and Snapshot Replications and monitoring for the same.
• Monitoring live Database Mirroring, Log-Shipping.
• Monitoring SQL Performance, SQL error logs and event Logs.
• Creating and Maintaining scheduled jobs, Maintenance plans, database native backups.
• Performing Database backup and Restore activities as per requirement.
• Monitoring server performance and tuning whenever required
• Building database backup and disaster recovery plan.
• Resolving/minimizing application deadlock/Blocking issues.
• Regular checking of the database consistency using DBCC commands to minimize complexity
• Worked with developers to tune the SQL queries using SQL Profiler.
• Execution of database script in UAT and production environment.