Job Description
Skills: Look for very strong Oracle PL / SQL programming with strong Performance Tuning, Partitioning of tables, Indexing, Bulk Collections (Advanced PL / SQL concepts).
Exp. Level: 5+ years
# of Position: 2
Work Location (also mention if we can consider relocation): Bangalore dell domlur
Max PR for Candidate: 13 LPA
Interview location: Bangalore
Remarks (if any) deadline to share profiles /walk-in deadline/etc
Mode of interview is F2F.
1st round Written Test, 2n round Technical and 3rd round Techno-Managerial
Notice period:- immediate to 15 Days.
Detailed JD
Expert in PL/SQL development for Oracle high demand OLTP/reporting applications (preferably in 11g or above)
Must have thorough understanding, knowledge, exposure to advanced SQL and PL/SQL (collections, Native Dynamic SQL etc).
Extensive experience with Data Transfers/Sharing using Flat Files, DB Links, Web Services
Experience with large databases with high transaction volume in a fast-paced, production environment
Expert in troubleshooting, optimizing, and performance tuning PL/SQL queries/procedures
Experience at Oracle performance tuning Should be able to analyze Execution Plans, TKPROF and AWR reports.
Data Modeling
Experience implementing Materialized views for reporting applications.
Strong Data Analysis skills