Oracle Database Engineer

Red Arch Solutions

Fort Meade (MD)

Sur place

USD 190 000 - 220 000

Plein temps

14 jours+

Une candidature complète en une minute

Un CV et une lettre de motivation personnalisés, prêts à envoyer.

Passez les filtres ATS

Résumé du poste

Red Arch Solutions seeks a Senior Oracle Database Engineer with 10+ years of experience to develop, troubleshoot, and support enterprise Oracle database applications. The role is hands-on with SQL and PL/SQL, production debugging, script remediation, ad hoc data analysis, and maintaining data feeds and integration endpoints.

The ideal candidate has deep Oracle SQL/PL/SQL knowledge, experience with RAC, Data Guard, RMAN, and related tools, and can collaborate with DBA, infrastructure, and

Qualifications

  • 10+ years of experience with Oracle Database in enterprise environments.
  • Advanced expertise in Oracle SQL and PL/SQL, including packages, procedures, functions, triggers, views, and more.
  • Active CompTIA Security+ certification.
  • Experience with Oracle Exadata, Database Vault, and Label Security.
  • Ability to coordinate with developers, DBAs, and infrastructure teams.
  • TS/SCI w/ polygraph required.

Responsabilités

  • Debug and resolve complex SQL/PLSQL and production issues.
  • Review, rewrite, and optimize SQL and PL/SQL scripts.
  • Develop ad hoc queries for investigations, reporting, reconciliation, and data correction.
  • Maintain PL/SQL packages, procedures, functions, triggers, and interfaces.
  • Monitor data feeds involving Oracle, NiFi, AWS endpoints, APIs, files, and connected apps.
  • Coordinate resolution across database, integration, application, and infra teams.

Connaissances

Oracle SQL/PLSQL
Production debugging
Data analysis
Cross-functional collaboration
Independent, detail-oriented

Formation

Bachelor's degree in Computer Science/IT or related field

Outils

Oracle Exadata
Database Vault
Label Security
Oracle RAC
RMAN
Data Guard
Oracle diagnostic tools (AWR/ASH/ADDM/TKPROF)

Description du poste

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:
  • 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/ polygraphrequired
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:
    • 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

Obtenez votre examen gratuit et confidentiel de votre CV.

ou faites glisser et déposez votre fichier ici.

Similar jobs

Postes similaires à comparer

Oracle Database Engineer
Oracle Database Engineer

Red Arch Solutions, Inc. • Fort Meade (MD)

Sur place
USD 190 000 - 220 000
100% paid employee healthcare premiums
HaloScripts Concierge prescription Med
Generous PTO
+8
Oracle Database Engineer
Oracle Database Engineer

Red Arch Solutions, Inc. • Maryland

Hybride
USD 190 000 - 220 000
100% paid employee healthcare premiums
HaloScripts Concierge service
Generous PTO
+1
Sr. Oracle Database Engineer (Development & Administration)
Sr. Oracle Database Engineer (Development & Administration)

NewGen Technologies • Annapolis (MD)

Sur place
USD 150 000 - 200 000
Sr. Oracle Database Engineer (Development & Administration)
Sr. Oracle Database Engineer (Development & Administration)

NewGen Technologies • Maryland

Sur place
USD 140 000 - 190 000
Senior Oracle DB Engineer | Data-Driven, Performance Expert
Senior Oracle DB Engineer | Data-Driven, Performance Expert

Red Arch Solutions, Inc. • Fort Meade (MD)

Sur place
USD 190 000 - 220 000
100% paid employee healthcare premiums
HaloScripts Concierge prescription Med
Generous PTO
+8
Senior Oracle DB Engineer: Performance & Data Integration
Senior Oracle DB Engineer: Performance & Data Integration

Red Arch Solutions • Fort Meade (MD)

Sur place
USD 190 000 - 220 000
Senior Oracle DB Engineer – TS/SCI Clearance
Senior Oracle DB Engineer – TS/SCI Clearance

Red Arch Solutions, Inc. • Maryland

Hybride
USD 190 000 - 220 000
100% paid employee healthcare premiums
HaloScripts Concierge service
Generous PTO
+1
Senior Database Administrator & Ops Engineer
Senior Database Administrator & Ops Engineer

RedIron Technologies Inc. • Groton (MA)

À distance
USD 95 000 - 120 000
Cleared Senior Oracle Database Engineer
Cleared Senior Oracle Database Engineer

Azusa Solutions LLC • Maryland

Hybride
USD 140 000 - 190 000
Paid time off
Health benefits
401(k) match
+1
Senior Oracle Database Engineer (Development & Administration)
Senior Oracle Database Engineer (Development & Administration)

Piper Companies • Fort Meade (MD)

Sur place
USD 120 000 - 220 000