SQL Server Data Engineer

Vytwo Technologies Inc is seeking a highly skilled technical consultant to support a homegrown VBA-based application called Star Tracker. The role focuses on documenting the existing solution, optimizing SQL Server databases, and providing maintenance support while preparing for migration to Snowflake.

Responsibilities:

• Application & Architecture Documentation
• Conduct a thorough assessment of the existing MS Access/VBA front-end and SQL Server back-end architecture
• Document application workflow, business logic, data flows, dependencies, and integration points
• Create detailed technical documentation including:
• Entity relationship diagrams
• Process flows and data lineage
• VBA module/function catalog
• Configuration and environment details
• SQL Server Database Refresh & Optimization
• Review and assess the current SQL Server database structure, stored procedures, tables, indexes, and jobs
• Perform cleanup, optimization, and refresh activities including:
• Index tuning
• Query optimization
• Archival strategies
• Database health checks and remediation
• Ensure alignment of SQL Server structures with documented business and technical requirements
• Application Maintenance & Support
• Provide ongoing support for the existing Star Tracker application during the engagement period
• Troubleshoot issues with both the MS Access/VBA front end and SQL Server back end
• Implement minor fixes or enhancements as needed to maintain stability
• Migration Readiness & Handoff
• Partner closely with Optum Tech to prepare the solution for migration to Snowflake
• Ensure documentation is complete, structured, and migration friendly
• Participate in knowledge transfer sessions with technical and product teams
• Identify risks, gaps, or dependencies that may impact migration readiness

Requirements:

• 5+ years of experience with MS Access, VBA, and SQL Server development and support
• Strong SQL Server expertise including stored procedures, performance tuning, indexing, and data modeling
• Experience documenting legacy systems and reverse engineering both database and application logic
• Ability to quickly interpret and simplify complex VBA and Access form structures
• Strong understanding of data architecture principles and migration considerations
• Excellent communication skills for cross team collaboration and knowledge transfer
• Must be authorized to work in USA with a valid VISA/GC/USC
• Previous United Health /Optum experience is a must
• Experience modernizing or supporting VBA/MS Access based applications
• Exposure to cloud data technologies—especially Snowflake—is a plus
• Familiarity with Optum's technology ecosystem or healthcare data environments
• Experience producing migration ready documentation