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. This lead analyst role demands technical expertise in providing level 2 application support, proactive application/database monitoring, and issue resolution. 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. The ideal candidate possesses deep understanding and experience in web application support using Microsoft technologies (IIS/MSSQL) and thrives in fast-paced environments. Success requires passion for the StarCompliance brand and its solutions, along with strong critical thinking and problem-solving skills. The role involves collaboration with various teams, including Client Services, Professional Services, Product, Relationship Management, and Sales.

Requirements

• Extensive experience supporting web applications at a Windows server level, with a strong understanding of hosted application within IIS and Azure environments
• Strong understanding of Microsoft SQL (SSMS) and experience with database management and T-SQL querying including identifying and improving performance bottlenecks
• 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
• Proven ability to independently analyze complex technical issues, identify root causes, and implement effective solutions in a timely manner, leveraging application monitoring data
• Excellent verbal and written communication skills, with the ability to convey technical information to both technical and non-technical stakeholders
• Previous experience in a lead or supervisory role, with the ability to motivate and guide a team of technical analysts
• Demonstrated ability to work effectively in a cross-functional team environment, fostering collaboration and knowledge sharing
• Strong attention to detail and the ability to prioritize tasks effectively while managing multiple competing priorities
• A passion for staying up to date with the latest technologies and industry trends related to web application support and cloud computing

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

Previous exposure to Kusto Query Language (KQL) experience is preferred