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.