Pl/Sql Developer
1+ years of Experience in Application development and Maintenance/Support projects using SQL, PL/SQL, Power bi and Unix Shell Scripting with extensive understanding of different Application development tools and technologies. Having good experience in SQL, Power bi and PLSQL development using ORACLE 10g, ORACLE 11g and ORACLE 12c.Good Knowledge of Supply Chain Planning, Health care & BFSI.Extensive experience in creating complex database objects like stored procedure, Functions, Packages, Collections and Triggers. Experience in Creating Tables, Views, Constraints, Sequences and Synonyms.Proficient in PL/SQL programming - Stored Procedures, Functions and Packages, SQL tuning, Constructing of Tables, Views, Database Triggers, Synonyms, Sequence, Cursors, user defined exception, Pragma Autonomous Transaction, Bulk Collect and for all, Oracle Hint, Explain Plan, Sys ref-cursor, indexes, Analytical Functions, Dynamic SQL, SQL-Loader, External Table etc. Aware of the Concept of Exception handling mechanism in various scope and visibility.Having knowledge on Database Architecture and Performance Tuning.Involved in development of code from scratch for the given requirement.Experience in Agile/Scrum development methodology.Good communicational and interpersonal skills and involved in client interactions for scoping, effort estimates and status reporting.Ability to learn new technologies with minimal time period and excellence in team playing with multi-location teams.Expertise in Client-Server application development using Oracle 11g/10g/12c, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
