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.

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

1. Performance Tuning

- SQL query optimization and execution-plan analysis.

- Index optimization and statistics management.

- Troubleshooting slow-running queries and database performance issues.

1. Database Design

- Database schema design and normalization.

- Primary/foreign keys, relationships and constraints.

- Understanding of ER diagrams and data modelling.

1.



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.

1. Database Troubleshooting

- Identification and resolution of Oracle errors.

- Knowledge of locks, blocking sessions, deadlocks and transaction management.

- Debugging and maintenance of PL/SQL code.

1. Database Security

- User and role management.

- GRANT/REVOKE privileges and basic database security concepts.

📌 Oracle Database Developer (Mumbai)
🏢 Bahwan Cybertek
📍 Mumbai