Maryland jobs

Oracle Database Engineer

Red Arch SolutionsFt Meade, MDFull-timeFirst seen 20 days ago

$190k–$220k/yr listed by the employer

Key facts

Experience
10+ years
Degree
Bachelor's degree or equivalent
Clearance
TS SCI clearance required

Strong: looks real and checked open today.

On Red Arch Solutions’ own careers site (JazzHR).

  • Checked: On the company's own careers siteJazzHR board
  • Checked: Checked open todayJazzHR board
  • Checked: Pay listedJob posting
  • Checked: No reposts foundJazzHR board
  • Trust score 100 / 100 · Strong
See all 5 checksShow fewer
How we check

What you’ll do

  • Debug and resolve SQL, PL/SQL, data, and production-processing issues; refactor and tune scripts and workloads.
  • Maintain PL/SQL database objects, batch jobs, operational scripts, and interfaces; create queries for investigations, reporting, reconciliation, and operational needs.
  • Monitor and troubleshoot data feeds across Oracle, NiFi, AWS endpoints, APIs, files, and connected applications, coordinating issue resolution across teams.
  • Validate data, investigate source-to-target discrepancies, and support releases, database deployments, production incidents, and post-deployment checks.

Summarised from the posting by AI and can be wrong. The full description is the source.

Requirements

Licenses and certifications

  • Active CompTIA Security+ certification

Experience

  • 10+ years of experience developing and supporting enterprise solutions using Oracle Database, including Oracle 10g through current versions
  • Extensive experience debugging and troubleshooting complex SQL and PL/SQL code in development, test, and production environments
  • Ability to analyze database code and business logic, identify defects, data issues and performance bottlenecks, and rewrite, refactor, and optimize scripts
  • Experience developing and maintaining operational and production-support scripts and creating ad hoc queries for analysis, reporting, reconciliation, validation, and issue resolution
  • Strong experience maintaining and supporting data feeds and system integrations, including Apache NiFi, AWS services and endpoints, APIs, file transfers, batch interfaces, and application dependencies
  • Experience with data validation, reconciliation, exception handling, and feed monitoring
  • Experience diagnosing data-feed and integration failures across database objects, PL/SQL processes, NiFi flows, AWS endpoints, files, APIs, and dependent systems
  • Experience using Oracle diagnostic and performance tools including AWR, ASH, ADDM, SQL Trace, TKPROF, and Oracle Enterprise Manager Cloud Control
  • Experience supporting high-volume data processing, batch jobs, ETL workflows, data conversion, data migration, and data-reconciliation processes
  • Experience with Oracle Exadata, Database Vault, Label Security, and large-scale data migration (preferred)

Education

  • Bachelor’s degree in Computer Science, Information Technology, or a related field, or an equivalent combination of education and professional experience

Skills

  • Advanced expertise in Oracle SQL and PL/SQL, including packages, procedures, functions, triggers, views, materialized views, dynamic SQL, collections, bulk processing, exception handling, and database
  • Strong knowledge of SQL and PL/SQL performance tuning, including execution-plan analysis, optimizer statistics, indexing, partitioning, query optimization, locking, concurrency, and wait-event análise
  • Working knowledge of database application design, data modeling, schema development, and database object management

Other requirements

  • TS/SCI with polygraph

Your match

Sign in and add your resume to see which of this job's requirements it shows.

Sign in to check your match

Saved to your account, encrypted. The AI that reads it doesn't keep it or train on it.

Full job description

From Red Arch Solutions’ careers site

Red Arch Solutions is seeking a Senior Oracle Database Engineer with 10+ years of experience developing, troubleshooting, and supporting enterprise-scale Oracle database applications. This position is primarily focused on hands-on SQL and PL/SQL development, production debugging, script remediation, ad hoc data analysis, and the maintenance of data feeds and integration endpoints. The ideal candidate has expertise in Oracle SQL and PL/SQL, along with complementary database administration skills that support effective production troubleshooting, performance tuning, deployment, recovery, and collaboration with DBA and infrastructure teams.

Basic Qualifications:

Show full descriptionShow less
  • 10+ years of experience developing and supporting enterprise solutions using Oracle Database.
  • Bachelor’s degree in Computer Science, Information Technology, or a related field, or an equivalent combination of education and professional experience.
  • Active CompTIA Security+ certification
  • Experience with Oracle Exadata, Database Vault, Label Security, and large-scale data migration is highly desirable.
  • Ability to work effectively with developers, database administrators, application owners, business analysts, infrastructure teams, and upstream and downstream integration partners.
  • Must be an independent, analytical, and detail-oriented contributor with strong written and verbal communication skills and the ability to manage production issues and competing priorities.
  • TS/SCI w/ polygraph required.

Required Skills:

  • 10+ years of experience developing and supporting enterprise solutions using Oracle Database, including Oracle 10g through current versions.
  • Advanced expertise in Oracle SQL and PL/SQL, including packages, procedures, functions, triggers, views, materialized views, dynamic SQL, collections, bulk processing, exception handling, and database APIs.
  • Extensive experience debugging and troubleshooting complex SQL and PL/SQL code in development, test, and production environments.
  • Demonstrated ability to:
  • Analyze existing database code and business logic.
  • Identify defects, data issues, and performance bottlenecks.
  • Rewrite, refactor, and optimize existing scripts.
  • Develop and maintain operational and production-support scripts.
  • Create ad hoc queries for data analysis, reporting, reconciliation, validation, and issue resolution.
  • Strong experience maintaining and supporting data feeds and system integrations, including:
  • Apache NiFi data flows and endpoints.
  • AWS services, interfaces, and endpoints.
  • APIs and service-based integrations.
  • File-based data transfers and batch interfaces.
  • Upstream and downstream application dependencies.
  • Data validation, reconciliation, exception handling, and feed monitoring.
  • Experience diagnosing data-feed and integration failures by tracing issues across database objects, PL/SQL processes, NiFi flows, AWS endpoints, files, APIs, and dependent systems.
  • Strong knowledge of SQL and PL/SQL performance tuning, including execution-plan analysis, optimizer statistics, indexing, partitioning, query optimization, locking, concurrency, and wait-event analysis.
  • Experience using Oracle diagnostic and performance tools such as AWR, ASH, ADDM, SQL Trace, TKPROF, and Oracle Enterprise Manager Cloud Control.
  • Experience supporting high-volume data processing, batch jobs, ETL workflows, data conversion, data migration, and data-reconciliation processes.
  • Working knowledge of database application design, data modeling, schema development, and database object management sufficient to maintain and enhance scalable, reliable database solutions.
  • Experience deploying SQL, PL/SQL, schema, and configuration changes through structured development, testing, validation, and production-release processes.
  • Familiarity with source control, code review, release documentation, rollback planning, and automated or repeatable database deployment practices.
  • Complementary Oracle database administration experience, including working knowledge of:
  • Oracle RAC.
  • RMAN backup and recovery.
  • Oracle Data Guard.
  • Database security, roles, privileges, and auditing.
  • Tablespaces, storage, sessions, locks, and database-object management.
  • Production monitoring, incident troubleshooting, and recovery procedures.

Primary Responsibilities:

  • Debug and resolve complex SQL, PL/SQL, data, and production-processing issues.
  • Review, rewrite, refactor, and optimize existing SQL and PL/SQL scripts.
  • Develop ad hoc queries and scripts to support investigations, reporting, reconciliation, data correction, and operational requests.
  • Maintain and enhance PL/SQL packages, procedures, functions, triggers, batch jobs, and database interfaces.
  • Monitor, troubleshoot, and maintain data feeds involving Oracle, Apache NiFi, AWS endpoints, APIs, files, and connected applications.
  • Investigate failed or incomplete data flows and coordinate resolution across database, integration, application, and infrastructure teams.
  • Perform data validation and root-cause analysis to identify discrepancies between source and target systems.
  • Support application releases, database deployments, production incidents, and post-deployment validation.
  • Tune SQL and PL/SQL workloads to improve performance, scalability, and reliability.
  • Partner with Oracle DBAs on database configuration, RAC, recovery, Data Guard, security, performance, and environment-related issues.
  • Create and maintain technical documentation, support procedures, deployment instructions, troubleshooting guides, and operational runbooks.

Salary range for this position: $190,000-$220,000 #CJ

Something wrong with this job? Report it

Similar jobs

Software Engineer

Red Arch Solutions · Annapolis Junction, MD

$185k–$200k/yrFull-time

StrongChecked open todayPosted 10 days ago

Test Engineer

Red Arch Solutions · Annapolis Junction, MD

$160k–$180k/yrFull-time

StrongChecked open todayPosted 17 days ago

Database Administrator

Red Arch Solutions · Ft Meade, MD

$180k–$238k/yrFull-time

StrongChecked open todayPosted 20 days ago

Process Engineer

Red Arch Solutions · Annapolis Junction, MD

$130k–$140k/yrFull-time

StrongChecked open todayPosted 20 days ago

System Engineer

Red Arch Solutions · Annapolis Junction, MD

Full-time

Looks goodPay not listedChecked open todayPosted 2 days ago

Senior Software Engineer

Red Arch Solutions · Annapolis Junction, MD

$200k–$215k/yrFull-time

StrongChecked open todayPosted 20 days ago

See more like this