PLSQL Workflow Developer

Job description

Job Description Senior PLSQL Workflow Developer

Position Overview

We are seeking a skilled and experienced Senior PLSQL Workflow Developer to design develop and maintain highperformance database applications and automated workflow solutions In this role you will bridge the gap between complex database architecture and business process automation You will be responsible for writing optimized database code while leveraging workflow engines Intalio HP KintanaPPMC or similar BPM tools to streamline track and optimize enterprise operations

Key Responsibilities

·        Database Development Optimization

·        PLSQL Programming Design and develop complex packages stored procedures functions triggers and views

·        Performance Tuning Analyze execution plans optimize heavy SQL queries tune PLSQL code and manage indexes to ensure highspeed data processing

·        Data Modeling Assist in designing relational database schemas ensuring data integrity and implementing security best practices

·        Workflow BPM Management

·        Workflow Automation Design configure and deploy endtoend business processes using orchestration tools like Intalio BPM or HP Kintana PPMC

·        System Integration Connect workflow modules with Oracle databases external APIs web services and legacy enterprise systems

·        Process Migration Manage transitions request flows and deployment steps through Kintana packages or Intalio process engines

·        Support Collaboration

·        Troubleshooting Provide tier3 support for complex database bottlenecks and stuck workflow processes in production

·        Collaboration Partner with Business Analysts and Project Managers to translate operational requirements into technical specifications

·        Required Skill Set Qualifications

·        Core Technical Skills

·        Database Strong proficiency in Oracle Database 12c19c21c and expertlevel PLSQL development

·        Workflow Systems Handson experience with at least one major workflow orchestration platform specifically Intalio BPM BPELBPMN or HP Kintana Mercury IT Governance HP PPMC

·        Tools Experience with development utilities like TOAD PLSQL Developer SQL Developer and version control systems Git SVN

·        Web Services Basic understanding of XML JSON SOAP and RESTful web services for workflow integrations

·        Experience Education

·        Education Bachelors degree in Computer Science Information Technology or a related field

·        Experience 3 to 6 years of professional experience in Oracle PLSQL development combined with workflow administrationconfiguration

·        Preferred NicetoHave Skills

·        Experience with JavaJ2EE often used for extending IntalioKintana workflows

·        Knowledge of UnixLinux shell scripting for automated job scheduling

·        Familiarity with AgileScrum development methodologies

Skills

Mandatory Skills : Flexcube technical PL/SQL-Performance Tuning & Shell Scripting, Oracle PL/SQL