Oracle Application Developer

DRT Strategies; Arlington (VA); A distancia; USD 50.000 - 65.000; Jornada completa

Descripción de la vacante

DRT Strategies is seeking a mid-level Oracle APEX developer to support two USDA property management systems. You will design and implement Oracle APEX pages, apps, and components, ensure coding standards, and contribute to design and deployment activities. Daily work is performed remotely with collaboration across government teams.

The role requires 3+ years of hands-on Oracle APEX/SQL-PLSQL experience, strong relational database skills, and excellent communication. A U.S.

Formación

• 3+ years designing, developing, testing and maintaining Oracle APEX applications
• Experience with SQL/PL-SQL programming
• Strong relational database design and Oracle database knowledge
• Ability to analyze problems, create design specs and unit tests
• Excellent communication and documentation skills

Responsabilidades

• Design and develop Oracle APEX pages and components per requirements
• Write code that adheres to government-approved standards and design documents
• Prepare technical design docs and unit test plans; execute tests and document results
• Conduct design reviews, knowledge transfers, and code reviews with government team
• Provide LOE estimates for development and testing for release planning
• Resolve service requests and prepare data update scripts
• Recommend solutions for complex business problems and upgrades
• Provide status updates and participate in requirement/design and release meetings
• Create migration packages and oversee deployment to Test and Production environments

Conocimientos

Oracle APEX

SQL/PL-SQL

Javascript

Oracle database design

Educación

Bachelor's degree in computer science or related field

Herramientas

Oracle SQL Developer

TOAD

SQLcl

Oracle APEX Office Print

Descripción del empleo

Overview

DRT Strategies delivers expert management consulting and information technology (IT) solutions to large federal agencies, state and local government and commercial clients in health care, technology, and financial services industries.

Overview

DRT Strategies delivers expert management consulting and information technology (IT) solutions to large federal agencies, state and local government and commercial clients in health care, technology, and financial services industries. The three letters of our name, DRT, stand for Driving Resolution Together, which is the core philosophy on which the company was founded. That is, we collaborate with our clients to solve their most pressing challenges - together. We are problem solvers dedicated to your success, combining Fortune 500 experience with small business responsiveness. We have established a reputation with our clients as a forward-thinking consulting firm with demonstrated success in implementing solutions that lead to meaningful results. Our world-class consultants unite people to work collaboratively to achieve project goals and make vision a reality.

Project Description

DRT is responsible for functional and technical Operations & Maintenance (O&M) support for two of USDA’s major mission supportive web-based database management systems operated under the Office of the Chief Financial Officer (OCFO). These systems integrate fiscal accounting with property accountability to support the Department’s agencies and mission areas.

Job Summary

DRT is seeking a mid-level developer with experience in Oracle Application Express (APEX) and Oracle database systems (or similar) to provide technical support for two enterprise-level property management systems used across USDA. Within this project, our company is responsible for requirements, design, development, system testing, functional and technical documentation, supporting quality assurance and user acceptance testing, and preparing deployment packages/scripts. Daily work is performed remotely.

Responsibilities

• Design and develop new or updated Oracle APEX application pages and shared components based on supplied business requirements.
• Develop quality codein accordance withtheappropriate government-approved codingstandards that conforms to documented requirements and functional/technical design.
• Prepare technical design documents with the appropriate government-approved templates. Develop and execute unit test plans and document the results.
• Conduct technical design document walk-throughs, knowledge transfer sessions, and code reviews with government team members asrequested.
• Provide LOE estimates for development including technical design, coding, andunit testing as input into the approval process andreleaseschedules.
• Resolveservice requestsby working with users to address system issues and preparing scripts for data updates as needed.
• Provide recommendations for solutions to complex business problems or technical upgrades to maintain the operating environment of the systems.
• Provide status updates and participate in requirements/design meetings and release planning meetings as required.
• Create migration packages and oversee deployment to Test and Production environments.

Required Experience:

• Advanced knowledge and skills (e.g., 3+ years of experience) in designing, developing, testing and maintaining complex programs using Oracle APEX (or similar) and SQL/PL-SQL programming languages
• Experience in the development, testing, maintenance, and administration of IT applications, with comprehensive knowledge of the principles and techniques of systems analysis, design, testing, and program documentation
• Strong understanding of relational database design, including PL/SQL logical structures and advanced features of Oracle databases
• Ability to analyze and investigate problems in programs, conduct feasibility studies, develop technical design specifications, and create / execute unit test plans
• Excellent communication and documentation skills
• Technical Skills:Oracle (12c or later), Oracle APEX 22.1 and later, SQL/PL-SQL, Javascript

Preferred Experience:

• Experience working with Oracle APEX Office Print
• Experience working with toolsets such as Oracle SQL Developer, TOAD, and SQLcl
• Experience with Oracle database administration and/or server environment
• Familiarity with Oracle APEX upgrade process, including reviewing release notes, identifying possible compatibility conflicts, testing upgrades, and troubleshooting any issues
• Experience working with government accounting or financial systems
• Knowledge of federal IT environments, security standards, and compliance requirements

Education & Training:

• Bachelor’s degree in computer science, Information Technology, or related field

Work Authorization, Clearance Requirement, & Additional Information:

• This position requires the ability to obtain and maintain a U.S. government Public Trust clearance. Due to contract requirements, candidates must be U.S. citizens or lawful permanent residents (green card holders) to be eligible.
• No agencies, third parties, or Corp-to-Corp submissions.

Salary Range:

• $50,000 – $65,000
• Salary commensurate with experience.

DRT Strategies, Inc. (DRT) follows the guidelines outlined by the Equal Employment Opportunity Commission (EEOC) to provide all employees and qualified applicants employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related conditions, transgender status, and sexual orientation), national origin, age, genetic information, disability, protected veteran status, or any other protected characteristic under federal, state, or local law.

Reasonable accommodations for applicants and employees with disabilities will be provided. If a reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please contact Human Resources by emailing [e-mail], or by dialing 571-482-2517.

For additional information, please review the Know Your Rights: Workplace Discrimination is Illegal, E-Verify (English), E-Verify (Spanish). Right to Work (English), Right to Work (Spanish).