Pranali Gujar

Experience

• 

  Reliance Industries Limited

  Feb 2010 - Jun 2015

  Sr. IT Associate

   Done installation, configuration, and maintenance of MS SQL Server on various environments. Designed database maintenance plans, profiler and execution plans for stored procedure development and indexes for optimizing performance. Relocation of Databases from one server to another server using attach and detach databases. Rebuilding the indexes at regular intervals for better performance. Implemented log shipping between two instances of server using Database Maintenance Plan by creating a Monitor server and a shared Folder. Responsible to Monitor and troubleshooting Log Shipping. Involved in trouble shooting and fine-tuning of databases for its performance and concurrency. Monitored and modified Performance using execution plans and Index tuning. Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).  Performed the migration of SQL Server 2000 to SQL Server 2008. Show less

• 

  Atos

  Jun 2015 - Aug 2019

   Responsible for installation, configuration, and maintenance of MS SQL Server on various environments. Responsible for routine Backups and Restoration. Database Backup Procedures, Restoration Procedures, and Disaster Recovery procedures. Testing and implementing these procedures. Monitoring MS SQL Server performance and managing the use of disk space, memory and connections. Recovering the databases from backup in disasters. Monitoring SQL server performance using profiler to find performance and dead-locks. Updating database systems by reviewing, planning, testing and installing database security patches and service packs. Migrating objects from development/test environments to production. Prepared Documentation for the Disaster Recovery plan. Show less  Responsible for installation, configuration, and maintenance of MS SQL Server on various environments. Responsible for routine Backups and Restoration. Database Backup Procedures, Restoration Procedures, and Disaster Recovery procedures. Testing and implementing these procedures. Monitoring MS SQL Server performance and managing the use of disk space, memory and connections. Recovering the databases from backup in disasters. Monitoring SQL server performance using profiler to find performance and dead-locks. Updating database systems by reviewing, planning, testing and installing database security patches and service packs. Migrating objects from development/test environments to production. Prepared Documentation for the Disaster Recovery plan. Show less

  • Consultant

    Oct 2017 - Aug 2019

  • Associate Consultant

    Jun 2015 - Sept 2017
• 

  Reliance Industries Limited (Retail)

  Sept 2019 - Mar 2023

  Deputy Manager
• 

  Jio Platforms Limited (JPL)

  Apr 2023 - now

  Manager