Oracle Database Developer

Preferred candidate profile :

Oracle Database

• Strong hands-on experience with Oracle 19c/12c/11g.
• Knowledge of tables, views, indexes, sequences, synonyms, constraints and database objects.

2. SQL & PL/SQL

• Advanced SQL queries, joins, subqueries, CTEs and analytical functions.
• Development of Procedures, Functions, Packages, Cursors and Triggers.
• Dynamic SQL and exception handling.

3. Performance Tuning

• SQL query optimization and execution-plan analysis.
• Index optimization and statistics management.
• Troubleshooting slow-running queries and database performance issues.

4. Database Design

• Database schema design and normalization.
• Primary/foreign keys, relationships and constraints.
• Understanding of ER diagrams and data modelling.

5. 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.

6. Database Troubleshooting

• Identification and resolution of Oracle errors.
• Knowledge of locks, blocking sessions, deadlocks and transaction management.
• Debugging and maintenance of PL/SQL code.

7. Database Security

• User and role management.
• GRANT/REVOKE privileges and basic database security concepts.