Lead and optimize stored procedures for performance on transactional databases.
Analyze and manage data model complexity, including understanding the current and historical states of our data architecture.
Driving performance and scalability for massive hybrid database infrastructures like SaaS and on-premises database ecosystems.
Triage, organize, and prioritize incoming database development tasks and issues to ensure timely and effective resolution.
Drive initial training and documentation efforts to ensure smooth onboarding and knowledge transfer across teams.
Collaborate across teams—including Program Managers, Technical Leads, Platform Teams, and Data Architecture & Engineering—to design, build, scale, and support cloud-based analytics and data platforms.
Automate routine tasks using custom scripts and open-source tools to improve operational efficiency.
Participate in Agile/Scrum product development cycles, contributing to design, coding, testing, and deployment phases.
Supporting ETL pipelines to ensure high performance and scalability across complex data models.
Requirements
8+ years of experience in database/data engineering with proven success in large-scale data environments.
Proven track record in Design/architecting transactional databases across both IaaS and PaaS environments.
Proficiency in SQL Server, including advanced store procedure development and optimization.
Proficiency in C# and scripting languages such as PowerShell or other scripting languages highly desirable.
Experience in data warehouses (DWH), ETL pipelines, and BI solutions across both IaaS and PaaS environments is a plus.
Strong analytical and organizational skills, with the ability to triage, prioritize, and manage complex tasks effectively is a must.
Deep understanding of VEHR systems—prior experience is highly preferred.