PL/SQL Developer

CNSI and Kepro are now Acentra Health!  Acentra Health exists to empower better health outcomes through technology, services, and clinical expertise. Our mission is to innovate health solutions that deliver maximum value and impact. 

Lead the Way is our rallying cry at Acentra Health. Think of it as an open invitation to embrace the mission of the company; to actively engage in problem-solving; and to take ownership of your work every day. Acentra Health offers you unparalleled opportunities. In fact, you have all you need to take charge of your career and accelerate better outcomes – making this a great time to join our team of passionate individuals dedicated to being a vital partner for health solutions in the public sector. 

Acentra is looking for a PL/SQL Developer to join our growing team.

Job Summary:

We are seeking a skilled and experienced PL/SQL Systems Analyst to join our dynamic team in the healthcare IT industry. The ideal candidate will be responsible for analyzing, solutioning, designing, and implementing Oracle PL/SQL stored procedures, packages, functions, and SQLs to support our healthcare software applications. As a PL/SQL Systems Analyst, you will play a crucial role in ensuring the alignment of technology solutions with business needs and driving the success of our healthcare IT projects.

Key Responsibilities:

• Understand the data, business requirement and perform data analysis to support building new PL/SQL object and/or modify existing ones
• Perform code promotions and unit test that the codes are operating correctly
• Perform Technical Review of requirements, analyze source data and provide gap analysis
• Demonstrate the organization’s Core Competencies and values held within
• Collaborate, coordinate, and communicate across disciplines and departments
• Research, construct, develop, and test complex SQL and PL/SQL scripts for new developments
• Coordinate cross-functional projects as assigned and interact with all areas of the organization to achieve timely results
• Work with the advanced features of PL/SQL like collections, nested table, ref cursors, materialize views and dynamic SQL
• Ensure compliance with HIPAA regulations and requirements
• Communicate with end users on functional and logical issue and facilitate discussions to arrive at a solution
• Use of structured coding methodology and to follow organization’s PL/SQL development guideline/coding practice such that the developed code is reusable and shared across projects and of high standard
• Monitor and optimize database and PL/SQL object performance to ensure optimal application response time
• Perform code reviews/walk-throughs and unit testing of code developed by team members
• Work with team members to develop program units that integrate seamlessly into the overall system

Requirements

Required Qualifications:

• Bachelor's degree in computer science, Information Technology, or related field
• 5+ years of experience in PL/SQL development and systems analysis in the healthcare IT industry
• Strong proficiency in database design, data modeling, and PL/SQL programming
• Shell Scripting Knowledge
• Basic Java Working knowledge of Java
• Effective communication, collaboration, and leadership skills
• Knowledge of healthcare industry standards and regulations, such as HIPAA
• Experience with Oracle databases and healthcare software applications

Preferred Technology/Experience

• Data Modeling tools (e.g., ERwin, Oracle SQL Developer Data Modeler)
• Healthcare IT systems and applications
• SQL Tuning and Optimization techniques
• Business Intelligence tools (e.g., Tableau, Power BI)
• ETL (Extract, Transform, Load) tools
• Healthcare data standards (e.g., HL7, FHIR)

Benefits

Why us? 

We are a team of experienced and caring leaders, clinicians, pioneering technologists, and industry professionals who come together to redefine expectations for the healthcare industry. State and federal healthcare agencies, providers, and employers turn to us as their vital partner to ensure better healthcare and improve health outcomes. 

We do this through our people. 

You will have meaningful work that genuinely improves people's lives across the country. We are a company that cares about our employees, and we give you the tools and encouragement you need to achieve the finest work of your career. 

Benefits

Benefits are a key component of your rewards package. Our benefits are designed to provide you with additional protection, security, and support for both your career and your life away from work. Our benefits include comprehensive health plans, paid time off, retirement savings, corporate wellness, educational assistance, corporate discounts, and more.  

Compensation 

The pay range for this position is $90,000 - 110,000

“Based on our compensation program, an applicant’s position placement in the pay range will depend on various considerations, such as years of applicable experience and skill level.” 

Thank You!

We know your time is valuable and we thank you for applying for this position. Due to the high volume of applicants, only those who are chosen to advance in our interview process will be contacted. We sincerely appreciate your interest in Acentra Health and invite you to apply to future openings that may be of interest. Best of luck in your search!

~ The Acentra Health Talent Acquisition Team

Visit us at Acentra.com/careers/

EOE AA M/F/Vet/Disability

Acentra Health is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran or any other status protected by applicable Federal, State or Local law.