BSE - MS SQL - L2

Algoleap Technologies; Mumbai; Vor Ort; INR 1.200.000 - 1.800.000; Vollzeit

Zusammenfassung

Algoleap Technologies Pvt Ltd in Mumbai seeks an experienced SQL Database Administrator to join our team. You will manage MS SQL Databases including Failover Cluster, Always ON setups, transactions, link servers, hardening and patching in day-to-day operations.

You will monitor logs, DR availability, log replication status, and performance across sessions, queries, and jobs. Proactive tuning and maintenance are essential for uptime and reliability.

Qualifikationen

• Experience in MS SQL databases with high availability features.
• Strong troubleshooting and performance tuning skills.
• Hands-on with failover cluster, Always ON, replication, and link servers.

Aufgaben

• Monitor generated logs and events to pre-empt incidents.
• Manage DR database availability and report log replication status.
• Monitor sessions, queries, logs and latches for performance.
• Tuning DB parameters and periodic maintenance tasks.
• Handle database patching, hardening and upgrades.
• Create and manage maintenance jobs and index rebuilds.
• Coordinate database migrations and server provisioning.
• Respond to database incidents and drive corrective actions.
• Defragmentation and performance tuning for optimal DB health.

Kenntnisse

Always ON Cluster

DB Installation

Replication

Link Server configuration

Database Hardening

Maintenance Plan

Database Migration

Performance Tuning

Job Scheduling

Jobbeschreibung

Algoleap Technologies Pvt Ltd | Full time

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 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
• 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
• 14) Transaction replication Configuration
• 15) Link Servers configuration
• 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
• 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

Technical Skills/Knowledge Requirement

• 1) Database Installation and troubleshooting (Must)
• 2) Always ON Cluster configuration and Management (Must)
• 4) patching and Failover cluster and Always ON (Must)
• 5) Replication and Link Server configuration (Must)
• 6) Database Patching and Hardening (Must)
• 7) Job Scheduling and Maintenance plan
• 8) Database Migration (Must)
• 9) Troubleshooting on DB performance issue.