Sonal Pathak

Background

About Sonal Pathak

Database Engineer- • Administer and DB integrity and availability by following best practices. • Backup, recovery, monitor SQL server, backups and improve DB performance. • Analyse and solve DB problems in a timely and accurate fashion. • Install SQL server environments & configure as per guidelines recommended (SSIS, SSAS, SSRS) • DB backup and DB restore from production to test and vice versa (Refresh), and across servers. • Creation of managed instance, SQL on Azure VM and single database. • Review the job executions, change schedule of a job & configure jobs as per guidelines. • Review available free space, capacity planning and troubleshooting database latency • Create users & grant, remove, change permissions to users on SQL server & its dBs. • Database migration, upgrade of SQL server 2012 r2 to 2016 & 2019 and from on prem to Azure. • Creating scripts, functions, trigger, procedures, database tables, schemas. • Testing databases and performing bug fixes. • Fixing any issues related to performance, shrink database, index rebuild, reorg.Creating a dashboard in power bi to understand trends and business in depth.