
Senior Oracle / SQL / Data Integration Developer | Contingent | with Security Clearance
Quick overview
Job description
>
Senior Oracle / SQL / Data Integration Developer | Contingent | Washington, DC ARES Enterprise Senior Oracle / SQL / Data Integration Developer | Contingent | Washington, DC DC Description The Senior Oracle / SQL / Data Integration Developer will serve as the team's database, financial-data, and systems-integration technical lead. This individual will support the Oracle-based data environment underlying NIMS/CMIS and the interfaces connecting NIMS with FAA financial systems, including PRISM and Delphi.
This is a hands-on position requiring expertise in enterprise Oracle databases, advanced SQL development, data integration, data validation, reporting, troubleshooting, backup/recovery, and production database support. NIMS performs critical financial-management functions involving obligations/de-obligations, invoice/payment processing and financial reporting. The system receives financial information from FAA's PRISM and Delphi systems and makes that information available to NIMS/TSSC financial personnel.
The developer will maintain these interfaces, investigate data discrepancies, support data refreshes, develop and maintain reporting functionality, and participate in designing the future data architecture supporting NISC V.
Key Responsibilities
- Develop, maintain, troubleshoot, and optimize Oracle databases supporting NIMS/CMIS.
- Develop and maintain complex SQL queries, stored procedures, scripts, and data-processing routines.
- Support Oracle Database 19c Enterprise Edition.
- Use and support SQL*Plus, Toad, Oracle Enterprise Manager (OEM), RMAN, and Oracle Data Pump.
- Perform database administration and production database support.
- Monitor database performance and troubleshoot performance issues.
- Perform backup, recovery, archiving, data refresh, and restoration activities.
- Maintain interfaces between NIMS and FAA PRISM and Delphi financial systems.
- Execute and monitor recurring financial-data refreshes.
- Analyze incoming PRISM/Delphi information and identify and correct data errors.
- Troubleshoot interface failures and data-quality problems.
- Coordinate and test interface modifications resulting from PRISM or Delphi upgrades.
- Support KFDB database refreshes and reporting.
- Develop and modify operational and financial reports.
- Support invoice and payment-processing issue resolution.
- Support database security, access controls, patching, vulnerability remediation, and cybersecurity scans.
- Develop and maintain database documentation, data dictionaries, interface specifications, and operating procedures.
- Participate in Transition-In knowledge transfer and validation of databases, integrations, jobs, scripts, and operational procedures.
- Support data architecture, migration, integration, and reporting requirements for NISC V.
- Bachelor's degree in Computer Science, Information Systems, Data Engineering, Software Engineering, or related discipline, or equivalent relevant professional experience.
- 7+ years of Oracle database development, database administration, data engineering, or enterprise integration experience.
- Advanced SQL development skills.
- Strong Oracle Database experience.
- Experience with Oracle Database 19c or comparable enterprise Oracle environments.
- Experience with Oracle backup, recovery, maintenance, and performance tuning.
- Experience with SQL*Plus and database-management tools such as Toad.
- Experience with Oracle Enterprise Manager.
- Experience with RMAN and Oracle Data Pump.
- Experience developing and maintaining enterprise data integrations/interfaces.
- Experience diagnosing data discrepancies and interface failures.
- Experience with ETL/data-processing concepts.
- Experience supporting production databases and business-critical applications.
- Strong analytical and troubleshooting capabilities.
Preferred Qualifications
- Experience integrating financial, ERP, procurement, invoicing, or contract-management systems.
- PRISM and/or Delphi experience.
- Federal financial-management systems experience.
- AWS database/cloud experience.
- Experience supporting ATO/cybersecurity requirements.
- Experience developing financial and operational reporting.
- Oracle certification. By clicking “Accept All Cookies”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. Cookies Settings Accept All Cookies Privacy Preference Center When you visit any website, it may store or retrieve information on your browser, mostly in the form of cookies. This information might be about you, your preferences or your device and is mostly used to make the site work as you expect it to. The information does not usually directly identify you, but it can give you a more personalized web experience. Because we respect your right to privacy, you can choose not to allow some types of cookies. Click on the different category headings to find out more and change our default settings. However, blocking some types of cookies may impact your experience of the site and the services we are able to offer. More information
Will your resume get past this employer's screening? Check your resume against this job, free
Similar jobs
- TC
Guidewire PC CC Developer – Data ModernizationRecently posted
Techwave Consulting Inc · Iowa City, IA · On-site · Posted 20 Nov 2026 🇺🇸
SQLJavaRESTTechnologySalary not listed - IN

ServiceNow DeveloperRecently posted
InterSources Inc. · North Charleston, SC · On-site · Posted 20 Nov 2026 🇺🇸
RESTJavaScriptNetwork AdministrationTechnologySalary not listed - WG

Oracle ODI DeveloperRecently posted
Wiselink Global Inc · Sacramento, CA · On-site · Posted 20 Nov 2026 🇺🇸
OracleETLTechnologySalary not listed - SE
Salesforce PSA DeveloperRecently posted
SunRay Enterprise Inc · United States · Hybrid · Posted 20 Nov 2026 🇺🇸
TechnologySalary not listed - RT
Java Full Stack DeveloperRecently posted
Reveille Technologies · New York, NY · Hybrid · Posted 20 Nov 2026 🇺🇸
MicroservicesMySQLOracle+25TechnologySalary not listed - AL

Training Content Developer and FacilitatorRecently posted
Arthur Lawrence · Jackson, MS · Hybrid · Posted 20 Nov 2026 🇺🇸
TechnologySalary not listed - EX
.NETCORE/Breeze DeveloperRecently posted
Excelraise LLC · Raleigh, NC · Hybrid · Posted 20 Nov 2026 🇺🇸
SQLT-SQLSAML+5TechnologySalary not listed - FT
CIAM Developer(116095-1)Recently posted
Flexon Technologies Inc. · Phoenix, AZ · Hybrid · Posted 20 Nov 2026 🇺🇸
AWSMFAOAuth+8TechnologySalary not listed - VI

Software Engineer (Full Stack) with Security Clearance
Visionist, Inc. · Fort Meade, MD · Hybrid · Posted 12 Nov 2026 🇺🇸
Next.jsGitHTML+6Technology$126.5k - $176k/yr - SV

Doctrine, Training, Integration Developer – Senior (SR) (DTID with Security Clearance
Semper Valens Solutions, Inc. · Fort Leavenworth, KS · Hybrid · Posted 5 Nov 2026 🇺🇸
TechnologySalary not listed - AP

Java DeveloperRecently posted
Apexon · Santa Fe, NM · Hybrid · Posted 20 Nov 2026 🇺🇸
OraclePL/SQLSQL+15TechnologySalary not listed - DH

Sr. Salesforce DeveloperRecently posted
Digital Health Links · Columbus, OH · On-site · Posted 20 Nov 2026 🇺🇸
ScrumJavaREST+2TechnologySalary not listed