Job Description

The Oracle PL/SQL Developer will design, development, optimization, and maintenance of Oracle database applications using PL/SQL. This role requires deep expertise in Oracle database technologies, and strong problem-solving skills. The candidate will collaborate with cross-functional teams to deliver scalable, high-performance database solutions that meet business requirements.

Key Responsibilities:

Database Development:

Design, develop, and implement complex PL/SQL programs, stored procedures, functions, packages, triggers, and views to support business applications. Write efficient, optimized, and maintainable SQL and PL/SQL code for data manipulation, reporting, and ETL processes. Develop and maintain database schemas, tables, indexes, and partitions to ensure performance and scalability.
Performance Optimization:

Analyze and optimize SQL queries and PL/SQL code to improve performance and reduce execution time. Implement partitioning, indexing, and materialized views to enhance database performance.
System Integration:

Collaborate with application developers to integrate Oracle databases with front-end applications, middleware, or third-party systems. Develop and maintain APIs, database interfaces, and data migration scripts for seamless integration.
Documentation and Standards:

Create and maintain technical documentation, including data flow diagrams, ERDs, and code documentation. Adhere to coding standards, version control practices, and change management processes.
Collaboration:

Work closely with business analysts, project managers, and stakeholders to gather requirements and translate them into technical solutions.
Required Skills and Qualifications:

Education: Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent experience). Experience: 5+ years of experience in Oracle PL/SQL development. Proven expertise in Oracle Database versions (e.g., 11g, 12c, 19c, or higher). Experience with large-scale, high-transaction database environments.
Technical Skills:

Advanced proficiency in writing and optimizing complex PL/SQL code (stored procedures, packages, triggers, etc.). Strong knowledge of SQL query optimization, indexing, and performance tuning techniques. Familiarity with Oracle tools like SQL Developer, TOAD, or SQLPlus.
Experience with data modeling tools (e.g., ERwin, Toad Data Modeler). Knowledge of Oracle features like partitioning, materialized views, and advanced queuing. Understanding of database security, roles, and privileges. Familiarity with ETL processes, data warehousing, and tools like Oracle Data Integrator (ODI) or Informatica (a plus).
Job Type: Full-time