1. Working as Database developer.
2. Participated in the development and maintenance of database in Banking Product.
3. Extensive experience in developing Stored Procedures, Functions, Triggers, Views, Packages, Exception Handling, Joins, Cursors, Collections/Arrays and Types.
4. Hands on Cursors, Bulk Binding Process and Collections in Oracle, Arrays and Temp Tables in Postgres for better performance.
5. Good development, troubleshooting and debugging experience in Oracle, Postgres databases.
6. Worked Product migration project. As part of it converted Oracle code base with 1500+ tables and thousands of code objects into Postgres database and fine-tuned the code to stabilize in terms of performance.
7. Tuned the bottle neck Queries, Views, Functions and Triggers in PostgreSQL for better performance, used PLPROFILER tool and PG_STAT_STATEMENTS to analyze the behavior of the functions.
8. Proficient in using tools SQL Developer, PL/SQL Developer, SQLPLUS, DBEAVER, Tortoise SVN.
9. Better understanding of Agile methodology and Scrum Call Mechanism.
10. Worked closely with DBA team in stabilizing the migration process from Oracle to Postgres with little or no discrepancies.
11. Proficient in end-to-end development of software products from requirement analysis to system study, designing, coding, debugging, documentation, implementation & maintenance, acquired understanding of Software Development Life-cycle (SDLC).
12. Extensive creation of DDL and DML scripts to make the enhancements to the design of the product.
13. Created new tables,triggers, views, constraints and added numerous columns to the existing tables.
14. Created number of stored procedures and functions for the support of 3i internal upgradation process, ASW scripts which plays a vital role in copying the product configuration data across the instances without modifying the client related customization's to the product.
15. Designed the Entity Relationship (ER) Diagram for the product using Visual Studio.
16. Managed and maintained positive and on-going relationships with clients: coordinating between teams (onsite & Offshore).
17. Excellent problem-solving skills.
18. Good knowledge in debugging the code in both Oracle and Postgres.
19. Worked on DBA activities like creating databases, users, tablespaces, DBLINKS, granting particular permissions to the users, taking DUMPS and restoring the DUMPS.
20. Experienced in interacting with client team to understand the requirement and specification.