Sign upLog in

Senior SQL Developer

Expert In Recruitment Solutions

Corona, CA

Apply
JOB DETAILS
SKILLS
Application Programming Interface (API), Auditing, Authentication, Cloud Computing, Coding Standards, Data Management, Data Structures, Database Extract Transform and Load (ETL), ERP (Enterprise Resource Planning), Ecosystems, Integration Testing, Microsoft Access Database, Microsoft SQL Server, Microsoft Transact-SQL (T-SQL), Microsoft Visual Basic for Applications (VBA), Reconciliation, Reverse Engineering, SQL (Structured Query Language), SQL Databases, Software Design, Source Code/Configuration Management (SCM), Statistics, Technical Writing, Test Harness, Unit Test, User Interface/Experience (UI/UX)
LOCATION
Corona, CA
POSTED
30+ days ago
Senior SQL Developer (MS Access/VBA) — SnapShot Modernization
Corona , CA
18+ Month Contract




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

About the Company

E

Expert In Recruitment Solutions

Resume Resources

Free Resume TemplatesFree Resume Builder