Quick overview
Job description
Piper Companies is seeking a Senior Oracle Database Engineer to join a growing government-focused technology team for an onsite contract opportunity in Fort Meade, MD. The Senior Oracle Database Engineer will be responsible for developing, troubleshooting, optimizing, and supporting enterprise-scale Oracle database applications while maintaining critical data feeds, integrations, and production environments. This role requires a highly technical contributor with deep expertise in Oracle SQL, PL/SQL, performance tuning, and production support within secure enterprise environments. 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.
- 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.
- 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
Keywords: Oracle Database Engineer, Oracle DBA, Oracle SQL, PL/SQL, Oracle RAC, Data Guard, RMAN, Oracle Exadata, Database Vault, Label Security, Apache NiFi, AWS, ETL, Data Integration, Enterprise Database Development, Database Performance Tuning, SQL Optimization, Production Support, Database Migration, Oracle Enterprise Manager, AWR, ASH, ADDM, TS/SCI, Full Scope Polygraph, Security+, Government Contracting. #LI-KI1 #LI-ONSITE
Similar jobs
- RA

Senior Systems Engineer - Requirements Development/Requirements Management (Onsite)Recently posted
Raytheon · Albuquerque, NM · Hybrid 🇺🇸
AgileTechnology$86.8k - $165.2k/yr - RA

Senior Systems EngineerRecently posted
Raytheon · Houston, TX · Hybrid 🇺🇸
AssemblyAgileTechnology$86.8k - $165.2k/yr - RA

Software Engineer I - (Onsite)Recently posted
Raytheon · Orlando, FL · On-site 🇺🇸
C#C++Technology$62.9k - $119.7k/yr - RH

Sr. Software EngineerRecently posted
Robert Half · Peoria, AZ · Hybrid 🇺🇸
GitEmbedded SystemsTechnologySalary not listed - TE

Engineer, CPU Performance VerificationRecently posted Auto Apply
Tenstorrent · Austin · Hybrid 🇺🇸
ComplianceC++Python+1Engineering$100k - $500k/yr - AD

Software Engineer, Anti-AdblockRecently posted
Ad-Shield · Mundelein, Illinois · On-site 🇺🇸
Edge ComputingCloudflareHTTP+2TechnologySalary not listed - RA

Senior Embedded Software EngineerRecently posted
Raytheon · Tucson, Arizona · Hybrid 🇺🇸
FPGARoboticsAssembly+6Technology$86.8k - $165.2k/yr - RE

Staff Software EngineerRecently posted
Refactor. · New York · Hybrid 🇺🇸
LLMRAGTechnology$220k - $240k/yr - DA
Data Software Engineer - AI TrainerRecently posted
DataAnnotation · San Mateo, California · Hybrid 🇺🇸
SwiftC#C+++8Technology$50 - $100/hr - IN
Staff Software Engineer - Event-Driven ArchitectureRecently posted
Intellibus · Newark, New Jersey · Hybrid 🇺🇸
DockerMicroservicesNestJS+14Technology$75 - $85/hr - GR

Senior Software Engineer - Directed EnergyRecently posted Auto Apply
GRVTY · Albuquerque · Hybrid 🇺🇸
C#EEOCSEMTechnologySalary not listed - GR

Software Engineer - Directed EnergyRecently posted Auto Apply
GRVTY · Albuquerque · Hybrid 🇺🇸
C#EEOCSEMTechnologySalary not listed
