Senior Full Stack Engineer - SQL, JavaScript, Azure

TSV Consulting LLC is partnering with a high growth Health Tech company in the Prior Authorization space to hire a Senior Full Stack Engineer. This role involves identifying and resolving software issues, optimizing database performance, and ensuring application reliability in the Azure Cloud.

Responsibilities:

• Identify, investigate, and resolve software issues across front-end (Kendo UI, JavaScript) and database-layer (stored procedures, query optimization) components
• Conduct root cause analysis, writing advanced SQL queries to troubleshoot data inconsistencies, performance bottlenecks, and application slowdowns
• Optimize database stored procedures and cache mechanisms to enhance execution speed and system efficiency
• Monitor, debug, and maintain applications running in Azure Cloud, ensuring reliability and scalability
• Develop query performance tuning strategies, including indexing and partitioning optimization
• Implement and manage cache-clearing strategies to prevent stale data and optimize system responsiveness
• Collaborate with developers, data engineers, and QA teams to maintain a stable and responsive system
• Conduct thorough code reviews, recommending improvements to enhance efficiency and prevent future issues
• Work in a fast-paced startup environment, adapting to evolving business needs and infrastructure changes

Requirements:

• 5+ years of hands-on experience in software troubleshooting, debugging, database optimization, and cache management
• Advanced experience with SQL, JavaScript, and Azure Cloud
• Advanced experience with Kendo UI or similar front end user interface
• Experience with code reviews
• Strong ability to write complex SQL queries for problem-solving at the database layer
• Advanced experience with stored procedures, database concepts, functions, logging, tables, and indexing
• Strong architectural deliberation and leadership
• An ability to quickly triage, analyze and solution design complex and ambiguous problems across the entire stack
• Process leadership, an ability to advocate for or own certain maturation initiatives within the engineering organization
• Ability to develop systems and patterns to measure both their own work and the work of the team
• Experience in Healthcare Tech or PBM domain