Summary
Overview
Work History
Education
Skills
Certification
Affiliations
Timeline
Generic
Pranita Deshmukh

Pranita Deshmukh

Pune

Summary

MSSQL Database Administaror

Overview

13
13
years of professional experience
1
1
Certification

Work History

Database Administrator

Equifax
Pune
12.2023 - Current
  • Successfully managed the team of 6 people
  • Demonstrated as a critical resource during the project transition period.
  • Represented the DBA team at multiple platforms at Equifax.
  • Developed documentation for database processes and standards for the team.
  • Assisted in capacity planning and resource allocation for database environments.
  • Developed scripts for automating routine maintenance tasks like windows patching
  • Conducted training sessions for junior DBAs regarding best practices related to database administration.
  • Coordinated with development teams to optimize database queries and indexes.
  • Troubleshooted established database refresh activity
  • Leading the project for data extraction from multiple server.
  • Actively involved in on-prem to cloud GCP POC.
  • Contributed to database perging activity reducing the disk space issues.
  • Individual contrubutor for migration activity.
  • worked on TDE and encryption at rest for critical databases.
  • Critical resource for security and compliance, vulnerability remediations.
  • Automation of the Jira tasks whereever the scope is.
  • Performed DR drill activity from DBA side.

Greensolution

SQL Database Administrator
Pune
06.2020 - 06.2023
  • Resolved performance tuning issues related to memory, CPU, disk I/O, and statistics.
  • Demonstrated expertise in indexing, execution plans, and query optimization.
  • Installed and configured MS SQL Server 2016, 2019, and 2022 environments.
  • Worked on disaster recovery plans, including log shipping, mirroring, replication, and Always On.
  • Executed backup and recovery processes while ensuring database security protocols.
  • Monitored critical database and server metrics using Excel for DB and disk growth tracking.
  • Automated tasks through PowerShell scripting to enhance operational efficiency.
  • Performed day-to-day responsibilities with accuracy and efficiency.
  • Azure DBA:

SQL on Azure VM (IAAS)

Azure DB (Single DB / Elastic Pool)

Managed instance

Worked in Purchase Model

Migration on DBs from on premise to Azure Db with Backpac file

Adding and removing database from and in Elastic Pool

Technical Manager at

MAARC Lab Pvt Ltd
Pune
12.2012 - 05.2017
  • to coordinate with all departments to managed their bussiness process.

Education

Master in Science -

Nagpur University
2010

Skills

  • Performance tuning
  • DP plans: AlwaysOn, replication, log shippingg
  • Scripting: PowerShell
  • Query optimization
  • OS migration: Windows 2016 to 2019
  • Tools : SSMS, DMA, Datadog Monitoring tool
  • BI: SSIS, SSRS
  • Cloud: Microsoft Azure, GCP
  • Database Purging
  • Security Compliance

Certification

  • Azure Fundamentals AZ900
  • Google cloud Associate certification.

Affiliations

  • Yes, passport available

Timeline

Database Administrator

Equifax
12.2023 - Current

Greensolution

SQL Database Administrator
06.2020 - 06.2023

Technical Manager at

MAARC Lab Pvt Ltd
12.2012 - 05.2017

Master in Science -

Nagpur University
Pranita Deshmukh