Over 12 years of experience in database development and over 7 years as an Oracle PL/SQL Developer in Analysis, Design, and Implementation of Business Applications using the Oracle (RDBMS). Over 4 years in Java. Involved in all phases of the SDLC from analysis, design, development, testing, implementation, and maintenance. I took key roles in development and support the life cycle of projects for many big companies.
- Expertise in Client-Server application development using Oracle 10/11/12, PL/SQL, SQL, JAVA
- Effectively made use of Table Indexes, Table Partitioning, Collections, Analytical functions.
- Strong experience in Data warehouse concepts, ETL(Extract, Transform, Load).
- Developed Complex database objects like Stored Procedures, Functions, Packages, and Triggers using SQL and PL/SQL.
- Experience in Oracle supplied packages, Dynamic SQL, Records, and PL/SQL Tables.
- Partitioned large Tables using range partition technique.
- Experience with Oracle Supplied Packages such as DBMS_%.
- Worked extensively on Ref Cursor, External Tables, and Collections.
- Excellent knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans, and Indexes.
- Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
I'm a Certified Technical Interviewer and conducted many interviews. I can prepare you to pass successfully the technical interview.
I’m more than happy to help you!