Prometheus Group

Senior Oracle Developer

Prometheus Group

full-time

Posted on:

Location Type: Remote

Location: Australia

Visit company website

Explore more

✨ AI Apply
Apply

Job Level

Senior

Tech Stack

ETLOracleRDBMSSQL

About the role

  • Design robust stored procedures, functions, packages, triggers, and views using Oracle PL/SQL.
  • Build ETL/ELT pipelines (native PL/SQL, external tools, or DBMS_* packages) to ingest, transform, and publish data.
  • Implement error handling, exception management, logging, and instrumentation for traceability.
  • Develop and maintain database schemas, constraints, indexes, and materialized views.
  • Create reusable APIs (e.g., PL/SQL APIs, REST) to expose data services.
  • Analyze query plans and tune SQL (e.g., EXPLAIN PLAN, SQL Monitor, dbms_xplan).
  • Optimize data access patterns (indexes, partitioning, hints, statistics) and reduce I/O.
  • Work with architects to align physical design (partitioning, tablespaces) with data growth and access patterns.
  • Partner with application developers to design efficient SQL/PLSQL interfaces.
  • Work with business analysts to translate requirements into robust data solutions.
  • Produce documentation: Application specs, deployment guides, and runbooks.

Requirements

  • Strong knowledge on RDBMS, Enterprise Data architecture (+5 years hand-on experience with Oracle Database and PL/SQL)
  • Strong knowledge of PL/SQL including functions, procedures, packages, and triggers
  • Solid SQL Tuning, Trace, and Performance experience for 19g Oracle databases
  • Strong knowledge of Oracle advanced querying techniques and writing high performing and optimized queries
  • Ability to Document technical specifications
  • Ability to troubleshoot and resolve complex issues related to the application in the form of support and defect resolution
  • Ability to collaborate with stakeholders working closely with other application developers, partners, and front-line application consultants.
  • Ability to support report development using various business intelligence platforms.
Benefits
  • Health insurance
  • Retirement plans
  • Flexible work arrangements
  • Professional development

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
Oracle PL/SQLETLELTSQL TuningDatabase SchemasAPIsData Access PatternsPerformance OptimizationError HandlingException Management
Soft skills
CollaborationTroubleshootingDocumentationCommunicationProblem Solving