Sr. Software Developer – Forms

DSFederal is seeking a Senior Software Developer specializing in Oracle Forms and Reports to support a federal agency. The developer will enhance and modernize the core grants management system (Oracle Forms/Reports on WebLogic 12c with Oracle Database 19c), and the PL/SQL and interface logic it shares with related applications such as the Financial Processing Application (FPA), which manages the flow of information between the grants management system and Treasury’s ASAP system.

• Develop and enhance Oracle Forms and Reports modules – forms, triggers, program units, PL/SQL libraries, menus, and report definitions – deployed on WebLogic 12c.

• Analyze backlog work orders and perform impact analysis across the shared Oracle 19c schemas; document requirements and estimate effort.

• Write and optimize PL/SQL packages, procedures, triggers, and batch jobs supporting grants processing and reporting.

• Enhance and support the data flow, including IBM Sterling Connect:Direct file transfers.

• Implement application changes driven by external sources (ASAP, FMMI, SAM, Grants.gov), Presidential Executive Orders, Government priorities, and business-process changes.

• Upgrade Forms/Reports, WebLogic, and database components to security-compliant versions; support infrastructure hosting changes; evaluate and implement modernization options (e.g., moving selected Forms modules to Oracle APEX) when directed.

• Implement encryption/decryption of PII in Forms, PL/SQL, and database layers.

• Develop and maintain Oracle Reports outputs (PDF, RTF, spreadsheet) and ensure delivered content meets Section 508 / WCAG Level A/AA requirements.

• Perform unit and integration testing, support QA and user acceptance testing, and deploy through change management governance.

• Manage code in Git/Subversion, track work in JIRA and Remedy, and maintain technical documentation in Confluence/SharePoint.

• Participate in code reviews and Integrated Project Team meetings; provide status input for Weekly/Monthly Status Reports.

• Support knowledge transfer, handoff of completed work, and Transition-Out activities.

Experience Required

• Minimum 7 years of professional software development experience, including at least 5 years of hands-on Oracle Forms and Reports development (10g/11g/12c).

• Minimum 7 years of Oracle SQL and PL/SQL development.

• Demonstrated competency with Ruby on Rails (RoR), Java, WSDL, and PL/SQL, and with MySQL, Oracle, and SQL Server.

• Experience upgrading or migrating Oracle Forms/Reports applications (e.g., 11g to 12c) and deploying them on WebLogic Server.

• Experience with federal grants management or financial systems, and with interfaces to Treasury ASAP, FMMI, SAM.gov, or Grants.gov, strongly preferred.

• Experience working in Agile/Scrum teams with backlog-driven delivery and formal change management.

• Bachelor’s degree in Computer Science, Information Technology, or a related field preferred; additional relevant experience may substitute.

• Must be a U.S. Citizen, Lawful Permanent Resident, or valid work-visa holder, and able to obtain and maintain a Public Trust (Moderate Risk or higher) background investigation (minimum NACI), fingerprinting, and an HSPD-12 PIV credential. Must complete annual Information Security Awareness (ISA) and Rules of Behavior (ROB) training.

• Strong written and verbal communication skills;

Technical Skills Required

• Oracle Forms & Reports: Forms/Reports 12c (Forms Builder, Reports Builder), PLL libraries, Forms/Reports server configuration on Oracle WebLogic Server 12c.

• Oracle Database 19c: Advanced SQL and PL/SQL (packages, bulk processing, dynamic SQL, exception handling), performance tuning, DBMS_SCHEDULER, UTL_FILE, DBMS_CRYPTO.

• Integration: SOAP/WSDL and REST web services, flat-file interfaces, XML, IBM Sterling Connect:Direct.

• Java: Java/OpenJDK 11/21 and Red Hat JBoss EAP 7.4/8.1 – able to read and modify the Java EE applications sharing the C-REEMS database (PRS, CDS, GAC, EAM, FOLS, FPA).

• Other languages & databases: Ruby on Rails, MySQL 5.7, SQL Server.

• Oracle APEX: Working knowledge (plus), to support Forms-to-APEX modernization.

• Platform: Red Hat Enterprise Linux 8 and shell scripting.

• Tools: JIRA, Confluence, Remedy, Git, Subversion, SharePoint, SQL Developer/TOAD.