Description

You will design, develop, and optimize database objects within an Oracle environment.

Responsibilities

• Design and implement database programming using SQL and PL/SQL.
• Develop and maintain stored procedures, functions, triggers, and views.
• Build and manage dimensional data models.
• Tune complex SQL queries and manage database performance using AWR reports and partitioning.

Required Skills

• 5-7 years of experience with Oracle 12c or better.
• Expertise in SQL and PL/SQL programming.
• Hands-on experience with stored procedures, functions, triggers, and views.
• Solid understanding of dimensional data modeling.
• Proven ability in database performance tuning and SQL optimization.
• Experience using AWR reports and partitioning for performance management.
• Bachelor’s or Master’s degree in Computer Science or a related field.

Preferred Skills

• Experience with Oracle GoldenGate for database replication.

Key Skills

Education

Any Graduate