> Markdown version of [/jobs/ext/4760896-application-software-engineer-2](https://www.wearedevelopers.com/jobs/ext/4760896-application-software-engineer-2). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Application Software Engineer 2 - **Company:** Oracle - **Location:** Kansas City, MO, United States - **Experience:** Starter - **Contract:** Permanent contract - **Skills:** Cerner, Artificial Intelligence, Software Applications, Databases, Software Debugging, Oracle (Applications), Cloud Services, Standard Sql, Software Engineering, SQL Databases, Cerner CCL, Custom Reports - **Published:** November 17, 2026 - **Apply:** https://eeho.fa.us2.oraclecloud.com/hcmUI/CandidateExperience/en/sites/CX_1/requisitions/preview/349015 ## About the Role 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. ## 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.