Ms Sql Database Administrator

Visara Human Capital Services

Mumbai

On-site

INR 1,200,000 - 2,300,000

Full time

3 days ago

Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Visara Human Capital Services is seeking an experienced MS SQL Database Administrator to join our team in Mumbai. The role requires strong technical skills in managing MS SQL databases, Failover Cluster, Always ON setups, replication, link servers, hardening, patching, and ongoing maintenance.

Responsibilities include monitoring logs, DR availability, log replication, performance tuning, and regular maintenance tasks to ensure high availability and reliability of database systems.

Qualifications

Experience with MS SQL Database administration including Failover Cluster and Always ON setup.
Proficiency in patching, hardening and day-to-day operation of SQL servers.
Experience with replication, linked servers and performance tuning.
Ability to monitor logs, sessions, queries and system events.

Responsibilities

Monitor log and event files to identify incidents.
DR database availability monitoring and log replication monitoring.
Provide monthly reports on database availability.
Reinstall DB software and reconfigure log shipping as needed.
Configure transaction replication and link servers; manage failover clustering and Always ON.
Troubleshoot performance issues and perform DB maintenance tasks.
Create maintenance jobs and index rebuilding; purge logs and trace files.
Manage changes through the change management process and document DB environment.

Skills

Always ON Cluster configuration

Failover Cluster Management

Replication and Link Server"

Database Patching and Hardening

Database Installation and Troubleshoоt

Job Scheduling and Maintenance plan

Database Migration

Troubleshooting DB performance

Job description

Role Purpose

We are seeking an experienced MS 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 new 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 Configuration
15) Link Servers configuration
16) Failover clustering
17) Always ON
18) Responding to database related incidents and driving corrective action
19) Tuning DB parameters
20) Correlate related incidents together into a problem ticket and manage through the problem management process
21) Use trend analysis to identify, detail, categorize, prioritize and create Problems Management Records.
22) Restoration of database
23) Creating jobs/job schedule for routine/Maintenance jobs & Rebuilding of indexes
24) Purging database Logs and trace files & Performance Management
25) Defragmentation of Database and performance tuning
26) Manage all Service requests through the change management process
27) Automate administration tasks where possible
28) Manage and update all Database environment documentation