Having around 4+ years of Experience in Application development and
Maintenance/Support projects using PYTHON, SQL, PL/SQL with good understanding of different application development tKIRools and technologies.
- Have good experience in SQL and PLSQL development using ORACLE 10g, ORACLE
11g and ORACLE 12c.
- Proficient in Creating Tables, Views, Constraints, Sequences and Synonyms.
- Good experience in creating complex database objects like Stored Procedure,
Functions, Packages, Collections and Triggers.
- Good in PL/SQL programming - SQL tuning, Cursors, User Defined Exception,
Pragma Autonomous Transaction.
- Implemented Bulk collect and for all, Oracle hint, Explain plan, Sys refcursor,
Indexes, Analytical Functions, Dynamic SQL, SQL-Loader and PL/SQL
Collections.
- Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application and stored the rejected data in audit tables.
- Have knowledge on Database Architecture and Performance Tuning.
- Involved in development of code from scratch for the given requirement.
- Experience in Agile/Scrum development methodology.
- Having Good Knowledge in Client-Server application development using
Oracle 11g/10g/12c, PL/SQL, SQL *PLUS.
- 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.
