Send me more jobs like this

Sorry, This job is expired.

Keywords / Skills : PL/ SQL Developer, Oracle 11g, Oracle 12c, Database design, SQL, DBMS, Dynamic SQL , Data Transfers, Flat Files, DB Links, Web Services, Oracle performance tuning

0 - 1 years
Posted: 2019-08-12

Industry
IT/Computers - Software
Function
IT
Role
Software Engineer/ Programmer
Posted On
12th Aug 2019
Job Ref code
15-00471
Job Description

Job Description
  • Knows Oracle 11g/Oracle 12c architecture
  • Experience in Database design (focused around- normalization, Snapshot usage, Index optimization, explain plan, database interactions, System & inbuilt packages)
  • Must have good experience at SQL (e.g. joins, functions, sub queries, Data Manipulation etc).
  • Expert in PL/SQL development for Oracle high demand OLTP/reporting applications (preferably in 11g or above)
  • Significant experience with Oracle PL/SQL packages (DBMS_*, UTL_*)
  • Must have thorough understanding, knowledge, exposure to advanced SQL and PL/SQL (collections, Native Dynamic SQL etc).
  • Extensive experience with Data Transfers/Sharing using Flat Files, DB Links, Web Services
  • Experience with large databases with high transaction volume in a fast-paced, production environment
  • Expert in troubleshooting, optimizing, and performance tuning PL/SQL queries/procedures
  • Experience at Oracle performance tuning – Should be able to analyze Execution Plans, TKPROF and AWR reports.
  • Data Modeling
  • Experience implementing Materialized views for reporting applications.
  • Strong Data Analysis skills


About Company

Diverse Lynx India Private Limited
Similar Jobs
View All Similar Jobs


Walkin for you