Senior Oracle Database Engineer

Zp Group Llc
  • MD
  • $120,000–$220,000 Per Year
2 days ago

Job Description

Responsibilities: of the Senior Oracle Database Engineer include: Debug and resolve complex SQL, PL/SQL, data-processing, and production issues across development, test, and production environments. Review, rewrite, refactor, and optimize existing SQL and PL/SQL code to improve performance, scalability, and reliability. Develop ad hoc queries and scripts to support investigations, reporting, data validation, reconciliation, and operational requests. Develop and maintain PL/SQL packages, procedures, functions, triggers, batch jobs, and database interfaces. Monitor, troubleshoot, and maintain data feeds and integrations involving Oracle databases, Apache NiFi, AWS services, APIs, files, and connected applications. Investigate failed or incomplete data flows, identify root causes, and coordinate resolution across application, infrastructure, database, and integration teams. Perform SQL and PL/SQL performance tuning using execution plans, indexing strategies, partitioning, optimizer statistics, and Oracle performance tools. Support database deployments, production releases, incident response activities, and post-deployment validation efforts. Partner with Oracle DBAs on RAC, Data Guard, security, recovery, performance, and environment-related initiatives. Create and maintain technical documentation, deployment procedures, troubleshooting guides, and operational runbooks. Qualifications: for the Senior Oracle Database Engineer include: 7+ years of experience developing and supporting enterprise solutions using Oracle Database. Advanced expertise in Oracle SQL and PL/SQL, including packages, procedures, functions, triggers, views, materialized views, dynamic SQL, collections, exception handling, and bulk processing. Extensive experience troubleshooting and debugging SQL and PL/SQL applications in production environments. Experience analyzing existing database code, identifying defects, and optimizing database performance. Strong experience supporting data integrations, APIs, file transfers, batch processing, ETL workflows, and enterprise data feeds. Experience with Apache NiFi, AWS services, and service-based integrations. Strong understanding of Oracle performance tuning, execution-plan analysis, indexing, partitioning, locking, concurrency, and optimizer behavior. Experience utilizing Oracle performance and diagnostic tools including AWR, ASH, ADDM, SQL Trace, TKPROF, and Oracle Enterprise Manager. Working knowledge of Oracle RAC, RMAN backup and recovery, Data Guard, database security, auditing, and production support procedures. Active CompTIA Security+ Certification required. Bachelor's degree in Computer Science, Information Technology, or a related field, or equivalent professional experience. Ability to collaborate effectively with developers, DBAs, business analysts, infrastructure teams, application owners, and integration partners. Experience with Oracle Exadata, Database Vault, Label Security, and large-scale data migration is highly preferred. TS/SCI with Full Scope Polygraph (FSP) required. Compensation: for the Senior Oracle Database Engineer: Salary Range: $120,000 - $220,000/year Comprehensive Benefits: Medical, Dental, Vision, 401(k), PTO, paid holidays, and additional benefit offerings. Work Environment: 100% Onsite Fort Meade, MD 5 Days per Week Onsite W2 Contract Opportunity This job opens for applications on 11/2/26. Applications for this job will be accepted for at least 30 days from the posting date.

Numbers & Facts

LocationMD
Salary$120,000–$220,000 Per Year

Skills

  • Amazon Web Services (AWS)unmatched
  • Analysis Skillsunmatched
  • Apacheunmatched
  • Application Integrationunmatched
  • Application Programming Interface (API)unmatched
  • Business Analysisunmatched
  • CompTIA Security+unmatched
  • Computer Scienceunmatched
  • Concurrencyunmatched
  • Data Migrationunmatched
  • Data Qualityunmatched
  • Data Recoveryunmatched
  • Database Analysisunmatched
  • Database Extract Transform and Load (ETL)unmatched
  • Database Optimizationunmatched
  • Database Programmingunmatched
  • Database Triggersunmatched
  • Debugging Skillsunmatched
  • Editingunmatched
  • Error Handlingunmatched
  • Full Scope Polygraphunmatched
  • Identify Issuesunmatched
  • Incident Responseunmatched
  • Information Technology & Information Systemsunmatched
  • Information/Data Security (InfoSec)unmatched
  • Operations Planningunmatched
  • Oracleunmatched
  • Oracle Databaseunmatched
  • Oracle Enterprise Managerunmatched
  • Oracle PL-SQLunmatched
  • Oracle RAC (Real Application Clusters)unmatched
  • Performance Managementunmatched
  • Performance Tuning/Optimizationunmatched
  • Production Supportunmatched
  • Production Systemsunmatched
  • RMANunmatched
  • Reconciliationunmatched
  • Refactoringunmatched
  • Root Cause Analysisunmatched
  • SQL (Structured Query Language)unmatched
  • Scripting (Scripting Languages)unmatched
  • Security Auditingunmatched
  • Sensitive Compartmented Information (SCI)unmatched
  • Statisticsunmatched
  • Team Playerunmatched
  • Technical Writingunmatched
  • Test Plan/Scheduleunmatched
  • Top Secret Clearanceunmatched

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Resume Builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Resume Builder