Solution Integrator and Developer

  • ALEXANDRIA, VA
  • Posted 26 days ago | Updated 6 hours ago

Overview

On Site
Full Time

Skills

IT management
DoD
Business-to-business
PL/SQL
Oracle Application Express
Crystal Reports
Enterprise services
Program evaluation
Information systems
Business intelligence
Quality assurance
Technical Support
RESTful
Programming languages
Visual Basic
Software administration
Data collection
Web services
Web content
Java Servlets
SQL
Unstructured data
Query optimization
SQL Trace
Information Technology
Systems engineering
Federal government
Security clearance
Prism
Secretary
OSD
Planning
Software development
Budget
Agile
Design
Testing
Scalability
Creativity
Supervision
Debugging
Database
Operations
Training
Data
Documentation
XML
DHTML
Java
VBA
Apex
JavaScript
IMPACT
Acquisition
Reporting
Ajax
XSLT
JSON
HTML
Cascading style sheets
jQuery
OAuth
Authentication
Oracle
Analytical skill
Workflow
Writing
Collections
Storage
FTP
SFTP
Forms
GRID
SAP BASIS
Policies
FOCUS

Job Details

Job ID: 2404836

Location: ALEXANDRIA, VA, US

Date Posted: 2024-04-02

Category: Software

Subcategory: SW Systems Engr

Schedule: Full-time

Shift: Day Job

Travel: No

Minimum Clearance Required: Interim Secret

Clearance Level Must Be Able to Obtain: Secret

Potential for Remote Work: No

Description

SAIC is seeking a Solution Integrator and Developer located out of the Mark Center in Alexandria, VA.

Support the Resource Enterprise Services (RES) for Program Resources and Information Systems Management Division (PRISM), for the Office of the Secretary of Defense (OSD), Cost Assessment and Program Evaluation (CAPE)

The PRISM division is responsible for maintaining of business applications to support matters relating to the planning and programming phases of the Planning, Programming, Budgeting, and Execution (PPBE) and the preparation of material and guidance for such systems PPBE is the Department of Defense (DOD) process for allocating resources.

The Solution Integrator is responsible for designing, developing, and supporting agile applications that respond to meet client requirements and works with the project business owner and/or executive to ensure delivery that responds to timelines.

Works in an engineering environment focusing on engineering and/or scientific studies and analysis providing technical solutions.

Provides design, implementation, testing services for complex information systems providing Business Intelligence solutions with attention to performance, scalability, and security.

Supports programs with exceptional creativity and resourcefulness in the most demanding and complex assignments.

Works independently on project(s) with minimum supervision to analyze, architect, design, code, test, debug, document and maintain applications and application enhancements.

Collaborates with cross-functional teams, including database administrators, system administrators, and quality assurance teams, to ensure smooth application deployments and operations.

Evaluates and introduces new technologies, tools, and methodologies to enhance development processes.

Conducts training of system users or technical support personnel.

Designs and implements secure Business to Business data exchanges utilizing RESTFul Services.

Assesses impacts on existing systems for proposed changes; estimate level of effort required to implement.

Develops, tests, debugs, documents and maintains application modules and object classes, using programming languages such as Oracle PL/SQL, SQL, XML, DHTML, Java, Visual Basic for Applications (VBA), Application Express (APEX) and JavaScript, in a complex and changing business environment across multiple systems.

Provides technical expertise and guidance to team members and junior developers.

Performs complex analyses and develops recommendations that may impact acquisition programs and activities.

Qualifications

Requirements:

At least 10 years of relevant experience such as working with the DoD Future Years Defense Program (FYDP) data and with Program Review.

Ten years being a solution provider/software developer.

Proven and in-depth experience with Oracle Application Express (APEX) 5.0/19.2 or greater Application Administration/Development supporting minimum (5) large scale complex APEX applications supporting secure role-based multi-user data collection, reporting, and document generation functions.

In-depth knowledge of PL/SQL, SQL, Java, JavaScript, Web Services, AJAX, XML, XSLT, JSON, HTML, and CSS and other programming languages.

Design and manipulation skills to modify web content dynamically using JQuery, Ajax, JavaScript, CSS, and HTML.

Proven experience developing secure (OAUTH2 authentication) RESTful services using Oracle RESTful Data Services (ORDs) and Java Servlets.

Strong design, development, implementation technical expertise with web based analytical front ends and workflows.

Excellent knowledge in writing SQL queries, Views, Materialized views, PL/SQL procedures, functions, packages, indexes, triggers, cursors, materialized views, collections, Ref cursor, cursor variables, System reference cursor, Dynamic SQL.

Provide support with storage, efficient retrieval, and manipulation of unstructured data (BLOBs, CLOBs, JSON, XMLType) in an Oracle environment.

Hands on experience in query optimization, performance and tuning (PL/SQL) using SQL Trace, Explain Plan, Indexing, Hints, Bulk Binds and Bulk Collect.

Experience using Oracle built-in database packages (DBMS_SCHEDULER) and mail.

Experience using FTP and SFTP services in APEX applications.

Extensive experience developing APEX interactive grids, custom update processing, interactive reports, forms based on views, tables, and procedures in interactive grid, tabular and form layouts.

Experience designing and developing SAP Crystal Reports.

Required Clearance:

Interim Secret or higher.

SAIC accepts applications on an ongoing basis and there is no deadline.

Covid Policy: SAIC does not require COVID-19 vaccinations or boosters. Customer site vaccination requirements must be followed when work is performed at a customer site.


About SAIC