Senior SQL Developer (MS Access/VBA)
URGENT REQUIREMENT
Looking for candidates regarding the following:
POSITION
Senior SQL Developer (MS Access/VBA) - ERP/Database Modernization
LOCATION
Tampa, FL (Hybrid )
DURATION
12- 18 Month Contract
C2C PAY RATE
$70-$75/hour on c2c
Salary Range
INTERVIEW TYPE
Video
Sponsorship
Open
Qualifications
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).
REQUIRED SKILLS
• 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 SnapShot) 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.
Looking for candidates regarding the following:
POSITION
Senior SQL Developer (MS Access/VBA) - ERP/Database Modernization
LOCATION
Tampa, FL (Hybrid )
DURATION
12- 18 Month Contract
C2C PAY RATE
$70-$75/hour on c2c
Salary Range
INTERVIEW TYPE
Video
Sponsorship
Open
Qualifications
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).
REQUIRED SKILLS
• 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 SnapShot) 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.