The Role
Develop and maintain Oracle APEX applications and Oracle database systems supporting USDA property management systems. Responsibilities include requirements analysis, technical design, coding, unit testing, documentation, code reviews, issue resolution, data-update scripting, migration package creation, deployment oversight, and participation in release planning. The role also provides technical recommendations, estimates development effort, supports quality assurance and user acceptance testing, and conducts knowledge transfer sessions.
Summary Generated by Built In
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:
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 code in accordance with the appropriate government-approved coding standards 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 as requested.
- Provide LOE estimates for development including technical design, coding, and unit testing as input into the approval process and release schedules.
- Resolve service requests by 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.
- 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
- 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
- Bachelor’s degree in computer science, Information Technology, or related field
- 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.
- $50,000 – $65,000
- Salary commensurate with experience.
Skills Required
- 3+ years of experience designing, developing, testing, and maintaining complex programs using Oracle APEX or similar technologies
- Proficiency with SQL and PL/SQL programming languages
- Experience developing, testing, maintaining, and administering IT applications
- Knowledge of systems analysis, design, testing, and program documentation principles and techniques
- Strong understanding of relational database design and advanced Oracle database features
- Ability to analyze and investigate program problems, conduct feasibility studies, develop technical design specifications, and execute unit test plans
- Excellent communication and documentation skills
- Experience with Oracle 12c or later
- Experience with Oracle APEX 22.1 or later
- Experience with JavaScript
- Bachelor's degree in computer science, information technology, or a related field
- Experience with Oracle APEX Office Print
- Experience with Oracle SQL Developer, TOAD, and SQLcl
- Experience with Oracle database administration or server environments
- Familiarity with Oracle APEX upgrades, compatibility review, upgrade testing, and troubleshooting
- Experience with government accounting or financial systems
- Knowledge of federal IT environments, security standards, and compliance requirements
- U.S. citizenship or lawful permanent resident status
- Ability to obtain and maintain a U.S. government Public Trust clearance
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
DRT Strategies, Inc. (DRT) is an award-winning technology innovator and leading digital transformation partner to large federal agencies and commercial clients for nearly 20 years. The company is a ServiceNow™ Partner - Specialist, Amazon Web Services (AWS) Consulting Partner, UiPath Partner, SAFe Bronze Partner, Esri Bronze Partner, and holds ISO 9001:2015, ISO/IEC 20000-1:2018, and ISO/IEC 27001:2013 certifications and has achieved CMMI-DEV Level 3. DRT is headquartered in Arlington, Virginia, with offices in Atlanta, Georgia. More information on the company can be found at www.drtstrategies.com.
