user avatar

Oracle Report Developer

OneZero Solutions, LLC

Posted 1 month ago

Job Requirements

Portsmouth, NH
Secret Polygraph not specified
Early Career (2+ yrs experience)
$65,000 - $71,000

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: https://www.onezerollc.com/careers/

Position Title: Oracle Report Developer

Clearance: Secret

Location: Portsmouth NH 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.

Develop extraction, transformation, and loading pipelines to support application data integration and operational needs.

Design, develop, test, and deploy Oracle-based reports using SQL, PL/SQL, and in house reporting tools.

Design, develop, and maintain PL/SQL database applications.

Optimize query performance and troubleshoot reporting issues.

Assist application and web development staff and users on database solutions to business problems; data warehouse architectures; database management system facilities; and capabilities, operation, and tuning of databases.

Work with business units to convert requirements to database objects and implement business intelligence reports to meet organization needs.

Ensure reports meet data accuracy, security, and compliance requirements.

Administer and use current and emerging database tools, strategies, and technologies.

Create and maintain technical documentation for reports and database objects.

Must have:
Design, develop, and maintain PL/SQL database applications.
Experience writing complex SQL queries including joins, subqueries, and aggregate functions.
Design, develop, test, and deploy reports using PL/SQL, SQL, and in-house reporting tools.
Ensure reports meet data accuracy, security, and compliance requirements.
Develop PL/SQL based automation to update records according to stakeholder requirements.
Optimize PL/SQL and SQL query performance
Troubleshoot application and reporting issues.

Nice to have:
Develop extract, transform, and load pipelines (ETL) to support application data integration and operational needs.
Assist application and web development staff and users on database solutions to business problems; data warehouse architectures; database management system facilities; and capabilities, operation, and tuning of databases.
Work with business units to convert requirements to database objects and implement business intelligence reports to meet organization needs.
Administer and use current and emerging database tools, strategies, and technologies.
Create and maintain technical documentation for reports and database objects.

Qualifications:
Two (2) or more years' experience developing reports and queries using PL/SQL and SQL

OR

Relevant Oracle certifications (such as Oracle Database SQL Certified Associate or Oracle PL/SQL Developer Certified Professional) combined with demonstrated practical experience.

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.
group id: 91092480
N
Name HiddenTechnical Recruiter