Senior Oracle Database Engineer; Development & Administration

Piper Companies is seeking a Senior Oracle Database Engineer (Development & Administration) to join a highly secure government contracting environment supporting enterprise-scale Oracle database platforms and mission-critical data integrations.

The Senior Oracle Database Engineer (Development & Administration) will serve as a hands-on technical expert focused on Oracle SQL and PL/SQL development, production support, performance tuning, data-feed troubleshooting, and database administration within complex enterprise environments.

• Debug and resolve complex SQL, PL/SQL, data integrity, and production-processing issues across multiple environments.
• Review, rewrite, refactor, and optimize existing SQL and PL/SQL code to improve maintainability and performance.
• Develop ad hoc queries and scripts for reporting, reconciliation, data analysis, investigations, and operational support requests.
• Maintain and enhance Oracle packages, procedures, functions, triggers, batch jobs, and database interfaces.
• Monitor and support enterprise data feeds involving Oracle databases, Apache NiFi, AWS services, APIs, file transfers, and connected applications.
• Troubleshoot failed integrations and data-processing workflows while coordinating with application, infrastructure, and database teams.
• Perform root-cause analysis and data validation activities to identify and resolve discrepancies between source and target systems.
• Support database deployments, production releases, incident response activities, and post-deployment validation efforts.
• Analyze and tune SQL and PL/SQL workloads using Oracle performance tools and best practices.
• Partner with DBA teams to support Oracle RAC, Data Guard, backup and recovery operations, security, monitoring, and performance optimization.
• Create and maintain technical documentation, deployment procedures, operational runbooks, and troubleshooting guides.

• 10+ years of experience developing and supporting enterprise solutions utilizing Oracle Database.
• Advanced expertise in Oracle SQL and PL/SQL, including packages, procedures, functions, triggers, materialized views, dynamic SQL, collections, bulk processing, and exception handling.
• Extensive experience troubleshooting and debugging complex database applications in development, testing, and production environments.
• Strong knowledge of SQL and PL/SQL performance tuning, execution-plan analysis, indexing strategies, partitioning, optimizer statistics, concurrency management, and wait-event analysis.
• Hands-on experience with Oracle diagnostic and performance tools including AWR, ASH, ADDM, SQL Trace, TKPROF, and Oracle Enterprise Manager Cloud Control.
• Experience supporting Apache NiFi data flows, AWS integrations, APIs, file-based interfaces, and enterprise data-feed monitoring.
• Working knowledge of Oracle RAC, RMAN backup and recovery, Oracle Data Guard, database security, auditing, and database-object management.
• Experience with source control, release management processes, code reviews, deployment planning, and rollback procedures.
• Bachelor's degree in Computer Science, Information Technology, or a related field, or equivalent professional experience.
• Active CompTIA Security+ certification required.
• Experience with Oracle Exadata, Database Vault, Label Security, and large-scale data migration is highly desirable.
• Active TS/SCI with Full Scope Polygraph (FSP) clearance required.

• Salary range: $120,000 - $220,000
• Comprehensive benefits package including medical, dental, vision, 401(k), and PTO

This job opens for applications on 10/28/2026. Applications for this job will be accepted for at least 30 days from the posting date.