SQL Server Data Engineer

SQL Server Data Engineer (EL3)

Work Type: ONLY W2

Role Overview

The client is seeking a highly skilled technical consultant to support a homegrown VBA-based application (Star Tracker) built using MS Access Forms (front end) and SQL Server (back end). The role focuses on documentation, database optimization, maintenance support, and migration readiness for a future move to Snowflake

Key Responsibilities

1. Application & Architecture Documentation

• Assess existing MS Access/VBA front-end and SQL Server back-end
• Document:
• Application workflows
• Business logic
• Data flows
• Dependencies and integrations
• Deliver detailed technical documentation including:
• Entity Relationship Diagrams (ERDs)
• Process flows and data lineage
• VBA modules/functions catalog
• Configuration and environment details

2. SQL Server Database Refresh & Optimization

• Review database structures, stored procedures, tables, indexes, and jobs
• Perform:
• Index tuning
• Query optimization
• Archival strategies
• Database health checks and remediation
• Align database structures with business and technical requirements

3. Application Maintenance & Support

• Provide ongoing support for the Star Tracker application
• Troubleshoot MS Access/VBA front-end and SQL Server back-end issues
• Implement minor fixes and enhancements as needed

4. Migration Readiness & Handoff

• Ensure documentation is complete and migration-ready
• Participate in knowledge transfer sessions
• Identify risks, gaps, and migration dependencies

Required Qualifications

• 5+ years of experience with MS Access, VBA, and SQL Server
• Strong SQL Server expertise:
• Stored procedures
• Performance tuning
• Indexing
• Data modeling
• Experience reverse-engineering and documenting legacy systems
• Strong understanding of data architecture and migration considerations
• Excellent communication and collaboration skills

Desired Qualifications

• Experience modernizing or supporting VBA/MS Access applications
• Exposure to Snowflake or other cloud data platforms
• Experience producing migration-ready documentation