Skip to content
Search jobs inside your AI agent. Claude, ChatGPT, Claude Code, Codex, Gemini, Cursor and Grok
Connect

V.L.S. Systems, Inc

NewBe an early applicant

W2 Role || Technical Business Analyst (Oracle SQL/PLSQL & Legacy System Migration)

Posted Updated

Description

Position: Technical Business Analyst (Oracle SQL/PLSQL & Legacy System Migration)

Location: Jackson, MS-Onsite

Description:

Ideal candidate profile:

• 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

Key responsibilities

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.

4. Required skills and experience

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

Experience

Skills

Apply

See also

Business Analysis jobs by country — openings, pay and top skills →