Expertise in the areas of PL/SQL.
- Having ability to manage Production / Application Support to various Live Application.
- Good knowledge about financial /Lending domain.
- Good knowledge of FinnOne backend and frontend.
- Having good knowledge of Pennant Lending Platform.
- Proficient in Sequences and Synonyms.
- Having good knowledge of Predefined SQL Functions.
- Expertise in development of PL/SQL Stored Functions, Packages, Procedures, cursors, Collections.
- Good knowledge of Referential integrity - Primary Key, Foreign Key, Constraints etc.
- Creating database users and assigning roles, privileges and profiles to users.
- Good Hand on creating database objects Like Views, Indexes, Sequences, Tables.
- Good knowledge about Sub queries.
- Having good knowledge of PL/SQL Cursors, Triggers.
- Good knowledge of implementing DML, DDL, Instead of, Compound Triggers.
- Hands on data base table Partitioning.
- Good knowledge of Optimization and tuning.
