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

Developer Advocate, Backend (C#, .N…

Freshers/Experienced

Bengaluru, Karnataka

View Details

Last Date: Jan. 28, 2025

Oracle

Senior Cloud support Engineer

Professional

Bengaluru, Karnataka

View Details

Last Date: Feb. 12, 2025

Google

Engineering Manager, Information Re…

Freshers/Experienced

Bengaluru, Karnataka

View Details

Last Date: Jan. 30, 2025

Oracle

Senior Developer - PLSQL with Java

Professional

Bengaluru, Karnataka

View Details

Last Date: May 6, 2025

Google

Product Manager, Workspace Monetiza…

Freshers/Experienced

Bengaluru, Karnataka

View Details

Last Date: Jan. 30, 2025

Oracle

Software Developer 3

Professional

Bengaluru, Karnataka

View Details

Last Date: May 19, 2025

Oracle

Senior Principal Consultant Core Ba…

Professional

Bengaluru, Karnataka

View Details

Last Date: April 23, 2025

Oracle

Network Developer 2

Professional

Bengaluru, Karnataka

View Details

Last Date: Feb. 9, 2025

Oracle

Senior Migration Consultant

Professional

Bengaluru, Karnataka

View Details

Last Date: Jan. 28, 2025

Amazon

Sr. Technical Program Manager, Deni…

Freshers/Experienced

Bengaluru, Karnataka

View Details

Last Date: Jan. 28, 2025

Oracle

Software Developer 3

Professional

Bengaluru, Karnataka

View Details

Last Date: April 23, 2025

Oracle

Site Reliability Developer 4

Professional

Bengaluru, Karnataka

View Details

Last Date: June 9, 2025




More Jobs at Oracle

Oracle

Contracts Administrator 2-Fin

Professional

Bengaluru, Karnataka

View Details

Last Date: March 5, 2025

Oracle

5G Software Engineering Manager

Professional

Bengaluru, Karnataka

View Details

Last Date: April 9, 2025

Oracle

Oracle Database Engineer - RAC

Professional

Bengaluru, Karnataka

View Details

Last Date: June 15, 2025

Oracle

Contracts Administrator 2-Fin

Professional

Bengaluru, Karnataka

View Details

Last Date: July 6, 2025

Oracle

Software Developer 4

Professional

Bengaluru, Karnataka

View Details

Last Date: May 7, 2025

Oracle

Software Developer 3

Professional

Bengaluru, Karnataka

View Details

Last Date: March 30, 2025

Oracle

Applications Developer 3

Professional

Hyderabad, Telangana

View Details

Last Date: Feb. 17, 2025

Oracle

Senior Integrations Developer

Professional

Bengaluru, Karnataka

View Details

Last Date: Feb. 2, 2025

Oracle

Principal Consultant

Professional

Bengaluru, Karnataka

View Details

Last Date: Jan. 28, 2025

Oracle

Associate Technical Consultant - Or…

Professional

Bengaluru, Karnataka

View Details

Last Date: Feb. 18, 2025

Oracle

Senior Software Developer

Professional

Bengaluru, Karnataka

View Details

Last Date: March 28, 2025

Oracle

Software Developer 4

Professional

Bengaluru, Karnataka

View Details

Last Date: June 20, 2025




Actively Recruiting Companies at Bengaluru, Karnataka