PL/SQL Oracle Developer

PL/SQL Oracle Developer

Posted 3 days ago by 1757580401

Negotiable
Outside
Remote
USA

Summary: The role of PL/SQL Oracle Developer involves designing, developing, and maintaining Oracle database solutions with a focus on PL/SQL programming and performance tuning. The ideal candidate will support enterprise-level applications by ensuring database optimization and integrity. Collaboration with application developers and stakeholders is essential for implementing effective database solutions. The position requires a strong technical background in SQL and PL/SQL, along with extensive experience in database management.

Key Responsibilities:

  • Design, develop, test, and deploy PL/SQL packages, procedures, functions, triggers, and views.
  • Write efficient, reusable, and scalable SQL queries for complex business requirements.
  • Perform database performance tuning, query optimization, and debugging.
  • Develop and maintain stored procedures and data integration scripts.
  • Collaborate with application developers, business analysts, and stakeholders to implement database solutions.
  • Ensure data integrity, security, and compliance with organizational standards.
  • Participate in code reviews, unit testing, and documentation.
  • Provide production support, troubleshoot issues, and perform root cause analysis.
  • Work with ETL processes, data migration, and reporting tools as needed.

Key Skills:

  • Bachelor's degree in Computer Science, Information Technology, or related field.
  • 8 years of experience in Oracle PL/SQL development.
  • Strong expertise in SQL, PL/SQL, stored procedures, functions, and triggers.
  • Hands-on experience with performance tuning and query optimization.
  • Knowledge of Oracle 11g/12c/19c databases.
  • Experience with data modeling, database design, and normalization.
  • Familiarity with UNIX/Linux shell scripting.
  • Strong problem-solving and analytical skills.
  • Ability to work in a fast-paced, collaborative environment.

Salary (Rate): undetermined

City: undetermined

Country: USA

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

We are seeking a skilled and detail-oriented PL/SQL Oracle Developer to design, develop, and maintain Oracle database solutions. The ideal candidate will have strong expertise in PL/SQL programming, performance tuning, and database optimization to support enterprise-level applications.


Key Responsibilities

  • Design, develop, test, and deploy PL/SQL packages, procedures, functions, triggers, and views.

  • Write efficient, reusable, and scalable SQL queries for complex business requirements.

  • Perform database performance tuning, query optimization, and debugging.

  • Develop and maintain stored procedures and data integration scripts.

  • Collaborate with application developers, business analysts, and stakeholders to implement database solutions.

  • Ensure data integrity, security, and compliance with organizational standards.

  • Participate in code reviews, unit testing, and documentation.

  • Provide production support, troubleshoot issues, and perform root cause analysis.

  • Work with ETL processes, data migration, and reporting tools as needed.


Required Skills & Qualifications

  • Bachelor s degree in Computer Science, Information Technology, or related field.

  • 8 years of experience in Oracle PL/SQL development.

  • Strong expertise in SQL, PL/SQL, stored procedures, functions, and triggers.

  • Hands-on experience with performance tuning and query optimization.

  • Knowledge of Oracle 11g/12c/19c databases.

  • Experience with data modeling, database design, and normalization.

  • Familiarity with UNIX/Linux shell scripting.

  • Strong problem-solving and analytical skills.

  • Ability to work in a fast-paced, collaborative environment.