Ashima Mehra Email & Phone Number

Waterloo, On, Ca

Markham, Ontario, Canada

Maharashtra, India

Implementing SQL server hardening for best practices. Hands-on experience in configuring and scheduling Database maintenance plans.✓ Managing security by creating logins, users and assigning privileges.✓ Planning and implementation of SQL Server Backup and Restoration.✓ Ensuring data consistency in the database through DBCC Commands.✓ Experience in troubleshooting and resolving database performance issues,blocking connectivity issues, security issues.✓ Expertise in Database refresh from Prod to Staging/Dev/Testing environments.✓ Ensuring that all databases are backed up on a regular basis by monitoring full,differential, transactional log backups, fixing backup failures.✓ Experienced in Shrinking log files to free up the space and Indexing, updatestatistics at regular intervals for better performance.✓ Experienced in monitoring Event viewer, SQL Error logs and Log File Viewer forSoftware and hardware-related errors.✓ Scheduled and maintain jobs, alerts and maintenance plans and troubleshoot thefailed jobs.✓ Security – Remove unneeded logins and users for individuals that have left theorganization, had a change in position, etc.✓ Working experience in Migration of databases.✓ Closely monitoring the growth of the databases, as a part of capacity planning.✓ Resolving the issues like blocking, slow running queries High etc...✓ Planning and implementation of Log Shipping, Mirroring, Replication and alwaysOn.✓ SQL Server Failover clustering installation, administration and patching.✓ Working experience on Azure Cloud and AWS✓ Providing 24*7 production support including on call support.✓ Excellent communication, presentation and interpersonal skills.✓ Handling the daily backlog call, weekly change call, client standup call and RCA call.✓ Expertise in monthly deep dive analysis towards to reduce the repetitive incident.✓ Working experience on few tools like Azure ADO and Change Requests