Senior SQL Developer

Corona, CA - USA

Monthly Salary: Not Disclosed

Posted on: 15 hours ago

Vacancies: 1 Vacancy

Job Summary

Seeking a hands on Senior SQL Developer with deep T SQL expertise and the ability to read and write MS Access 2003/VBA.

TOP MUST-HAVES

T SQL
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.

Seeking a hands on Senior SQL Developer with deep T SQL expertise and the ability to read and write MS Access 2003/VBA. TOP MUST-HAVES T SQL 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 lo...