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
No Job have been added
{{contact.cdata.phone}}
{{contact.cdata.email}}
View Resume