Senior PL/SQL Developer

Senior PL/SQL Developer

McLean, VA Remote - EST

Duration: 6-12Months

Contract to Perm

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. Client 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 )