Job Title: Senior Consultant | Oracle Data Engineering | Hyderabad | Oracle
PL/SQL | 5 to 7 Years | Location – Hyderabad
Strong SQL skills – Query optimization, indexing, and performance tuning
Materialized Views (MViews) – Creation, refresh strategies, and usage
Partitions – Table partitioning strategies and implementation
Database Architecture – Understanding of database structures, performance tuning, and best practices.
- SQL real-time scenarios
- Performance tuning
- MView
- Indexing concepts
- Partitioning strategies
- Data modeling and architecture
- Database design knowledge
- Differences between Oracle 9i and 19c
- Production environment issues and troubleshooting scenarios.
- Other PL/SQL Topic ( Data Quality , GIT , Project Plan and ER Diagram )