Summary
Overview
Work History
Education
Skills
Personal Information
Technicalskillsets
Roles And Responsibilities
Disclaimer
Timeline
Generic

Soham Kulkarni

Pune

Summary

My goal is to obtain a dynamic, challenging opportunity that contributes to the outstanding success of the business via 4 experience and best utilize my skills and strengths.

Overview

6
6
years of professional experience

Work History

SQL SERVER DBA

INDUS VALLEY PATNERS
02.2023 - Current

SQL SERVER DBA

PIXEL TECH SERVICES
09.2019 - 02.2023

TECH SUPPORT

PIXEL TECH SERVICES
06.2018 - 09.2019

Education

BE ELECTRICAL ENGINEERING -

JSPM'S RAJARSHI SHAHU COLLEGE OF ENGINEERING, PUNE

Skills

  • SQL Server Database Administration
  • Installation and configuration
  • MS SQL Server
  • Fragmentation
  • Troubleshooting
  • Database Solutions Log-Shipping
  • Disk space issues
  • Managing Security
  • Creating users
  • Logins and roles
  • Granting permissions
  • SQL and MYSQL servers
  • Creating Maintenance plans
  • Scheduled jobs
  • Backup/Recovery
  • Daily health check-up
  • Logs
  • Checking the log file size
  • Databases
  • SQL server
  • Resolving commands
  • Database refresh activity
  • Creating VM in Azure
  • Create And Restore
  • Export Databases
  • RDS
  • EC2 services

Personal Information

Date of Birth: 04/20/99

Technicalskillsets

  • SQL Server Versions: - 2014,2016,2017 & 2019.
  • BI Technology: - SSRS
  • Azure :- SQL managed Instance.
  • AWS- RDS, EC2

Roles And Responsibilities

  • Installation of SQL Server
  • Disaster Recovery Planning: Configured Log-Shipping, Database Mirroring, Replication.
  • Configured DB mails.
  • Monitoring: Database backup reports, Services, Data, Job Monitoring, Disk space Monitoring through site 24x7 tool, SQL Server Error log, Event viewer log etc.
  • Performance Tuning: Extensively worked with SQL Profiler, Activity monitor, DMVs, DMFs and DTA to tune the databases, queries, performance related issues like memory CPU and I/O issues, Reorganize/Rebuilding the indexes at regular intervals for better performance.
  • Security: Implementation of SQL Logins, Roles and Authentication Modes for SQL and MYSQL.
  • CRITICAL ISSUES HANDLED: SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options, Involved in troubleshooting and fine-tuning of databases for its performance. Blocking issue, Storage issue, Backup failure
  • Configuring TEMP DB on files and file groups and capacity planning of databases.
  • TICKET MANAGEMENT (Zendesk): Handling Incidents, Service Request, Change Requests, Problem Tickets as per ITIL Framework.
  • Configuring and deploying SSIS packages and SSRS reports.
  • Creating VM in Azure, Creating Resource Group (RG).
  • Create And Restore Databases on SQL and MYSQL.
  • Export Databases from PROD TO UAT\DEV, Premise to Azure, Import, Deploy.
  • Documentation of important information and circulating it among the team members.
  • Creating and Editing SOP's

Disclaimer

I solemnly declare that the information furnished above is free from errors to the best of my knowledge and belief.

Timeline

SQL SERVER DBA

INDUS VALLEY PATNERS
02.2023 - Current

SQL SERVER DBA

PIXEL TECH SERVICES
09.2019 - 02.2023

TECH SUPPORT

PIXEL TECH SERVICES
06.2018 - 09.2019

BE ELECTRICAL ENGINEERING -

JSPM'S RAJARSHI SHAHU COLLEGE OF ENGINEERING, PUNE
Soham Kulkarni