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

Moss Point, MS, US • Posted 2 hours ago • Updated 2 hours ago
Contract W2
24 Months
No Travel Required
Able to Sponsor
On-site
$60 - $62/hr
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • Technical Business Analyst
  • Oracle SQL/PLSQL
  • SQL
  • PL/SQL
  • Oracle SQL
  • application modernization
  • legacy system migration
  • data validation
  • Crystal Reports
  • Business Analyst
  • System Integration Testing (SIT)
  • User Acceptance Testing (UAT)
  • Oracle PL/SQL
  • SQL/PLSQL programming
  • AWS database
  • Power BI
  • AWS QuickSight
  • Offender Management / Justice systems
  • Legacy DHTML applications
  • Vendor-led modernization projects
  • Business Analysis
  • Business Analytics
  • Business Rules
  • DHTML
  • Amazon Web Services
  • Acceptance Testing
  • Functional Requirements
  • Documentation
  • Microsoft Power BI
  • Legacy Systems
  • User Stories
  • Software Modernization
  • Stored Procedures
  • Pivot Table
  • Data Mapping
  • Code Review
  • Oracle

Summary

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

 

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 10112454
  • Position Id: 9144638
  • Posted 2 hours ago
Contact the job poster
RA

Rob Addapalli

Recruiter @ V.L.S. Systems, Inc

Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.