Description

You will manage Oracle database environments and develop complex database logic to support data integration and warehousing needs.

Responsibilities

  • Design, develop, and optimize PL/SQL stored procedures, functions, packages, triggers, and anonymous blocks.
  • Implement database structures including tables, indexes, views, and constraints using normalization principles.
  • Optimize SQL queries and PL/SQL code to identify and resolve performance bottlenecks.
  • Manage Oracle database server installation and maintenance for versions 11g and 19c.
  • Execute Oracle Data Pump import/export operations and manage schema modifications.

Required Skills

  • 5+ years of experience in database administration and development.
  • Expertise in Oracle Database 11g and 19c.
  • Advanced PL/SQL development and SQL proficiency (DDL, DML, and DCL).
  • Experience with Data Warehousing design and data modeling.
  • Practical knowledge of ETL processes for data migration and integration.
  • Proficiency with SQL Developer and Toad.
  • Strong technical troubleshooting skills for complex database issues.
  • Any Graduate degree.

Preferred Skills

  • Experience with Snowflake, Javascript, Tibco, or Java.
  • Knowledge of Jasper Reports and Jaspersoft Studio.

Education

Any Gradute