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

V.L.S. Systems, Inc
Jackson County, MS, United States
2 days ago
Apply on www.dice.com
Prepare application

Role details

Contract type
Contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Working hours
Regular working hours
Job source

Tech stack

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
+11 more
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

Job 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.

Requirements

  • 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

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.dice.com
Prepare application

Good distractions

Loading talks and stories from around this role…