Oracle PL/SQL Developer

Oracle PL/SQL Developer

Key Responsibilities

• PL/SQL Development

  : Design, develop, and implement complex

  PL/SQL packages, stored procedures, functions, and triggers

  for new and existing applications.

• Advanced PL/SQL Concepts

  : Apply

  advanced PL/SQL concepts

  to build efficient, modular, and reusable database components.

• Performance Tuning

  : Conduct comprehensive

  Performance Tuning

  on SQL queries and PL/SQL code, especially in environments with

  huge databases in the tune of TBs

  , to optimize database response times and resource utilization.

• Development Projects

  : Work on end-to-end

  development projects

  , from requirements analysis to deployment and support.

• Database Optimization

  : Identify and resolve database performance bottlenecks, suggesting and implementing effective solutions.

• Collaboration

  : Collaborate with application developers, data architects, and other team members to ensure seamless integration and optimal database design.

• Code Quality

  : Ensure code quality, maintainability, and adherence to best practices and coding standards.

Required Skills and Experience

• Proven experience as an

  Oracle PL/SQL Developer

  on

  development projects

  .
• Strong understanding and application of

  advanced PL/SQL concepts

  .
• Demonstrated experience in

  Performance Tuning

  , specifically on

  huge databases (in the tune of TBs)

  .
• Proficiency in writing complex SQL queries.
• Solid understanding of relational database design and normalization.
• Ability to analyze and troubleshoot complex database issues.