Senior Oracle Database Engineer

Bespoke Technologies, Inc.; Annapolis (MD); On-site; USD 120,000 - 180,000; Full time

Job summary

Bespoke Technologies, Inc. seeks an experienced Oracle Database professional to lead enterprise solutions, ensure performance, security, and reliable data integration in a complex environment.

You will debug and optimize SQL/PLSQL, maintain data feeds with NiFi and AWS endpoints, and collaborate with DBAs, developers, and infrastructure teams to resolve production issues.

Qualifications

• 10+ years of experience developing and supporting enterprise solutions using Oracle Database.
• Bachelor’s degree in Computer Science, Information Technology, or a related field, or an equivalent combination of education and professional experience.
• Active CompTIA Security+ certification.
• Experience with Oracle Exadata, Database Vault, Label Security, and large-scale data migration is highly desirable.
• Ability to work effectively with developers, database administrators, application owners, business analysts, infrastructure teams, and upstream and downstream integration partners.
• Must be an independent, analytical, and detail-oriented contributor with strong written and verbal communication skills and the ability to manage production issues and competing priorities.

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.

Skills

Oracle SQL

PL/SQL

Performance tuning

Data integration

NiFi data flows

AWS endpoints

APIs and batch interfaces

Troubleshooting

Data quality

Analytical thinking

Education

Bachelor’s degree in CS/IT

Active CompTIA Security+

Equivalent experience accepted

Tools

Oracle RAC

RMAN

Data Guard

AWR/ASH/ADDM

Oracle Enterprise Manager

Job description

Location- Annapolis Junction, MD

**Please do NOT apply if you do not have an active Poly clearance. Those without a Poly will not be considered.**

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 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 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.
• RMAN backup and recovery.
• Oracle Data Guard.
• Database security, roles, privileges, and auditing.
• Tablespaces, 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 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.

Qualifications:

• 10+ years of experience developing and supporting enterprise solutions using Oracle Database.
• Bachelor’s degree in Computer Science, Information Technology, or a related field, or an equivalent combination of education and professional experience.
• Active CompTIA Security+ certification
• Experience with Oracle Exadata, Database Vault, Label Security, and large-scale data migration is highly desirable.
• Ability to work effectively with developers, database administrators, application owners, business analysts, infrastructure teams, and upstream and downstream integration partners.
• Must be an independent, analytical, and detail-oriented contributor with strong written and verbal communication skills and the ability to manage production issues and competing priorities.