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
Job description
Develop and support custom reports for Oracle Health clients as part of the AMS Custom Reporting team. Use CCL and SQL to build reports, troubleshoot reporting issues, and improve report accuracy and performance. Work with clients to define requirements and confirm that reports meet their needs.
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., 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
Position Level SQL/CCL Experience Database Management Experience SD1 0-2 years 0-2 years SD2 1-3 years 1-3 years
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.
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…