Oracle PL/SQL Developer

Oracle PL/SQL Developer | Location: Providence, RI | Contract An immediate opportunity exists for an experienced Oracle PL/SQL Developer to join a dynamic team supporting data-driven initiatives within the healthcare and federal reporting domains. This role involves designing, developing, and maintaining complex database solutions, with a focus on optimizing performance and ensuring data integrity in a fast-paced environment. Key Responsibilities • Designs, implements, and optimizes Oracle database objects, including complex PL/SQL procedures, functions, and packages to support business reporting and data analysis needs. • Analyzes large datasets to develop efficient SQL queries and troubleshoot performance issues. • Collaborates with business resources and technical leads to deliver high-quality database solutions aligned with project requirements. • Implements data validation, quality assurance, and referential integrity measures to ensure data accuracy. • Utilizes version control tools such as Git to manage code repositories and supports continuous integration processes with tools like Jenkins. • Applies knowledge of ETL practices to support data transformation and loading processes, leveraging tools such as Informatica or Pentaho (preferred). • Documents system architecture and database design using UML and other modeling tools. • Supports web development components involving XML, CSS, and JavaScript frameworks such as JQuery, AngularJS, NodeJS, or React. • Maintains awareness of database security practices, including role-based access controls. • Contributes to troubleshooting and debugging complex logical and functional coding errors within large data environments. • Supports reporting initiatives, including those submitted to federal agencies, utilizing data visualization tools like Tableau or Power BI (preferred). Required Qualifications • Bachelor’s degree in Information Technology, Data Analytics, or Computer Science. • 8-10 years of experience with Oracle databases, including writing complex SQL queries and developing PL/SQL objects. • Strong experience with database and SQL performance tuning. • Proficiency in data modeling and data visualization tools (Tableau/Power BI preferred). • Working knowledge of ETL practices and tools such as Informatica or Pentaho. • Excellent understanding of database management systems, including relational database design, security, and query tools like SQL Developer, TOAD, or SQL Navigator. • Strong troubleshooting and debugging skills with large data sets. • Experience with version control systems (Git) and continuous integration tools (Jenkins). • Knowledge of UML for system documentation. • 5+ years of experience in the healthcare or federal eligibility domain, including developing reports for agencies such as Medicaid, SNAP, or TANF. • Ability to work on-site in Providence, RI. Preferred Qualifications • Oracle certifications. • Experience with XML, CSS, and JavaScript frameworks (JQuery, AngularJS, NodeJS, React). • Familiarity with Agile methodologies, especially Scrum, XP, and Kanban. • Experience with enterprise workflow management tools such as JIRA and ServiceNow. • Knowledge of environmental regulatory processes. • Understanding of client-specific technical environments. About Delphi-US - Peacemakers In The Talent War Delphi-US is a national IT Services firm based in Newport, Rhode Island. Delphi attracts our nation's best and brightest Technical & Professional Talent and positions our nation's finest employers to further their competitive advantages. Delphi's core technical focus includes Data Sciences & Analytics, Modern AI/ML Model Monetization, Cloud Engineering, Cyber Security, ERP Rescue; serving domains from sensitive national energy sectors to critical financial services, biomed, life sciences & pharma, major government & municipal institutions, and much of the USA's Fortune 500 corporations. Delphi Associates are deployed on critical IT Projects where their consultative business acumen, comprehensive technical expertise, and committed service mission drives our client's success. Our proprietary skill-based and cultural matching process results in higher qualified project teams, custom curated for our client’s specific technical & functional goals. We are supremely experienced, friendly, professional, and ready to advocate on your behalf. Delphi has an indelible understanding of employer expectations, a track record of project success and we deliver lasting results. 6123