H1B Only - Oracle PL/SQL Developer - 100% Remote

[Ron]

**MUST HAVE EXPERIENCE WORKING WITH GOVERNMENT/FEDERAL AGENCY**

Hi {JobSeeker : firstname} :
Hope you are doing well today!

This is in reference to your profile I got from our database. I wanted to check your availability for an URGENT position we have. Please find below the detailed job description for your reference.

If you are interested please send me your updated resume along with your expected hourly rate.

Position:    Oracle PL/SQL Developer
Location:   Remote
Duration:   03 Years
Client:         State of Mississippi [Mississippi Department of Corrections (MDOC)]


Job Description:

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.   Beginner: 1-2 years      Intermediate: 3-5 years      Advanced: 5-7 years       SME: 7+ years Skill Set Skill Level (See key code above) Required/Preferred Notes Operating Systems SQL/ORACLE Programmer SME Required Able to write, review SQL and PL-SQL code Business Analyst Advanced Required Able to review SQL/PLSQL code, business rules, MS Code for sentencing rules   Database Systems/Database Tools ORACLE Advanced Required Enter text here SQL Advanced Preferred Enter text here

Looking forward to working with you!

Thanks,

Ron D'Silva
r...@elegantsolutions.us

EMail is the best way to reach me

Elegant Enterprise-Wide Solutions, Inc
We Participate in E-Verify
An SBA 8(a), ISO 9001:2008 Company
Prime on GSA Schedule 70, 8(a) STARS II, eFAST, Seaport-e & many State/Local Contracts