Synopsis
ü Had total experience 9+yrs good knowledge of Software Development Life Cycle that include requirement analysis, Solutioning approach, supporting, development and testing.
ü Good knowledge on Experience in Database Developer, Oracle PL/SQL, SQL, utPLSQL, Performance Tuning, Data Engineer, PostgreSQL, Snowflake, ETL(SSIS), Oracle Forms/Reports, UNIX, Linux, Shell Scripting
ü Good knowledge of multiple Development tools like Clear case, ALM, JIRA, SVN, Anthill and GITHUB/GITLAB and Bitbucket etc.
ü Worked on the multiple POC’s against new technologies or innovative ideas.
ü Experience on Oracle, SQL Server, PostgreSQL, Snowflake Database with multiple activity like Create Database, Schema, Stages and Tablespace etc.
ü Participated in technical design, code review and performance code review to develop and deliver good quality code.
ü Good Experience in Shell and Python scripting language.
ü Strong Knowledge in Oracle 19c/12c/11g/11g/9i/8i database programming using PL/SQL (Store Procedures, Function, Package, Triggers), developing Replications and standard built-in Oracle packages.
ü Good Experience in performance tuning, generate trace file, DBMS_hprof, DBMS_trace etc.
ü Expertise in creating and maintaining Database Objects like Tables, Indexes, Views, Synonyms, etc.
ü Expertise in complex SQL query, with joins, sub query, analytical function and set operator.
ü Experience in DBMS like SQL Server and knowledge of know-hows of the same and troubleshooting experience.
ü Good Knowledge on Unix commands and shell scripting.
ü Experience performing unit testing, UAT testing, and regression testing
ü Excellent coding skill in Oracle, SQL/PLSQL, Java, utplsql2|3, JSON, API services and D2K, Query writing, Function, Trigger, Procedure, Package.
ü Strong performance tuning and optimization techniques for managing large databases, as well as Collections and Bulk operations.
ü Good experience worked on Agile methodology process in the Organization.