Senior SQL Developer

Corona, CA - USA

Monthly Salary: Not Disclosed

Posted on: 6 hours ago

Vacancies: 1 Vacancy

Job Summary

Job Title: Senior SQL Developer (MS Access/VBA) - SnapShot Modernization
Location: Corona CA
Work Type: Onsite
Job Type: Contract
Rate: $58 $60/hr on W2

Please Note: As of July 22 2021 our team will require that all candidate submissions include a LinkedIn profile. Please do not submit any candidates who do not have a LinkedIn with picture

Notes:
Duration: 18 Month Contract
Work model: Primarily on-prem (SQL heavy); hybrid last options if needed
Interview Process: 2 rounds
Interview times between 4 6 pm EST next week understanding
Confirmed feedback following each interview

Unmarked visa copy only

Job Description:

Were seeking a hands-on Senior SQL Developer with deep T SQL expertise and the ability to read and write MS Access 2003/VBA. Youll 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).

MUST SKILLS
* TSQL

* MS Access 2003/VBA

* ETL/Data Pipelines

Essential Duties and Responsibilities:

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 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

Job Title: Senior SQL Developer (MS Access/VBA) - SnapShot Modernization Location: Corona CA Work Type: Onsite Job Type: Contract Rate: $58 $60/hr on W2 Please Note: As of July 22 2021 our team will require that all candidate submissions include a LinkedIn profile. Please do not submit any cand...