Abhrajit Sarkar

Detail-Oriented MSSQL Database Administrator with 2+ years of Experience in managing and maintaining SQL Server environments in Production and UAT systems. Skilled in Backup recovery, performance Tuning, HA DR and user access management etc. Proven ability to troubleshoot issues, optimize queries and collaborate with cross functional teams to support business-critical apps. Known for being Enthusiastic to learn

MS-SQL DBA(L1+L2) - Wipro Limited - Bengaluru, Karnataka

(2024-05-23)

• Executed manual backup & restore operations, ensuring 100% data availability and adherence to business continuity standards.
• Monitored and managed ServiceNow Queue, ensuring zero SLA breaches through proactive ticket handling.
• Performed daily health checks on SQL Server instances, monitoring disk usage, CPU performance and DB integrity to maintain optimal server uptime including SQL version monthly patching for Prod and Non Prod servers.
• Administered user access permissions and roles to safeguard data integrity and meet compliance requirements.
• Resolved DB performance bottlenecks by addressing blocking sessions, optimizing long-running queries and troubleshooting deadlocks.
• Executed maintenance Operations such as databases shrinking, adding DB to Always-On Availability groups, and implementing preventive measures against data corruptions.
• Deployed and validated T-SQL scripts in UAT and Prod ENVs, ensuring accuracy and minimal service disruptions including Sybase DB scripts deployments.
• Partnered with cross-functional teams including developers, app teams to resolve DB-related issues efficiently.

BCA - Bachelor Of Computer Application - Techno India Institute of Technology, Kolkata

H.S.C - BDM International, Kolkata

S.S.C - BDM International, Kolkata