Oracle Report Developer

OneZero Solutions; Portsmouth (NH); On-site; USD 80,000 - 100,000; Full time

Benefits offered by this job

Health, dental, vision insurance

401K with company matching

Paid time off and holidays

Employee referral program

Educational assistance

Job summary

A technology solutions provider is seeking an Oracle Report Developer to create and maintain complex reports using Oracle databases and SQL. The role requires three years of experience in report development, with strong skills in PL/SQL and database optimization. A competitive benefits package is offered, including health insurance and 401K matching. This full-time position is based on-site in Portsmouth, New Hampshire, and requires clearance at the Secret level.

Qualifications

• Three or more years' experience developing reports and queries using Oracle databases, SQL, and PL/SQL.
• Relevant Oracle certifications combined with demonstrated practical experience.
• Experience writing complex SQL queries including joins, subqueries, and aggregate functions.

Responsibilities

• Design, develop, and maintain complex reports and queries.
• Develop PL/SQL based automation to update records as required.
• Optimize query performance and troubleshoot reporting issues.
• Work with business units to implement business intelligence reports.

Skills

Oracle databases

SQL

PL/SQL

Data analysis

Complex SQL queries

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.

Qualifications:

Three (3) or more years' experience developing reports and queries using Oracle databases, SQL, and PL/SQL.

OR

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

Experience writing complex SQL queries including joins, subqueries, and aggregate functions.

Ability to analyze business requirements and translate them into technical solutions.

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 [e-mail] or call [phone].