Oracle
Senior Database Developer
Job Description
SQL / PLSQL:
Should have developed Complex SQL Queries, Sub-Queries, Correlated Sub-Queries, and Dynamic SQL and understanding of SQL processing.
Created SQL scripts to migrate the data from SQL Loader into the database tables as per the data model and requirements.
Used tools like SQL *Loader to load the data into the database tables from flat files and excel sheets.
Designed/developed tables, views, various SQL queries, stored procedures, function, complex PL/SQL packages for ETL.
Created new tables, views, Indexes, constraints, synonym, DB link, queries, PL/SQL Function, packages, procedures for new enhancement in the application.
Should have worked on collections.
Should have worked on Oracle Database 19c.
Should be aware of new features in Oracle Database 19c and upcoming Oracle 23AI database.
Performance:
Should have Oracle architecture understanding, data dictionary views / catalog views.
Identifying bottlenecks that affect the performance and should have worked on performance tuning issues for SQL queries and Database.
Working knowledge on performance monitoring and reporting utilities. (STATSPACK,AWR,ADDM,SQL Monitoring)
Involved in SQL tuning, PL/SQL tuning and Application tuning using various tools like TKPROF, EXPLAIN PLAN, SQL Monitoring etc.
Tuned SQL queries using indexes, table partitioning, partition swapping.
Involved in optimizing database performance by analyzing database objects, creating indexes, creating materialized views etc.
Should be well versed with the concept of bucketing and should have worked on it.
Should be well versed with scheduling jobs in Oracle Database and troubleshooting the same.
Move data between different database environments using Import/Export.
Career Level - IC3
Jobs at Bengaluru
Amazon
Program Manager ATS, RoW ATS Tech
Freshers/Experienced
Bengaluru, Karnataka
Last Date: April 15, 2025
Oracle
Java, Microservices with Core Banki…
Professional
Bengaluru, Karnataka
Last Date: Sept. 14, 2025
Oracle
Principal Software Developer
Professional
Bengaluru, Karnataka
Last Date: June 3, 2025
Amazon
Applied Scientist I, Alexa AI
Freshers/Experienced
Bengaluru, Karnataka
Last Date: April 15, 2025
Oracle
Principal Consultant - Siebel
Professional
Bengaluru, Karnataka
Last Date: July 1, 2025
Oracle
Principal Member of Technical Staff
Professional
Bengaluru, Karnataka
Last Date: Sept. 15, 2025
Oracle
Site Reliability Engineer 3
Professional
Bengaluru, Karnataka
Last Date: April 15, 2025
Oracle
Principal Technical Account Manager
Professional
Bengaluru, Karnataka
Last Date: April 22, 2025
Software Engineer, Google Nest
Freshers/Experienced
Bengaluru, Karnataka
Last Date: April 17, 2025
Oracle
Oracle Fusion SCM Technical/ Functi…
Professional
Bengaluru, Karnataka
Last Date: Sept. 28, 2025
Oracle
Oracle Fusion Financials Techno Fun…
Professional
Bengaluru, Karnataka
Last Date: June 4, 2025
More Jobs at Oracle
Oracle
Senior Consultant - Application Sup…
Professional
Bengaluru, Karnataka
Last Date: April 26, 2025
Oracle
Senior Advanced Services Engineer, …
Professional
Mumbai, Maharashtra
Last Date: July 26, 2025
Oracle
Oracle CPQ Cloud - Senior Cloud Con…
Professional
Bengaluru, Karnataka
Last Date: May 4, 2025
Oracle
Software Development Snr Manager
Professional
Bengaluru, Karnataka
Last Date: April 22, 2025
Oracle
Senior DevSecops Engineer
Professional
Bengaluru, Karnataka
Last Date: Aug. 20, 2025
Oracle
Principal Cloud Operation Engineer
Professional
Bengaluru, Karnataka
Last Date: Aug. 5, 2025
Oracle
Senior Program Manager-ProdDev
Professional
Bengaluru, Karnataka
Last Date: Aug. 11, 2025
Oracle
Oracle Fusion Consultant - HCM/ERP/…
Professional
Bengaluru, Karnataka
Last Date: June 4, 2025
Oracle
Senior Member of Technical Staff
Professional
Bengaluru, Karnataka
Last Date: Sept. 20, 2025
Actively Recruiting Companies at Bengaluru, Karnataka