Senior Oracle/SQL Data Integration Lead (19c)

Ares Enterprise; Washington (District of Columbia); Hybrid; USD 120,000 - 160,000; Full time

Job summary

Ares Enterprise in Washington, DC seeks a Senior Oracle/SQL/Data Integration Developer to serve as the technical lead for databases, financial-data interfaces, and systems integration. The role focuses on Oracle 19c, advanced SQL, data validation, and production DB support across NIMS/CMIS and FAA interfaces such as PRISM and Delphi.

The position is hands-on, with responsibilities spanning data refreshes, reporting, troubleshooting, security, and documentation to support critical

Qualifications

• Bachelor’s degree or equivalent professional experience in a related field.
• 7+ years of Oracle database development, administration, data engineering, or enterprise integration.
• Strong SQL development and experience with Oracle 19c or equivalent.
• Experience with backup, recovery, performance tuning, and DB maintenance.
• Experience with SQL*Plus and tools like Toad and OEM.
• Experience developing/maintaining enterprise data integrations and diagnosing data discrepancies.
• Experience with ETL concepts and production database support.

Responsibilities

• Develop, maintain, troubleshoot, and optimize Oracle databases supporting NIMS/CMIS.
• Create and maintain complex SQL queries, stored procedures, and data-processing routines.
• Utilize SQL*Plus, Toad, OEM, RMAN, and Data Pump for operations.
• Provide database administration and production support, including performance monitoring.
• Handle backups, recovery, archiving, and data refresh activities.
• Maintain interfaces between NIMS and FAA PRISM/Delphi systems.
• Analyze data discrepancies and supervise data-quality improvements.
• Coordinate interface changes from system upgrades and test thoroughly.
• Develop and maintain operational and financial reports and documentation.

Skills

Oracle database development

Advanced SQL development

Data integration

ETL processing

Troubleshooting

Production database support

Data validation

Education

Bachelor's degree in Computer Science, Information Systems, Data Engineering, Software Engineering, or related discipline

Tools

SQL*Plus

Toad

Oracle Enterprise Manager (OEM)

RMAN

Oracle Data Pump

Job description

Ares Enterprise in Washington, DC seeks a Senior Oracle/SQL/Data Integration Developer to serve as the technical lead for databases, financial-data interfaces, and systems integration. The role focuses on Oracle 19c, advanced SQL, data validation, and production DB support across NIMS/CMIS and FAA interfaces such as PRISM and Delphi.

The position is hands-on, with responsibilities spanning data refreshes, reporting, troubleshooting, security, and documentation to support critical