Senior Oracle Database Engineer Job Annapolis area,Maryland USA,Software Development

BT-382 - Senior Oracle Database Engineer

Location:

Annapolis Junction, MD (fully on-site, no remote option)

** MUST HAVE A TS/SCI POLY CLEARANCE TO APPLY. Those without a TS/SCI Poly clearance will not be considered.**

BT-382 - Senior Oracle Database Engineer

Location:

Annapolis Junction, MD (fully on-site, no remote option)

Bespoke Technologies is 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.

Required Skills

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 to:
- Analyze existing database code and business logic.
- Identify defects, data issues, and performance bottlenecks.
- Rewrite, refactor, and optimise 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, optimiser statistics, indexing, partitioning, query optimisation, locking, concurrency, and wait‑event analysis.
Experience using Oracle diagnostic and performance tools such as AWR, ASH, ADDM, SQL Trace, TKPROF, and Oracle Enterprise Manager Cloud Control.
Experience supporting high‑volume data processing, batch jobs, ETL workflows, data conversion, data migration, and data‑reconciliation processes.
Working knowledge of database application design, data modelling, schema development, and database object management sufficient to maintain and enhance scalable, reliable database solutions.
Experience deploying SQL, PL/SQL, schema, and configuration changes through structured development, testing, validation, and production‑release processes.
Familiarity with source control, code review, release documentation, rollback planning, and automated or repeatable database deployment practices.
Complementary Oracle database administration experience, including working knowledge of:
- Oracle RAC.
- RMAN backup and recovery.
- Oracle Data Guard.
- Database security, roles, privileges, and auditing.
- Table spaces, storage, sessions, locks, and database‑object management.
- Production monitoring, incident troubleshooting, and recovery procedures.

Primary Responsibilities

Debug and resolve complex SQL, PL/SQL, data, and…