Oracle PL/SQL Developer

Veriipro; Columbus (OH); On-site; USD 85,000 - 120,000; Full time

Job summary

Veriipro is seeking an Oracle PL/SQL Developer to design, build, and optimize database solutions in Columbus, OH. You will create packages, procedures, functions, and complex queries, and work under Agile/Scrum practices with cross-functional teams.

You will also optimize SQL performance, contribute to SDLC activities, perform troubleshooting, and document standards for ongoing support and maintenance.

Qualifications

• 3-5 years of experience in application development or database development.
• Strong hands-on experience with Oracle PL/SQL and Oracle Database.
• Proficiency in developing packages, procedures, functions, triggers, and SQL queries.
• Experience with SQL performance tuning and query optimization.
• Experience across the full SDLC, including development, testing, deployment, and production support.
• Hands-on experience with Oracle SQL Developer, TOAD, or equivalent tools.
• Experience with GitLab, SVN, or other version control systems.
• Strong troubleshooting, analytical, and problem-solving skills.
• Experience working in Agile/Scrum development environments.
• Strong technical documentation and communication skills.

Responsibilities

• Design, develop, and maintain Oracle PL/SQL applications, database objects, and business logic.
• Develop and maintain packages, procedures, functions, triggers, and complex SQL queries.
• Perform SQL query optimization and performance tuning to improve database application performance.
• Analyze business and technical requirements and translate them into effective database solutions.
• Participate in all phases of the Software Development Life Cycle (SDLC), including analysis, design, development, unit testing, system testing, deployment, and production support.
• Troubleshoot and resolve database, application, and production issues.
• Perform code reviews, testing, debugging, and performance analysis.
• Use Oracle SQL Developer, TOAD, or equivalent database development tools for development and troubleshooting.
• Manage database development code using GitLab, SVN, or similar version control systems.
• Create and maintain technical documentation, development standards, and support procedures.
• Collaborate with application developers, business analysts, QA teams, and other technical stakeholders in an Agile/Scrum environment.
• Track development tasks, defects, and deliverables using Jira or similar tools.

Skills

Oracle PL/SQL

Oracle Database

SQL optimization

GitLab/SVN

Jira

TOAD/SQL Developer

SDLC

Agile/Scrum

Documentation

Troubleshooting

Job description

Roles and Responsibilities

• Design, develop, and maintain Oracle PL/SQL applications, database objects, and business logic.
• Develop and maintain packages, procedures, functions, triggers, and complex SQL queries.
• Perform SQL query optimization and performance tuning to improve database application performance.
• Analyze business and technical requirements and translate them into effective database solutions.
• Participate in all phases of the Software Development Life Cycle (SDLC), including analysis, design, development, unit testing, system testing, deployment, and production support.
• Troubleshoot and resolve database, application, and production issues.
• Perform code reviews, testing, debugging, and performance analysis.
• Use Oracle SQL Developer, TOAD, or equivalent database development tools for development and troubleshooting.
• Manage database development code using GitLab, SVN, or similar version control systems.
• Create and maintain technical documentation, development standards, and support procedures.
• Collaborate with application developers, business analysts, QA teams, and other technical stakeholders in an Agile/Scrum environment.
• Track development tasks, defects, and deliverables using Jira or similar tools.

Required Qualifications

• 3-5 years of experience in application development or database development.
• Strong hands-on experience with Oracle PL/SQL and Oracle Database.
• Proficiency in developing packages, procedures, functions, triggers, and SQL queries.
• Experience with SQL performance tuning and query optimization.
• Experience across the full SDLC, including development, testing, deployment, and production support.
• Hands-on experience with Oracle SQL Developer, TOAD, or equivalent tools.
• Experience with GitLab, SVN, or other version control systems.
• Strong troubleshooting, analytical, and problem-solving skills.
• Experience working in Agile/Scrum development environments.
• Strong technical documentation and communication skills.