Oracle PL/SQL Developer
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Tech stack
+14 more
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.
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦