The posting
Responsibilities and Requirements:
1. 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.
Education
UG: B.Tech / B.E. in Computer Science and Engineering (CSE), Electronics and Communication Engineering (ECE), Electrical and Electronics Engineering (EEE)
Experience:
- 10+ years development experience with Oracle Database version 9i /10g / 11g /12c
- Manage all phases of the SDLC from analysis, design, development, testing, implementation and maintenance.



