Nitish Verma

Experience

• 

  Tech Mahindra

  May 2019 - Jul 2021

  Technical Associate

  · Configured, Installed, and Maintained SQL Server 2005, 2008 in development, test, and production environment· Installed and Configured SQL Server Reporting Services (SSRS)· Configured and Maintained Replications, Log Shipping· Upgraded databases from SQL Server 7.0/2000 to 2005 in testing and production environment.· Expertise in database Performance tuning· Writing T-SQL and Stored-Procedures· Strong working experience in creating, modifying tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Stored Procedures, Triggers· Data Modeling, developing E-R Diagram using ERWin and SQL Server Data Diagram· Backward & Forward Engineering with data modeling tools mentioned above· Export & Import data from Flat file, CSV file, Oracle, and Access to/from SQL Server Database using DTS, SSIS, and BCP· Working experience in Database Backup, Restore and Point-in-Time Recovery· Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification· Developed Different Maintenance Plans for database monitoring· Monitor Server Activity, Error Log, space usage, and solving problem as needed Show less

• 

  FIS

  Jul 2021 - Aug 2022

  Senior Engineer

  · Installed, Configured, and Maintained SQL Server 2012, 2014, 2016, 2017 in development, test, and production environment· Configured database software, associated database tools and performance monitoring software.· Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.· Customized support for Client’s Applications and provided client will won the responsibility of creating and maintaining database objects and structures such as tables, indexes, views, triggers, Functions, Procedures.· Developed & maintained scripts, utility jobs or implement needed software for database maintenance.· Implemented & managed database clustering, failover and load balance technologies as per client requirement.· Developed, tested & implemented a robust database backup and recovery strategy with client assistance. Monitored data activities such as database status, logs, space utilization, extents, Checkpoints, locks and long transactions.· Suggested Application level tuning changes for code, queries, SQL objects that may not be performing up to the optimum database performance standards.· Adhered to Change Control Procedures and developed & executed scripted changes requests in accordance with change control procedures.· Deployed and Restored database including Point in Time Recovery Show less

• 

  HCL Technologies

  Aug 2022 - May 2024

  Specialist

  • Installed, configured and maintained SQL server 2005, 2008, 2012, 2014, 2016, 2017, 2019• Database backup/restore activities including point in time recovery.• Production database support and issue resolution•DR activities• Working on replication, always on environment, mirroring and log shipping• Set up job alerts, maintenance plans for backups• Analyze Application logs, troubleshoot issues, determine action and ensure Application Environments work smoothly• Support to Incident, Problem, Change and Request Tickets• Troubleshooting disk space and CPU utilisation issues.• Experience working on event viewer, task manager.• Operations and Processing Support• Using various sql and unix techniques to troubleshoot production issues.• Performed Patching activities.• Monitoring servers activity.• MSX/TSX Show less

• 

  Emerson

  Jun 2024 - now

  Database Administrator