DBA Developer - HCA Healthcare

Description

The estimate displayed represents the typical salary range of candidates hired. Factors that may be used to determine your actual salary may include your specific skills, how many years of experience you have and comparison to other employees already in this role. The typical candidate is hired below midpoint of the range.

Introduction
Are you passionate about the patient experience? At HCA Healthcare, we are committed to caring for patients with purpose and integrity. We care like family! Jump-start your career as a(an) DBA Developer today with 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
Note: Eligibility for benefits may vary by location.
Come join our team as a(an) DBA Developer. We care for our community! Just last year, HCA Healthcare and our colleagues donated $13.8 million dollars to charitable organizations. Apply Today!

What you will do in this Role:   

• Primary function is to monitor operation of MS SQL database and Jobs, analyze, develop, organize, coordinate, review projects, and produce reports for utilization management, quality improvement, disease management, finance and claims and to develop and maintain systems and user databases. This position is also responsible for production processes related to data management, including interface development and support; EDI infrastructure support; in-house application support.
• Set up and Maintain MS SQL database. 
• Perform various DBA duties. (Replication, backup, recovery, DB security setup/maintenance, etc.) 
• Create, schedule, and maintain reports in SQL Server and Microsoft Access. 
• Monitor jobs run through PPMSI’s scheduler and correct any anomalies. 
• Lead projects for process improvement, reporting infrastructure changes, new report definitions, etc. 
• Document processes and maintain report request logs. 
• Keep upper management informed of system and operational issues. 
• Ensure quality of reports. Develop testing scenarios, with end-user collaboration, conduct thorough testing and build test environments as needed. 
• Coordinate testing of system enhancements/implementations. Coordinate testing with external business partners and data clearing house partners. 
• Maintain the EDI application, including ETL design, development, testing, and deployment activities effectively and efficiently while maintaining existing ETL code and developing new code using SSIS. Maintain EDI trading partner-mapping objects. 
• Develop EDI processes that meet HIPAA compliancy. 
• Interpret the 837P 5010 Professional Consolidated Guide and translate into technical requirements for specialized data exchanges with data partners. Use guide to find root-case of EDI data defects. 
• SQL code tuning as needed to improve performance. 
• Manage small projects like encounter data submission from data partner  

What you will need in this role: 

• Ability to maintain documentation in format, which easily understood by users. 
• Ability to work independently and to prioritize and schedule tasks. 
• Technical writing experience, preferably documenting system procedures. 
• Strong system experience and ability to learn new system structures. 
• Ability to understand system interfaces and organization operations and work as a team member to identify issue and develop solutions. 
• Excellent written and verbal communication skills. 
• Demonstrated analytical skills with ability to review information to resolve user problems. 

Nice to have: 

• ACOM EZConnect 
• NextGen Mirth Connect 
• Arcana AdTempus

REQUIREMENTS: 

Education: 

• Degree, or Work Experience in lieu of Degree

Experience:

• Three years equivalent work experience. 
• Experience in database administration and support in MS SQL Server (2005, 2008, 2012, 2019) required. 
• Experience in troubleshooting and resolving data defects and code defects required. 
• Experience in developing data driven EDI applications using SSIS, T-SQL, C#, VB.NET, and scripting languages (PowerShell, SFTP, WSH) required. 
• Experience in Healthcare IT (emphasis on HIPPA transaction standards); preferably within a health plan/payer environment required. 
• Experience with Claims Systems and processes, utilization review and management concept and finance systems required. 

Physician Services Group is skilled in physician employment, practice and urgent care operations. We are experts in hospitalist integration, and graduate medical education. We lead more than 1,300 physician practices and 170+ urgent care centers. We are HCA Healthcare’s graduate medical education leader. We provide direction for over 260 exceptional resident and fellowship programs. We focus on carrying out value-added solutions. These solutions help physicians deliver patient-centered healthcare. We support HCA Healthcare's commitment to the care and improvement of human life.

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.

"The great hospitals will always put the patient and the patient's family first, and the really great institutions will provide care with warmth, compassion, and dignity for the individual."- 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 DBA Developer 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 and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.