MS SQL Database Administrator (L3)

8 years

0 Lacs

Posted:6 days ago| Platform: Linkedin logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

Position: MS SQL Database Administrator (L3)

Location: Mumbai (Fort Road)

Experience: 8+ Years with Relevant experience

Work Mode: Work from office

Notice Period : Immediate / 15 Days only (Mandatory)

 

Education Qualification:

 

B.E./Diploma/BSC/BTech (No education gap, Full time)

1. B.E. / Diploma [ In Computers Science, IT , Electronics & Telecommunication ] [ Civil and Mechanical not preferred]

2. B.Sc. -IT 

3. BCA or MCA [ Full time course from reputed University]

4. No gap in education [ Passing year for S.S. C , H.S.C. and Degree/Diploma to be mentioned]

 

JOB RESPONSIBILITIES:

 

  • 8+ years relevant experience and minimum 2+ years team lead experience is mandatory
  • Database troubleshooting and Failover cluster, Always ON working experience is Mandatory plus team management
  • Monitor generated log and event files indicating errors that will result in an incident
  • DR Database availability Monitoring
  • Monitor database log replication
  • Report Status of Log Replications as per agreed schedules
  • Session/Query/Log/Latch monitoring
  • Monitor the DB for failures and logged system events that indicate an imminent failure
  • Purging database Logs and trace files
  • Periodic config review to maintain consistent configurations
  • Review and recommendation to maintain availability
  • Monthly report on database availability
  • Monitor the DB for failures and logged system events that indicate imminent failure.
  • Reconfigure log Shipping
  • Transaction replication Configuration
  • Link Servers configuration
  • Failover clustering
  • Always ON
  • Responding to database related incidents and driving corrective action
  • Tuning DB parameters
  • Correlate related incidents together into a problem ticket and manage through the problem management process
  • Use trend analysis to identify, detail, categorize, prioritize and create Problems Management Records.
  • Restoration of database
  • Support SQL DB L2 team for handling critical issues.
  • Handle DB performance related issues.
  • Handle end to end Major incidents and communicate to customers on production issue.
  • Creating jobs/job schedule for routine/Maintenance jobs & Rebuilding of indexes
  • Purging database Logs and trace files & Performance Management
  • Defragmentation of Database and performance tuning
  • Manage all Service requests through the change management process
  • Automate administration tasks where possible
  • Manage and update all Database environment documentation
  • SQL patch compliance and hardening compliance.
  • Ensure DB server availability for business application.


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

RecommendedJobs for You