Vikash Kumar

Experience

• 

  Mphasis

  May 2007 - Dec 2008

  Sr. Tech Support

  L1, L2 support to Bank of America EmployeesTaking calls, resolving issues on calls, incident management per ITIL, Resolving escalated issues, Creating monthly reports, call monitoring, Providing feedback.

• 

  IYogi

  Nov 2009 - Jan 2011

  Specialist

  - Install, upgrade, apply service packs. Fix issues or error.-Installed SQL Server 2008 Upgrade Advisor to test the pre-up gradation test and fix issues or error in case any occurs.- Performed Windows 2008 Cluster configuration and SQL Server 2008 Cluster Installation.- Planned and done log shipping for migration of huge database within 30 min downtime window.- Did backup and restoration of smaller databases.- Configured 3 node cluster with storage on SAN on Windows Server 2008 E.E Show less

• 

  Patni Computer Systems

  Apr 2011 - Jun 2013

  Senior Associate

  - Install, upgrade, apply service packs. Fix issues or error.-Install SQL Server 2008 Upgrade Advisor to test the pre-up gradation test and fix issues or error in case any occurs.- Perform Windows 2008 Cluster configuration and SQL Server 2008 Cluster Installation.- Log shipping for migration of huge database within 30 min downtime window.- 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-off (for UAT & Production).- Documented SOP for database Migration (SQL Server 2005 & SQL Server 2008).- Configured 3 node cluster with storage on SAN on Windows Server 2008 E.E- Restored the Database on all the nodes depending upon their resource utilization- Setup DB Mail and SQL Server Alerts (Disk Space, TLog Full, Replication, Backup, Schema Change, CPU, Indexing Fragmentation etc.) Show less

• 

  Policybazaar.com

  Feb 2014 - Oct 2019

  Sr. SQL Server DBA

  Installing and maintaining SQL Server (2005, 2008, 2008R2, 2012, 2016) database systems. Updating database systems by reviewing, planning, testing and installing database security patches and service packs. Design, document and promote security "best practices", policies, standards and protocols. Migrating application code and objects from development/test environments to production. Working with development and systems teams to perform application and database tuning. Migrating Databases from SQL Server 2005 to SQL Server 2008, 2008R2, 2012, 2016. Setup and maintenance of appropriate database and application monitoring. Planned and done log shipping for migration of huge database.Backup and restoration of smaller databases.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-off (for UAT & Production).Documented SOP for database Migration (SQL Server 2005 & SQL Server 2008, 2008R2, 2012, 2016).Restored the Database on all the nodes depending upon their resource utilisationSetup DB Mail and SQL Server Alerts (Disk Space, T-Log Full, Replication, Backup, Schema Change, CPU, Indexing Fragmentation etc.) Implementation and monitoring of Always On feature for SQL server 2016 Show less

• 

  R Systems

  Sept 2020 - Oct 2022

  • Implemented various time series forecasting techniques to predict surge in orders, lowering customer wait time.• Built a customer attrition random forest model that improved monthly for clients likely to opt-out by providing relevant product features for them.• Coordinated with the product and marketing teams to determine what kind of client interactions resulted in maximized service opt-ins.• Coordinated with product team to create an engine in Python that improved the length on-page for users.• Implemented machine-learning models for different programs and projects. Show less

  • Data Scientist

    Jan 2022 - Oct 2022

  • Lead Database Administrator

    Sept 2020 - Oct 2022