RAMMILAN KUSHWAHA
kalyan
Summary
Work experience as a Database Administrator Team Lead with over 17 years of experience managing teams of database administrators and developing innovative solutions to complex database problems.
Proven ability to lead teams through challenging projects and mentor other administrators in best practices.
Strong technical skills with experience in various database platforms, including MSSQL, Qlik Sense, AWS, AZ cloud and Qlik sense Nprinting tools
Overview
17
17
years of professional experience
1
1
Certification
Work History
Database Administrator Team Lead
Tata Consultancy Services
06.2011 - Current
- Installed SQL Server 2012, 2014, 2017 and 2019 Upgrade Advisor to test the pre-up gradation test and x issues or error in case any occurs
- Performed Disk and Hardware resource planning for 2 Node Cluster
- Performed Windows 2012, 2014, 2017 and 2019 Cluster conguration and SQL Server 2012, 2014, 2017 and 2019 Cluster Installation (tested MSSQL 2022)
- Planned and done log shipping for migration of huge database within 30 min downtime window
- Did backup and restoration of smaller databases
- Scripted all user and jobs and applied the same on the new production Box
- Redirecting all the applications to new SQL Server Production BOX (virtual name), testing the connectivity and data retrieval and report generation
- Securing the user and business sign-o (for UAT & Production)
- Documented SOP for database Migration (SQL Server 2008, 2012, 2016 & SQL Server 2019)
- Restored the Database on all the nodes depending upon their resource utilization
- Setup DB Mail and SQL Server Alerts (Disk Space, Log Full, Replication, Backup, Schema Change, CPU, Indexing Fragmentation etc.)
- Qlik Sense -Nov-2023 and Qlik Sense Feb-2024 upgrade.
- Cleanup activity on DATA Base.
Technical Support Executive (Incident Management)
Reliance Infostream Private Ltd
Mumbai
04.2007 - 05.2011
- Handling application outage issues from circles and escalating to concerned operations team for resolution
- Updating circles regarding planned and Unplanned (Incidents) Activates
- Monitoring Mercury, HP-OV SIP, IT-BOSS
- Maintaining daily, weekly, MIS for Planned events, Incidents, Server activities, cases assigned in Remedy and reported to the manager.
Education
Master of Science in Mathematics -
06.2016
B.Sci. IN Mathematics -
06.2006
Skills
- English
- Hindi
- Marathi
- Microsoft SQL
- Data conversion and migration
- Data Security
- Database Management
- Database analysis
- Data Migration
- Database Administration
Languages
- Writing Short Story
- Travelling
Awards
1.Star of the Month In appreciation of your outstanding contribution.
2.Best Team Awards
3.On the spot Awards
4.Outstanding contribution Awards for -contiunes working 3 days for storage issues.
Projects
DBA Trainer, 06/01/11, Present, Created training manual, PDF, PPT for 20 application, Created User manual and SOP (Standard operating procedure) for MSSQL, AZ Cloud SQL, Qlik Sense, Mobile Applications.
MSSQL Database administrator, 06/01/11, Present, Migration 2008 MSSQL To 2016, Migration from one network to another network, entire applications, total 20 application, 6 servers, and replication.
MSSQL server 2016 always on availability groups setup new servers, Prod, UAT, Test server, MSSQL server 2016 installation, 2014 2012 2019 and migration server 2012 to 2016 & 2019.
Qlik Sense DBA Lead, 04/01/18, Present, Qlik Sense Application upgraded to Nov 2020 and working on May 2022 version.,
Qlik N-Printing Setup and User Reports, Qlik QVD Reports, Qlik DR setup and Replication ON-Prime to DR servers., Qlik Automation parts.
Qlik Sense Nov-2023 upgrade.
Qlik Sense Feb-2024 upgrade.
Microsoft Server 2026 to 2019 upgrade.
Certification
- AZ-104 Microsoft Azure Administrator Certification
- DP-300 Azure Database Administrator Associate
Timeline
Database Administrator Team Lead
Tata Consultancy Services
06.2011 - Current
Technical Support Executive (Incident Management)
Reliance Infostream Private Ltd
04.2007 - 05.2011
Master of Science in Mathematics -
B.Sci. IN Mathematics -
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Kamlesh MadanKamlesh Madan
Software Engineer at LTIMindtreeSoftware Engineer at LTIMindtree