SQL DEV

Corona, CA - USA

Monthly Salary: Not Disclosed

Posted on: 8 hours ago

Vacancies: 1 Vacancy

Job Summary

INDUSTRY Door company

POSITION SQL DEV

LOCATION Onsite in Corona CA-- must be local

DURATION 6 Months

PAY RATE $65/hr on W2

INTERVIEW TYPE Video

LinkedIn needed and unmasked visa copy

REQUIRED SKILLS

Tsql

Ms access/VBA

ETL/Data Pipelines

ERP Exposure

What Youll 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 existing 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 on 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.

INDUSTRY Door company POSITION SQL DEV LOCATION Onsite in Corona CA-- must be local DURATION 6 Months PAY RATE $65/hr on W2 INTERVIEW TYPE Video LinkedIn needed and unmasked visa copy REQUIRED SKILLS Tsql Ms access/VBA ETL/Data Pipelines ERP Exposure What Youll Do Rever...