W2 Role || Technical Business Analyst (Oracle SQL/PLSQL & Legacy System Migration)
Quick overview
Job 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:
- 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.
- 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.
- On-site availability: The Mississippi residency requirement and two-year on-site commitment
Key responsibilities
The selected Business Analysts will be responsible for:
- Reviewing existing application architecture, data models and workflows.
- Analyzing legacy application functionality and documenting business rules.
- Reviewing Oracle SQL and PL/SQL code, including procedures, functions, triggers and packages.
- Reviewing Crystal Reports and documenting report calculations and data sources.
- Documenting core application modules, including:
- Offender records.
- Sentence computation.
- Classification.
- Programs and alerts.
- Movement and disciplinary.
- Grievances.
- Community Corrections accounting and supervision.
- Validating source-to-target data mapping.
- Preparing functional requirements, user stories and acceptance criteria.
- Supporting System Integration Testing (SIT) and User Acceptance Testing (UAT).
- 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
Similar jobs
- JI
Senior Business Analyst – Data, GenAI & Agentic AIRecently posted
J-RAM IT Consulting Inc. · Pennington, NJ · Hybrid · Posted 16 Nov 2026 🇺🇸
Stakeholder ManagementGenerative AIAgile+3TechnologySalary not listed - TL

Operations Business AnalystRecently posted
Total Loan Services LLC · Dayton, Ohio · Hybrid 🇺🇸
Microsoft ExcelMicrosoft OfficeMicrosoft PowerPoint+11Operations & Project ManagementSalary not listed - RI
Business AnalystRecently posted
Radiant Infotech · United States · Hybrid · Posted 15 Nov 2026 🇺🇸
ScrumBusiness AnalysisConfluence+4Operations & Project ManagementSalary not listed - SP

Business Operations Analyst (Human Data)Recently posted Auto Apply
SpaceXSI · Palo Alto · Hybrid · Posted 18 Nov 2026 🇺🇸
Microsoft ExcelGoogle WorkspaceCapacity Planning+1Operations & Project Management$122k - $180k/yr - AA
BUSINESS ANALYSTRecently posted
AaraTechnologies Inc · Virginia Beach, VA · Hybrid · Posted 17 Nov 2026 🇺🇸
Stakeholder ManagementScrumBusiness Analysis+4Operations & Project ManagementSalary not listed - PG

Business Analyst VRecently posted
PTR Global · Chicago, IL · Remote · Posted 18 Nov 2026 🇺🇸
Root Cause AnalysisOperations & Project Management$70 - $80/hr - GO

Operations AnalystRecently posted
GovCIO · Philadelphia, PA · Hybrid · Posted 18 Nov 2026 🇺🇸
ComplianceData EntryFleet Management+2Operations & Project Management$70k - $80k/yr - HI

Functional AnalystRecently posted
Healthcare IT Leaders · New York, NY · Hybrid · Posted 18 Nov 2026 🇺🇸
Microsoft OfficeERPPayroll+2Salary not listed - EM

Senior PeopleSoft Business AnalystRecently posted
EmployVision · United States · Hybrid · Posted 18 Nov 2026 🇺🇸
Operations & Project ManagementSalary not listed - GO

Operations AnalystRecently posted
GovCIO · Elkridge, MD · Hybrid · Posted 18 Nov 2026 🇺🇸
ComplianceData EntryFleet Management+2Operations & Project Management$70k - $80k/yr - OR

Configuration Analyst - Oracle Health Charge Services ( hybrid Kansas City MO office) Auto Apply
Oracle · Kansas City · Hybrid · Posted 10 Nov 2026 🇺🇸
OnboardingOracle$24 - $57/hr - SC

Regulatory Strategy and Analytics AnalystRecently posted Auto Apply
Southern Company · Birmingham · Hybrid · Posted 17 Nov 2026 🇺🇸
ComplianceRegulatory ComplianceSalary not listed