Sr. Oracle Database Engineer (Development & Administration)
On-siteAnnapolis Junction, Maryland, United States
Job Summary
Debug and resolve complex SQL, PL/SQL, data, and production-processing issues while reviewing, rewriting, and optimizing existing scripts. Develop ad hoc queries for investigations, reporting, reconciliation, and operational requests, then 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, and connected applications, investigating failed flows and coordinating resolution across database, integration, application, and infrastructure teams. Perform data validation and root-cause analysis to identify discrepancies between source and target systems, tune SQL and PL/SQL workloads to improve performance, and partner with Oracle DBAs on configuration, recovery, and security. Create and maintain technical documentation, support procedures, deployment instructions, troubleshooting guides, and operational runbooks. Requires TS/SCI FSP clearance and 10+ years of experience.
Required Qualifications
- 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 to analyze existing database code and business logic
- Demonstrated ability to identify defects, data issues, and performance bottlenecks
- Demonstrated ability to rewrite, refactor, and optimize existing scripts
- Demonstrated ability to develop and maintain operational and production-support scripts
- Demonstrated ability to 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
- Strong experience maintaining and supporting data feeds and system integrations, including AWS services, interfaces, and endpoints
- Strong experience maintaining and supporting data feeds and system integrations, including APIs and service-based integrations
- Strong experience maintaining and supporting data feeds and system integrations, including file-based data transfers and batch interfaces
- Strong experience maintaining and supporting data feeds and system integrations, including upstream and downstream application dependencies
- Strong experience maintaining and supporting data feeds and system integrations, including 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 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 modeling, 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
- Complementary Oracle database administration experience, including working knowledge of RMAN backup and recovery
- Complementary Oracle database administration experience, including working knowledge of Oracle Data Guard
- Complementary Oracle database administration experience, including working knowledge of database security, roles, privileges, and auditing
- Complementary Oracle database administration experience, including working knowledge of tablespaces, storage, sessions, locks, and database-object management
- Complementary Oracle database administration experience, including working knowledge of production monitoring, incident troubleshooting, and recovery procedures
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.