Logo
nTech Workforce

Senior PL/SQL Developer - W2 ONLY

nTech Workforce, New York, New York, United States

Save Job

Title: Senior PL/SQL Developer Location: Remote, Preferred EST time zone only

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