Having 4.2 years of experience in Oracle SQL and PLSQL development

 Over 8.8 years of experience in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS). Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation, and maintenance with timely delivery against aggressive deadlines. Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL. Developed materialized views for data replication in distributed environments. Experience in Dynamic SQL,SQL Joins, Anchor Data type, Records and PL/SQL Tables. Loaded Data into Oracle Tables using SQL Loader. Partitioned large Tables using range partition technique. Worked extensively on Cursor, Parameterized Cursor, For Cursor Ref Cursor and Collections, Global temporary table. Expertise in Dynamic SQL, Bulk Collect, Collections and Exception handling. Worked on Joins, Sub Queries and Set Operators, Aggregate function, Analytical Function. Created Tables, SQL statements (DDL,DML,TCL,DCL,DRL) Constraints, Indexes, Roles, sequences, and synonyms. Granted resources privileges to users. Experience of good client interaction and to deal with their requirements. Having knowledge on Linux command . Having knowledge on Github commands. Created AWS instances to connect with Linux machine and creating IAM user.