SME - AzureMSSQL DBA, Microsoft Azure

Application Operations & Technical Ownership • Own and manage L3-level application operations for Windows-based enterprise applications built on.NET / ASP.NET, hosted on IIS, and integrated with Microsoft SQL Server. • Provide expert-level support for complex production issues impacting availability, latency, performance, errors, capacity, and reliability. • Act as the technical owner for application stability, ensuring production environments remain reliable, resilient, and aligned with agreed service levels. • Review application configuration, deployment patterns, environment dependencies, and operational risks to improve service reliability. Incident & Major Incident Management • Serve as the L3 technical escalation point for incidents escalated from L1/L2 support teams. • Lead technical investigation and resolution of complex P1/P2 incidents, ensuring timely service restoration and effective stakeholder communication. • Perform deep-dive analysis across application logs, IIS logs, Windows event logs, SQL performance indicators, metrics, traces, and monitoring dashboards. • Support on-call and 24x7 major incident response as required for business-critical applications. Problem Management & Root Cause Elimination • Lead root cause analysis for recurring, complex, or business-critical incidents and define corrective and preventive actions. • Identify systemic reliability gaps and drive permanent fixes, workarounds, automation, configuration changes, or architectural improvement recommendations. • Work with development, infrastructure, and database teams to resolve underlying application, platform, configuration, and performance bottlenecks. • Ensure known errors, recurring issues, and technical risks are captured, tracked, and addressed through structured problem management. Monitoring, Observability & Reliability Engineering • Design, configure, and enhance monitoring, alerting, dashboards, and observability solutions for application health, user impact, performance, and reliability indicators. • Analyze metrics, logs, traces, and monitoring trends to proactively detect performance degradation, stability risks, capacity constraints, and emerging failure patterns. • Drive adherence to SLOs, SLIs, SLAs, and error budget principles, ensuring reliability objectives are measurable and actionable. , • Recommend improvements to monitoring coverage, alert quality, runbooks, dashboards, and operational readiness. , Technical Operations – IIS, Windows Server & SQL Server • Provide expert-level troubleshooting and administration support for IIS-hosted applications, including website/application configuration, application pools, deployments, SSL certificates, performance tuning, and issue resolution. • Diagnose and resolve complex Windows Server and application runtime issues impacting application availability or performance. • Analyze and troubleshoot Microsoft SQL Server issues related to query performance, connectivity, capacity, database health, and application-level database dependencies. • Partner with database teams to drive SQL tuning, database health monitoring, and long-term performance improvement actions. Automation & Continuous Improvement • Develop and maintain automation scripts and tools using PowerShell, C#, or related technologies to reduce manual effort, operational toil, and repeat incidents. • Identify opportunities to automate health checks, log analysis, deployment validation, incident diagnostics, and routine operational activities. • Support CI/CD, release validation, deployment readiness, rollback planning, and production acceptanceactivities. • Drive continuous improvement actions to improve scalability, reliability, operational efficiency, and supportability.

Technical Leadership, Governance & Documentation • Provide technical guidance and mentoring to L1/L2 support engineers for troubleshooting, incident handling, monitoring, and operational best practices. , • Maintain and improve runbooks, SOPs, troubleshooting guides, knowledge articles, and technical documentation. • Contribute to service improvement plans, architectural fix recommendations, reliability reviews, and operational governance forums. • Communicate effectively with technical teams, business stakeholders, and leadership during incidents, problem reviews, and service improvement discussions. Core Technical Skills • Strong hands-on experience supporting and troubleshooting.NET / ASP.NET applications in enterprise production environments. , • Advanced knowledge of IIS, including application pools, bindings, SSL certificates, configuration, deployment, performance tuning, and troubleshooting. • Strong working knowledge of Microsoft SQL Server, including querying, performance tuning, troubleshooting, database health monitoring, and capacity considerations. , • Strong understanding of Windows Server environments, application deployment, configuration management, log analysis, and debugging. • Experience with observability and monitoring tools such as Splunk or equivalent platforms. ________________________________________ SRE / Operations Skills • Strong experience in production support, application operations, and SRE practices, preferably at L3 or senior technical escalation level. • Strong understanding of Incident, Problem, and Change Management processes aligned with ITIL practices. • Practical knowledge of monitoring, observability, performance tuning, capacity management, SLOs, SLAs, and error budgets. • Ability to analyze complex application behavior using logs, metrics, traces, SQL data, IIS configuration, and infrastructure signals. • Strong automation mindset with experience in scripting and operational tooling. ________________________________________ Soft Skills • Strong analytical, diagnostic, and problem-solving capabilities for complex production issues. • Ability to work effectively under pressure during major incidents and high-priority escalations. • Strong communication skills with the ability to explain technical issues clearly to technical and business stakeholders. • Collaborative mindset with the ability to work across application, development, infrastructure, database, and business teams. , • Ability to mentor junior engineers and contribute to knowledge sharing and operational maturity.