MS SQL Database Administrator

Position : MS SQL Database Administrator (L3)

Budget : 20 LPA

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.