Description

You will focus 80% of your time on PL/SQL development and query optimization, with the remaining 20% dedicated to basic DBA administrative tasks.

Responsibilities

• Develop, optimize, and maintain PL/SQL stored procedures, triggers, functions, and packages.
• Design and implement database tables, indexes, constraints, and relationships.
• Write complex SQL queries and optimize performance for large datasets.
• Perform DBA tasks including user access control, privileges management, and database security.
• Monitor database performance, resource utilization, and storage management.

Required Skills

• 5+ years of experience in Oracle PL/SQL development.
• Expertise in writing and optimizing PL/SQL procedures, functions, and triggers.
• Experience with SQL query performance tuning and execution plan analysis.
• Knowledge of database design principles, indexing strategies, and normalization.
• Hands-on experience with Oracle 12c, 19c, or newer.
• Basic experience in Oracle DBA tasks, including user management and backup/recovery.
• Familiarity with Oracle Enterprise Manager (OEM) and database monitoring tools.
• Strong debugging and problem-solving skills.

Preferred Skills

• Experience collaborating with DBA teams on upgrades, patches, and maintenance.

Key Skills

Education

Any Graduate