Iswarya KS

• Having around 10+ years of experience in Database Administration and Production Support as SQL DBA with proficiency in SQL Server 2005/2008/2008 R2 , 2012, 2016, 2017 & 2019
• Installation, configuration and maintenance of SQL Server 2005/2008, 2008 R2, 2012 and 2016, 2017 & 2019
• Experience in implementing and managing backup strategies.
• Experience in administering SQL Server High Availability and Disaster Recovery Strategies using. Always On, Replication, Mirroring and Log Shipping.
• Hands on experience in Database Backups, Restores, Attach and Detach databases, shrinking Log files etc.
• Experience in configuring database mail for SQL server alerts.
• Experience in planning and implementing MS SQL server security and database permissions.
• Good experience in Migration of databases between Servers & upgrade SSIS Packages as well.
• Experience on creating maintenance plans like database backups, update statics and rebuild indexes, reorganize indexes based on Fragmentation.
• Experience in SQL Server tools, including Management Studio, Query Editor, Profiler, SQL Server Agent.
• Managing the Disk Space and Memory management and maintaining the daily checkup of Systems.
• Refreshes from Production backup to Test and Development environments.
• Scheduling jobs in SQL Server Supporting huge production databases, troubleshooting the problems.
• Managing Security, creating users, logins and roles and granting permissions.
• Worked on Import and Export tables in OLEDB.
• Extensively involved in Performance and tuning.
• Experience in using DBCC commands, Dynamic Management View’s and Stored procedures.
• Monitored data activities (i.e. database status, logs, space utilization, blockings Login Failure, Backup Report and SQL Memory Usage).
• Created a SQL job to perform Rebuild/re-organize indices based on fragmented level. Involved in Data Centre Relocation and Migration.
• Experience ITIL Process change, problem and Incident management.
• Provided 24/7 Supports for Production, Development & Test Servers of MSSQL Servers.

Implemented SQL Dashboard - Hexaware Technologies:

Implemented SQL Dashboard through Splunk Monitoring tool to monitor SQL Job, Disk space, Log shipping status, Mirroring Status, Blocking, Locking, Fragmentation and Data file to get recent activity details on the instance

Automated Alerts - ATOS|SYNTEL :

Implemented PowerShell scripts to automate the blockings, SQL memory usage, Backup failure, Clustering, DB creation, DB Restart, Disk space usage