Programmer Analyst (Project – Data Conversion)
S R International
Full-time
On-site
Jackson, Mississippi, United States
IT/Tech
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 (40 hrs/week)
Background Check: Standard
Occasional Travel Required
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
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.
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): —
About SR International INC.
SR International has been a leading name among the IT consulting companies with offices in US and India. For past 16 years, our industry experience and domain knowledge have enabled us to provide innovative solutions to our customers.
Who We Are
Who We Are
We Are Leading IT Based Solution Providers
Today, the world of business information represents the realization of our collective efforts toward improving the future. Held only by the limits of our imagination, the business world is accelerating at an ever-increasing pace. Imagine a better way of doing business, of implementing the perfect software, of refining practice or business integration. All it takes are benchmark standards in service, support, and technical know-how, which have been our bread and butter.
Our Vision.
Our Vision.
Established in 2002, SR International Inc is one of the fastest growing and reputed provider of Information Technology Services and Solutions in the USA. Since our inception, we have been a trusted IT partner for our clients. We take pride in our highly skilled IT Resources and unique engagement model. We have been consistently delivering on our promises as a high-performance team. Our expertise in Cloud Computing, Mobility, Web Technologies, ERP and CRM are second to none. Our industry-leading flagship product iMathSmart is re-defining math learning experience for school students.
Career At SR International
At SR International, we treat our consultants like family. Our business and our reputation have been built and maintained by quality resources working onboard, so it’s important for us to maintain the quality resource pool.