SR ORACLE DATABASE & DATA INTEGRATION ENGINEE

Role Description

Owns the OBIWAN Oracle database and data-integration layer supporting timely and accurate FAA financial reporting. The position administers Oracle Database 19c and associated platforms, operates and enhances Oracle Data Integrator (ODI) workflows, maintains GoldenGate replication, executes daily DELPHI and PRISM data loads and reconciliation, performs backup and recovery, tunes performance, resolves failures, and preserves data integrity across development, test, staging, and production environments.

The candidate must have the ability to operate effectively under pressure adhering to the ProSol Core Values of:

• Agility: rapid adaptation to the changing requirements and environment of our clients;
• Excellence: Service quality that exceeds the expectations of our clients;
• Integrity: Accountability and honesty−always doing the right thing;
• Long-Term Commitment: Unquestioned loyalty and dedication to our clients, partners and employees.

Qualifications

• Advanced Oracle Database administration and troubleshooting skills in high-availability production environments.
• Strong Oracle Data Integrator experience, including complex load plans, scheduling, mappings, job dependencies, automation, restartability, exception handling, and performance optimization.
• Hands-on experience with Oracle GoldenGate replication, RMAN backup/recovery, Oracle Enterprise Manager, AWR, SQL/PLSQL, and database performance tuning.
• Ability to operate time-sensitive financial data pipelines, validate source-to-target completeness, reconcile balances and records, and resolve discrepancies under strict daily deadlines.
• Experience with flat-file transfer, FTP/SFTP, secure shell tools, file parsing, job scheduling, logging, alerting, and automated controls.
• Ability to diagnose failures spanning source systems, network transfer, ETL, databases, replication, reports, and downstream dependencies.
• Strong documentation and communication skills, including clear incident status, root-cause analysis, recovery procedures, and technical recommendations.

Requirements

• Bachelor’s degree in computer science, information systems, data engineering, software engineering, or a related technical field; directly relevant experience may substitute for a portion of formal education.
• At least seven years of experience supporting enterprise Oracle database, data warehouse, ETL, data-integration, or financial-reporting environments.
• At least five years of hands-on experience with Oracle Database administration and/or Oracle Data Integrator in production operations.
• Demonstrated experience with backup and recovery, performance tuning, patching, upgrades, replication, production batch operations, data validation, and root-cause analysis.
• Demonstrated ability to support early-morning Eastern Time production deadlines and respond calmly to high-impact data or database incidents.

Preferred Qualifications

• Oracle Certified Professional (OCP), Oracle Database Administration, ODI, GoldenGate, Exadata, or comparable Oracle credentials.
• Experience with FAA systems, OBIWAN, DELPHI / Oracle Federal Financials, PRISM, or other federal financial and procurement data sources.
• Experience with Exadata X9, Oracle Enterprise Manager, VxRail, Red Hat Linux, and hybrid application/database operations.
• Experience creating automated reconciliation controls, anomaly detection, dashboards, and preventive monitoring for daily data pipelines.
• Experience supporting ATO sustainment, NIST controls, vulnerability remediation, security scans, and audit evidence in federal environments.

Core Competencies

• Oracle database administration
• ODI and ETL operations
• Daily data reconciliation
• GoldenGate replication
• Backup and recovery
• Performance tuning and capacity
• Root-cause analysis and automation
• Time-critical production support

Supervisory Responsibilities

This position has no routine direct reports. The employee may lead database and integration work, coordinate incident response, conduct peer reviews, and provide technical direction to team members or vendor support personnel.

Work Environment and Physical Requirements

Work is primarily performed remotely or at a Contractor facility. The role requires sustained computer use, early-morning availability aligned to Eastern Time, careful review of logs and financial data, and occasional after-hours work during maintenance, releases, outages, or recovery events. The employee must be able to respond promptly through telephone, messaging, and virtual collaboration tools.

Performance Expectations

• Daily integrations and reconciliation complete within required contract timelines with accurate status and escalation when deadlines are at risk.
• Database services, replication, backup, and recovery remain reliable, secure, performant, and fully documented.
• Data discrepancies and integration failures are resolved quickly, with root cause and preventive controls documented.
• Patches, upgrades, migrations, and configuration changes are tested, controlled, reversible, and supported by complete evidence.
• Database and data-integration documentation remains current enough for backup personnel to execute routine operations and recovery.

Position Description Disclaimer

This description summarizes the position’s primary duties and may be revised for related business or contract needs. It does not create an employment contract. Reasonable accommodations may be provided in accordance with applicable law and company policy.

Additional Information

ProSol is an equal opportunity employer, all interested qualified applicants are encouraged to apply, EEO/D/M/V/F. ProSol welcomes and encourages diversity in the workforce. All your information will be kept confidential according to EEO guidelines.