Jobs

Interviews
Job Alerts
Tools

Upskill and Grow with AI

Mock Interview Practice interviews in realistic simulations

Coding Practice Improve your coding skills with challenges

Certification Earn certifications to validate your skills

AI Learning Get trained with AI expert sessions

Career Path AI insights for smarter career decisions

AI Job Match Score AI-Powered Job Match Against Your Resume and Optimize Your Resume

Career Tools and Resources

Resume Builder Build Professional Resume with Ease

ATS Friendliness Check Check Resume Friendliness for Applicant Tracking Systems

Auto Apply Apply to hundreds of jobs on any platform effortlessly

Co-Pilot (Chrome Extension) Your AI Assistant for Seamless Browsing Efficiency

Interview Questions Streamline interviews with ready-to-use questions

Salaries Discover market-driven salary insights across skillsets and geographies

Companies Explore leading companies actively hiring talent
For Employers

Home
>
Jobs in mumbai
>
Softenger
>
Job Profile : Database Administrator, MSSQL

Job Profile : Database Administrator, MSSQL

Softenger

6 - 7 years

10 - 15 Lacs

mumbai

Posted:1 week ago| Platform:

Apply

Skills Required

performance tuning automation powershell disaster recovery javascript stored procedures database administrator technical support monitoring product support

Work Mode

Work from Office

Job Type

Full Time

Job Description

Job Profile : Database Administrator, MSSQL Location : Mumbai Experience Required : 6-7 yrs - Softenger

Job Profile :

Database Administrator, MSSQL

Job Location :

Mumbai

Experience Required :

6-7 yrs 1. Database Maintenance Troubleshooting
Diagnose and resolve databases stuck in Recovery Pending, Suspect, or Emergency states. Perform root cause analysis for database startup failures, log file corruption, incomplete recovery, and storage issues. Fix issues related to missing/corrupted MDF, NDF, LDF files. Work on strip files, log file growth issues, disk threshold incidents, and fragmentation problems.

2. Performance Tuning
Execute and analyze Index Scan and Index Seek behavior using execution plans. Perform index maintenance: rebuilds, reorganize, and defragmentation. Trigger manage UPDATE STATISTICS (manual or automated). Identify slow queries, apply tuning techniques, and optimize stored procedures. Resolve CPU/memory bottlenecks, buffer pool pressure, tempdb contention, and IO issues.

3. Backup Recovery
Handle full, differential, log, striped, and filegroup backups. Restore databases using point-in-time recovery, tail-log backup, and piecemeal restore. Validate backup integrity using RESTORE VERIFYONLY.

4. High Availability Disaster Recovery
Configure and manage AlwaysOn Availability Groups (Synchronous/Asynchronous modes). Troubleshoot AG failover, replica sync issues, latency, and quorum/witness problems. Perform controlled failover and DR drills. Ensure RPO/RTO compliance.

5. Security Compliance
Implement and manage SQL logins, roles, permissions, encryption (TDE), audit, and compliance controls. Work with IAM/OIM teams for DB access provisioning.

6. Monitoring Automation
Use DMVs, PerfMon, SQL Profiler/Extended Events, and monitoring suites (SolarWinds, Idera, SCOM, OEM, etc.). Automate database tasks using T-SQL, PowerShell Agent Jobs. Create health checks and proactive alerts for performance and availability.

7. L3 Support Ownership
Provide expert-level technical support for production outages and escalated incidents. Lead RCA (Root Cause Analysis) and corrective action plan preparation. Write scripts, SOPs, knowledge articles, and operational runbooks.

More Jobs at Softenger

Oracle Database Administrator

Pune

Experience: Not specified

INR 2 - 5 Lacs

Network Engineer | L2 | Onsite | Pune

Pune

3 - 5 yrs

INR 1 - 3 Lacs

Network Administrator/Network Engineer | L2 | Mumbai

Mumbai, Thane

2 - 4 yrs

INR 1 - 5 Lacs

Lead Engineer Email Gateway

Nagpur

5 - 10 yrs

INR 4 - 9 Lacs

Linux Administrator

Chennai

3 - 8 yrs

INR 4 - 7 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start JavaScript Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

Enhance Your Javascript Skills

Practice Javascript coding challenges to boost your skills

Start Practicing Javascript Now

Softenger

IT Services and IT Consulting

Pune Maharashtra

Login to

Please Verify Your Phone or Email

Confirm Action

Job Profile : Database Administrator, MSSQL