Description

Maintain and optimize legacy MS Access and SQL Server solutions while preparing them for migration to Snowflake.

This role is remote.

Responsibilities

• Assess existing MS Access/VBA front-end and SQL Server back-end architecture to document workflows, logic, and data flows.
• Review and optimize SQL Server structures, including stored procedures, indexes, and query performance.
• Provide ongoing support for the Star Tracker application, troubleshooting issues across MS Access/VBA and SQL Server.
• Partner with client tech teams to prepare the solution for migration to Snowflake, ensuring documentation is complete.

Required Skills

• 5+ years of experience with MS Access, VBA, and SQL Server development and support.
• Strong expertise in SQL Server, including stored procedures, performance tuning, and indexing.
• Experience documenting legacy systems and reverse-engineering application and database logic.
• Ability to interpret and simplify complex VBA and Access form structures.
• Strong understanding of data architecture principles and migration considerations.

Preferred Skills

• Experience modernizing or supporting VBA/MS Access-based applications.
• Exposure to Snowflake or cloud data technologies.

Key Skills

Education

Any Graduate