Overview
Skills
Job Details
**This is a W2 position ONLY and Contract-to-Hire
Title: Senior PL/SQL Developer
Terms of Employment
W2 Contract-to-Hire, 6-12 Months
This is a Remote Opportunity (Preferably EST time zone for federal projects 9am to 6PM)
Overview
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 include:
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.
Developsdetailed, 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 Skills & Experience
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 Skills & Experience
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