Nayan Shah

Experience

• 

  Techexcel Pvt. Ltd.

  Apr 2011 - Dec 2013

  Software Developer

  -- Develop and customize ERP financial applications across the multiple programming languages like Coldfusion,.net,javaScipt and MS SQL-- Administrator financial market applications from End- to- End

• 

  Datavail Infotech Pvt. Ltd.

  Feb 2014 - Jun 2016

  SQL DBA -Tier II

  1.Responsible for Database support, troubleshooting, planning and migration.2.Upgrading SQL Server by applying patches, hot fixes and service packs.3.Implementation of database mirroring, log-shipping, replication to configure disaster recovery/high availability plan for production databases.4. Worked on database refresh from production environment to development/QA/staging environments.5. Created backup policies for database recovery and as per the business needs.6.Detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention using perfmon, SQL Profiler and DMV’s .7.Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, connectivity issues and security issues.8.Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.9.Handling performance related issues with respect to disk space, database files, long running queries, database indexing10.Rebuilding the indexes at regular intervals for better performance.10.Daily monitoring of incidents, change requests & acting upon those pertaining to database issues/requests Show less

• 

  Capgemini Invent

  Jul 2016 - Jun 2021

  Database Architect & Data Scientist Database and Visualization team lead

  • Senior Consultant

    Apr 2018 - Jun 2021

  • Consultant

    Jul 2016 - Apr 2018
• 

  GeBBS Healthcare Solutions

  Jun 2021 - Jul 2022

  Technical Architect
• 

  Aker Solutions

  Jul 2022 - now

  Chief Data Architect