Is the SR ORACLE DATABASE & DATA INTEGRATION ENGINEE position at Professional Solutions 1 LLC fully remote?

Yes, this SR ORACLE DATABASE & DATA INTEGRATION ENGINEE position at Professional Solutions 1 LLC is a remote position. The role is available for candidates in United States.

Is this a full-time or part-time SR ORACLE DATABASE & DATA INTEGRATION ENGINEE role?

This is a full-time SR ORACLE DATABASE & DATA INTEGRATION ENGINEE position at Professional Solutions 1 LLC.

How do I apply for the SR ORACLE DATABASE & DATA INTEGRATION ENGINEE position at Professional Solutions 1 LLC?

You can apply for this SR ORACLE DATABASE & DATA INTEGRATION ENGINEE position by clicking the "Apply Now" button on this page, which will take you to Professional Solutions 1 LLC's application portal.

SR ORACLE DATABASE & DATA INTEGRATION ENGINEE at Professional Solutions 1 LLC

United States

<div><div>Position SummaryOwns 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; and Long-Term Commitment: Unquestioned loyalty and dedication to our clients, partners and employees. Essential Duties and Responsibilities<div style="margin-left:0in;"><ul style="list-style-type: disc;margin-left: 5.85px;"><li style="margin-left:0in;">Administer Oracle Database 19c environments, including instance monitoring, storage and space management, user and privilege support, configuration, performance tuning, patching, upgrades, consolidation, migration, and operational reporting.</li><li style="margin-left:0in;">Operate, monitor, maintain, and improve Oracle Data Integrator workflows, load plans, schedules, packages, procedures, mappings, job dependencies, variables, and exception-handling routines.</li><li style="margin-left:0in;">Execute and monitor daily integrations from DELPHI / Oracle Federal Financials, PRISM, flat-file sources, FTP/SFTP locations, and approved direct database connections into OBIWAN staging and production environments.</li><li style="margin-left:0in;">Ensure source data is integrated within contract timelines, including completion by 9:00 a.m. Eastern Time when source files are available before 6:00 a.m., excluding weekends and holidays.</li><li style="margin-left:0in;">Perform daily reconciliation and validation of financial obligations, expenditures, record counts, balances, referential integrity, file completeness, and source-to-target consistency; resolve discrepancies by 11:00 a.m. or within two hours of load completion.</li><li style="margin-left:0in;">Promptly notify the Program Manager and Program Office when daily load or reconciliation deadlines are at risk and provide accurate status, impact, workaround, and recovery estimates.</li><li style="margin-left:0in;">Conduct structured root-cause analysis for significant integration, database, replication, or data-quality failures; document corrective and preventive action and support formal reports within required timeframes.</li><li style="margin-left:0in;">Maintain and troubleshoot Oracle GoldenGate replication, including lag, connectivity, missing records, transaction consistency, failover, and recovery between PRISM and OBIWAN-related environments.</li><li style="margin-left:0in;">Implement and validate Oracle Recovery Manager (RMAN) backup, restoration, recovery, control-file, archive-log, and disaster-recovery procedures; routinely test recoverability and remediate backup failures.</li><li style="margin-left:0in;">Monitor and tune CPU, memory, I/O, sessions, waits, queries, indexes, execution plans, redo logs, tablespaces, jobs, and workload patterns using Oracle Enterprise Manager, AWR, and other approved tools.</li><li style="margin-left:0in;">Support Oracle Exadata X9 and database-related infrastructure activities, including migrations, patching, service requests, capacity planning, diagnostics, and coordination with infrastructure or Oracle support personnel.</li><li style="margin-left:0in;">Maintain accurate database architecture diagrams, schema and interface documentation, data dictionaries, operational procedures, reconciliation instructions, remediation records, configuration baselines, and runbooks.</li><li style="margin-left:0in;">Apply database security patches, secure configurations, least-privilege controls, and remediation actions; support scans, audits, ATO sustainment, POA&M activities, evidence collection, and FAA security coordination.</li><li style="margin-left:0in;">Coordinate with the Oracle Analytics Developer to ensure physical schemas, logical models, presentation-layer objects, and reporting calculations remain synchronized and accurate.</li><li style="margin-left:0in;">Provide Tier 3 database and integration support, participate in production releases and maintenance windows, contribute to monthly reporting, and cross-train backup personnel.</li></ul></div>Required Technical and Professional Competencies<div style="margin-left:0in;"><ul style="list-style-type: disc;margin-left: 5.85px;"><li style="margin-left:0in;">Advanced Oracle Database administration and troubleshooting skills in high-availability production environments.</li><li style="margin-left:0in;">Strong Oracle Data Integrator experience, including complex load plans, scheduling, mappings, job dependencies, automation, restartability, exception handling, and performance optimization.</li><li style="margin-left:0in;">Hands-on experience with Oracle GoldenGate replication, RMAN backup/recovery, Oracle Enterprise Manager, AWR, SQL/PLSQL, and database performance tuning.</li><li style="margin-left:0in;">Ability to operate time-sensitive financial data pipelines, validate source-to-target completeness, reconcile balances and records, and resolve discrepancies under strict daily deadlines.</li><li style="margin-left:0in;">Experience with flat-file transfer, FTP/SFTP, secure shell tools, file parsing, job scheduling, logging, alerting, and automated controls.</li><li style="margin-left:0in;">Ability to diagnose failures spanning source systems, network transfer, ETL, databases, replication, reports, and downstream dependencies.</li><li style="margin-left:0in;">Strong documentation and communication skills, including clear incident status, root-cause analysis, recovery procedures, and technical recommendations.</li></ul></div>Minimum Education and Experience<div style="margin-left:0in;"><ul style="list-style-type: disc;margin-left: 5.85px;"><li style="margin-left:0in;">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.</li><li style="margin-left:0in;">At least seven years of experience supporting enterprise Oracle database, data warehouse, ETL, data-integration, or financial-reporting environments.</li><li style="margin-left:0in;">At least five years of hands-on experience with Oracle Database administration and/or Oracle Data Integrator in production operations.</li><li style="margin-left:0in;">Demonstrated experience with backup and recovery, performance tuning, patching, upgrades, replication, production batch operations, data validation, and root-cause analysis.</li><li style="margin-left:0in;">Demonstrated ability to support early-morning Eastern Time production deadlines and respond calmly to high-impact data or database incidents.</li></ul></div>Preferred Qualifications<div style="margin-left:0in;"><ul style="list-style-type: disc;margin-left: 5.85px;"><li style="margin-left:0in;">Oracle Certified Professional (OCP), Oracle Database Administration, ODI, GoldenGate, Exadata, or comparable Oracle credentials.</li><li style="margin-left:0in;">Experience with FAA systems, OBIWAN, DELPHI / Oracle Federal Financials, PRISM, or other federal financial and procurement data sources.</li><li style="margin-left:0in;">Experience with Exadata X9, Oracle Enterprise Manager, VxRail, Red Hat Linux, and hybrid application/database operations.</li><li style="margin-left:0in;">Experience creating automated reconciliation controls, anomaly detection, dashboards, and preventive monitoring for daily data pipelines.</li><li style="margin-left:0in;">Experience supporting ATO sustainment, NIST controls, vulnerability remediation, security scans, and audit evidence in federal environments.</li></ul></div>CertificationsNo certification is contractually mandated. Oracle Database, ODI, GoldenGate, Exadata, Linux, Security+, or comparable technical certifications are preferred when supported by relevant experience.Core Competencies<table border="0" cellspacing="0" cellpadding="0"><tbody><tr><td valign="top" style="width: 50%;">• Oracle database administration</td><td valign="top" style="width: 50%;">• ODI and ETL operations</td></tr><tr><td valign="top" style="width: 50%;">• Daily data reconciliation</td><td valign="top" style="width: 50%;">• GoldenGate replication</td></tr><tr><td valign="top" style="width: 50%;">• Backup and recovery</td><td valign="top" style="width: 50%;">• Performance tuning and capacity</td></tr><tr><td valign="top" style="width: 50%;">• Root-cause analysis and automation</td><td valign="top" style="width: 50%;">• Time-critical production support</td></tr></tbody></table> Supervisory ResponsibilitiesThis 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 RequirementsWork 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<div style="margin-left:0in;"><ul style="list-style-type: disc;margin-left: 5.85px;"><li style="margin-left:0in;">Daily integrations and reconciliation complete within required contract timelines with accurate status and escalation when deadlines are at risk.</li><li style="margin-left:0in;">Database services, replication, backup, and recovery remain reliable, secure, performant, and fully documented.</li><li style="margin-left:0in;">Data discrepancies and integration failures are resolved quickly, with root cause and preventive controls documented.</li><li style="margin-left:0in;">Patches, upgrades, migrations, and configuration changes are tested, controlled, reversible, and supported by complete evidence.</li><li style="margin-left:0in;">Database and data-integration documentation remains current enough for backup personnel to execute routine operations and recovery.</li></ul></div>Position Description DisclaimerThis 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 InformationProSol 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. </div></div>

Apply Now

Remote Opportunity

SR ORACLE DATABASE & DATA INTEGRATION ENGINEE

Join Professional Solutions 1 LLC as a senior professional working remotely from United States. Explore the role, benefits, and apply in one place.

SR ORACLE DATABASE & DATA INTEGRATION ENGINEE

Professional Solutions 1 LLC

Full Time

2 months ago

Position Summary 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,…

United States

Data

Senior

Oracle Data Integrator

Oracle GoldenGate

RMAN

+5 more

Job Description

Position Summary

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; and Long-Term Commitment: Unquestioned loyalty and dedication to our clients, partners and employees.

Essential Duties and Responsibilities

Administer Oracle Database 19c environments, including instance monitoring, storage and space management, user and privilege support, configuration, performance tuning, patching, upgrades, consolidation, migration, and operational reporting.
Operate, monitor, maintain, and improve Oracle Data Integrator workflows, load plans, schedules, packages, procedures, mappings, job dependencies, variables, and exception-handling routines.
Execute and monitor daily integrations from DELPHI / Oracle Federal Financials, PRISM, flat-file sources, FTP/SFTP locations, and approved direct database connections into OBIWAN staging and production environments.
Ensure source data is integrated within contract timelines, including completion by 9:00 a.m. Eastern Time when source files are available before 6:00 a.m., excluding weekends and holidays.
Perform daily reconciliation and validation of financial obligations, expenditures, record counts, balances, referential integrity, file completeness, and source-to-target consistency; resolve discrepancies by 11:00 a.m. or within two hours of load completion.
Promptly notify the Program Manager and Program Office when daily load or reconciliation deadlines are at risk and provide accurate status, impact, workaround, and recovery estimates.
Conduct structured root-cause analysis for significant integration, database, replication, or data-quality failures; document corrective and preventive action and support formal reports within required timeframes.
Maintain and troubleshoot Oracle GoldenGate replication, including lag, connectivity, missing records, transaction consistency, failover, and recovery between PRISM and OBIWAN-related environments.
Implement and validate Oracle Recovery Manager (RMAN) backup, restoration, recovery, control-file, archive-log, and disaster-recovery procedures; routinely test recoverability and remediate backup failures.
Monitor and tune CPU, memory, I/O, sessions, waits, queries, indexes, execution plans, redo logs, tablespaces, jobs, and workload patterns using Oracle Enterprise Manager, AWR, and other approved tools.
Support Oracle Exadata X9 and database-related infrastructure activities, including migrations, patching, service requests, capacity planning, diagnostics, and coordination with infrastructure or Oracle support personnel.
Maintain accurate database architecture diagrams, schema and interface documentation, data dictionaries, operational procedures, reconciliation instructions, remediation records, configuration baselines, and runbooks.
Apply database security patches, secure configurations, least-privilege controls, and remediation actions; support scans, audits, ATO sustainment, POA&M activities, evidence collection, and FAA security coordination.
Coordinate with the Oracle Analytics Developer to ensure physical schemas, logical models, presentation-layer objects, and reporting calculations remain synchronized and accurate.
Provide Tier 3 database and integration support, participate in production releases and maintenance windows, contribute to monthly reporting, and cross-train backup personnel.

Required Technical and Professional Competencies

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.

Minimum Education and Experience

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.

Certifications

No certification is contractually mandated. Oracle Database, ODI, GoldenGate, Exadata, Linux, Security+, or comparable technical certifications are preferred when supported by relevant experience.

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.

Skills

Oracle Data Integrator

Oracle GoldenGate

RMAN

performance tuning

Oracle Enterprise Manager

Oracle Database 19c

SQL/PLSQL

Exadata X9

Ready to Apply?

Join Professional Solutions 1 LLC today

Posted 2 months ago

More Data roles you might like

Discover similar opportunities from companies that are also hiring remotely.

QA Analyst

Brightscout

Full Time

15 hours ago

The Role As a Quality Assurance Analyst at BRIGHTSCOUT, you will play a crucial role in ensuring the quality and flawless execution of our digital experiences—across both websites and applications.

Argentina

Data

Data Science

Mid

Quality Assurance

Functional Testing

Visual Testing

+5 more

Operations Analyst (Finance)

Able

Full Time

17 hours ago

Back in 2012, we were a group of engineers and designers who decided we wanted to build things, so we did. Able started as an engineering and product hub building for a portfolio of early-stage startups.

Worldwide

Data

Data Science

Senior

Finance Operations

Financial Analysis

Expense Management

+5 more

Explore more remote openings

Browse fresh listings from our global community of remote-friendly teams.

Appointment Setter (Telesales, Freelance, Remote)

In Marketing We Trust

Contract

14 hours ago

What In Marketing We Trust is all about We're a technical performance marketing agency, and we exist to solve tough problems in marketing. We bring an engineering mindset to complex marketing situations to deliver scalable performance that generates an exponential return on investment.

Australia

Sales

Account Executive

Mid

Telesales

Lead Qualification

Appointment-setting

+5 more

Appointment Setter (Telesales, Freelance, Remote)

In Marketing We Trust

Contract

14 hours ago

Australia

Sales

Account Executive

Mid

Telesales

Lead Qualification

Appointment-setting

+5 more

Consultor Oracle Fusion SCM / PLM - Bilingüe Remoto

Towa

Full Time

15 hours ago

📍 Modalidad: Remoto | 🇲🇽 Vacante exclusiva para residentes mexicanos 🗣️ Inglés: Conversacional avanzado indispensable 🕐 Horario: 1:00 PM a 8:00 PM PST (horario de California) 💰 Esquema de contratación: Honorarios 🚀 Sobre la posición Buscamos una persona para la posición de Consultor(a)…

Mexico

Engineering

Backend Engineering

Senior

Oracle Fusion Cloud SCM

Supply Chain Management

Product Lifecycle Management

+5 more

Senior Webflow Developer

Brightscout

Full Time

15 hours ago

The Role As a Senior Webflow Developer at BRIGHTSCOUT , you will own the architecture and implementation of complex Webflow websites for B2B tech companies.

Argentina

Engineering

Backend Engineering

Senior

Webflow

HTML

CSS

+5 more

Assistant Team Leader - FCM After Hours

Flight Centre

Full Time

15 hours ago

  About the Opportunity Join Corporate After Hours and play a key leadership role supporting operational excellence across a 24/7 environment.   As an Assistant Team Leader, you'll work closely with Team Leaders to deliver exceptional service outcomes, support team performance, and foster…

Worldwide

Engineering

Backend Engineering

Mid

Leadership

Operational Excellence

Customer Service

+5 more

Revenue Operations Specialist (Toronto, Canada)

Fortive

Full Time

15 hours ago

Revenue Operations Specialist Position Overview The Revenue Operations Specialist plays a key role in supporting Intelex's Quote-to-Cash (QTC) process by partnering with Sales, Renewals, Finance, Billing, Legal, and other cross-functional teams.

Canada

Operations

Mid

Revenue Operations

Sales Operations

Salesforce

+5 more

Sales Manager Filtration Africa & Nordics

Imerys

Full Time

15 hours ago

The Company Imerys is the world’s leading supplier of mineral-based specialty solutions for the industry with €3.4 billion in revenue and 12,300 employees in 40 countries in 2025.

France

Sales

Account Executive

Senior

Sales Management

Strategic Account Planning

Commercial negotiation

+5 more

Program Manager

Shuru Technologies Private Limited

Full Time

15 hours ago

This is a remote position. Shuru is a self-managed technology team specializing in accelerating visions through product, technology, and AI leadership. With a focus on bespoke execution, we deliver impactful solutions that are scalable and designed for success.

Worldwide

Operations

Mid

Scrum

Agile

Jira

+5 more

Candidate Manager, Fixed Term (6 months)

InstantScripts

Contract

AUD 70k - AUD 80k

15 hours ago

Company Description At InstantScripts, we believe healthcare should be accessible, flexible, and driven by excellence. As Australia's leading online medical services provider, we are reshaping how patients access care, and that starts with building an exceptional clinical workforce.

Australia

Engineering

Backend Engineering

Mid

Recruitment

Candidate Management

Credentialing

+5 more

DevOps Support Engineer

Buildkite

Full Time

15 hours ago

About Buildkite Buildkite's CI platform is trusted by the world's leading engineering teams, helping ship software used by more than 1 billion people every day.

United Kingdom

Ireland

Poland

Engineering

DevOps / SRE

Senior

Bash

Ruby on Rails

Golang

+5 more

Senior Customer Advocate (English & German)

Boldr

Full Time

15 hours ago

A LITTLE BIT ABOUT Boldr • Boldr is the first global B-Corp dedicated to delivering world-class Client experiences while creating access to dignified, meaningful work in communities worldwide. • We are a global team, united by our desire to connect diverse people with common values for boldr impact.

Mexico

Engineering

Backend Engineering

Mid

Customer Service

Email Support

Chat support

+5 more

Customer Support Specialist

Pearl Certification

Full Time

$55k - $65k

16 hours ago

About the role The Customer Support Specialist handles front line customer requests and the operational data work that keeps Pearl’s certification and reporting pipeline running.

United States

Customer Success

Customer Success Management

Entry

Customer Support

Data Processing

Ticket Management

+5 more