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 recruiting@onezerollc.com or call (202) 987-2580.
OneZero Solutions is an 8(a), Service-Disabled Veteran-Owned Small Business (SDVOSB) that is problem-solving and solutions-oriented. OneZero was founded in 2017 when our founder, Al Sowers, was medically retired from the United States Coast Guard (USCG). While Al could no longer serve on active duty, he wanted to continue serving and protecting his country. Al also wanted to promote the professional advancement of military veterans - especially disabled veterans like himself.
OneZero specializes in cybersecurity operations, information assurance, computer network operations, solutions engineering, and project management in support of federal, state, and local government organizations. Employing professional, knowledgeable, and experienced personnel, OneZero strives to provide superior service and unparalleled results to our customers.
Our industry-leading security experts have designed and implemented some of the largest secure networks in the world, and have implemented and managed numerous large-scale, enterprise-wide infrastructures focused on strategic compliance factors across multiple government and private sector organizations. With our people-first approach and methodology, we create customer-centric environments leveraging technologies to increase productivity throughout the workforce.
For more information about OneZero Solutions, visit www.onezerollc.com.
