PL/SQL Developer: Oracle DB, Tuning & Cloud

Insight Global; New Albany (OH); On-site; USD 85,000 - 120,000; Full time

Job summary

Insight Global is seeking an experienced Oracle PL/SQL developer to design, implement, and optimize complex database programs in PL/SQL. You will analyze current functionality across packages, functions, and procedures and document findings.

Responsibilities include tuning SQL performance, providing troubleshooting support, and maintaining technical docs. Experience with Oracle Retail and Oracle Cloud Database is preferred; Agile/Scrum participation is expected.

Qualifications

• 3–5 years of experience in an application development environment.
• Strong Oracle PL/SQL development experience.
• Experience with all phases of the software development life cycle, including analysis, design, unit testing, system testing, deployment, and production support.

Responsibilities

• Design, develop, and test complex database programs in PL/SQL.
• Inspect, analyze, and document current functionality in packages, functions, and procedures.
• Ensure database programs are written correctly and comply with current development standards.
• Performance tune SQL statements and application programs.
• Provide technical assistance, problem resolution, and troubleshooting support.
• Create and maintain technical documentation.
• Support Oracle Cloud Database and Oracle Retail product suite environments where applicable.
• Actively participate in Agile ceremonies as part of the Scrum Team.

Skills

Oracle PL/SQL

Oracle Database

SQL performance tuning

Packages, procedures, and functions

Agile / Scrum

Jira

Oracle Retail Product Suite

Oracle Cloud Database

Strong communication

Tools

Oracle SQL Developer

TOAD

GitLab

SVN

Jira

Job description

Insight Global is seeking an experienced Oracle PL/SQL developer to design, implement, and optimize complex database programs in PL/SQL. You will analyze current functionality across packages, functions, and procedures and document findings.

Responsibilities include tuning SQL performance, providing troubleshooting support, and maintaining technical docs. Experience with Oracle Retail and Oracle Cloud Database is preferred; Agile/Scrum participation is expected.