Sneha Korpol
Bangalore
Summary
Accomplished SQL Server Database Administrator with extensive experience at Bristol Myers Squibb, adept at optimizing server performance and automating maintenance tasks. Proficient in T-SQL and PowerShell, I excel in problem-solving and teamwork, ensuring seamless database operations and enhancing operational efficiency across multiple SQL Server versions.
Overview
3
3
years of professional experience
Work History
SQL Server Database Administrator
HCLTech
Bangalore
09.2022 - Current
- Monitored 200+ server health, automate maintenance tasks, and proactively resolved issues for uninterrupted operation. configuring 200+ servers.
- Experience in Installation and Configuration of SQL Servers (2012, 2014, 2016, 2019 and 2022) with Latest Service Packs & Cumulative Updates as well as SQL server Instance & Database decommission.
- Automated routine tasks by creating and scheduling maintenance plans, E-mail alerts and familiar with DBCC commands and DMVs for operational efficiency and index optimization.
- Hands on experience to solve space issues like Temp DB full and log file full and evaluated data storage considerations to store databases and Transactions logs.
- Hand on experience with SQL Server Always On Availability Group (AOAG) and Distributed Availability Group (DAG) and Involved in trouble shooting parts like database unavailability or out of sync.
- Having Basic experience Clustering, Replication, Mirroring and Log Shipping.
- Good knowledge on cluster architecture and involved in failover activities.
- Administering the MS SQL Server by Creating User Logins with appropriate roles, monitoring the user accounts, granting the privileges to users and groups with SQL Authentication.
- Executed regular database backups, recovery models, and disk space management including shrinking logs.
- Having experience in troubleshooting issues like Blocking and Deadlocking, fail over maintenance and database recovery.
- Basic knowledge in working on all SQL Automation related stuff with the help of PowerShell and T-SQL.
- Dealing with P1 and P2 and P3 incidents and user tasks(service requests)using service now tool
Database Administrator
Bristol Myers Squibb (BMS)
- Company Overview: Bristol Myers Squibb (BMS), is an American multinational pharmaceutical company. Headquartered in Princeton, New Jersey, BMS is one of the world's largest pharmaceutical companies and consistently ranks on the Fortune 500 list of the largest U.S.
- Environment: SQL Server 2008, 2008 R2, 2012, 2014, 2016, 2019 & 2022
- Bristol Myers Squibb (BMS), is an American multinational pharmaceutical company. Headquartered in Princeton, New Jersey, BMS is one of the world's largest pharmaceutical companies and consistently ranks on the Fortune 500 list of the largest U.S.
Education
B.Tech.(CSE) -
CMR Institute of technology
Hyderabad01.2022
Class 12 th -
Narayana Junior College
Hyderabad01.2018
Class 10th -
The Hyderabad Public School
Begumpet01.2016
Skills
- T-SQL
- PowerShell
- Microsoft Server
- SQL Server Management Studio
- Windows Failover Cluster
- SQL Server Agent Jobs
- Service now
- Bigfix
- Windows Server 2008
- Windows Server 2008R2
- Windows Server 2012
- Windows Server 2012R2
- Windows Server 2022
- Leadership
- Time Management
- Teamwork
- Problem-solving
- Documentation
Current Project
Bristol Myers Squibb (BMS), SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2019, SQL Server 2022, Database Administrator, Bristol Myers Squibb (BMS) is an American multinational pharmaceutical company. Headquartered in Princeton, New Jersey, BMS is one of the world's largest pharmaceutical companies and consistently ranks on the Fortune 500 list of the largest U.S.
Timeline
SQL Server Database Administrator
HCLTech
09.2022 - Current
Database Administrator
Bristol Myers Squibb (BMS)
B.Tech.(CSE) -
CMR Institute of technology
Class 12 th -
Narayana Junior College
Class 10th -
The Hyderabad Public School