Jobs · Information Technology · New Hampshire

Oracle Report Developer with Security Clearance

OneZero Solutions · Portsmouth, NH · 1 wk ago
Information TechnologyFull-time

Core Responsibilities

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

Qualifications

  • 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).

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.

Benefits

  • Health/dental/vision/life insurance plans.
  • 401K with company matching.
  • PTO & paid holidays.
  • Employee referral program.
  • educational assistance.

Pay

N/A

Schedule

N/A

Skills

N/A

Benefits

N/A

Schedule

N/A

Similar jobs