Job Summary and Responsibilities The role is responsible for analyzing defects, troubleshooting production issues, proposing technical fixes, and implementing solutions within defined turnaround times. The candidate will…
Company Overview 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 W…
Skills: Provider relations, Customer service, Medicaid policy, Public speaking, Training delivery
Company Overview 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 W…
EAP On-site Clinician - Full-time in San Francisco, CA (Must be Licensed in California)
United States · On-site
Mid level
Company Overview 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 W…
Skills: Counseling, EAP services, Clinical assessment, Crisis intervention, Case management
EAP On-site Clinician - Full-time in Nogales, AZ (Licensed in Arizona)
Nogales, Arizona, United States · On-site
Mid level
Company Overview 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 W…
Skills: Counseling, Clinical assessment, Crisis intervention, Case management, EAP services
Company Overview 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 W…
Skills: Healthcare program management, Project planning, Leadership, Medicare, Medicaid
Company Overview 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 W…
Skills: Python, Machine Learning, Generative AI, Natural Language Processing, SQL
Company Overview 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 W…
Job Summary and Responsibilities Job Description – Engineering Manager, Product Transformation (.NET) Position Summary We are seeking an experienced Engineering Manager to lead engineering execution for the transfo…
Company Overview 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 W…
Company Overview 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 W…
EAP Consultant Full-Time Remote (Licensed in Texas)
United States · Remote Solely
Mid level
Company Overview 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 W…
Skills: Tele-mental health, Direct counseling, Case management, Crisis intervention, Clinical staffing
Company Overview 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 W…
Skills: Medicaid Systems Design, MMIS Management, SDLC, STLC, Project Management
Clinical Assessor, - RN (Hybrid/Travel) Wake County, NC
Raleigh, North Carolina, United States · Hybrid
Mid level
Company Overview 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 W…
Skills: Clinical Assessment, Case Management, Patient Eligibility Determination, Medicaid Regulations, Home Healthcare
Company Overview 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 W…
Skills: Direct Counseling, Critical Incident Response, Psychoeducational Presentations, Case Management, Clinical Case Staffing
Company Overview 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 W…
Skills: Clinical Assessment, Psychiatric Diagnosis, Medical Record Abstraction, Critical Thinking, Medical Terminology
Company Overview 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 W…
Skills: Presentation Design, Graphic Design, Microsoft PowerPoint, Microsoft Word, Microsoft Excel
Company Overview 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 W…
Skills: Direct Counseling, Critical Incident Response, Psychoeducational Presentations, Case Management, Clinical Case Staffing
Company Overview 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 W…
Skills: Direct Counseling, Critical Incident Response, Psychoeducational Presentations, Case Management, Clinical Case Staffing
Company Overview 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 W…
Skills: Direct Counseling, Critical Incident Response, Psychoeducational Presentations, Case Management, Clinical Case Staffing
Sign up with Clera and we'll reach out the moment a role actually fits you — no more spraying applications into the void.
Full-time
bachelor degree, postgraduate degree
Posted 8d ago
Apply by Aug 4
~40 hrs/week
Responsibilities
The role involves analyzing and resolving production defects, troubleshooting technical issues, and implementing solutions using Oracle PL/SQL. The specialist will collaborate with architects to convert functional requirements into technical logic while adhering to SDLC standards and deployment processes.
Requirements
Candidates must hold a Bachelor's or Master's degree in Computer Science or IT with 5 to 7 years of relevant experience. Strong proficiency in Oracle PL/SQL, database performance tuning, and experience in production support environments are required.
Full job description
Job Summary and Responsibilities
The role is responsible for analyzing defects, troubleshooting production issues, proposing technical fixes, and implementing solutions within defined turnaround times. The candidate will work closely with Technical Leads, Architects, and team members to understand functional requirements, convert use cases into programming logic, and deliver quality code as per organizational coding standards.
The position involves hands-on development and support activities using Oracle PL/SQL, SQL Developer, TOAD, Oracle 12C, and related database technologies. The candidate will also participate in code reviews, release and deployment activities, status reporting, and adherence to SDLC processes and organizational policies.
Key Responsibilities
Analyze defects, identify root causes, propose fixes, and implement solutions.
Troubleshoot and resolve bugs or production issues within minimum turnaround time.
Write, modify, and maintain Oracle PL/SQL packages, stored procedures, functions, views, and complex SQL queries.
Work on performance tuning, materialized views, data dictionaries, and bulk collect concepts.
Convert functional requirements and use cases into pseudocode, programming logic, and technical solutions.
Collaborate with Technical Leads, Architects, and team members to prepare detailed design documents.
Develop code for assigned functionality as per defined coding standards.
Perform code reviews to prevent defects and improve code quality.
Support release and deployment activities.
Use tools such as SVN and JIRA for configuration management, issue tracking, and delivery coordination.
Provide clear and timely status updates to the reporting manager.
Follow SDLC methodologies, organizational processes, and policies.
Support operations-related activities, including weekend work when required.
Job Requirements and Qualifications
Education and Experience
Bachelor’s or Master’s degree in Computer Science, Information Technology, or a related field.
5 to 7 years of relevant work experience.
Experience in operations support work is preferred.
Technical Skills
Strong programming experience in Oracle PL/SQL.
Hands-on experience with Oracle 12C, SQL Developer, TOAD, MySQL, and advanced SQL.
Experience in writing and modifying Oracle PL/SQL packages, stored procedures, functions, views, and complex SQL queries.
Strong understanding of bulk collect concepts, data dictionaries, materialized views, and performance tuning.
Good knowledge of SVN configuration management tool.
Good understanding of JIRA for defect tracking and workflow management.
Strong analytical and troubleshooting skills.
Good understanding of SDLC methodologies.
Ability to understand functional requirements and use cases and convert them into technical logic.
Preferred Skills
Domain knowledge of US Healthcare is preferred.
Experience working in production support or operations support environments.
Ability to work on issue resolution, defect analysis, and deployment support.
Professional Skills
Strong commitment to learning and delivering quality work.
Ability to work effectively in a team environment.
Good written and verbal communication skills.
Strong work ethics and ownership.
Ability to work under pressure and meet deadlines.
Willingness to learn, train, and mentor junior team members.
Other Requirements
Willingness to work in the 3:00 PM to 12:30 AM IST shift.
Willingness to work on weekends, with weekly offs scheduled on weekdays instead of Saturday and Sunday.
Flexibility to support operations and production support activities as needed.
Acentra Health combines knowledge, clinical expertise, and technological ingenuity to modernize the healthcare experience for public and commercial partners and their priority populations. From designing and developing advanced claims, encounter, and provider solutions that drive efficiency and cost savings to delivering clinically focused service models for care management and quality oversight, Acentra Health is accelerating better outcomes. Acentra Health is backed by Carlyle (NASDAQ: CG), a global investment firm.
Acentra Health combines knowledge, clinical expertise, and technological ingenuity to modernize the healthcare experience for public and commercial partners and their priority populations. From designing and developing advanced claims, encounter, and provider solutions that drive efficiency and cost savings to delivering clinically focused service models for care management and quality oversight, Acentra Health is accelerating better outcomes. Acentra Health is backed by Carlyle (NASDAQ: CG), a global investment firm.