SHRINIVAS CHOUDEKAR
SQL Server Database Administrator
Pune
Summary
Results-orientated Database Administrator with 9.5+ years of comprehensive experience managing SQL databases. Strengths in troubleshooting and maintaining servers and systems to ensure smooth business operations.
Overview
10
10
years of professional experience
10
10
years of post-secondary education
4
4
Certifications
Work History
Senior Lead Database Consultant
Allstate India Pvt. Ltd.
2023.12 - Current
- Experience in Database Administration of complex databases in SQL Server 2019.
- SSRS and SQL Server upgrade from 2016 to 2019.
- Implemented Datadog Monitoring in database system to track record of DB health.
- Regular SQL database refresh and migration.
- SQL Server security patching - Installed CU, Hotfixes as routine database server maintenance activity.
- Migrated Microsoft SQL Server to Postgres.
- Determine, enforce and document database policies, procedures and standards.
- Allocating system storage and planning future storage requirements for the database system.
- Enrolling users and maintaining system security by controlling database access.
Lead Database Administrator
Cigres Technologies Private Limited (Cignex Datamatics)
2023.02 - Current
- Total 9 years of experience in IT domain as DBA.
- Experience in Database Administration of complex databases in SQL Server 2019, 2016
- SSRS and SQL Server upgrade from 2016 to 2019
- Experience of managing Replication (Transactional), AOAG.
- Monitoring and managing TempDB database issues.
- SQL Server security patching - Installed CU, Hotfixes as routine database server maintenance activity.
- Being a part of App DBA Team worked to developers in code deployment and handled releases using GitHub.
- Implemented Datadog Monitoring in database system to track record of DB health.
- Managing Database Users and Security.
Lead DBA/Senior Associate
Cognizant Technology Solutions
2021.08 - 2023.02
- Worked as part of a team providing 24X7 support as needed
- Experience in Database Administration of complex databases in SQL Server 2019, and earlier
- Installed, Configured, and Managed SQL Server 2019 & 2016 in development, test, and production environment
- Experience of managing Replication (Transactional), AOAG
- Monitoring and managing TempDB database issues
- Resolve database performance issues, database capacity issues, replication, and other distributed data issues
- SQL Server security patching - Installed CU, Hotfixes as routine database server maintenance activity
- Establish standards and schedules for database backups using OLA scripts
- Assign permissions to the various database objects such as tables, views, and stored procedures
- Automated database tasks (created jobs, alerts and schedules for database maintenance tasks)
SQL SERVER DBA
TietoEvry India Pvt. Ltd
2014.12 - 2021.07
- Extensive working experience with Always on Availability Groups
- Installed and configured of MS SQL Server 2016
- Execution of SQL User, Logins, Roles as a part of security policies for various categories of users
- Deploying new code base release to SIT, UAT and Production Environments
- Perform SQL Server patching of service pack / hotfixes / CU
- Experience in using Proactive DBA tool to monitor databases and CPU health
- Experience in working with PRTG monitoring tool to administer disk space, blocking, availability of DBs
- Approving database DML - DDL queries provided by developers to merge in built process.
Education
Master of Computer Application - Computer Science and Application
Babasaheb Ambedkar Marathwada University
Aurangabad, Maharashtra 2009.07 - 2013.06
Bachelor of Computer Science -
MGM College of CS & IT
Nanded, Maharashtra 2006.04 - 2009.07
Higher Secondary School Certificate -
Maharashtra State Board
2002.06 - 2004.08
SSC -
Board Latur
Nanded, Maharashtra 2003.03 - 2004.04
Skills
High Availability (HA) and Disaster
Recovery (DR) management
SQL Server to Postgres migration
SQL Server to Azure Migration
Replication and Always On Availability Groups
Datadog Monitoring Tool
Client Communications
Certification
DP 300 : Administering Relational Databases on Microsoft Azure
Timeline
Senior Lead Database Consultant
Allstate India Pvt. Ltd.
2023.12 - Current
Lead Database Administrator
Cigres Technologies Private Limited (Cignex Datamatics)
2023.02 - Current
Lead DBA/Senior Associate
Cognizant Technology Solutions
2021.08 - 2023.02
SQL SERVER DBA
TietoEvry India Pvt. Ltd
2014.12 - 2021.07
Master of Computer Application - Computer Science and Application
Babasaheb Ambedkar Marathwada University
2009.07 - 2013.06
Bachelor of Computer Science -
MGM College of CS & IT
2006.04 - 2009.07
SSC -
Board Latur
2003.03 - 2004.04
Higher Secondary School Certificate -
Maharashtra State Board
2002.06 - 2004.08
DP 300 : Administering Relational Databases on Microsoft Azure
AZ 104 : Microsoft Azure Administrator
MTA: Database Fundamentals - Certified 2018
ITIL Foundation Certificate in IT Service Management
Similar Profiles
Sumeet KotekarSumeet Kotekar
Sr. Operations Analyst at Allstate India Pvt. Ltd.Sr. Operations Analyst at Allstate India Pvt. Ltd.
Megha SanyalMegha Sanyal
Associate Manager at Allstate India Pvt. Ltd.Associate Manager at Allstate India Pvt. Ltd.
Uttara GiriUttara Giri
Operations Analyst at Allstate India PVT LTDOperations Analyst at Allstate India PVT LTD