Job Summary:
· The role of the Senior PL/SQL Developer is to work under minimal supervision with wide latitude for managing program and project implementation and making significant contributions to project goals and planning efforts. Acentra Health supports a high-volume healthcare data system that is accessed through multiple web portals. This high-volume system operates out of multiple data centers and must reliably be available to its clients 7x24x365
Responsibilities:
Application Support and Maintenance:
· Functions as an individual contributor under minimal supervision, contributing to non-routine problem-solving and/or designs, and implements new software applications or programs; coordinates and plans all the tasks required for implementation, operations and maintenance.
· Analyzes and studies system requirements and develops methods for problem-solving by producing complex flow charts/data flow diagrams and/or associated documents.
· Advises on computer requirements and limitations to help define automation needs.
· Develops detailed, coding-level flowcharts, action diagrams, pseudo codes, and associated documents from high-level flowcharts.
· Collaborates with senior team members on system design, documents and maintains software component specifications in detailed technical design.
· Collaborates with global development and testing team and for the successful delivery of the project
· Leads design discussions with application and program team leads.
· Develops pseudo codes, tables, and narrative descriptions to implement changes.
· Provides technical consultation in solving problems of design and reliability, and in maintaining the ability of the system.
· Writes procedural guidance to be followed by users.
· Maintains files, records, and operational data, and prepares periodic and special reports and other various documents pertaining to assignments.
· Participates in the testing of computer programs, revising and refining all necessary documentation as testing is completed.
· Monitors system errors, diagnoses, and corrects errors.
· Participates in the review of existing programs to make refinements that increase their efficiency.
· Triages production tickets and troubleshoots issues as needed; communicates with customer as appropriate.
General:
· Excellent understanding of how software applications and programs are developed, deployed, and maintained.
· Fully understands the software development life cycle (SDLC) and software testing life cycle (STLC) as well as system support and maintenance processes; demonstrates strong knowledge
of applications methodologies, best practices, and procedures; and applies them to projects to ensure that applications objectives are achieved.
· Demonstrates business knowledge in one or more domains.
· Understands the concept of SLAs / OLAs in support of system operations.
· Tracks and manages work through an internal ticketing system.
· Adheres to CMMI standards and process level improvements.
· Excellent understanding of standard operating procedures in Operations and ITIL processes. Customer:
· Participates in meetings with customer and actively contributes towards resolving problems and walking through design solutions as needed.
· Possesses unwavering commitment to customer service and operational excellence.
· Assists in supporting client presentations and demos.
· Provides technical and operational support to projects and programs.
· Keeps abreast of new technology and market developments.
Talent Development:
· Requests and gives both negative and positive feedback.
· Guides and mentors junior Systems Analyst staff in ensuring compliance with operations release standards and best practices.
· Conducts knowledge transfer to junior Systems Analyst staff and provides training on new techniques and processes.
Required Qualifications
· Bachelor’s degree in Computer Science, Information Systems, or a related field
· 7–11 years of experience in software development across multiple programming languages and operating systems
· Experience with the Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC)
· Experience supporting system operations using ITIL processes
· Advanced experience with relational database development (Oracle, SQL Server)
· Strong PL/SQL development skills, including: o Stored procedures, packages, functions, and triggers o Performance tuning and optimization of complex queries
· Experience working with large datasets and relational database concepts
· Experience with version control and defect management tools (e.g., Git, SVN, JIRA)
· Experience in healthcare industry, RA Process, 835, Claims module
· Strong understanding of client-server architecture
· Experience designing and building scalable, high-availability applications
· Strong analytical and problem-solving skills
· Strong written and verbal communication skills, including the ability to explain technical issues and solutions to stakeholders
· Ability to work independently and collaboratively in cross-functional teams
· Ability to manage multiple priorities and meet delivery commitments
Preferred Qualifications
· Master’s degree in Computer Science, Information Systems, or a related field
· Domain knowledge of Medicare, Medicaid, or other healthcare programs
· Experience with object-oriented analysis and design and modern programming languages (e.g., Java, .NET, SQL)
· Experience with web-based application development and client-server architecture
· Strong understanding of relational database concepts and performance optimization
· Familiarity with UML or similar modeling techniques
· Experience with Linux-based environments and scripting languages (e.g., Python, Perl)
· Familiarity with modern web technologies (e.g., AJAX, XML-RPC)
· Proficiency with Microsoft Office and collaboration tools (e.g., SharePoint, WebEx, Teams)
Never miss an opportunity! Create an alert based on the job you applied for.
