[Hiring] SQL Data Engineer @Spruce Infotech

Role Description

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
• Providing maintenance support
• Producing comprehensive documentation for a clean handoff to the lead for upcoming migration of the solution to Snowflake

Qualifications

• 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

Requirements

• 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
• 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
• 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
• 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

Benefits

• 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