JOB Description for MS SQL Database Management MS SQL Database Administrator (L2)

LOCATION Mumbai, Fort

DOMAIN MS SQL Database

Level (L1/L2/L3) L2

Required Relevant Domain Experience 4-6 Years relevant experience

Job Type (Onsite/Remote) Onsite

Shift details (General/ 24X7) Onsite support 24 X 7

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 a

reputed University]

4. No gap in education [Passing year for S.S.C, H.S.C.

and Degree/Diploma to be mentioned]

Certifications Required if ANY Relevant Certification (Preference)

Specific Remarks/Requirement by

customer

Database troubleshooting and Failover cluster, Always ON

working experience is Mandatory

Role Purpose

We are seeking an experienced SQL Database Administrator to join our team. The ideal candidate will

have strong technical skills and experience in managing and supporting MS SQL Database including





Failover Cluster, Always ON Setup and recent server provisioning, Transaction replication, Link Servers,

Hardening, and patching in day-to-day operations.

JOB RESPONSIBILITIES

1) Monitor generated log and event files indicating errors that will result in an incident

2) DR Database availability Monitoring

3) Monitor database log replication

4) Report Status of Log Replications as per agreed schedules

5) Session/Query/Log/Latch monitoring

6) Monitor the DB for failures and logged system events that indicate an imminent failure

7) Purging database Logs and trace files

8) Periodic config review to maintain consistent configurations

9) Review and recommendation to maintain availability

10) Monthly report on database availability

11) Monitor the DB for failures and logged system events that indicate imminent failure.

12) Reinstall Database software

13) Reconfigure log Shipping

14) Transaction replication

📌 Opening For MS SQL Database Admin at Fort Salary 12 LPA (Mumbai)
🏢 Aforeserve
📍 Mumbai