<p>Kforce has a client that is seeking an SQL Developer in Tampa, FL.</p> <p>Summary: 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.</p> <p>Duties:</p> <ul> <li>Reverse engineer, read, and author MS Access 2003/VBA code; Untangle ~100k lines of legacy logic to document workflows and stabilize critical functions </li><li>Design and implement SQL Server schemas (approx. 500 fields, with ~100 Q&A fields flowing into system) to support modernized processing </li><li>Build robust ETL/data ingestion pipelines (e.g., parsing output files and loading into SQL DB for downstream processing); Automate validation and reconciliation </li><li>Integrate with Infor: design interfaces/APIs/bridge tables and orchestrations to pass configuration/estimator data between Access/SQL and the Infor ecosystem </li><li>Maintain on prem performance and reliability: indexing, query tuning, statistics management, isolation levels, and transactional integrity </li><li>Establish coding standards, version control, and technical documentation for legacy and modern components; Implement unit/integration test harnesses </li><li>Partner with business (estimators, dealers) to map legacy rules to modern data structures; Convert tribal knowledge into testable specifications </li><li>Prepare for the S4 migration (start-to-finish planning) by isolating dependencies, defining cutover strategies, and drafting rollback/safety nets </li><li>Drive secure handling of ERP data (authentication, role-based access, auditing), and plan for multi-year on prem operation before any cloud move* To be considered for this position, candidates must have experience in a similar role, or they must possess significant knowledge, experience, and abilities to successfully perform the responsibilities listed </li><li>Relevant education and/or training will be considered a plus </li></ul>