Application Support Engineer

Summary

Join StarCompliance's expanding Technical Services team as a highly skilled Application Support Engineer (SQL Expert) based on the West Coast. In this lead analyst role, you will provide technical expertise for the level 2 application support team, proactively monitor applications and databases, and resolve issues. You will ensure smooth operation of web applications in co-located and cloud environments, driving operational excellence and delivering a best-in-class client experience. This position requires deep understanding of web application support using Microsoft technologies (IIS/MSSQL) and experience in fast-paced environments. Success requires passion for the StarCompliance brand and understanding of its solutions. The role involves collaboration with various teams and leadership responsibilities within the technical team.

Requirements

• Have extensive experience supporting web applications at a Windows server level, with a strong understanding of hosted application within IIS and Azure environments
• Have a strong understanding of Microsoft SQL (SSMS) and experience with database management and T-SQL querying including identifying and improving performance bottlenecks
• Have proven experience implementing and utilizing application monitoring tools such as Application Insights (or similar) to capture and analyze application metrics, performance data, and error logs
• Have a proven ability to independently analyze complex technical issues, identify root causes, and implement effective solutions in a timely manner, leveraging application monitoring data
• Have excellent verbal and written communication skills, with the ability to convey technical information to both technical and non-technical stakeholders
• Have previous experience in a lead or supervisory role, with the ability to motivate and guide a team of technical analysts
• Have a demonstrated ability to work effectively in a cross-functional team environment, fostering collaboration and knowledge sharing
• Have strong attention to detail and the ability to prioritize tasks effectively while managing multiple competing priorities
• Have a passion for staying up to date with the latest technologies and industry trends related to web application support and cloud computing
• Undergo a rigorous background investigation with checks including, but not limited to, criminal record history, consumer credit, employment history, qualifications, and education checks

Responsibilities

• Provide technical expertise and support for StarCompliance web applications, acting as the primary point of contact for highly technical issues undertaking troubleshooting and issue resolution
• Utilize deep knowledge of Microsoft SQL Server, using SQL Server Management Studio (SSMS) and Profiler, to analyze, optimize, and troubleshoot database performance issues
• Collaborate with development and operations teams to support and monitor Azure environments, leveraging tools such as Application Insights for performance monitoring and proactive issue identification
• Configure, monitor, and maintain Internet Information Services (IIS) to ensure optimal performance and reliability of web applications
• Investigate and resolve complex technical incidents related to web application functionality, performance, and infrastructure components
• Create and maintain technical documentation, guidelines, and best practices for web application support and troubleshooting processes
• Operate as a lead analyst to a team of likeminded technical analysts, providing guidance, mentoring, and technical expertise to ensure the team's success and professional growth
• Work closely with cross-functional teams, including client services, infrastructure, and development, to ensure seamless integration and continuous improvement of web applications

Preferred Qualifications

Have previous exposure to Kusto Query Language (KQL) experience