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