Oracle Report Developer

Summary

RSSi / OneZero Solutions is an employee-centric company that values its team members and their contributions. They are seeking an Oracle Report Developer who will design, develop, and maintain complex reports and queries to support mission-critical operations, working closely with business stakeholders to translate requirements into technical solutions using Oracle databases and reporting tools.

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

Skills

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

Qualifications

Must Haves

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

Nice to Haves

• 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

Benefits

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