Senior VBA Developer

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

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

Employment Type : Full Time

Experience : years

Vacancy : 1