Senior Oracle Database Engineer - PL​/SQL

Job Description

Quevera is seeking a highly skilled

Quevera is seeking a highly skilled Senior Oracle Database Engineer - PL/SQL with an active TS/SCI clearance with Polygraph to support mission-critical programs in Annapolis Junction, Maryland
. In this role, you will develop, troubleshoot, and support enterprise-scale Oracle database applications with a primary focus on hands-on SQL and PL/SQL development, production debugging, script remediation, ad hoc data analysis, and maintenance of data feeds and integration endpoints. Working with developers, database administrators, application owners, business analysts, infrastructure teams, and integration partners, you will troubleshoot production issues, optimize SQL and PL/SQL workloads, maintain database interfaces and data feeds, and support database deployments and application releases.

• Debug and resolve complex SQL, PL/SQL, data, and production-processing issues.
• Review, rewrite, refactor, and optimize existing SQL and PL/SQL scripts.
• Develop ad hoc queries and scripts to support investigations, reporting, reconciliation, data correction, and operational requests.
• Maintain and enhance PL/SQL packages, procedures, functions, triggers, batch jobs, and database interfaces.
• Monitor, troubleshoot, and maintain data feeds involving Oracle, Apache NiFi, AWS endpoints, APIs, files, and connected applications.
• Investigate failed or incomplete data flows and coordinate resolution across database, integration, application, and infrastructure teams.
• Perform data validation and root-cause analysis to identify discrepancies between source and target systems.
• Support application releases, database deployments, production incidents, and post-deployment validation.
• Tune SQL and PL/SQL workloads to improve performance, scalability, and reliability.
• Partner with Oracle Database Administrators on database configuration, Oracle RAC, recovery, Data Guard, security, performance, and environment-related issues.
• Create and maintain technical documentation, support procedures, deployment instructions, troubleshooting guides, and operational runbooks.

• Active TS/SCI clearance with Polygraph required.
• Ten (10) or more years of experience developing and supporting enterprise solutions using Oracle Database, including Oracle 10g through current versions.
• Bachelor’s degree in Computer Science, Information Technology, or a related field, or an equivalent combination of education and professional experience.
• Advanced expertise in Oracle SQL and PL/SQL, including packages, procedures, functions, triggers, views, materialized views, dynamic SQL, collections, bulk processing, exception handling, and database APIs.
• Extensive experience debugging and troubleshooting complex SQL and PL/SQL code in development, test, and production environments.
• Experience analyzing existing database code and business logic, identifying defects, data issues, and performance bottlenecks, and rewriting, refactoring, and optimizing existing scripts.
• Experience developing and maintaining operational and production-support scripts.
• Experience creating ad hoc queries for data analysis, reporting, reconciliation, validation, and issue resolution.
• Strong experience maintaining and supporting data feeds and system integrations, including Apache NiFi data flows and endpoints, AWS services and endpoints, APIs and service-based integrations, file-based data transfers, batch interfaces, and upstream and downstream application dependencies.
• Experience with data validation, reconciliation, exception handling, and feed monitoring.
• Experience diagnosing data-feed and integration failures across database objects, PL/SQL processes, NiFi flows, AWS endpoints, files, APIs, and dependent systems.
• Strong knowledge of SQL and PL/SQL performance tuning, including execution-plan analysis, optimizer statistics, indexing, partitioning, query optimization, locking, concurrency, and wait-event analysis.
• Experience using Oracle diagnostic and performance tools, including AWR, ASH, ADDM, SQL Trace, TKPROF, and Oracle Enterprise Manager Cloud Control.
• Experience supporting high-volume data…