Senior Oracle PL/SQL Developer

Presbyterian Healthcare is hiring a Senior Oracle PL/SQL Developer (Remote Eligible) to formulate and define system scope and objectives based on user needs. Devises or modifies procedures to solve complex problems considering computer equipment capacity and limitations, operating time, and form of desired results. Prepares detailed specifications from which programs will be written. Analyzes and revises existing system logic difficulties and documentation as necessary. Competent to work at the highest technical level of all phases of applications systems analysis activities.

Full Time - Exempt: Yes
• Job is based at Rev Hugh Cooper Admin Center
• Work hours: Days

Prefer Qualifications:

This role provides specialized, professional-level support for complex business objectives, requiring experience in application development, troubleshooting, and multi-environment technologies.

Key Responsibilities:

• Develop, test, and troubleshoot code, including stored procedures, packages, triggers, and complex queries

• Serve as the primary technical resource for implementing and maintaining applications

• Provide technical leadership for project implementation and operational support

• Support multiple projects simultaneously with a customer-focused approach

Ideal Candidate:

• Proven experience in application development and support across diverse technologies

• Strong analytical and problem-solving skills with the ability to produce innovative solutions

• Technical experience in Facets, HealthRules Payer or other Claims Processing Systems a plus

• Superior experience with Oracle, SQL, PL/SQL, packages, triggers and views for programming, development, and reporting

• Experience with ETL processes and the use of an Operational Data Store (ODS)

• Experience with EDI transaction sets and knowledge of EDI standards used in healthcare data exchange, such as 834, 835, 820, etc.

• Java development skills desired

• Bachelor s degree in related technical/business area plus 4 years of IT or business experience. 6 years of additional experience can be substituted in lieu of degree

• Provides advanced support for definition/refinement of business requirements and for quality assurance/acceptance testing efforts
• Designs, develops, tests and debugs software components of moderate to high complexity
• Provides implementation, production and upgrade support for software components of moderate to high complexity
• May act as supporting liaison between the application team and the user community, responsible for facilitating communications, coordinating system enhancements, and providing production support.
• Works with user community to define business requirements in sufficient detail and define business use cases that systems configuration, development/enhancement, and/or Operations activities can be pursued.
• Manages the development of user and technical documentation according to department standards.

About Presbyterian Healthcare Services

Presbyterian offers a comprehensive benefits package to eligible employees, including medical, dental, vision, disability coverage, life insurance, and optional voluntary benefits.

The Employee Wellness Rewards Program encourages staff to engage in health-enhancing activities-like challenges, webinars, and screenings-with opportunities to earn gift cards and other incentives.

As a mission-driven organization, Presbyterian is deeply committed to improving community health across New Mexico through initiatives like growers' markets and local partnerships.

Founded in 1908, Presbyterian is a locally owned, not-for-profit healthcare system with nine hospitals, a statewide health plan, and a growing multi-specialty medical group. With nearly 14,000 employees, it is the largest private employer in the state, serving over 580,000 health plan members through Medicare Advantage, Medicaid, and Commercial plans.

AA/EOE/VET/DISABLED. PHS is a drug-free and tobacco-free employer with smoke free campuses.