Application Software Engineer 2
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Tech stack
+2 more
Job description
Help advance how health happens through technologies that empower patients, support clinicians, and improve the healthcare experience.
As a member of the AMS Custom Reporting team, you will contribute to software development and custom reporting projects within Oracle Health client environments. You will develop, debug, test, document, and maintain application features, SQL queries, CCL programs, and custom reports in accordance with established requirements and design specifications.
This role combines software development, database knowledge, production support, and client collaboration. Clear communication, effective troubleshooting, and the ability to balance client and business priorities are essential. The complexity of assigned work and level of independence will align with the position’s experience level.
Only Oracle brings together the data, infrastructure, applications, and expertise to power everything from industry innovations to life-saving care. And with AI embedded across our products and services, we help customers turn that promise into a better future for all. Discover your potential at a company leading the way in AI and cloud solutions that impact billions of lives.
True innovation starts when everyone is empowered to contribute. That’s why we’re committed to growing a workforce that promotes opportunities for all with competitive benefits that support our people with flexible medical, life insurance, and retirement options. We also encourage employees to give back to their communities through our volunteer programs., Report Development and Maintenance
- Develop and maintain CCL programs and SQL queries for custom reports in Oracle Health Millennium.
- Clarify report requirements with clients, including data fields, filters, parameters, calculations, and output formats.
- Identify the database tables, relationships, and query logic needed to retrieve the required data.
- Document report logic, data sources, parameters, and dependencies so other developers can support and maintain the reports.
Testing, Performance, and Releases
- Test report results against requirements and source data, checking for incorrect calculations, missing records, and duplicate results.
- Investigate slow-running reports and optimize SQL queries and CCL code.
- Review report code and coordinate testing and releases with the team and clients. Verify that reports continue to work after relevant application or database changes.
- Follow approved procedures for accessing patient data and handling report outputs during development, testing, and support.
Report Support and Troubleshooting
- Provide business-hours support for custom reports and participate in assigned incident rotations with guidance.
- Investigate report failures and incorrect results by reviewing logs, querying database tables, examining CCL and SQL code, and reproducing users’ report inputs and workflows.
- Develop and test fixes, and work with clients to confirm that reported issues are resolved.
- Document investigation steps, findings, and resolutions. Create knowledge articles for recurring reporting issues.
- Prioritize report requests and defects by severity, urgency, and client impact. Communicate progress and escalate issues that require additional expertise or another team’s involvement.
Requirements
Software Engineering, Healthcare, Testing, Requirements Management, Software Development, Software Administration, Debugging Skills, Oracle, SQL (Structured Query Language), Production Support
Benefits & conditions
Oracle is an Equal Employment Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability and protected veterans’ status, or any other characteristic protected by law. Oracle will consider for employment qualified applicants with arrest and conviction records pursuant to applicable law.
Disclaimer:
Certain U.S. based or U.S. customer or client-facing roles may be required to comply with applicable requirements, such as immunization/occupational health mandates, and/or drug testing requirements.
Range and benefit information provided in this posting are specific to the stated locations only
US: Hiring Range in USD from: $74,100 to $148,300 per annum. May be eligible for bonus and equity.
Oracle maintains broad salary ranges for its roles in order to account for variations in knowledge, skills, experience, market conditions and locations, as well as reflect Oracle’’s differing products, industries and lines of business.
Candidates are typically placed into the range based on the preceding factors as well as internal peer equity.
Oracle US offers a comprehensive benefits package which includes the following:
- Medical, dental, and vision insurance, including expert medical opinion
- Short term disability and long term disability
- Life insurance and AD&D
- Supplemental life insurance (Employee/Spouse/Child)
- Health care and dependent care Flexible Spending Accounts
- Pre-tax commuter and parking benefits
- 401(k) Savings and Investment Plan with company match
- Paid time off: Flexible Vacation is provided to all eligible employees assigned to a salaried (non-overtime eligible) position. Accrued Vacation is provided to all other employees eligible for vacation benefits. For employees working at least 35 hours per week, the vacation accrual rate is 13 days annually for the first three years of employment and 18 days annually for subsequent years of employment. Vacation accrual is prorated for employees working between 20 and 34 hours per week. Employees working fewer than 20 hours per week are not eligible for vacation.
- 11 paid holidays
- Paid sick leave: 72 hours of paid sick leave upon date of hire. Refreshes each calendar year. Unused balance will carry over each year up to a maximum cap of 112 hours.
- Paid parental leave
- Adoption assistance
- Employee Stock Purchase Plan
- Financial planning and group legal
- Voluntary benefits including auto, homeowner and pet insurance
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this role…