Overview
On Site
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - start date
Skills
SQL
Powershell
Python
Packages
Power BI
Triggers
Functions
Oracle PL/SQL
AWS (Cloud Architecture)
Cloud Environment Migration
QuickSight
Job Details
Location & Work Arrangement
- Location: Jackson, Mississippi
- Work Arrangement: Remote
- Contract: This is a Contract position.
- Mode of Interview: In-person/Webcam (Hybrid interview process).
Key Responsibilities
- Code Refactoring & Optimization: Review, rewrite, and optimize Oracle PL/SQL packages, functions, triggers, and views for migration to a cloud environment (AWS).
- Data Conversion & ETL: Extract, map, validate, and transform data to support ETL and database conversion activities, ensuring data integrity during schema transformation.
- Legacy Analysis: Analyze, document, and refactor core logic modules such as records, classification, and sentence computation, often from undocumented code.
- Reporting Migration: Migrate legacy reporting platforms, specifically Crystal Reports, to a modern reporting platform compatible with AWS.
- Documentation & Workflow: Review and document existing application architecture, data models, workflows, and stored procedures to promote knowledge transfer.
- Front-End Conversion: Convert legacy DHTML-based UI forms to modern formats as part of the system redesign.
- Collaboration: Work closely with a third-party vendor and internal teams to clarify requirements and support all modernization efforts.
Required Technical Skills
- Expert Oracle PL/SQL: Expert knowledge of Oracle PL/SQL (procedures, functions, triggers, packages, views).
- SQL Mastery: Strong SQL expertise, including query optimization and performance tuning.
- Cloud Readiness: Experience with data migration, ETL workflows, and schema transformation.
- Legacy Knowledge: Ability to understand logic from legacy applications and undocumented code; familiarity with legacy front-end technologies (DHTML, HTML/JavaScript forms).
- Automation: Experience with task schedulers for data automation.
Preferred Qualifications
- Experience with AWS database and reporting services (e.g., QuickSight).
- Knowledge of BI/reporting tools such as Power BI.
- Scripting experience (Python, PowerShell).
- Experience with Offender Management or enterprise justice systems.
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.