Ms Sql Database Administrator

Visara Human Capital Services; Mumbai; On-site; INR 1,500,000 - 2,200,000; Full time

Job summary

Visara Human Capital Services seeks an experienced MS SQL Database Administrator in Mumbai to manage and support MS SQL databases, including Failover Cluster, Always On setup, replication, and hardening. You will handle day-to-day provisioning, tuning, and maintenance tasks, ensuring high availability and optimal performance across the environment.

The role requires strong skills in database installation, patching, and problem resolution, with a focus on proactive monitoring and incident

Qualifications

• Extensive MS SQL database administration experience.
• Experience with Always On, Failover Clustering and patching/hardening.
• Proficient in replication and linked servers setup and maintenance.

Responsibilities

• Monitor logs/events and manage incidents.
• Manage DR readiness and log shipping.
• Configure and maintain Always On/Failover Clusters.
• Plan and perform database maintenance, indexing, and tuning.
• Create and manage maintenance jobs and schedules.
• Reinstall and reconfigure database software as needed.
• Prepare monthly database availability reports.

Skills

Always On

Failover clustering

Database monitoring

Replication

Performance tuning

Patch management

Job scheduling

Linked servers

DB administration

Education

Bachelor's degree in Computer Science

Tools

SQL Server

SQL Server Agent

SSMS

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

• 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.
• Reinstall Database software
• 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
• 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

Technical Skills/Knowledge Requirement

• Database Installation and troubleshooting (Must)
• Always ON Cluster configuration and Management (Must)
• Failover Cluster Management (Must)
• patching and Failover cluster and Always ON (Must)
• Replication and Link Server configuration (Must)Database Patching and Hardening (Must)
• Job Scheduling and Maintenance plan
• Database Migration (Must)
• Troubleshooting on DB performance issue