Oracle Database
Robust hands-on experience with Oracle 19c/12c/11g.
Knowledge of tables, views, indexes, sequences, synonyms, constraints and database objects.
SQL & PL/SQL
Advanced SQL queries, joins, subqueries, CTEs and analytical functions.
Development of Procedures, Functions, Packages, Cursors and Triggers.
Agile SQL and exception handling.
Performance Tuning
SQL query optimization and execution-plan analysis.
Index optimization and statistics management.
Troubleshooting slow-running queries and database performance issues.
Database Design
Database schema design and normalization.
Primary/foreign keys, relationships and constraints.
Understanding of ER diagrams and data modelling.
Data Management & Migration
Data migration, bulk data processing and data validation.
Experience with Oracle Data Pump (EXPDP/IMPDP) and SQL*Loader.
Handling large-volume datasets.
Database Troubleshooting
Identification and resolution of Oracle errors.
Knowledge of locks, blocking sessions, deadlocks and transaction management.
Debugging and maintenance of PL/SQL code.
Database Security
User and role management.
GRANT/REVOKE privileges and basic database security concepts.