Senior Oracle Apex Developer

Savantage Solutions is seeking a Oracle APEX Developer to join our core engineering team supporting Altimate, a proprietary Federal Financial Management System deployed for federal agency clients. This is a fully remote, senior-level production support and development role requiring deep Oracle APEX and PL/SQL expertise within a federal contractor environment. The ideal candidate is an experienced Oracle developer who understands the discipline of federal IT delivery, ATO boundary constraints, SCR-based change management, restricted-rights IP, and CMMI Level 3 process standards, and who can operate independently on complex technical problems without close supervision.

• Own end-to-end Oracle APEX application development: page design, process logic, dynamic actions, validations, authorization schemes, and authentication configuration
• Diagnose and resolve production defects across APEX applications under defined SLA windows, including root cause analysis documentation aligned to CMMI Level 3 standards
• Develop and maintain APEX plugins, REST-enabled SQL services, and API integrations supporting federal financial workflows
• Perform APEX application upgrades, workspace migrations, and version compatibility assessments
• Execute and document configuration management procedures including deployment step documents, release notes, and rollback plans
• Design, develop, and optimize complex PL/SQL packages, stored procedures, functions, triggers, and scheduled jobs supporting federal financial processing
• Perform SQL query tuning, execution plan analysis, and index optimization across large-volume federal financial datasets
• Develop and maintain database objects supporting but not limited to IPAC, GTAS, CARS/GWA, GL, payroll, and bankcard financial modules.
• Write and maintain data validation logic, reconciliation routines, and exception handling procedures aligned to USSGL and Treasury reporting requirements
• Support advance federal financial reconciliation report output processing, and Intra-Governmental transaction workflows
• 7+ years of Oracle SQL and PL/SQL development experience including advanced stored procedures, packages, triggers, and performance optimization
• 4+ years of Oracle APEX development experience across multiple major versions; demonstrated production application ownership
• Proven experience working within federal IT contractor environments: ATO constraints, SCR-based workflows, and government deliverable standards
• Working knowledge of Git Lab or equivalent Git-based source control with structured branching and merge request discipline
• Experience supporting live production systems under SLA, including defect triage, root cause analysis, and documented resolution
• Ability to produce clear, audit-ready technical documentation for both developer and government stakeholder audiences
• Experience with Oracle APEX 22.x or later including Universal Theme, Faceted Search, and REST Data Sources
• Familiarity with Oracle APEX plug-in development and JavaScript/CSS customization within the APEX framework
• Experience with Git Lab CI/CD pipeline configuration for automated testing or deployment of APEX and PL/SQL objects
• Knowledge of Oracle Database 19c or later features: partitioning, advanced analytics, JSON support, or In-Memory Column Store
• Exposure to AI-assisted development tools (Git Hub Copilot, Oracle AI features, or similar) and ability to validate AI-generated SQL output
• Familiarity with federal financial management data structures: appropriations, USSGL chart of accounts, fund balance with Treasury
• Experience with IPAC, GTAS, CARS/GWA, or G-Invoicing transaction processing at the database or application tier
• Knowledge of federal financial system audit requirements and internal control documentation standards (OMB A-123)
• Experience with CMMI Level 3 or ISO 9001 process frameworks in a federal software delivery context

• Design, develop, and optimize complex PL/SQL packages, stored procedures, functions, triggers, and scheduled jobs supporting federal financial processing
• Perform SQL query tuning, execution plan analysis, and index optimization across large-volume federal financial datasets
• Develop and maintain database objects supporting but not limited to IPAC, GTAS, CARS/GWA, GL, payroll, and bankcard financial modules.
• Write and maintain data validation logic, reconciliation routines, and exception handling procedures aligned to USSGL and Treasury…