Job Title : Programmer Analyst ( Oracle PL/SQL ) - Jackson, MS ( On-site )
Shekhar K
Location : Jackson, MS ( On-site )
Duration : 12+ Months
Summary :
We are seeking a skilled Programmer Analyst with strong experience in enterprise software development, SQL/Oracle programming, and cloud-based modernization initiatives. The ideal candidate will review, refactor, and migrate legacy application logic including PL/SQL code, stored procedures, and Crystal Reports into a modern AWS-based architecture. This role involves understanding existing
business logic, documenting current workflows, and collaborating with both internal teams and a third-party vendor. They will support the redesign of core application functionality, including modules such as
records, classification and sentence computation, to ensure accurate operation within the updated system.
Key Responsibilities :
- Review and document existing application architecture, data models, workflows, and stored procedures.
- Rewrite and optimize Oracle PL/SQL packages, functions, triggers, and views for migration to a cloud environment.
- Migrate legacy Crystal Reports to a modern reporting platform compatible with AWS.
- Extract, map, validate, and transform data to support ETL and database conversion activities.
- Analyze, document, and refactor core logic modules such as sentence computation.
- Convert legacy DHTML-based UI forms to modern formats as part of system redesign.
- Understand and document scheduled jobs and backend automation processes.
- Collaborate with a third-party vendor to clarify requirements and support modernization efforts.
Required Technical Skills :
- Expert knowledge of Oracle PL/SQL (procedures, functions, triggers, packages, views).
- Strong SQL expertise including query optimization and performance tuning.
- Experience with data migration, ETL workflows, and schema transformation.
- Ability to understand logic from legacy applications and undocumented code.
- Familiarity with legacy front-end technologies (DHTML, HTML/JavaScript forms).
- Experience with task schedulers for data automation.
Preferred Qualifications :
- Experience with AWS database and reporting services.
- Knowledge of BI/reporting tools such as Power BI or AWS QuickSight.
- Scripting experience (Python, PowerShell).
- Experience with Offender Management or enterprise justice systems.
- Experience working with external vendor teams on modernization projects.
Share the Resumes & Below Required Mandatory Details & 3 Professional References to my Official email id sek...@transreach.com only
|
Three (3) references of submitted candidates required . Must submit with resume
|
|
If References are Not Shared Resumes Won’t Be Considered :::
Reference 1 :
Reference 2 :
Reference 3 :
|
- Legal Name (First/Last):
- Phone (Primary and secondary):
- Candidate Email:
- Current Location (City, State):
- Work Authorization / Visa Status :
- Last 5 Digits of SSN :
- Interview Availability ( Any 2 days Interview Slots ) :
- LinkedIn URL:
- Education Details ( Bachelors / Masters , University Name , Location, Year of Pass out ) :
- Availability once Confirmed:
- Total years of Work Experience in USA :
- Over All Years of Work Experience :
- Open to Relocate ( Yes / No ) :
- Expected Hourly Bill Rate on C2C :
- Employer Contact Information :
