I was responsible for application team’s technical information from the monitoring tools to assist in app side performance issues related to SQL.Involved in 24x7 production support.
- Design and implementation of Performance Tuning and Maintenance plan for consistency checks, backup/restore
Rebuild Indexes on Various tables.
- Managing logins, roles, assigning rights and permissions. Created views to implement security.
- Successfully implemented Log Shipping Technique to maintain a standby server backup for Disaster Recovery.
- Published technical documentation to set standards, guidelines and best practices for SQL Server Configuration, Physical model, Database Backup & Restore Procedures.
.