MS-SQL L1 & L2 Engineers (WFH)

About the job:

Job Title: MS-SQL L1 & L2 Engineers

Location: Andheri, Mumbai (On-site)

Employment Type: Full-Time (Partner Payroll)

Experience Required: Minimum 5+ years of relevant MS-SQL Database Administration experience

Shift Pattern: 24x7 Operations / Rotational Shift-Based Support

Job Overview

We are looking for experienced and proactive MS-SQL L1 & L2 Database Engineers with a minimum of 5 years of relevant experience to join our core database infrastructure team. In this role, you will be responsible for maintaining database health, monitoring performance, performing backup/recovery operations, and delivering end-to-end production support in a 24x7 operational environment.

Key Responsibilities
- Database Administration & Maintenance:
- Perform day-to-day administration, installation, configuration, and maintenance of MS-SQL Server instances across production, staging, and development environments.
- Execute routine database maintenance tasks including index defragmentation, index rebuilding, and statistics updates.
- Troubleshooting & Incident Management:
- Serve as L1/L2 escalation point to handle database incidents, performance issues, and user requests.
- Conduct root cause analysis (RCA) for database outages and performance bottlenecks.
- Monitor and resolve blocking, deadlocks, connectivity issues, and query performance problems.
- Monitoring & Alerts:
- Proactively monitor database health, CPU/memory usage, disk space utilization, and SQL Server logs.

- Respond promptly to automated system alerts and take necessary corrective actions to ensure high availability.
- Backup, Recovery & Security:
- Implement, manage, and regularly test backup strategies (full, differential, transaction log) and point-in-time recovery processes.
- Manage user access, database roles, permissions, and security configurations in adherence to compliance standards.
- Production Support & Operations:
- Provide 24x7 shift-based production support to maintain maximum uptime and operational continuity.
- Execute database deployment tasks, schema changes, script executions, and database migrations during planned maintenance windows.

Key Technical & Professional Qualifications
- Core Technical Skills:
- Strong expertise in MS-SQL Server Administration (SQL Server 2012/2016/2017/2019/2022).
- Hands-on experience with SQL Server agent jobs, backup/restore procedures, and database consistency checks (DBCC).
- Knowledge of High Availability (HA) and Disaster Recovery (DR) solutions (e.g., AlwaysOn Availability Groups, Database Mirroring, Log Shipping, and Clustering) is preferred.
- Proficiency in T-SQL scripting for administrative automation and operational reporting.
- General Requirements:
- 5+ years of hands-on experience in MS-SQL Server Database Administration.
- Proven experience working in a 24x7 production support environment with rotational shifts.
- Strong problem-solving abilities and clear communication skills for coordinating with multi-disciplinary IT teams.
- Willingness to work on Partner Payroll and report on-site at the Andheri, Mumbai office.

Who can apply:

Only those candidates can apply who:
- have minimum 5 years of experience

Salary:
Competitive salary

Experience:
5 year(s)

Deadline:
2035-01-01 00:00:00