> Markdown version of [/jobs/ext/3896729-oracle-report-developer](https://www.wearedevelopers.com/jobs/ext/3896729-oracle-report-developer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Oracle Report Developer

- **Company:** OneZero Solutions
- **Location:** Kittery, ME, United States
- **Experience:** Experienced
- **Contract:** Permanent contract
- **Skills:** Databases, Extract Transform Load (ETL), Data Warehousing, Database Applications, Web Development, Operational Data Store, Oracle Databases, Oracle (Applications), Oracle SQL Developer, Application Data, SQL Stored Procedures, PL-SQL, SQL Databases, Freeform SQL, SC Clearance, Bug Reporting, Tools for Reporting, Data Pipelines
- **Published:** October 23, 2026
- **Apply:** https://www.thejobnetwork.com/job/4c3b626f-4c25-4ef2-90cd-3a715ddd45d5/oracle-report-developer

## About the Role

Required

 * Two (2) or more years of hands-on experience developing reports and queries using PL/SQL and Oracle SQL.
 * OR: Relevant Oracle certification (Oracle Database SQL Certified Associate or Oracle PL/SQL Developer Certified Professional) combined with demonstrated practical project experience.
 * Active Secret clearance (or ability to obtain).

Preferred

 * Experience with ETL tool development and data pipeline architecture.
 * Familiarity with data warehouse concepts and business intelligence reporting.
 * Strong communication skills and ability to engage directly with non-technical stakeholders., Applicants must be authorized to work in the U.S. without current or future employer sponsorship.

## Description

The Oracle Report Developer designs, develops, and maintains complex reports and queries to support mission-critical operations. This position works closely with business stakeholders to translate reporting requirements into technical solutions using Oracle databases, SQL, PL/SQL, and reporting tools. This position includes developing PL/SQL based automation to update records according to stakeholder requirements.

Core Responsibilities

Application & Report Development

 * Design, develop, and maintain PL/SQL-based database applications and stored procedures.
 * Write complex SQL queries including multi-table joins, subqueries, window functions, and aggregate operations.
 * Design, build, test, and deploy reports using PL/SQL, SQL, and in-house reporting tools.
 * Ensure all reports and outputs meet data accuracy, security classification, and compliance requirements.
 * Develop PL/SQL automation to update, transform, and manage records per stakeholder-defined business rules.

Performance & Quality

 * Optimize PL/SQL stored procedures and SQL query performance for operational workloads.
 * Troubleshoot application and reporting defects, identifying root cause and implementing durable fixes.
 * Create and maintain technical documentation for reports, procedures, and database objects.

Additional Responsibilities (Preferred)

 * Develop ETL pipelines to support application data integration and operational data movement needs.
 * Collaborate with application and web development teams on database-side solutions to business problems.
 * Partner with business units to convert requirements into database objects and BI reports.
 * Leverage current and emerging Oracle database tools, strategies, and technologies to drive improvements.