> Markdown version of [/jobs/ext/2203479-oracle-report-developer](https://www.wearedevelopers.com/jobs/ext/2203479-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:** Portsmouth, NH, 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:** August 23, 2026
- **Apply:** https://www.clearancejobs.com/jobs/9096653/oracle-report-developer

## About the Role

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.

## 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.


## Related Videos

- [How building an industry DBMS differs from building a research one](https://www.wearedevelopers.com/videos/768-how-building-an-industry-dbms-differs-from-building-a-research-one)
- [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases)
- [Database DevOps with Containers](https://www.wearedevelopers.com/videos/145-database-devops-with-containers)
- [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases)
- [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt)
- [Branch your database like your code:  How schema changes and pull requests go hand in hand](https://www.wearedevelopers.com/videos/350-branch-your-database-like-your-code-how-schema-changes-and-pull-requests-go-hand-in-hand)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [What’s the Difference between a Junior, Mid, and Senior Developer?](https://www.wearedevelopers.com/magazine/238-what-s-the-difference-between-a-junior-mid-and-senior-developer)
- [Résumé-Driven Development: How IT trends affect the job market for software developers](https://www.wearedevelopers.com/magazine/59-resume-driven-development-how-it-trends-affect-the-job-market-for-software-developers)
- [93 Java Interview Questions You Should Prepare For](https://www.wearedevelopers.com/magazine/14-93-java-interview-questions-you-should-prepare-for)
- [Fully Remote Software Engineer Jobs](https://www.wearedevelopers.com/magazine/447-fully-remote-software-engineer-jobs)
- [Is Software Engineering Over-Saturated?](https://www.wearedevelopers.com/magazine/418-is-software-engineering-over-saturated)