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