Remote Shopify Theme Developer Jobs in Ashburn, VA

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.

This role exists at the intersection of production stability and forward development. You will own complex SQL and PL/SQL engineering, drive Oracle APEX application development and debugging, and contribute to maturing the team's GitLab-based source control and pipeline practices.

 Duties and Responsibilities:

 Oracle APEX Development & Production Support

• 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 GitLab 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 GitLab 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 (GitHub 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
•  

 Duties and Responsibilities:

 Oracle APEX Development & Production Support

• 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

 Advanced SQL & PL/SQL Engineering

• 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

Knowledge, Skill, and Abilities:

 The candidate must have:

• U.S. citizenship and ability to obtain and maintain a federal Public Trust clearance or higher
• 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 GitLab 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
• U.S. citizenship and ability to obtain and maintain a federal Public Trust clearance or higher
• 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 GitLab 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 (GitHub 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

Preferred Qualifications

Technical Depth

• 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 GitLab 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 (GitHub 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

Federal Financial Domain

• 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

 Education and Certifications:

• Bachelor's degree in Computer Science, Information Systems, or a related technical field (or equivalent demonstrable experience)

 Compensation

$135,000 - $165,000 annually (based on the National Capital Region)

The pay range for this job level at Savantage Solutions serves as a general guideline and is not a guarantee of compensation or salary. Factors considered when extending an offer include but are not limited to, job responsibilities, education, experience, knowledge, skills, certifications, seniority, performance, and alignment with market data.

 This salary range is based on the National Capital Region and reflects our good faith estimate for this role at the time of posting. Actual compensation may vary based on geographic region or market conditions, and we may ultimately pay more or less than the stated range.

 We are committed to providing competitive compensation and encouraging candidates from all locations to apply.

Corporate Summary: 

Savantage Solutions provides a wide range of consulting, systems integration, and financial and project management support to federal and DoD agencies. For over two decades, Savantage Solutions has partnered with organizations in both the public and private sectors to achieve innovative solutions for customers' challenges. 

Savantage Solutions is a woman-owned company that values diversity, initiative, and a commitment to learning and growing. Our philosophy is that diversity is an asset to any industry or organization, and that innovation is only nurtured in an environment that embraces creativity and open minds. We thrive on the ideas and perspectives generated by a diverse workforce.

           Savantage Solutions is an Equal Opportunity/Affirmative Action Employer