PL-SQL Developer - Database Architecture (4-8 Yrs) Pune (Systems/Product Software)

Job Description : - Hands on coding in SQL and PLSQL - Create/implement database architecture for new applications and enhancements to existing applications - Create/implement strategies for partitioning, archiving and maturity models for applications.
-Review queries created by other developers for adherence to standards and performance issues - Interact with Database, Applications analysts and Business users for estimations.
-Do impact analysis of existing applications and suggest best ways of incorporating new requirements - Proactively engage in the remediation of software issues related to code quality, security, and/or pattern/frameworks.
-Development experience in Oracle 11g & PL/SQL (MUST) (advanced features such as BULK processing, Collections, Advanced Queues, Scheduling etc.) - Performance monitoring and tuning efforts, suggest changes to improve performance - Experience in performance tuning using different Oracle tools, like OEM, TKPROF, Explain Plan.
-Good experience of working on UNIX operating system and Shell scripting.

Required Skills : English