Oracle PL/SQL Developer

• *Job Summary**:

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 SQL\*Plus.
• 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

Work Location: In person