Principal Pl Sql Engineer
HCA Healthcare
**Description**
**Introduction**
Do you have the career opportunities as a Consulting Pl Sql Engineer you want with your current employer? We have an exciting opportunity for you to join HCA Healthcare which is part of the nation's leading provider of healthcare services, HCA 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 (https://careers.hcahealthcare.com/pages/employee-benefits-and-rewards)
**_Note: Eligibility for benefits may vary by location._**
Our teams are a committed, caring group of colleagues. Do you want to work as a Consulting Pl Sql Engineer where your passion for creating positive patient interactions is valued? If you are dedicated to caring for the well-being of others, this could be your next opportunity. We want your knowledge and expertise!
**Job Summary and Qualifications**
Position Summary
We are seeking a highly skilled Consulting Oracle PL/SQL Engineer to lead 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 ideal candidate 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)
Skills & Experience:
+ 7+ years of hands-on PL/SQL development 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.
Education & Experience:
+ Bachelor's degree Computer Science Required
+ Master's degree Preferred
+ 7+ years of experience in Developing Oracle PL/SQL Required
+ Or equivalent combination of education and/or experience
Licenses, Certifications, & Training:
+ Oracle Database PL/SQL Developer Certified Professional Preferred
Knowledge, Skills, Abilities, Behaviors:
+ Service and Quality Excellence: Ability to demonstrate an uncompromising commitment to delivering exceptional care to create an unmatched value proposition for our patients.
+ Honor our Mission and Values: Ability to build trust and act with authenticity to cultivate a culture of integrity, inclusion, and mutual respect.
+ Effective Decision Making: Ability to make timely, informed decisions that are in the best interest of our patients, employees, providers, community and HCA.
+ Attain and Leverage Strategic Relationships: Ability to develop and strengthen collaborative relationships with both internal and external stakeholders to advance the care of our patients and the growth of HCA.
+ Lead and Develop Others: Ability to lead others to accomplish organizational goals and objectives; provide meaningful coaching and mentoring to increase the capabilities of individuals and teams and drive employee engagement.
+ Communicate with Impact: Ability to deliver information in a clear, concise, and compelling manner to effectively engage others and achieve desired results.
+ Achieve Success through Change: Ability to identify opportunities for improvement and innovation, remove barriers and resistance, and enable desired behaviors.
+ Drive Execution and Financial Results: Ability to commit to the success and financial wellbeing of HCA by challenging others to excel and hold themselves and others accountable for achieving results.
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.
"Bricks and mortar do not make a hospital. People do."- Dr. Thomas Frist, Sr.
HCA Healthcare Co-Founder
If you are looking for an opportunity that provides satisfaction and personal growth, we encourage you to apply for our Consulting Pl Sql Engineer opening. We promptly review all applications. Highly qualified candidates will be contacted for interviews. **Unlock the possibilities and 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.
Por favor confirme su dirección de correo electrónico: Send Email