Senior VBA Developer
Share
Job Location:
Monthly Salary:
Posted on:
2 hours ago
Vacancies:
1 Vacancy
Job Summary
Job Title: Senior VBA Developer ERP / Database Modernization
Location: Tampa FL
Work Type: Onsite
Duration: 12-18 Month Contract
LinkedIn Profile: Required for Submission
NOTE: NO H1B // Local Candidates with DL
Primary Skills: VBA : MS Access 2003 : T-SQL : SQL Server : ERP Modernization : Legacy System Reverse Engineering : ETL Pipelines : Data Integration : Infor Integration : APIs : Database Design : Performance Tuning : On-Prem ERP : S/4 Migration Planning : Version Control : Technical Documentation : Data Security : Role-Based Access Control
Role Overview
We are seeking a hands-on Senior VBA Developer with deep T-SQL expertise and strong experience reading and writing MS Access 2003/VBA code. This role focuses on reverse engineering and stabilizing the legacy SnapShot application designing modern SQL-centric data flows and implementing integrations between the existing on-prem MS Access front end and SQL Server-based ERP with the Infor system. The immediate priority is delivering the first integration followed by a broader ERP/database modernization initiative with an S/4 migration planned in subsequent phases.
Key Responsibilities
Reverse engineer analyze and author MS Access 2003/VBA code including untangling approximately 100k lines of legacy logic to document workflows and stabilize critical functionality
Design and implement SQL Server schemas (approximately 500 fields including 100 Q&A fields flowing into SnapShot) to support modernized processing
Build and maintain robust ETL and data ingestion pipelines including parsing output files and loading data into SQL databases with automated validation and reconciliation
Design and implement integrations with Infor including interfaces APIs bridge tables and orchestrations to exchange configuration and estimator data between Access/SQL and the Infor ecosystem
Ensure on-prem performance and reliability through indexing query tuning statistics management isolation levels and transactional integrity
Establish coding standards version control and technical documentation for both legacy and modern components and implement unit and integration test frameworks
Collaborate with business stakeholders (estimators dealers) to translate legacy business rules into modern data structures and testable specifications
Prepare for the S/4 migration by identifying dependencies defining cutover strategies and developing rollback and safety plans
Enforce secure handling of ERP data including authentication role-based access auditing and planning for multi-year on-prem operations prior to any cloud migration
Warm regards
Vishal (Victor) Verma Assistant Manager
NS IT Solutions
Location: Tampa FL
Work Type: Onsite
Duration: 12-18 Month Contract
LinkedIn Profile: Required for Submission
NOTE: NO H1B // Local Candidates with DL
Primary Skills: VBA : MS Access 2003 : T-SQL : SQL Server : ERP Modernization : Legacy System Reverse Engineering : ETL Pipelines : Data Integration : Infor Integration : APIs : Database Design : Performance Tuning : On-Prem ERP : S/4 Migration Planning : Version Control : Technical Documentation : Data Security : Role-Based Access Control
Role Overview
We are seeking a hands-on Senior VBA Developer with deep T-SQL expertise and strong experience reading and writing MS Access 2003/VBA code. This role focuses on reverse engineering and stabilizing the legacy SnapShot application designing modern SQL-centric data flows and implementing integrations between the existing on-prem MS Access front end and SQL Server-based ERP with the Infor system. The immediate priority is delivering the first integration followed by a broader ERP/database modernization initiative with an S/4 migration planned in subsequent phases.
Key Responsibilities
Reverse engineer analyze and author MS Access 2003/VBA code including untangling approximately 100k lines of legacy logic to document workflows and stabilize critical functionality
Design and implement SQL Server schemas (approximately 500 fields including 100 Q&A fields flowing into SnapShot) to support modernized processing
Build and maintain robust ETL and data ingestion pipelines including parsing output files and loading data into SQL databases with automated validation and reconciliation
Design and implement integrations with Infor including interfaces APIs bridge tables and orchestrations to exchange configuration and estimator data between Access/SQL and the Infor ecosystem
Ensure on-prem performance and reliability through indexing query tuning statistics management isolation levels and transactional integrity
Establish coding standards version control and technical documentation for both legacy and modern components and implement unit and integration test frameworks
Collaborate with business stakeholders (estimators dealers) to translate legacy business rules into modern data structures and testable specifications
Prepare for the S/4 migration by identifying dependencies defining cutover strategies and developing rollback and safety plans
Enforce secure handling of ERP data including authentication role-based access auditing and planning for multi-year on-prem operations prior to any cloud migration
Warm regards
Vishal (Victor) Verma Assistant Manager
NS IT Solutions
Required Skills:
SQL SERVERMIGRATION PLANNINGDATA INTEGRATIONDOCUMENTATIONDATA SECURITYAPISVBAT-SQLSQLDATABASE DESIGNVERSION CONTROLMS ACCESS 2003
Key Skills
- APIs
- REST
- Spring
- SOAP
- .NET
- React
- Node.js
- Angular
- J2EE
- JavaScript
- Web Services
- Java
