Oracle PL/SQL Developer, Exadata

Insight Global
Jersey City, NJ, United States
29 days ago
Apply on jobs.insightglobal.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
10 years minimum
Compensation
$114,400.0 - $141,440.0
Working hours
Regular working hours

Tech stack

Legacy Database Algorithmic Trading Business Logic JIRA Big Data C Sharp (Programming Language) Databases Data Integrity Extract Transform Load (ETL) Oracle Exadata Python (Programming Language) Operational Databases
+13 more
Oracle Databases Oracle (Applications) Oracle SQL Developer Performance Tuning Systems Development Life Cycle Query Optimization Shell Script PL-SQL SQL Databases Windows Forms Git Bitbucket Software Version Control

Job description

This developer will support a suite of back-office, finance-adjacent systems-including the trading hub, general ledger reporting, and subledger and accounting platforms-that are critical to the firm’s financial operations. The role will be highly cross-functional, interacting with multiple teams across the organization such as finance, reporting, and platform engineering. An ongoing FRRR initiative will influence several of the projects this developer will work on and will help shape the overall roadmap. Within this environment, the developer will design, develop, and enhance PL/SQL-based application logic in an Exadata-backed Oracle environment, tune SQL and PL/SQL for performance across large datasets, and maintain and extend existing legacy database code while delivering smaller greenfield components as needed. The developer will follow established SDLC and compliance processes, including version control using Bitbucket/Git, Jira-based work tracking, and releasing viable code into controlled environments. They will pair closely with subject matter experts, while dedicated DBAs will manage operational database responsibilities such as backup, recovery, and core administration.

Requirements

10+ years of Oracle development experience

  • Oracle 12c minimum (strong preference for 19c; roadmap toward Oracle 23ai)
  • Expert at building/maintaining custom PL/SQL (schema objects, and database code)
  • Packages, Tables, views, synonyms, indexes, etc.
  • Data integrity and query optimization patterns
  • Work in Exadata-backed environments with real performance focus:
  • Query tuning, execution plans, indexing strategy
  • Handling large datasets and high-throughput workloads
  • Experience performance tuning on large data sets Experience within Bitbucket/Git, Jira, compliance controls, and standard SDLC

Nice to Have Skills & Experience

  • Python (light scripting / automation / utilities)
  • C# exposure (legacy WinForms app context)
  • Linux shell scripting (operational scripting; not DBA work)
  • Banking/financial domain experience:
  • Trading systems, GL reporting, accounting/subledger platforms
  • ETL familiarity (moving/landing data into Oracle), especially where file movement between systems is involved
  • Work tracking in JIRA Comfortable working within regulated/compliance SDLC gates

Benefits & conditions

Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on jobs.insightglobal.com
Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:05 min

Integrating an assistant application with Jira software

Felix Augenstein · LIVE

6:21 min

Investigating push inefficiencies with upstream Git experts

Jonathan Creamer · Coffee With Developers

1:06 min

Developer experience and project variety at scale

Alexandra Petri · World Congress 2023

5:47 min

Integrating user stories and test automation via Jira tools

Christoph Ruggenthaler · LIVE

56 sec

Favorite git commands and the importance of patch commits

Eileen Uchitelle Eileen Uchitelle +1 · Coffee With Developers

2:40 min

Evolving through early developer roles and technology stacks

Liam Hurrel +1 · World Congress 2021

Videos

See all

Related articles

See all