Website:
elixirglobal.com
Job details:
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.
Click on Apply to know more.
