Administrator - AzureMSSQL DBA, Microsoft Azure
Technology, Data & Digital · Software & Web Development · Software Engineering · Database Administration
In short
The SRE L2 Engineer is responsible for the stability, availability, and performance of production applications built on the Microsoft technology stack. This role focuses on L2 production support, advanced troubleshooting, and proactive reliability engineering to minimize incidents and improve operational efficiency.
Responsibilities
- Manage day-to-day application operations for .NET-based applications hosted on IIS and backed by SQL Server.
- Ensure high availability, performance, and reliability of production environments.
- Monitor application health (availability, latency, errors, capacity) and take proactive actions.
- Perform deployment support, configuration, and environment management for applications.
- Perform L2-level troubleshooting for incidents escalated from L1.
- Handle P1/P2 incidents with ownership and drive service restoration within SLA timelines.
- Conduct root cause analysis (RCA) and implement permanent fixes or workarounds.
- Participate in on-call support / 24x7 rotation.
- Configure and manage application monitoring, alerting, and dashboards.
- Analyze logs, metrics, and traces to detect performance or stability issues.
- Contribute to SLO/SLI adherence and error budget tracking.
- Drive proactive incident elimination and reliability improvements.
- Manage IIS web servers (website/application configuration, deployment, SSL, performance tuning).
- Administer SQL Server databases (query optimization, performance tuning, troubleshooting, monitoring).
- Analyze application logs and system behavior for issue diagnosis.
- Develop scripts/tools (PowerShell / C#) to reduce operational toil.
- Identify recurring issues and implement automation or permanent fixes.
- Support CI/CD and release validation activities.
- Work closely with development, infrastructure, and DB teams for issue resolution.
- Maintain runbooks, SOPs, and knowledge articles.
- Provide inputs for system improvements and architectural fixes.
Requirements
- Strong experience in .NET / ASP.NET applications.
- Hands-on experience with IIS (Internet Information Services).
- Hands-on experience with Microsoft SQL Server (querying, tuning, troubleshooting).
- Experience in production support (L2).
- Strong understanding of Incident, Problem, and Change Management (ITIL).
- Strong understanding of Monitoring and observability tools.
- Strong understanding of Performance tuning and capacity management.
- Familiarity with SLO / SLA / Error Budget concepts.
- Familiarity with Automation and scripting.
- Knowledge of Windows Server environments.
- Knowledge of Application deployment and configuration.
- Knowledge of Log analysis and debugging.
- Knowledge of Observability using solutions such as Splunk.
- 3–6 years of experience in Application Support / SRE / Production Support.
- Bachelor’s degree in Computer Science / IT or related field.
- Experience in enterprise-scale production environments preferred.
- Strong analytical and troubleshooting skills.
- Ability to work under pressure during major incidents.
- Effective communication with technical and business stakeholders.
- Collaborative mindset across cross-functional teams.
#Azure#MSSQL#DBA#SRE#L2 Support#Production Support#ITIL#Monitoring#Performance Tuning#Capacity Management#Automation#Scripting#IIS#SQL Server#Windows Server#Splunk#CI/CD#RCA