What are the responsibilities and job description for the Programmer Analyst - Oracle PL/SQL Modernization position at Delphi-US, LLC - Peacemakers in the Talent War?
| Location: Jackson, MS | Contract
Join a dynamic team focused on enterprise software development and modernization initiatives within a government or public sector environment. This role involves refactoring legacy application logic, migrating database components to cloud-based architectures, and supporting system redesign efforts to enhance operational efficiency and performance.
Key Responsibilities
Delphi-US is a national IT Services firm based in Newport, Rhode Island. Delphi attracts our nation's best and brightest Technical & Professional Talent and positions our nation's finest employers to further their competitive advantages. Delphi's core technical focus includes Data Sciences & Analytics, Modern AI/ML Model Monetization, Cloud Engineering, Cyber Security, ERP Rescue; serving domains from sensitive national energy sectors to critical financial services, biomed, life sciences & pharma, major government & municipal institutions, and much of the USA's Fortune 500 corporations. Delphi Associates are deployed on critical IT Projects where their consultative business acumen, comprehensive technical expertise, and committed service mission drives our client's success. Our proprietary skill-based and cultural matching process results in higher qualified project teams, custom curated for our client's specific technical & functional goals. We are supremely experienced, friendly, professional, and ready to advocate on your behalf. Delphi has an indelible understanding of employer expectations, a track record of project success and we deliver lasting results.
Join a dynamic team focused on enterprise software development and modernization initiatives within a government or public sector environment. This role involves refactoring legacy application logic, migrating database components to cloud-based architectures, and supporting system redesign efforts to enhance operational efficiency and performance.
Key Responsibilities
- Designs and documents existing application architecture, data models, workflows, and stored procedures to support modernization efforts.
- Rewrites and optimizes Oracle PL/SQL packages, functions, triggers, and views for migration to a cloud environment.
- Migrates legacy Crystal Reports to a modern reporting platform compatible with AWS.
- Extracts, maps, validates, and transforms data to facilitate ETL processes and database conversion activities.
- Analyzes, documents, and refactors core logic modules such as sentence computation to ensure accurate operation within the new system.
- Converts legacy DHTML-based UI forms to modern formats as part of the system redesign.
- Understands and documents scheduled jobs and backend automation processes to support operational continuity.
- Collaborates with third-party vendors to clarify requirements and support modernization initiatives.
- Expert knowledge of Oracle PL/SQL, including procedures, functions, triggers, packages, and views.
- Strong SQL skills with experience in query optimization and performance tuning.
- Proven experience with data migration, ETL workflows, and schema transformation.
- Ability to analyze and understand logic from legacy applications and undocumented code.
- Familiarity with legacy front-end technologies such as DHTML, HTML, and JavaScript forms.
- Experience working with task schedulers for data automation.
- Work on-site in Jackson, MS, with the ability to support project requirements.
- Experience with AWS database and reporting services.
- Knowledge of BI/reporting tools such as Power BI or AWS QuickSight.
- Scripting experience with Python or PowerShell.
- Background working with enterprise justice or Offender Management systems.
- Experience collaborating with external vendor teams on modernization projects.
Delphi-US is a national IT Services firm based in Newport, Rhode Island. Delphi attracts our nation's best and brightest Technical & Professional Talent and positions our nation's finest employers to further their competitive advantages. Delphi's core technical focus includes Data Sciences & Analytics, Modern AI/ML Model Monetization, Cloud Engineering, Cyber Security, ERP Rescue; serving domains from sensitive national energy sectors to critical financial services, biomed, life sciences & pharma, major government & municipal institutions, and much of the USA's Fortune 500 corporations. Delphi Associates are deployed on critical IT Projects where their consultative business acumen, comprehensive technical expertise, and committed service mission drives our client's success. Our proprietary skill-based and cultural matching process results in higher qualified project teams, custom curated for our client's specific technical & functional goals. We are supremely experienced, friendly, professional, and ready to advocate on your behalf. Delphi has an indelible understanding of employer expectations, a track record of project success and we deliver lasting results.