Job Responsibilities
Database Development: Design, build, and maintain complex stored procedures, functions, packages, triggers, views, and materialized views to support business applications.
Performance Tuning: Analyze execution plans (Explain Plan), optimizer costs, and indexes to diagnose and optimize slow-running SQL queries and PL/SQL blocks.
Bulk Data Handling: Implement effective bulk processing techniques using BULK COLLECT and FORALL constructs with LIMIT clauses to minimize context switching and manage memory effectively.
Data Integration & ETL: Utilize utilities like Oracle SQL*Loader to load, validate, and process flat/CSV files into core database tables, ensuring proper handling of bad and discarded records.
Collections & Data Structures: Apply appropriate PL/SQL collection types (Associative Arrays, Nested Tables, VARRAYs) based on business requirements and database persistence needs.
Database Maintenance & Support: Manage transactional operations, differentiate between DDL and DML implementations (e.g., DELETE vs. TRUNCATE),



and maintain secure data views.

Qualifications & Experience: -
Database Core: Solid proficiency in Oracle Database architecture, SQL, and PL/SQL.
Performance Optimization: Direct experience reading Execution Plans, using Cost-Based Optimization (CBO) concepts, and configuring composite or function-based indexes.
PL/SQL Mastery: Deep understanding of cursors, exception handling, energetic SQL, and collections (Associative Arrays, Nested Tables, VARRAYs).
Data Migration Utilities: Hands-on experience with Oracle SQL*Loader and handling control files, log files, and bad files.
Views & Storage: In-depth knowledge of simple/complex views, materialized view refresh options, and schema design.
Prior experience working on high-volume financial, loan processing, or core accounting database applications.
Exposure to Oracle Application Express (APEX) or shell scripting is a plus

📌 Oracle Plsql Programmer Mumbai (India)
🏢 Intellect Design Arena
📍 India