Application Support Specialist - SQL

Overview We are seeking a highly skilled and detail-oriented Tier 3 Support Analyst to join our technical support team. This role is the highest level of application support, responsible for resolving complex, high-priority production issues across our benefits administration platform. The ideal candidate will be a technical expert with deep knowledge of enterprise applications, strong analytical abilities, and experience in healthcare benefits systems.

Your work ensures system stability, data integrity, and exceptional customer experience in a fast-paced, mission-critical environment.

Conduct in-depth root cause analysis (RCA) using application logs, database records, API traces, and system workflows.

Perform advanced troubleshooting across multi-tiered systems, including backend services, databases, APIs, and integrations (e.g., HRIS, payroll, third-party benefit providers).

Write and execute complex SQL queries to analyze data anomalies, validate business logic, and support diagnostics.

Partner with Product and QA to clarify requirements, validate bug fixes, and support regression testing.

Monitor system health and proactively identify potential issues through log analysis and performance trends.

Required Skills & Experience

Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent experience).3+ years of experience in technical support, application support, or software engineering roles, with proven experience at Tier 3 or equivalent level.health, dental, vision, retirement, FSA/HSA) and associated workflows.Strong hands-on experience with SQL (query optimization, joins, subqueries, stored procedures) and database troubleshooting.Proficiency in analyzing logs (application, server, API), understanding system behavior, and identifying patterns in error messages.Working knowledge of RESTful APIs, web services, and integration platforms (e.g., MuleSoft, Informatica, Zapier, etc.).Familiarity with scripting languages such as Python, PowerShell, or Bash for automation and log parsing.Experience with agile development methodologies and ticketing systems (e.g., Jira, ServiceNow).Prior experience or similar benefits administration platforms.

Exposure to cloud platforms (AWS, Azure) and containerized environments (Docker, Kubernetes).

Experience with monitoring tools (e.g., Datadog, New Relic, Splunk).

Certification in IT support, cloud computing, or software development (e.g., AWS Certified Cloud Practitioner, CompTIA A+/Network+, etc.). .