Oracle PL/SQL Developer,

We are seeking an experienced Oracle PL/SQL Developer with 10 years of expertise in designing, developing, optimizing, and maintaining Oracle-based systems. The ideal candidate will possess advanced skills in SQL, PL/SQL, and Java, and will have a strong background in database performance tuning and monitoring using Oracle Enterprise Manager (OEM).

Roles and Responsibilities

• Design, develop, and maintain robust PL/SQL programs, including stored procedures, triggers, packages, and functions.
• Collaborate with application teams to integrate database solutions, ensuring data consistency and accuracy.
• Optimize and tune SQL queries and PL/SQL code for performance using Oracle tools and best practices.
• Monitor, diagnose, and resolve database performance issues using Oracle Enterprise Manager (OEM) and other diagnostic utilities.
• Participate in database design and architecture discussions, ensuring proper indexing, partitioning, and storage management.
• Support builds, deployments, and defect resolution alongside QA and DevOps teams.
• Provide ongoing production support, proactively monitoring database health and performance.
• Document technical solutions, database queries, and procedures for long-term maintainability and compliance.

Required Technical Skills

• 10 years of hands-on experience with Oracle Development, including expert-level proficiency in SQL and PL/SQL.
• Strong experience in designing and implementing database objects (tables, triggers, procedures, views, and partitions).
• Proficient in SQL tuning, troubleshooting, SQL trace analysis, and utilizing Oracle utilities (e.g., SQLLDR, Oracle Trace).
• Advanced experience with Oracle Enterprise Manager (OEM) for performance monitoring and optimization.
• Experience with Java, including the integration of database logic with Java applications.
• Strong debugging, troubleshooting, and performance improvement skills in an enterprise-level environment.