Business Analyst – (SQL, Oracle PL/SQL & AWS) | Jackson, MS


Vision Square
Dice Job Match Score™
🔢 Crunching numbers...
Job Details
Skills
- Amazon Web Services
- Business Intelligence
- Acceptance Testing
- Legacy Systems
- Data Mapping
- Microsoft Power BI
- PL/SQL
- Oracle
- SQL
- Reporting
Summary
Business Analyst – Legacy System Modernization, SQL, Oracle PL/SQL & AWS Cloud Migration
Job Details
Job Title: Business Analyst – Legacy System Modernization, SQL, Oracle PL/SQL & AWS Cloud Migration
Location: Jackson, Mississippi (Hinds County)
Work Arrangement: 100% Onsite
Number of Openings: 2
Employment Type: Temporary / Contract (Staff Augmentation)
Estimated Start Date: December 1, 2026
Estimated End Date: December 31, 2028
Contract Duration: Minimum 2 Years
Work Schedule: Monday – Friday
Working Hours: 8:00 AM – 5:00 PM
Hours Per Day: 8
Hours Per Week: 40
Travel: Occasional local travel may be required.
Security Requirement: Standard Background Check
Position Overview
We are seeking two experienced Business Analysts to support a large-scale legacy application modernization and cloud migration project.
The selected candidates will play an important role in migrating an existing Offender Management System to a new cloud-based platform. They will analyze existing application functionality, review business rules, document workflows, examine technical documentation and SQL code, and translate legacy system requirements into clear functional requirements for the redesigned application.
The Business Analysts will work closely with business stakeholders, technical teams, and third-party vendors to ensure that existing business processes and system functionality are accurately understood, documented, validated, and represented in the new environment.
The project involves reviewing application modules, reports, database logic, stored procedures, and existing business processes to support successful system modernization.
This position requires 100% onsite work. Remote candidates will not be considered. Selected candidates must be available for a minimum two-year contractual commitment.
Education Requirement
Professional Degree identified in the detailed job posting questionnaire.
Required Skills / Experience
Business Analysis – Advanced (Required)
Experience reviewing existing application code and business rules.
Ability to review and understand end-user requirements.
Experience analyzing user stories and technical documentation.
Ability to translate business requirements into functional requirements.
Experience reviewing workflows, application functionality, and business processes.
SQL and Technical Analysis
Working knowledge of SQL.
Ability to read and understand SQL queries, joins, data relationships, and stored procedure logic.
Experience reviewing technical documentation, business rules, workflows, reports, and SQL code.
Experience performing detailed analysis and preparing documentation to support migration of legacy business rules into a new cloud-based system.
Microsoft Excel
Strong Microsoft Excel skills, including PivotTables and Pivot Charts.
Ability to perform data analysis and data validation.
Preferred Skills / Experience
Programmer / SQL / PL-SQL experience at SME level (7+ years identified in the client's skill-level classification), preferred.
Ability to write and review SQL and PL/SQL code.
Advanced experience with Oracle database systems.
Advanced SQL knowledge and experience.
Experience with AWS database and reporting services.
Familiarity with business intelligence and reporting platforms such as Microsoft Power BI or AWS QuickSight.
Knowledge of Oracle PL/SQL, including procedures, functions, triggers, packages, and views.
Experience with Offender Management Systems or enterprise justice systems.
Familiarity with legacy web technologies, including DHTML-based applications.
Experience working with external vendor teams on modernization projects.
Job Responsibilities
Legacy Application Analysis
Review and document existing application architecture, data models, workflows, and stored procedures.
Analyze legacy application functionality and identify underlying business rules and dependencies.
Review existing application processes and identify gaps, inconsistencies, and potential improvements.
Understand existing application functionality and support its transition to the new cloud-based platform.
SQL and Oracle Database Analysis
Review Oracle PL/SQL packages, procedures, functions, triggers, and views to understand existing application logic.
Analyze SQL code and database relationships to support system migration.
Work with technical teams to understand existing database functionality.
Support migration of existing application logic to the new cloud environment.
Business Rules and Documentation
Review business rules, policies, Standard Operating Procedures (SOPs), user stories, and requirements verification documents.
Translate existing system functionality into clear functional requirements, user stories, acceptance criteria, and process documentation.
Ensure critical business rules and functionality from the legacy system are accurately represented in the redesigned application.
Identify gaps and inconsistencies in existing business processes and application functionality.
Reports and Reporting Migration
Review existing Crystal Reports.
Document report logic, calculations, data sources, and business rules.
Support migration to a modern reporting platform compatible with AWS.
Application Modules
Analyze and document core application logic, including:
· Sentence computation.
· Offender records.
· Offender programs.
· Alerts.
· Movement.
· Classification.
· Offender disciplinary.
· Offender grievances.
· Community Corrections accounting and supervision.
Data Mapping and Validation
Work with technical teams to validate source-to-target data mappings.
Ensure data accuracy and completeness.
Validate migrated functionality against the legacy system.
Assist in identifying and documenting defects.
Testing and Modernization Support
Support System Integration Testing (SIT) and User Acceptance Testing (UAT).
Participate in requirements walkthroughs.
Participate in design reviews and modernization discussions.
Collaborate with business stakeholders, technical teams, and external vendors.
Working Conditions
Position requires 100% onsite work in Jackson, Mississippi.
The selected candidates must be available to work Monday through Friday, 8:00 AM to 5:00 PM.
Occasional local travel may be required.
Candidates must be available for a minimum two-year contractual commitment.
Standard background check is required.
The position does not require overtime.
There is no formal on-call requirement; however, candidates must be available to answer calls from staff when needed.
Supervisory Responsibilities
No supervisory responsibilities have been specified in the provided job description.
Ideal Candidate
The ideal candidate is an experienced Business Analyst with strong business process analysis, technical documentation, and SQL knowledge.
The candidate should be comfortable reviewing existing application functionality, understanding SQL queries and database relationships, documenting complex business rules, and translating legacy system requirements into clear functional specifications.
Candidates with experience in Oracle databases, PL/SQL, AWS migration, reporting platforms, and enterprise justice or offender management systems will be preferred.
The candidate must be comfortable working with business users, developers, technical teams, and external vendors.
Strong analytical skills, attention to detail, Microsoft Excel proficiency, and the ability to support system integration and user acceptance testing are essential.
The candidate must be willing to work 100% onsite in Jackson, Mississippi, and commit to the minimum two-year contract.
- Dice Id: RTX1d0567
- Position Id: 9143718
- Posted 1 hour ago
Company Info
At Vision Square Inc, we believe that Great Workforce is the cause for phenomenal growth of the company. By combining the skill and experience of the founders and executives, Vision Square Inc follows a disciplined process of identifying quality candidates, partnering with employers to understand their core business and their employment requirements and delivering exceptional service, we achieve great results for all concerned.
Vision Square Inc is one of the fastest growing information technology consulting and services with superior value-priced consulting, contracting, permanent recruiting and placement services for both private and government sector clients.
Our vision is to provide complete quality services for all clients at all levels, while allowing the clients to remain focused on there core business. Our processes are robust and we invest heavily in our delivery models and ensure that our clients globally get uniformity of delivery and highest quality of service. Our clients rely on us to connect them with high caliber technology professionals and we ensure that they remain on top of the continually evolving technology landscape.
