MS SQL Server DBA

2 - 4 years

4 - 6 Lacs

Posted:1 week ago| Platform: Foundit logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

Detailed JD *(Roles and Responsibilities)

  • Manage SQL Server databases.
  • Provide production support and end-to-end problem resolution.
  • Install, configure, and maintain database servers and processes.
  • Monitor systems health and performance.
  • Experience in Database high availability feature like ALWAYS ON
  • Refine and automate regular processes, track issues, and document changes.
  • Provide support for critical production systems.
  • Perform scheduled maintenance and support release deployment activities.
  • Monitoring all the Alerts. Every alert DBA team member will respond with the initially response and followed by resolution email.
  • Troubleshooting the SQL jobs maintenance jobs failed
  • Troubleshooting the ETL jobs if incase job is failed.
  • Troubleshoot disk space alert.
  • Experience in Creating, maintaining and scheduled jobs.
  • Database backup and restore including monitoring and verifying backups and perform ad-hoc
  • backups and restore.
  • Implement and maintain database security (create and maintain users and roles, assign privileges).
  • Experience in MSSQL Built-in tools such as SQL Profiler, SQL Database Tuning Advisor, Query
  • Execution Plan, etc. as well as third party tools; Actifio/Foglight
  • Experience in creating and maintaining SQL Agent Jobs and Maintenance Plans
  • Knowledge on SSIS and SSRS
  • Microsoft SQL Server Version updates and patching activities.
  • Ability to collaborate and communicate clearly to team members and clients, verbally and in writing.
  • Experience with Performance Tuning and Optimization (PTO)
  • Experience with backups, restores and recovery models.
  • Experience with High Availability (HA) and Disaster Recovery (DR) options for SQL Server (including AlwaysOn)
  • Extensive knowledge on SQL, T-SQL, SQL Server database and SQL Server Database Administration.
  • Prior experience with Azure.

Mandatory skills

  • MS SQL ServerDBA2012/2014/2016/2017/2019 and Windows Administration

Desired skills

  • MS SQL ServerDBA2012/2014/2016/2017/2019 and Windows Administration

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Fusion Plus Solutions logo
Fusion Plus Solutions

Information Technology & Services

Innovation City

RecommendedJobs for You

Bengaluru / Bangalore, Karnataka, India

bengaluru, karnataka, india