Senior Oracle Database Engineer

Stratyx; Annapolis (MD); Híbrido; USD 140.000 - 200.000; Jornada completa

Descripción de la vacante

Stratyx is seeking a Senior Oracle Database Engineer in Annapolis Junction, MD. The role emphasizes hands-on SQL and PL/SQL development, production debugging, and maintaining data feeds and integration endpoints.

You will collaborate with DBAs and infrastructure teams to ensure high availability and performance in enterprise-scale Oracle environments. The ideal candidate has 10+ years of Oracle experience, strong SQL/PLSQL skills, and a record of optimizing complex data workflows and batch

Formación

• 10+ years of experience developing and supporting enterprise solutions using Oracle Database.
• Advanced expertise in Oracle SQL and PL/SQL including packages, procedures, functions, and triggers.
• Experience debugging complex SQL/PL/SQL in dev, test, and prod environments.
• Ability to analyze database code and business logic, identify defects, and optimize scripts.
• Experience in data feeds and system integrations using NiFi, AWS, APIs, and batch interfaces.
• Knowledge of RAC, RMAN, Data Guard, security, and production monitoring.

Responsabilidades

• Debug and resolve complex SQL, PL/SQL, data, and production-processing issues.
• Review, rewrite, and optimize existing SQL/PL/SQL scripts.
• Maintain PL/SQL packages, procedures, and database interfaces.
• Monitor and maintain data feeds involving Oracle, NiFi, AWS endpoints, and APIs.
• Coordinate resolution across database, integration, application, and infrastructure teams.
• Tune workloads to improve performance, scalability, and reliability.
• Create and maintain technical runbooks and deployment instructions.

Conocimientos

Oracle SQL

PL/SQL

Performance tuning

Data analysis

Debugging

Batch processing

Data feeds

Troubleshooting

SQL optimization

Educación

Bachelor's degree in Computer Science / IT or related field

Herramientas

Oracle RAC

RMAN

Data Guard

Oracle Enterprise Manager

Descripción del empleo

# Senior Oracle Database Engineer* Annapolis Junction, MD* Full-time* just now## About this roleWe 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.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.