Principal Oracle Developer (PL/SQL)
Required∙ 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.∙ Deep application-development background — this is not a Database Administrator position.∙ Experience validating data accuracy end-to-end — ensuring query and procedure output matches source data and handles edge cases correctly.∙ 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.∙ Experience working in global, distributed teams across multiple time zones.∙ Bachelor's degree in Computer Science, Engineering, or equivalent work experience.∙ Background in financial services, equity compensation, or adjacent regulated domains where data accuracy∙ Experience with PL/SQL unit testing frameworks such as utPLSQL.
Job Description:
Insight Global is looking for a Principal Database Engineer to serve as the hands-on Oracle expert This is a 100% individual contributor and application-development role, not a traditional DBA position. The engineer will focus heavily on Oracle SQL and PL/SQL development, performance tuning, and supporting database-tier feature work. Day-to-Day∙ Write, optimize, and maintain complex PL/SQL, stored procedures, packages, functions, triggers, views, and queries.∙ Diagnose long-running SQL and stored procedures and rebuild them into maintainable, production-ready solutions.∙ Analyze execution plans and apply indexing, partitioning, optimizer statistics, hints, and materialized views.∙ Support feature teams by developing and reviewing database-tier code.∙ Debug production database issues and identify root causes across packages, triggers, and views.∙ Validate data accuracy and benchmark changes against production-scale data.∙ Use AI development tools, including Claude Code, as part of the daily engineering workflow. Collaborate with architects, lead engineers, QA, and reporting/BI teams.