Consulting Application Engineer

Introduction

Experience the HCA Healthcare difference where colleagues are trusted, valued members of our healthcare team. Grow your career with an organization committed to delivering respectful, compassionate care, and where the unique and intrinsic worth of each individual is recognized. Submit your application for the opportunity below:Consulting Application EngineerHCA Healthcare

Benefits

HCA Healthcare offers a total rewards package that supports the health, life, career and retirement of our colleagues. The available plans and programs include:

• Comprehensive medical coverage that covers many common services at no cost or for a low copay. Plans include prescription drug and behavioral health coverage as well as free telemedicine services and free AirMed medical transportation.
• Additional options for dental and vision benefits, life and disability coverage, flexible spending accounts, supplemental health protection plans (accident, critical illness, hospital indemnity), auto and home insurance, identity theft protection, legal counseling, long-term care coverage, moving assistance, pet insurance and more.
• Free counseling services and resources for emotional, physical and financial wellbeing
  
• 401(k) Plan with a 100% match on 3% to 9% of pay (based on years of service)
  
• Employee Stock Purchase Plan with 10% off HCA Healthcare stock
  
• Family support through fertility and family building benefits with Progyny and adoption assistance.
  
• Referral services for child, elder and pet care, home and auto repair, event planning and more
  
• Consumer discounts through Abenity and Consumer Discounts
  
• Retirement readiness, rollover assistance services and preferred banking partnerships
  
• Education assistance (tuition, student loan, certification support, dependent scholarships)
  
• Colleague recognition program
  
• Time Away From Work Program (paid time off, paid family leave, long- and short-term disability coverage and leaves of absence)
  
• Employee Health Assistance Fund that offers free employee-only coverage to full-time and part-time colleagues based on income.

Learn more about Employee Benefits

Note: Eligibility for benefits may vary by location.

We are seeking a Consulting Application Engineer for our team to ensure that we continue to provide all patients with high quality, efficient care. Did you get into our industry for these reasons? We are an amazing team that works hard to support each other and are seeking a phenomenal addition like you who feels patient care is as meaningful as we do. We want you to apply!

Job Summary and Qualifications

The Consulting Application Engineer is skilled in Consulting Oracle PL/SQL applications and leads backend development and performance optimization efforts across mission-critical systems. This role requires deep expertise in Oracle PL/SQL programming, query and system performance tuning, and database architecture. The Consulting Application Engineer will have strong experience enhancing large-scale systems, debugging complex database issues, and optionally supporting or integrating with ETL pipelines.

MAJOR RESPONSIBILITIES

Database Performance Tuning

Analyze and optimize existing PL/SQL code, stored procedures, and queries.

Identify slow-running SQL statements and improve performance using execution plans, indexes, hints, and restructuring logic.

Work with DBAs to improve instance-level performance (e.g., memory, I/O, CPU bottlenecks).

Recommend partitioning, materialized views, and caching where applicable.

High-Quality PL/SQL Development

Design, develop, and maintain complex PL/SQL packages, triggers, procedures, and functions for business-critical applications.

Implement best practices for modular, reusable, and well-documented code.

Collaborate with application developers for seamless integration of business logic into applications.

System Architecture & Design

Participate in technical design and architecture discussions across systems that rely heavily on Oracle backend.

Lead design and review of database schema, normalization strategies, indexing approaches, and data flow models.

Ensure scalability, reliability, and maintainability of data processes and code.

Code Reviews & Mentorship

Review PL/SQL and database code written by others to ensure performance and standards compliance.

Provide mentoring and guidance to junior and mid-level developers.

Set coding standards, naming conventions, and performance benchmarks.

Troubleshooting & Root Cause Analysis

Investigate critical production issues involving data integrity or performance degradation.

Trace application bottlenecks to Oracle DB code and resolve them quickly.

Work across multiple environments (DEV, UAT, PROD) to replicate and resolve issues.

ETL Design and Data Integration

Collaborate with data engineering or ETL teams to ensure smooth data pipelines and transformations.

Optimize PL/SQL code used in ETL batch jobs to handle large datasets efficiently.

(Optional but valuable) Work with tools like DM Express, Oracle Goldengate, IBM Streamset or custom ETL processes written in PL/SQL or Shell.

Collaboration & Leadership

Coordinate across teams including application developers, DBAs, business analysts, QA, and project managers.

Take ownership of technical delivery in large initiatives involving Oracle backend systems.

Present technical designs and performance findings to leadership.

Tools & Technologies

Oracle 19c or later

SQL*Plus, TOAD, SQL Developer

AWR, ADDM, TKPROF, SQL Trace

ETL tools (DM Express, Streamset, Goldengate or PL/SQL ETL scripts)

Version control (Git), CI/CD pipelines (Jenkins or similar)

What qualifications you will need:

EDUCATION

Bachelor's Degree in Computer Science – Required

EXPERIENCE

7 or more years of experience in developing Oracle PL/SQL - Required

Or equivalent combination of education and/or experience could be considered

Other Skills & Experience

Deep understanding of Oracle execution plans, query optimization, and index strategy.

Proficiency in debugging performance issues in high-throughput environments.

Experience with database design for large-scale systems.

Prior experience leading small to medium technical teams is a plus.

Strong analytical and problem-solving skills.

LICENSES, CERTIFICATIONS & TRAINING

Oracle Database PL/SQL Developer Certified Professional - Preferred

HCA Healthcare has been recognized as one of the World's Most Ethical Companies® by the Ethisphere Institute more than ten times. In recent years, HCA Healthcare spent an estimated $3.7 billion in cost for the delivery of charitable care, uninsured discounts, and other uncompensated expenses.

"There is so much good to do in the world and so many different ways to do it."- Dr. Thomas Frist, Sr.
HCA Healthcare Co-Founder

If you find this opportunity compelling, we encourage you to apply for our Consulting Application Engineer opening. We promptly review all applications. Highly qualified candidates will be directly contacted by a member of our team. We are interviewing - apply today!

We are an equal opportunity employer. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.