1. 9+ years of experience in Database Programming, Web Engineering, and Data Warehouse systems.
2. Expert in the knowledge of Oracle Database, PLSQL programming, OLTP & OLAP database design, Unix Scripting.
3. Familiar with Java programming, JDBC, Hibernate, Java Services, XML and overall web architecture.
4. Strong domain expertise in Financial, E-commerce, Supply Chain, Services, and Education industries.
5. Involved in Data Migration, Data development, Application re engineering, New product development, Enhancement and Perform Tuning projects
6. Experienced in Oracle database internals, Tuning database at application level, designing data access modules, providing strategy for database development, Designing database
7. Designed database applications scalable for high volume OLTP (transaction) systems and multi terabyte OLAP (data warehouse and reporting) systems.
8. Developed batch applications for handling high volume, data access applications for quick response, and ETL applications for ware house systems.
9. Implemented my experience and skills in tuning database at the application level by applying explain plan, sql trace, tkprof, hints, index, partition techniques
10. Tuned SQL queries and PLSQL programs by observing query costs, consistent and direct data gets, cpu cost, elapsed time, and by reducing context switches in PLSQL.
11. Investigated Wait statistics, AWR reports, memory usage, buffer pool, keep...
Read More »