Position Overview & Specifications
Role- Pl/SQL DeveloperLocation- Hybrid Role (2-3 days a week onsite in Durham, N.C.)Duration- 6+ MonthsInterview Mode-WebEx Job Description: 6+ years of SQL and PL/SQL and core Java Development experienceKnowledge on Spring boot, UI (Angular) is good to haveProven experience of Oracle PL/SQL development involving Packages, Procedures, Functions, Triggers, Hints and data migration scriptsHigh 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 LocksExperience working with UNIX shell scripts with intermediate debugging and development skillsExperience working with version control tools Stash, GITHUB, (SourceTree, clearcase), Release Management build tools (Jenkins, buildforge), collaboration tools(Confluence, Sharepoint), Application life cycle management tools (JIRA, PPM) or similarExperience working in Agile Development Environment and exposure to SCRUM Tools and methodologyKnowledge of US Health benefits/HealthCare domain is good to haveExposure on Oracle Applications (R12) is good to haveExcellent Oral & Written communication skills, needs to be proactive, inquisitive, adaptable and trainableCoordinate 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.