Sr. SQL Developer | W2 Only | On-site |
Xlysi, Tampa, FL, United States
Senior SQL Developer
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 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 modern Infor system. The near-term focus is delivering the first integration, followed by a broader modernization program.
Duties:
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 and A fields flowing into system) 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
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 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 modern Infor system. The near-term focus is delivering the first integration, followed by a broader modernization program.
Duties:
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 and A fields flowing into system) 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