Prasanna

SQL Server DBA
placeholder
Location Pune
view-icon
Total Views41
availability
Shortlist0
back in time
Member since30+ Days ago
 back in time
Contact Details
phone call {{contact.cdata.phone}}
phone call {{contact.cdata.email}}
Candidate Information
  • User Experience
    Experience 4.5 Year
  • Cost
    Hourly Rate$2
  • availability
    Availability2 Week
  • work from
    Work FromOnsite
  • check list
    CategoryInformation Technology & Services
  • back in time
    Last Active OnMay 11, 2022
Key Skills
Java script JQueryApache TOMCATMYSQLJ2EECORE JAVAHTML
Summary
  1.  Having 4.5 years of Experience in SQL Server Database Administrator production support in Microsoft SQL Server 20005/2008, 2008R2, 2012, 2014 & 2016 and 2 years in java developer total 6.5 years of IT experience.
  2.  Installing, and configuring Microsoft SQL Server 2005/2008/2008R2/2012/2014 & 2016.
  3.  Applying Service Packs and Hotfixes in different versions 2005, 2008/R2, 2012, 2014 & 2016.
  4.  Supporting a total of 400 servers in 270 Servers production, Test, and Development Environment.
  5.  Implementing high availability solutions using the following techniques Replication, Log Shipping, Database Mirroring, Failover Clustering and AlwaysON in SQL Server 2012
  6.  Resolving the Disk space issues and finding the root cause and implemented permanent fixes.
  7.  Verifying and resolving the SQL Server Blocking issues and Finding the root cause
  8.  Creating and Administering the SQL Server Databases like data and log file placements and managing the growth parameters and database options.
  9.  Creation & administration of all database objects, including tables, indexes, views, stored procedures.
  10.  Working Experience on Migration activity from SQL Server 2008 to /2012/2014.
  11.  Protecting the databases by taking different kinds of Backups such as Full, Differential, and Transactional log backups.
  12.  Experience in implementing SQL Server security and Object permissions like maintaining the creation of users, configuring permissions, and assigning roles to users.
  13.  Establishing weekly maintenance plans such as Integrity check, Rebuilding indexes, Update statistics, and monthly maintenance plans such as clean-up history, etc. to run the databases efficiently.
  14.  Experience in Server Tuning, Query Tuning through SQL Server Profiler, and DETA.
  15.  Experience in SQL Server 2012 AlwaysON Configuration, troubleshooting, and failover.
  16.  Worked closely with management, development team, and users.
  17.  Work as part of a team and provide 24 x7 supports when required


Copyright : 2022 – OnBenchMark All Right Reserved.