MS-SQL L1 & L2 Engineers

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.