Description

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

This role is remote.

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.

Preferred Skills

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

Key Skills

Education

Any Gradute