Oracle

Application Software Engineer 2

Oracle
Apply
22 days ago
Kansas City, MO, USAMid Level
H1B sponsor

Base Salary

$74k - $148k/yr

Responsibilities

  • Develop and maintain CCL programs and SQL queries for custom reports in Oracle Health Millennium.
  • Clarify client requirements for data fields, filters, parameters, calculations, and output formats.
  • Identify database tables, relationships, and query logic needed for reporting.
  • Document report logic, data sources, parameters, dependencies, investigations, and resolutions.
  • Test reports against requirements and source data for calculation errors, missing records, and duplicates.
  • Optimize slow-running SQL queries and CCL code.
  • Review report code and coordinate testing and releases with team members and clients.
  • Provide business-hours support and participate in assigned incident rotations with guidance.
  • Investigate report failures and incorrect results using logs, database queries, CCL and SQL code, and reproduced user workflows.
  • Develop and test fixes, confirm resolutions with clients, create knowledge articles, and prioritize requests and defects by severity and impact.

Requirements

  • The SD2 position level requires 1–3 years of SQL/CCL experience.
  • The SD2 position level requires 1–3 years of database management experience.
  • Ability to develop, debug, test, document, and maintain application features, queries, programs, and custom reports.
  • Ability to troubleshoot report failures, optimize query and program performance, and work with clients to resolve issues.
  • Ability to communicate clearly, balance client and business priorities, and escalate issues when appropriate.
  • Ability to follow approved procedures for accessing patient data and handling report outputs.

Benefits

  • Medical, dental, and vision insurance, including expert medical opinion.
  • Short-term and long-term disability, life insurance, AD&D, and supplemental life insurance.
  • Health care and dependent care flexible spending accounts.
  • Pre-tax commuter and parking benefits.
  • 401(k) savings and investment plan with company match.
  • Paid vacation, 11 paid holidays, and paid sick leave.
  • Paid parental leave and adoption assistance.
  • Employee Stock Purchase Plan, financial planning, group legal, and voluntary insurance benefits.
  • U.S.-based employees must complete identity verification involving biometric information as part of onboarding, subject to applicable accommodations; certain roles may also require immunization, occupational health, or drug testing compliance.

Tech Stack

Categories

Oracle

About Oracle

10,000+ employees

Oracle builds database technology, enterprise applications, and Oracle Cloud Infrastructure for companies and governments. Its business spans cloud subscriptions, software licenses, and support services across ERP, HCM, CX, and industry suites, plus NetSuite. Founded in 1977 and headquartered in Austin, Texas, Oracle is a public company traded on the NYSE and serves global customers migrating and running critical workloads in its cloud.

Contact me