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.

Responsibilities of the Senior Oracle Database Engineer (Development & Administration):

• 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