Archived listing. The details below describe a past opening.
Required Skills & Experience
Job Description
Insightsoftware is looking for a Principal Database Engineer to serve as the hands-on Oracle expert for its Certent Equity Management platform. 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.
Nice to Have Skills & Experience
Plusses
- 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.
Job Description
Job Description
Insightsoftware is looking for a Principal Database Engineer to serve as the hands-on Oracle expert for its Certent Equity Management platform. 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.