Dieses Stellenangebot ist nicht mehr verfügbar
Programmer Analyst
S R INTERNATIONAL INC
- Jackson, Mississippi, United States
- Jackson, Mississippi, United States
Über
Job Post: Programmer Analyst (Project – Data Conversion)
Job Code: MS
Client Job ID: MS
Job Title: Programmer Analyst (Project – Data Conversion) – Onsite as needed
Location: Jackson, Mississippi (Remote allowed but must report onsite as needed)
Duration: 1 year 6 months 16 days (Approx. 24 months)
Work Hours: 8 AM – 5 PM (40 hrs/week)
Background Check: Standard
Occasional Travel Required
Client:
State of Mississippi – Department of Corrections (MDOC)
Project: Programmer Business Analyst – Data Conversion
Must be willing to report onsite occasionally to meet with user groups. Do NOT submit candidates unwilling to report onsite as needed.
Primary Skills:
- Crystal Reports
- Converting legacy DHTML-based UI forms
- ETL & database conversion
- Oracle PL/SQL (rewrite & optimize packages)
- AWS-based architecture
Job Description:
The Mississippi Department of Corrections (MDOC) is seeking an experienced Programmer Analyst to support a large-scale modernization project. The candidate will be responsible for reviewing, refactoring, and migrating legacy application logic—including PL/SQL code, stored procedures, business rules, and Crystal Reports—into a modern AWS-based platform.
This role requires strong technical expertise in enterprise application development, data conversion, ETL processes, and legacy system documentation. You will collaborate with internal teams and third-party vendors to ensure accurate migration of mission-critical features such as records management, classification, and sentence computation.
Key Responsibilities:
- Review and document existing architecture, workflows, data models, and stored procedures.
- Rewrite and optimize Oracle PL/SQL packages, triggers, views, and functions for cloud migration.
- Migrate legacy Crystal Reports to an AWS-compatible reporting solution.
- Perform ETL activities: extract, map, validate, and transform data for database conversion.
- Analyze, document, and refactor core logic modules (e.g., sentence computation).
- Convert legacy DHTML-based UI forms into modern equivalents.
- Document scheduled jobs and backend automated processes.
- Work with external vendors to clarify requirements and support migration efforts.
Required Technical Skills:
- Expert-level Oracle PL/SQL (procedures, functions, triggers, packages, views)
- Advanced SQL with query performance optimization
- Hands-on ETL/data migration experience
- Ability to interpret undocumented legacy logic
- Familiarity with DHTML/legacy frontend technologies
- Experience with scheduled job automation
Preferred Qualifications:
- Experience with AWS reporting and database services
- BI/reporting tools (Power BI, AWS Quicksight)
- Scripting (Python, PowerShell)
- Background in Offender Management / Justice Systems
- Vendor collaboration on modernization projects
Skills required:
SQL/Oracle Programmer – 7+ years (Required): Able to write and review SQL & PL/SQL code.
Business Analyst – 5–7 years (Required): Able to analyze SQL/PLSQL, business rules, and user requirements.
Oracle DB – 5–7 years (Required): —
SQL – 5–7 years (Preferred): —
Sprachkenntnisse
- English
Hinweis für Nutzer
Dieses Stellenangebot wurde von einem unserer Partner veröffentlicht. Sie können das Originalangebot einsehen hier.