StarCompliance

Application Support Engineer (SQL Expert) West Coast

United States

Not SpecifiedCompensation
Senior (5 to 8 years), Expert & Leadership (9+ years)Experience Level
Full TimeJob Type
UnknownVisa
Enterprise SoftwareIndustries

Application Support Engineer (SQL Expert)

Employment Type: Regular - Full-time

Position Overview

StarCompliance is seeking a highly skilled, critical-thinking Application Support Engineer (SQL Expert) to join our expanding Technical Services team. Based on the West Coast, this lead analyst position will primarily provide technical expertise for the level 2 application support team, alongside proactive application/database monitoring and issue resolution. You will play a crucial role in ensuring the smooth operation of our web applications using your extensive knowledge of co-located and cloud environments, and will be instrumental in driving operational excellence and delivering a best-in-class client experience.

The ideal candidate will have a deep understanding and previous experience of web application support using Microsoft technologies (IIS/MSSQL) and a proven track record of successfully operating within technical teams in a fast-paced environment. Technical Services is an integral function within StarCompliance, working directly with Client Services, Professional Services, Product, Relationship Management, and Sales. Technical knowledge is paramount for this position, alongside deep critical thinking and an ability to methodically assess, direct, or resolve issues that may not have been encountered previously. Successful candidates will need to be passionate about the StarCompliance brand identity and understand the solutions that the company provides.

Responsibilities

  • Web Application Support: 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.
  • Microsoft SQL Expertise: Utilize deep knowledge of Microsoft SQL Server, using SQL Server Management Studio (SSMS) and Profiler, to analyze, optimize, and troubleshoot database performance issues.
  • Azure Environment Support: 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.
  • IIS Management: Configure, monitor, and maintain Internet Information Services (IIS) to ensure optimal performance and reliability of web applications.
  • Incident Management: Investigate and resolve complex technical incidents related to web application functionality, performance, and infrastructure components.
  • Documentation and Knowledge Sharing: Create and maintain technical documentation, guidelines, and best practices for web application support and troubleshooting processes.
  • Leadership: Operate as a lead analyst to a team of like-minded technical analysts, providing guidance, mentoring, and technical expertise to ensure the team's success and professional growth.
  • Collaboration: Work closely with cross-functional teams, including client services, infrastructure, and development, to ensure seamless integration and continuous improvement of web applications.

Requirements

  • Deep Technical Expertise: Extensive experience supporting web applications at a Windows server level, with a strong understanding of hosted applications within IIS and Azure environments.
  • Database Expertise: Strong understanding of Microsoft SQL (SSMS) and experience with database management and T-SQL querying, including identifying and improving performance bottlenecks.
  • Application Monitoring Experience: 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. Previous exposure to Kusto Query Language (KQL) experience is preferred.
  • Problem-Solving Skills: Proven ability to independently analyze complex technical issues, identify root causes, and implement effective solutions in a timely manner, leveraging application monitoring data.
  • Strong Communication: Excellent verbal and written communication skills.

Company Information

StarCompliance

Location Type

West Coast

Skills

SQL
Microsoft SQL Server
SQL Server Management Studio (SSMS)
Profiler
IIS
Web Application Support
Database Performance Tuning
Troubleshooting
Issue Resolution
Azure

StarCompliance

Compliance software for financial institutions

About StarCompliance

StarCompliance provides compliance software solutions specifically designed for financial institutions and corporations. Its software platform automates compliance processes, helping clients manage regulatory requirements related to insider trading, market abuse, and conflicts of interest. By using advanced technology, StarCompliance allows firms to effectively monitor compliance risks, which helps prevent legal issues and protects their reputation. The company operates on a subscription model, where clients pay a recurring fee for access to the software, including updates and support. This model not only ensures a steady revenue stream but also offers clients various service tiers to meet their specific needs. Additionally, StarCompliance offers consulting services to assist firms in implementing and optimizing their compliance programs. The goal of StarCompliance is to help financial firms navigate complex regulations and maintain high ethical standards.

Rockville, MarylandHeadquarters
1999Year Founded
GROWTH_EQUITY_VCCompany Stage
Financial ServicesIndustries
51-200Employees

Risks

Emerging regtech startups offer innovative solutions at lower costs.
Rapid cryptocurrency regulation changes challenge platform updates.
Subscription model may suffer during economic downturns.

Differentiation

StarCompliance offers a configurable platform for global financial regulations.
The company integrates traditional and digital asset compliance in one solution.
StarCompliance's platform provides a 360-degree view of employee activity and behavior.

Upsides

Acquisition of Aer Compliance enhances cryptocurrency compliance capabilities.
New UI improves user experience and compliance outcomes.
Global recognition by CPD Standards Office boosts credibility and training offerings.

Land your dream remote job 3x faster with AI