Oracle PL/SQL Developer

Insight Global
Raleigh, NC, United States
1 day ago
Apply on dejobs.org
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
8 years minimum
Working hours
Regular working hours
Job source

Tech stack

Artificial Intelligence Microsoft Azure Big Data Databases Continuous Integration Database Development Monitoring of Systems Liquibase Oracle Databases Oracle (Applications) Oracle SQL Developer Query Optimization
+14 more
Power BI Software Engineering SQL Stored Procedures PL-SQL SQL Databases Tableau (Software) Datadog GitHub Copilot Oracle Enterprise Manager Claude Code Database Optimization Analytic Functions Redgate Looker Analytics

Job description

Insight Global is looking for a Principal Database Engineer to support our clients enterprise SaaS platform on their Financial management system. This is a purely Oracle role: the large majority of your time will be spent writing, optimizing, and maintaining PL/SQL, stored procedures, packages, and queries. This is a 100% individual contributor role with no direct reports. You will be assigned performance and feature work - diagnosing long-running queries and stored procedures, tuning them for production scale, and assisting engineering teams in developing new features by authoring and reviewing the database-tier code behind them - understanding requirements, authoring an Engineering Design Doc (EDD) where appropriate, coordinating across the team on any expected impacts, and delivering - then taking on the next piece and doing it again. This is not a Database Administrator position: deep application-development experience in PL/SQL is required. * Lead Oracle query tuning and optimization - execution plan analysis, indexing strategies, hints, optimizer statistics, partitioning, materialized views, and read-optimization patterns - within the constraints of the existing schema.

Requirements

  • Demonstrated AI-first engineering mindset - hands-on experience with agentic development tooling (Claude Code, GitHub Copilot, Devin.AI, or similar) and a track record of driving AI adoption within an engineering team. * 8-10+ years of hands-on software engineering experience with a strong specialization in Oracle database development in enterprise SaaS environments. * Deep Oracle SQL and PL/SQL expertise - stored procedures, packages, functions, triggers, views, and complex multi-join queries against large datasets; this is the primary skill requirement for this role. * Demonstrated experience diagnosing and optimizing poorly performing SQL and PL/SQL - reading execution plans, applying indexing strategies, using hints and optimizer statistics, and rebuilding queries at production scale. * Hands-on experience with Oracle 19c and Oracle-specific performance features - execution plan analysis, index types, partitioning, materialized views, bulk processing, and analytic functions. * Experience extending and optimizing large, long-lived Oracle schemas - working within existing table structures, conventions, and backward-compatibility constraints. * Financial services, equity compensation, or another regulated-industry background. * Experience with materialized views, query rewrite, result cache, and pre-aggregation. * AWR/ASH, Oracle Enterprise Manager, Datadog, or similar monitoring tools. * Liquibase, Flyway, Redgate, or similar database deployment tools. * Azure DevOps and CI/CD experience. * utPLSQL experience. * Familiarity with Logi Analytics/Logi Symphony, Power BI, or Tableau. Experience mentoring senior engineers and promoting database-development standards.

Apply for this position

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

Apply on dejobs.org
Prepare application

Good distractions

Loading talks and stories from around this role…