Sr SQL Developer

• *POSITION**

Senior SQL Developer (MS Access/VBA) — SnapShot Modernization

• *LOCATION**

Corona , CA

• *DURATION**

18+ Month Contract

• *Salary Range
• *INTERVIEW TYPE

Process

Interview times between 4-6 pm est next week understanding

Confirmed feedback following each interview

2 rounds

• *Sponsorship**

No (Must be able to convert without sponsorship )

• *Description & Requirements
• Type: Contract (initial 18 months)
• Work model: Primarily on prem (SQL heavy); hybrid options as needed
• Domain: Fleetwood high end doors & windows; ERP integration
• Role Overview
• We’re seeking a hands on Senior SQL Developer with deep T SQL expertise and the ability to read and write MS Access 2003/VBA. You’ll reverse engineer and stabilize the legacy SnapShot application, design and build modern SQL centric data flows, and implement integrations that connect the current Access front end (on prem) + SQL Server back end ERP with the Infor system. The near term focus is delivering the first integration, followed by a broader modernization program (S4 migration to follow).
• Essential Duties and Responsibilities:
• What You'll Do:
• \ Reverse engineer, read, and author MS Access 2003/VBA code; Untangle ~100k lines of legacy logic to document workflows and stabilize critical functions
• \ Design and implement SQL Server schemas (approx. 500 fields, with ~100 Q&A fields flowing into application) to support modernized processing
• \ Build robust ETL/data ingestion pipelines (e.g., parsing output files and loading into SQL DB for downstream processing); automate validation and reconciliation
• \ Integrate with Infor: design interfaces/APIs/bridge tables and orchestrations to pass configuration/estimator data between Access/SQL and the Infor ecosystem
• \ Maintain prem performance and reliability: indexing, query tuning, statistics management, isolation levels, and transactional integrity
• \ Establish coding standards, version control, and technical documentation for legacy and modern components; implement unit/integration test harnesses
• \ Partner with business (estimators, dealers) to map legacy rules to modern data structures; convert tribal knowledge into testable specifications
• \ Prepare for the S4 migration (start-to-finish planning) by isolating dependencies, defining cutover strategies, and drafting rollback/safety nets
• \ Drive secure handling of ERP data (authentication, role-based access, auditing), and plan for multi-year on prem operation before any cloud move
• *Required Skills**
• TSQL
• MS Access 2003/VBA
• ETL/Data Pipelines