What are the responsibilities and job description for the Oracle Developer position at RIVA Solutions Inc.?
Job Title: Oracle Developer
Location: Rockville, MD
Terms: Full-time
Clearance: Must be a U.S. Citizen and able to obtain and maintain a Public Trust clearance
Travel: 0–10%
RESULTS. INNOVATION. VALUES. ACCOUNTABILITY.
That’s RIVA. Our employee-first approach has created a culture that attracts the best and the brightest. By investing in people and offering flexibility, our employees achieve higher morale, strong productivity, and low turnover. At RIVA, people are our #1 priority.
Program Overview
RIVA Solutions supports the Department of Health and Human Services (HHS) Program Support Center (PSC) in providing shared services that improve efficiency, transparency, and financial accountability across the federal enterprise. This role supports the Financial Management Platform (FMP) modernization initiative — advancing automation, data accuracy, and interoperability among critical federal financial systems.
Position Overview
RIVA Solutions is seeking a Junior to Mid-Level Oracle Developer / Technical Analyst to support development, integration, and operations & maintenance (O&M) activities for federal financial management systems within the HHS PSC FMP environment.
The ideal candidate will have strong hands-on Oracle PL/SQL development experience, excellent analytical skills, and the ability to interface directly with federal customers to translate business needs into system solutions.
Responsibilities
PL/SQL Development & Backend Logic
- Develop and maintain backend logic using Oracle PL/SQL (procedures, packages, triggers, batch scripts).
- Recommend and implement Oracle-based automation and system enhancements to improve efficiency.
Testing, UAT, and Data Validation
- Conduct functional testing and data validation.
- Coordinate UAT activities with business users to validate system changes.
O&M Support, Troubleshooting & Defect Analysis
- Collaborate with developers, testers, and operations teams to troubleshoot issues and resolve support tickets.
- Analyze recurring defects and manual workflows to identify opportunities for process improvement.
Financial & Payroll Integration Support
- Support interface data integration across enterprise financial systems.
- Support the biweekly payroll accounting process, ensuring accurate posting and reconciliation of payroll transactions.
- Perform financial data reconciliations across Oracle systems, Treasury, and OPM data sources; identify discrepancies and recommend corrections.
- Assist with preparation, validation, and correction of federal payroll reports.
Customer Engagement & Documentation
- Engage directly with federal customers to gather business requirements and translate them into technical specifications.
- Maintain System Change Request (SCR) documentation and supporting technical artifacts.
- Support audits, including A-123 internal controls, documentation, and testing activities.
- Develop and maintain SOPs, process documentation, and training materials for users and support teams.
Oracle Forms Support (Enhancement/BREAK-FIX)
- Support and enhance Oracle Forms functionality through break/fix activities and minor enhancements highly preferred.
Minimum Qualifications
- Bachelor’s degree in Computer Science, Information Systems, Business, Accounting, or related field — or equivalent experience.
- 3–5 years of hands-on Oracle SQL / PL/SQL development experience (procedures, packages, triggers, data processing).
- Experience with TOAD/SQL Developer and Oracle database environments.
- Experience conducting data validation, functional testing, and supporting UAT activities.
- Ability to troubleshoot production issues and support daily O&M operations.
- Demonstrated experience analyzing financial data and performing data reconciliations across multiple data sources.
- Familiarity with Agile methodologies and ITSM tools (JIRA, ServiceNow).
- Familiarity with Unix/Shell scripting for batch jobs.
- Strong organization, documentation, and customer interaction skills.
- Ability to communicate clearly and explain system workflows and technical concepts to non-technical stakeholders.
- Exposure to DevSecOps/CI/CD pipelines is a plus.
- Exposure to JavaScript or modern full-stack frameworks is a plus.
Preferred Qualifications
- Experience working with Oracle Forms (maintenance, break/fix, enhancements).
- Experience supporting legacy-to-modernization interfaces or enterprise system integrations.
- Experience working in a federal O&M support environment.
- Experience with federal financial or payroll accounting systems (HHS or similar agency preferred).
- Understanding of federal accounting concepts such as Treasury/IPAC/GWA or OPM payroll reporting processes.
- Experience supporting audits and A-123 internal controls documentation requirements.
Soft Skill Expectations
- Excellent written and verbal communication skills.
- Comfortable presenting findings, issues, and recommendations to federal leadership.
- Able to translate ambiguous or high-level business needs into clear technical requirements.
- Strong analytical and problem-solving mindset with high attention to detail.
- Collaborative and customer-focused; effective working across business, technical, and operations teams.
Salary
Salary between $115,000 to $130,000 depending on experience.
RIVA Benefits
- Paid Time Off / Sick Leave
- Health, Dental, and Vision Coverage
- Life Insurance
- 401K Retirement Plan with Company Match
- HSA/FSA Spending Accounts
- Long- and Short-term Disability
- Pet Insurance
- Wellness Program Initiatives
- RIVA Flex (Flexible Hours and Hybrid Work Support)
- Additional Perks & Workplace Benefits
Equal Opportunity Statement
RIVA Solutions is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any protected class. If you need a reasonable accommodation to search for a job opening or to submit an online application, please email accommodations@rivasolutionsinc.com. Only messages left for this purpose will be returned.
Salary : $115,000 - $130,000