PL/SQL Developer

Job Description

Basic Qualifications

6+ years of SQL and PL/SQL and core Java Development experience Knowledge on Spring boot, UI () is good to have Proven experience of Oracle PL/SQL development involving Packages, Procedures, Functions, Triggers, Hints and data migration scripts High degree of knowledge and understanding of developing and debugging complex PL/SQL packages involving large data sets, Collections and advanced PL/SQL communications with Oracle Good knowledge on DBLinks, Hints, Performance Tuning and handling Database Locks Experience working with UNIX shell scripts with intermediate debugging and development skills Experience working with version control tools Stash, GITHUB, (AngularSourceTree, clearcase), Release Management build tools (Jenkins, buildforge), collaboration tools (Confluence, Sharepoint), Application life cycle management tools (JIRA, PPM) or similar Experience working in Agile Development Environment and exposure to SCRUM Tools and methodology Knowledge of US Health benefits/HealthCare domain is good to have Exposure on Oracle Applications (R12) is good to have Excellent Oral & Written communication skills, needs to be proactive, inquisitive, adaptable and trainable Coordinate with the Client Managers, Project Co-coordinators, Business Analysts and Testing Teams to ensure timely resolution for all Projects, enhancements, system tickets & defects. Triage technical issues reported by Client teams, performing technical analysis to identify root causes and appropriate remediation steps involving Oracle PL/SQL and related technologies. Participate in Daily SCRUM, Planning/grooming sessions, weekly status and management meetings to discuss progress, issues and challenges. Collaborate with peers and leads on process improvement ideas, policy and procedure enhancements, and opportunities to improve our customer's service experience. Peer testing, code review, and impact analysis of the modules developed by the other team members. Identify inadequately documented areas/processes and ensure documentation is created. Provides technical mentoring to junior team members. On occasion, addresses small groups on technical subjects or demonstrate systems