Profile
1. Thorough understanding of RDBMS database concepts and a high-level of efficiency working in Oracle Database.
2. Excellent database designing skills.
3. Familiarity with Database modeling using Entity-Relationship and Normalization Techniques.
4. Designed and developed SQL scripts, stored procedures, stored functions, Anonymous blocks, Packages, parameterized queries and objects using tools like SQL Developer, Pl/SQL developer.
5. Excellent hands-on with PL/SQL Collections and DYNAMIC SQL.
6. Good performance tuning skills and I have sound knowledge of concepts like Statistics, Indexes, Query Hints, Joining Algorithms, Explain Plan, Auto Trace, Tkprof and Cost Based Optimizer.
7. Excellent Hands on With UNIX Commands and Shell Scripting.
8. Strong Expertise in XML, Developed data standards, data exchange, XML data standard and Unmarshalling and Marshalling of XMLs.
9. Mailbox/Reports Automations.