Senior Oracle PL/SQL Programmer Analyst (AWS Modernization)( 151864)
Posted 1 day ago by 1764268946
Negotiable
Outside
Remote
USA
Summary: The Senior Oracle PL/SQL Programmer Analyst will support a modernization initiative focused on migrating legacy enterprise applications to an AWS cloud environment. This role requires expertise in Oracle PL/SQL, analytical skills for understanding undocumented legacy code, and experience with data migration and ETL workflows. The candidate will collaborate with internal teams and external vendors to redesign critical business modules, ensuring accuracy and reliability in the modernized system. Occasional onsite reporting is required for meetings with user groups.
Key Responsibilities:
- Analyze, understand, and document existing legacy application architecture, workflows, data models, and stored procedures.
- Review, refactor, and optimize Oracle PL/SQL packages, procedures, functions, triggers, and views for cloud migration.
- Migrate Crystal Reports to modern reporting platforms compatible with AWS.
- Support ETL activities, including extracting, mapping, validating, and transforming data for system conversion.
- Analyze and document complex logic modules such as sentence computation and related core functions.
- Convert legacy DHTML-based UI forms into modern user interface components as part of system redesign.
- Identify, document, and assist in rebuilding backend automation tasks and scheduled jobs.
- Collaborate with a third-party vendor to clarify requirements and support modernization tasks.
- Participate in technical reviews and provide recommendations for system optimization, performance, and best practices.
Key Skills:
- Expert proficiency in Oracle PL/SQL (packages, functions, procedures, triggers, views).
- Strong SQL experience with query optimization and performance tuning.
- Hands-on experience with data migration, ETL workflows, and schema transformation.
- Ability to interpret, understand, and refactor undocumented legacy application logic.
- Familiarity with legacy UI formats (DHTML, HTML/JavaScript forms).
- Experience with job schedulers and automation processes.
- Experience with AWS databases (Aurora, RDS) and reporting services.
- Experience with BI/reporting tools such as Power BI or AWS QuickSight.
- Scripting skills: Python or PowerShell.
- Experience with Offender Management Systems, justice or corrections systems.
- Experience collaborating with external vendors or modernization solution partners.
- Strong analytical and problem-solving abilities.
- Excellent communication skills written and verbal.
- Ability to work independently as well as part of a team.
- Strong attention to detail and documentation discipline.
- Ability to manage time, priorities, and deliverables in a fast-paced environment.
Salary (Rate): undetermined
City: undetermined
Country: USA
Working Arrangements: remote
IR35 Status: outside IR35
Seniority Level: undetermined
Industry: IT
Senior Oracle PL/SQL Programmer Analyst (AWS Modernization)( 151864)
Location: Jackson, MS-
Duration: Long-Term Contract
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.
Job Summary
We are seeking an experienced Senior PL/SQL Programmer Analyst to support a large-scale modernization initiative involving the migration of legacy enterprise applications to an AWS cloud-based environment. The ideal candidate will have deep expertise in Oracle PL/SQL, strong analytical skills for understanding undocumented legacy code, and hands-on experience with data migration, ETL workflows, and report transformation.
This role requires close collaboration with internal development teams and an external vendor to redesign and refactor critical business modules including records, classification, and sentence computation to ensure accuracy and reliability in the modernized system.
Key Responsibilities
- Analyze, understand, and document existing legacy application architecture, workflows, data models, and stored procedures.
- Review, refactor, and optimize Oracle PL/SQL packages, procedures, functions, triggers, and views for cloud migration.
- Migrate Crystal Reports to modern reporting platforms compatible with AWS.
- Support ETL activities, including extracting, mapping, validating, and transforming data for system conversion.
- Analyze and document complex logic modules such as sentence computation and related core functions.
- Convert legacy DHTML-based UI forms into modern user interface components as part of system redesign.
- Identify, document, and assist in rebuilding backend automation tasks and scheduled jobs.
- Collaborate with a third-party vendor to clarify requirements and support modernization tasks.
- Participate in technical reviews and provide recommendations for system optimization, performance, and best practices.
Required Technical Skills
- Expert proficiency in Oracle PL/SQL (packages, functions, procedures, triggers, views).
- Strong SQL experience with query optimization and performance tuning.
- Hands-on experience with data migration, ETL workflows, and schema transformation.
- Ability to interpret, understand, and refactor undocumented legacy application logic.
- Familiarity with legacy UI formats (DHTML, HTML/JavaScript forms).
- Experience with job schedulers and automation processes.
Preferred Qualifications
- Experience with AWS databases (Aurora, RDS) and reporting services.
- Experience with BI/reporting tools such as Power BI or AWS QuickSight.
- Scripting skills: Python or PowerShell.
- Experience with Offender Management Systems, justice or corrections systems.
- Experience collaborating with external vendors or modernization solution partners.
Soft Skills & Competencies
- Strong analytical and problem-solving abilities.
- Excellent communication skills written and verbal.
- Ability to work independently as well as part of a team.
- Strong attention to detail and documentation discipline.
- Ability to manage time, priorities, and deliverables in a fast-paced environment.