Senior Oracle Database Engineer

• 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., 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.

• Salary Range: $120,000 - $220,000/year
• Comprehensive Benefits: Medical, Dental, Vision, 401(k), PTO, paid holidays, and additional benefit offerings.

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.