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