Job description

We are an employee-centric company that truly appreciates our team members and their value to our customers and the missions they support. We pride ourselves on being forward-leaning thinkers and fostering teams that are and continue to be technically proficient and technically capable across a comprehensive range of cyber mission areas. OneZero full-time employees receive an extremely competitive benefits package that includes health/dental/vision/life insurance plans, 401K with company matching, PTO & paid holidays, employee referral program, and educational assistance. Additional details can be found on our website at: onezerollc.com / Position Title : Oracle Report Developer Clearance : Secret Location : Portsmouth NH Must be On Site 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. Qualifications 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. OneZero Solutions, LLC is an Equal Opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, pregnancy, genetic information, disability, status as a protected veteran, or any other protected category under applicable federal, state, and local laws. To request an accommodation, please contact us at recruiting@onezerollc.com or call (202) 987-2580. Applicants must be authorized to work in the U.S. without current or future employer sponsorship.

Requirements

Must-haves

Position Title : Oracle Report Developer
Clearance : Secret
Location : Portsmouth NH Must be On Site
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.
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.
Two (2) or more years of hands-on experience developing reports and queries using PL/SQL and Oracle SQL.

Nice-to-haves

Additional Responsibilities (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.
To request an accommodation, please contact us at recruiting@onezerollc.com or call (202) 987-2580.
Applicants must be authorized to work in the U.S. without current or future employer sponsorship.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sql

Platform: applicantpro
Effort: medium

Benefits

Benefits detected in the listing.

Dental

Vision

401k

Pto