Job Title : Senior MS Access / VBA Consultant
Location : Remote
The client is seeking a highly skilled technical consultant to support a homegrown VBA-based application called Star Tracker, built with MS Access Forms (front end) and SQL Server databases (back end). This engagement focuses on documenting the existing solution, refreshing and optimizing SQL Server databases, and providing maintenance support. The consultant will also produce comprehensive documentation to enable a clean handoff to the lead for upcoming migration of the solution to Snowflake.
Required Qualifications
Key Responsibilities
1. Application & Architecture Documentation
Entity relationship diagrams
2. SQL Server Database Refresh & Optimization
Index tuning
3. Application Maintenance & Support
4. 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.
Preferred Qualifications
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.
Senior MS Access VBA Consultant • AK, United States