> Markdown version of [/jobs/ext/4788859-w2-role-technical-business-analyst-oracle-sql-plsql-legacy-system-migration](https://www.wearedevelopers.com/jobs/ext/4788859-w2-role-technical-business-analyst-oracle-sql-plsql-legacy-system-migration). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # W2 Role || Technical Business Analyst (Oracle SQL/PLSQL & Legacy System Migration) - **Company:** V.L.S. Systems, Inc - **Location:** Jackson County, MS, United States - **Experience:** Expert - **Contract:** Contract - **Skills:** Microsoft Excel, Amazon Web Services, Applications Architecture, Code Review, Computer Programming, Databases, Crystal Reports (Reporting Software), Data Validation, Data Mapping, Dynamic HTML, Oracle (Applications), Oracle SQL Developer, Pivot Charts, Pivot Tables, Power BI, Standard Sql, SQL Stored Procedures, PL-SQL, SQL Databases, System Integration Testing, Sql Optimization, Information Technology, Tools for Reporting - **Published:** November 19, 2026 - **Apply:** https://www.dice.com/job-detail/d220ff1e-e5c2-4a57-bc16-09e773513ab2 ## About the Role * 7-10 years of overall IT experience. * At least 5 years of Business Analyst experience. * Strong Oracle SQL and PL/SQL expertise. * Experience with application modernization or legacy system migration. * Strong documentation, Excel and data validation skills. * Experience coordinating with technical teams and external vendors. Three aspects are particularly important when identifying suitable candidates: 1. Strong SQL/PLSQL background: Candidates should be comfortable reading and understanding existing Oracle code, stored procedures and database logic. Merely having experience gathering business requirements may not be sufficient. 2. Legacy application migration experience: Experience in documenting existing functionality and translating it into requirements for a modern cloud-based application will be a significant advantage. 3. On-site availability: The Mississippi residency requirement and two-year on-site commitment, This is a technically strong Business Analyst position, rather than a conventional functional BA role. Skill Experience / Requirement Years of Experience Business Analyst experience 5+ years SQL knowledge Working knowledge Microsoft Excel Strong skills, PivotTables, Pivot Charts SQL/PLSQL programming and code review 7+ years Oracle PL/SQL 5+ years Advanced SQL 5+ years AWS database and reporting services Experience Power BI / AWS QuickSight Familiarity Offender Management / Justice systems Experience Legacy DHTML applications Familiarity Vendor-led modernization projects ## Description The selected Business Analysts will be responsible for: 1. Reviewing existing application architecture, data models and workflows. 2. Analyzing legacy application functionality and documenting business rules. 3. Reviewing Oracle SQL and PL/SQL code, including procedures, functions, triggers and packages. 4. Reviewing Crystal Reports and documenting report calculations and data sources. 5. Documenting core application modules, including: * Offender records. * Sentence computation. * Classification. * Programs and alerts. * Movement and disciplinary. * Grievances. * Community Corrections accounting and supervision. 1. Validating source-to-target data mapping. 2. Preparing functional requirements, user stories and acceptance criteria. 3. Supporting System Integration Testing (SIT) and User Acceptance Testing (UAT). 4. Identifying defects and validating migrated functionality against the legacy system.