MS SQL DBA • August-2022 to June-2024
Description: Experience in creating packages, Scheduling Jobs, Sending Alerts using Database Mail. Experience in creation of Database authentication modes, configuring permissions and assigning roles to users Experience in investigating and applying necessary SQL Server database patches and installing service packs. Extensive experience in Capacity planning, Performance Tuning, Disaster Recovery, Troubles shooting. Extensive experience in Troubleshooting and Query Tuning complex SQL Code, Stored Procedures, Triggers, Views etc., by analyzing wait stats & Execution plan. Expertise in Analyzing Index Usage, Fragmentation and Reorganize/Rebuild Indexes, Update Statistics for Better Performance. Experience in administrative tasks such as data loading and unloading, Backup, Recovery and scheduling the backups. Experience in Performance Tuning, Query Optimization, Client/Server Connectivity. Experience in Database Consistency Checks using DBCC Utilities. Experience in Database backup and disaster recovery procedures
DBA • August-2021 to October-2021
Apex
Description: SQL Server job scheduling, execution handling etc. Creation of user login and granting required privileges Performed backup and recovery strategies Monitoring and resolving Disk space, Transaction log database issues.
DBA • July-2017 to July-2021
SSIGRUN Consultancy Pvt Ltd
Description: Monitoring the dashboards and assigning incidents to the team members Maintain all SQL Server and Databases using automated jobs. Maintained clustered environments. I/O Utilization monitoring on the server given a detail report to the management on the performance of the servers. Configuring the backups schedules and jobs. Responsibilities included user management, performance tuning, backup and recovery, and adherence to security protocols.