PLSQL Developer

Role: PL/SQL Developer (Production Support)

Primary Skill: Oracle PLSQL

Role Description: The PL/SQL Developer (Production Support)

• would need to have at least 2+ years of experience. This Candidate is responsible for providing overall development of solutions involving complex objects using Oracle PL/SQL, Oracle 10/11g/Exadata experience, including designing tables, stored procedures, triggers, and user-defined functions, performance tuning and will offer support and guidance to the other consultants should they run into any process or technical challenge.

Requirements:

• • Strong experience in UNIX shell scripting (Added Advantage)
• • Hands on experience in SQL tuning/Re-writing SQLs in an alternate/better way.
• • Identify performance bottlenecks in PLSQL procedure & eliminate by alternate implementation.
• • Identify suitable business scenario in the existing application and suggest/implement back end procedure implementation.
• • Must be comfortable in creating and maintaining complex PL/SQL packages.
• • Suggest design changes for overall application performance.
• • Help application development team in analysing code impact for the proposed database design change and take it to implementation
• Responsibilities:
• Build, maintain, and enhance all objects packages/functions in PL/SQL to support application process.
• Perform functions including SQL tuning, database application design, and developer support.
• Ability to quickly diagnose the problem areas and come up with solutions and/or workarounds.
• Write clear, concise, well organized technical documentation to maintain standards and procedures
• High-level Document (HLD) and Technical Design Document (LLD) preparation.
• Understand the requirement and analyze on a technical feasibility and design.
• Coding the requirement and proper Check.
• Communicating with client on issue/ ticket about clarification or resolution
• Would be responsible to manage support for one or multiple clients in banking domain.