• 7-10 years' experience in Oracle Exadata, SQL, PL/SQL
• Implement ETL solutions for large volume of data by applying various data warehouse modeling techniques like Star Schema, Data partitioning, Data compression, Direct path loads etc. and that maximizes re-usable components and services that incorporate versioning, reconciliation and exception handling
• 2-3 years' experience in SQL Performance tuning. Perform application tuning using various tools like EXPLAIN PLAN, SQL TRACE, TKPROF, AUTOTRACE and AWR Reports.
• Should have a clear understanding of Oracle Server Process Architecture and memory structures PGA (Program Global Areas) SGA (System Global Areas) to optimize memory usage.
• Knowledge about Oracle VPD
• Knowledge of Python is a desirable and a plus