Oracle Database Developer
Role details
Job location
Tech stack
Job description
We are seeking an experienced Oracle Database Developer to design, optimize, and scale our core systems. In this role, you will embed critical application business logic directly into the Oracle database layer by writing high-performance PL/SQL code and tuning complex queries. While your primary expertise lies in database engineering, a strong foundational knowledge of modern Java backend development will allow you to seamlessly bridge the gap between our data and application tiers., * Develop Logic: Design, write, and maintain robust, high-performance Oracle PL/SQL stored procedures, packages, functions, and triggers.
- Embed Business Rules: Architect and implement complex application business logic directly within the database layer for data integrity and speed.
- Performance Tuning: Diagnose, troubleshoot, and optimize slow-running SQL queries, execution plans, and PL/SQL blocks using tools like TKPROF, EXPLAIN PLAN, and AWR reports.
- Data Modeling: Collaborate with software engineering teams to design efficient relational database schemas, tables, views, and indexes.
- Backend Integration: Partner closely with backend developers to align database-level business logic with application-level APIs and services.
- Code Review: Review database code generated by application developers to ensure adherence to performance standards and best practices.
Requirements
- Oracle Expertise: Deep, hands-on experience with Oracle Database versions (e.g., 19c / 21c).
- Advanced PL/SQL: Mastery of advanced PL/SQL concepts including collections, bulk binds (FORALL, BULK COLLECT), ref cursors, and analytical functions.
- Expert Tuning: Proven track record of resolving database bottlenecks, optimizing indexes, partitioning tables, and rewriting inefficient queries.
- Architectural Knowledge: Strong understanding of database internals, locking mechanisms, concurrency, and session management.
- Tools: Proficiency with database management tools such as Oracle SQL Developer, PL/SQL Developer, or Toad.
Preferred Qualifications (Nice-to-Have Backend Skills)
- Java Backend: Familiarity with core Java development and modern enterprise frameworks.
- Spring Ecosystem: Experience or exposure to Spring Boot, Spring Data, and dependency injection patterns.
- Domain-Driven Design (DDD): Understanding of DDD principles (aggregates, bounded contexts, domain events) to help bridge application design with data models.
- ORM Tools: Knowledge of Hibernate or JPA, specifically regarding how application queries translate to the database layer.
Sponsorship
- You must currently possess valid and unrestricted U.S. work authorization to be considered for this role. Individuals with temporary visas including, but not limited to, F-1 (OPT, CPT, STEM), H-1B, H-2, or TN, or any candidate requiring sponsorship, now or in the future, will not be considered.
Benefits & conditions
$90,000.00 - $158,400.00
These pay ranges apply to employees in New Jersey and New York. Pay ranges for employees in other states may differ.
It is unlawful to discriminate against a prospective employee due to the individual's status as a veteran.
For incentive eligible associates, the successful candidate is eligible for an annual incentive opportunity which may be delivered as a mix of cash bonus and equity awards in the Company's sole discretion.