Senior PL/SQL Developer Atlanta, GA (Remote)
About the position Senior PL/SQL Developer Atlanta, GA (Remote) Duration: 6-12Months Contract to Perm It's a W2 Position 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 centres 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 the 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 the 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 application 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. Responsibilities • 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 the 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 the customer as appropriate. • Tracks and manages work through an internal ticketing system. • Adheres to CMMI standards and process level improvements. • Assists in supporting client presentations and demos. • Provides technical and operational support to projects and programs. • Keeps abreast of new technology and market developments. • 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. Requirements • 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 the 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 Nice-to-haves • 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 ) Apply tot his job