Sr. Oracle Database Engineer; Development & Administration Job Frederick area,Maryland USA,IT/Tech

Position: Sr. Oracle Database Engineer (Development & Administration)

Annapolis Junction, MD

We are seeking a Senior Oracle Database Engineer with 10+ years of experience developing, troubleshooting, and supporting enterprise-scale Oracle database applications. This position is primarily focused on hands‑on SQL and PL/SQL development, production debugging, script remediation, ad hoc data analysis, and the maintenance of data feeds and integration endpoints.

The ideal candidate has expertise in Oracle SQL and PL/SQL, along with complementary database administration skills that support effective production troubleshooting, performance tuning, deployment, recovery, and collaboration with DBA and infrastructure teams.

Responsibilities

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 DBAs on database configuration, RAC, recovery, Data Guard, security, performance, and environment‑related issues
Create and maintain technical documentation, support procedures, deployment instructions, troubleshooting guides, and operational runbooks

Requirements

TS/SCI FSP Clearance
10+ years of experience developing and supporting enterprise solutions using Oracle Database, including Oracle 10g through current versions
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
Demonstrated ability:
- Analyze existing database code and business logic
- Identify defects, data issues, and performance bottlenecks
- Rewrite, refactor, and optimize existing scripts
- Develop and maintain operational and production‑support scripts
- Create 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, interfaces, and endpoints
- APIs and service‑based integrations
- File‑based data transfers and batch interfaces
- Upstream and downstream application dependencies
- Data validation, reconciliation, exception handling, and feed monitoring
Experience diagnosing data‑feed and integration failures by tracing issues 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 such…