OnBenchMark Logo

Srinivas

Sr. MSSQL Database Administrator
placeholder
Location Hyderabad
view-icon
Total Views55
availability
Shortlist0
back in time
Member since30+ Days ago
 back in time
Contact Details
phone call {{contact.cdata.phone}}
phone call {{contact.cdata.email}}
Candidate Information
  • User Experience
    Experience 7.5 Year
  • Cost
    Hourly Rate$10
  • availability
    AvailabilityMore 1 Month
  • work from
    Work FromOffsite
  • check list
    CategoryInformation Technology & Services
  • back in time
    Last Active OnJune 21, 2024
Key Skills
MS SQL Server
Summary

Project : Vodafoneidea Role : Sr. SQL DBA Team Size : 7 Duration : Feb-2021 to till date Description: Vodafone Idea Limited is an Aditya Birla Group and Vodafone Group partnership. It is India's leading telecom service provider. The Company provides pan India Voice and Data services across 2G, 3G and 4G platform. With the large spectrum portfolio to support the growing demand for data and voice, the company is committed to deliver delightful customer experiences and contribute towards creating a truly 'Digital India' by enabling millions of citizens to connect and build a better tomorrow. The Company is developing infrastructure to introduce newer and smarter technologies, making both retail and enterprise customers future ready with innovative offerings, conveniently accessible through an ecosystem of digital channels as well as extensive on-ground presence. The Company is listed on National Stock Exchange (NSE) and Bombay Stock Exchange (BSE) in India. Roles and Responsibilities:

➢ Creation of user databases and ensuring file group creations as per requirement.

➢ Create various database objects, and create users with Fixed or Customized Server Roles and levels of security.

➢ Scheduled and maintain routine Jobs, Alerts and Maintenance Plans and setting up DB Mail.

➢ Performing SQL Server daily health check using DBCC commands and also DMV’S

➢ Checking the status of backup, troubleshooting failed backups and restoration of databases.

➢ Verifying all instances are up and running as per the checklist.

➢ Knowledge in Suspect DB troubleshooting.

➢ Understand clustering environment and monitoring through cluster administrator.

➢ Performing the failover and failback operations in the cluster environment.

➢ Migration of SQL Server 2005/2008/2012 to SQL Server 2014/2016.

➢ Monitoring Disk Space of all the Servers and freeing up space for cleanup.

➢ Reviewing SQL Server and SQL Server Agent Error Logs. ➢ Handling log file full and releasing space to OS by shrinking log files.

➢ Blockings, Deadlocks, Monitoring space issues Data File/Log File.

➢ Experience in optimizing the query by creating various clustered, non-clustered indexes and indexed views

➢ Installing, configuring, managing, monitoring and troubleshooting SQL 2019

➢ Patch Upgrade from SQL Server 2016 SP2 CU15 to SQL Server 2016 SP3 Professional Experience Project : RIL Role : SQL DBA Team Size : 9 Duration : SEP-2015 to Feb-2021 Description: Reliance Industries Limited (RIL) is an Indian multinational conglomerate company headquartered in Mumbai, Maharashtra, India. Reliance owns businesses across India engaged in energy, petrochemicals, textiles, natural resources, retail, and telecommunications. Reliance is one of the most profitable companies in India, the largest publicly traded company in India by market capitalization and the largest company in India as measured by revenue after recently surpassing the government-controlled Indian Oil Corporation

Roles and Responsibilities:

➢ Creation of user databases and ensuring file group creations as per requirement.

➢ Create various database objects, and create users with Fixed or Customized Server Roles and levels of security.

➢ Scheduled and maintain routine Jobs, Alerts and Maintenance Plans and setting up DB Mail.

➢ Performing SQL Server daily health check using DBCC commands and also DMV’S

➢ Checking the status of backup, troubleshooting failed backups and restoration of databases.

➢ Managing Backups on a daily basis, Restore and Disaster Recovery procedures and recovering the databases from backup in disaster situations.

➢ Verifying all instances are up and running as per the checklist.

➢ Knowledge in Suspect DB troubleshooting.

➢ Have understanding of clustering environment and monitoring through cluster administrator.

➢ Performing the failover and failback operations in the cluster environment.

➢ Migration of SQL Server 2005/2008/2012 to SQL Server 2014/2016.

➢ Monitoring Disk Space of all the Servers and freeing up space for cleanup.

➢ Reviewing SQL Server and SQL Server Agent Error Logs.

➢ Handling log file full and releasing space to OS by shrinking log files.

➢ Blockings, Deadlocks, Monitoring space issues Data File/Log File.

➢ Experience in optimizing the query by creating various clustered, non-clustered indexes and indexed views

Copyright© Cosette Network Private Limited All Rights Reserved
Submit Query
WhatsApp Icon