Programmer Analyst

2 days ago

Jackson, Mississippi, United States S R INTERNATIONAL INC Full time $80,000 - $125,000 per year


Job Post: Programmer Analyst (Project – Data Conversion)

Job Code: MS 151867
Client Job ID: MS 151867
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): —

  • Programmer Analyst

    2 days ago

    Jackson, Mississippi, United States S R INTERNATIONAL INC Full time $104,000 - $160,000 per year

    State of Mississippi - Programmer Analyst - MS - MSDOC Report Onsite as Needed)Can work remote but will be required to report onsite on occasion to meet with user groups.  Do NOT submit anyone unwilling to report onsite as needed.   Closing Date: 12/4/2025 2 PM       Agency: The Mississippi Department of Corrections (MDOC)  Project Name: Sentence...

  • Programmer Analyst

    5 days ago

    Jackson, MS, United States Ageatia Global Solutions Full time

    Hi, Greeting from Ageatia Global Solutions. We have a new job opening with my direct client. Please go through the Job Description and if you are comfortable and available in the job market, then please reply to me. Job Title: Programmer Analyst Duration: 12+ Months Location: Eastwood Dr, MS 39211 Job Title: Programmer Analyst Summary We are seeking...

  • Programmer Analyst

    6 days ago

    Jackson, MS, United States Ageatia Global Solutions Full time

    Hi, Greeting from Ageatia Global Solutions. We have a new job opening with my direct client. Please go through the Job Description and if you are comfortable and available in the job market, then please reply to me. Job Title: Programmer Analyst Duration: 12+ Months Location: Eastwood Dr, MS 39211 Job Title: Programmer Analyst Summary We are seeking...

  • Programmer Analyst

    3 days ago

    Jackson, MS, United States Ageatia Global Solutions Full time

    Hi, Greeting from Ageatia Global Solutions. We have a new job opening with my direct client. Please go through the Job Description and if you are comfortable and available in the job market, then please reply to me. Job Title: Programmer Analyst Duration: 12+ Months Location: Eastwood Dr, MS 39211 Job Title: Programmer Analyst Summary We are seeking...

  • Programmer Analyst

    5 days ago

    Jackson, MS, United States LanceSoft Full time

    Job DescriptionBelow is the Job Details for your reference: Role Programmer Analyst Location Remote (Jackson, MS 39211) Duration 12 months contact (Possible extension or Conversion) Can work remote but will be required to report onsite on occasion to meet with user groupsDescription: We are seeking a skilled Programmer Analyst with strong experience in...

  • Programmer Analyst

    1 week ago

    Jackson, United States S R INTERNATIONAL INC Full time

    State of Mississippi - Programmer Analyst - MS - MSDOC - 151864 (Report Onsite as Needed)Can work remote but will be required to report onsite on occasion to meet with user groups.  Do NOT submit anyone unwilling to report onsite as needed.   Closing Date: 12/4/2025 2 PM    Agency: The Mississippi Department of Corrections (MDOC)  Project Name:...

  • Programmer Analyst

    1 week ago

    Jackson, United States Integrated Resources Full time

    Job Title: Programmer Business Analyst Location: Remote but will be required to report onsite on occasion to meet with user groups(Jackson, MS) Job Duration: 30 months+ ContractJob Type: Contract Tax Term: W2 or C2C Pay Rate: Open rateSummary: We are seeking a skilled Programmer Analyst with strong experience in enterprise software development, SQL/Oracle...

  • iSeries AS400 Programmer/Analyst

    8 hours ago

    Jackson, United States Exec-Resourcing Full time

    JOB TITLE: Title:                     iSeries AS400 Programmer/AnalystLocation:             Jackson, MS (on-site)Compensation: Negotiable Salary plus Full BenefitsType:                     Full-TimeRelocation:        Yes – depending on overall relocation requirements.Start Date:         ...

  • Programmer Business Analyst

    2 weeks ago

    Jackson, United States Careers Integrated Resources Inc Full time

    Job Title: Programmer Business Analyst Location: Remote but will be required to report onsite on occasion to meet with user groups(Jackson, MS) Job Duration: 30 months Contract Job Type: Contract Tax Term: W2 or C2C Pay Rate: Open rate Summary: We are seeking a skilled Programmer Analyst with strong experience in enterprise software development, SQL/Oracle...

  • Programmer Analyst

    1 week ago

    Jackson, United States SR International Full time

    Replies within 24 hours State of Mississippi - Programmer Analyst - MS - MSDOC - 151864 (Report Onsite as Needed)Can work remote but will be required to report onsite on occasion to meet with user groups. Do NOT submit anyone unwilling to report onsite as needed Closing Date: 12/4/2025 2 PM Agency: The Mississippi Department of Corrections (MDOC) Project...

  • Programmer Analyst

    1 week ago

    Jackson, United States SR International Full time

    Replies within 24 hours Job Post: Programmer Analyst (Project - Data Conversion)Job Code: MS 151867 Client Job ID: MS 151867 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...