Oracle PL/SQL Developer

Veriipro; Boston (MA); On-site; USD 100,000 - 130,000; Full time

Job summary

Veriipro is seeking an experienced Oracle PL/SQL Developer in Boston to design and maintain scalable database solutions. The ideal candidate should have 8-12 years of hands-on experience and expertise in Oracle SQL and PL/SQL programming.

You will be responsible for developing complex Oracle PL/SQL packages, performance tuning, and collaborating with various business teams to deliver high-quality applications.

Qualifications

• 8–12 years of hands-on experience in Oracle Database development.
• Strong expertise in Oracle SQL and PL/SQL programming.
• Experience developing packages, procedures, and optimization.

Responsibilities

• Design, develop, and maintain Oracle PL/SQL packages for enterprise applications.
• Optimize SQL queries for performance and efficiency.
• Collaborate with business teams to deliver high-quality applications.

Skills

Oracle SQL

PL/SQL programming

Database performance tuning

SQL optimization

Data modeling

Debugging

Agile/Scrum

Education

Bachelor's degree in Computer Science or related field

Tools

Git

Oracle Cloud

AWS RDS for Oracle

Job description

We are seeking an experienced Oracle PL/SQL Developer with strong expertise in Oracle database development, performance tuning, and SQL optimization. The ideal candidate will be responsible for designing, developing, and maintaining scalable database solutions while collaborating with application development and business teams to deliver high-quality enterprise applications.

Roles and Responsibilities

• Design, develop, test, and maintain complex Oracle PL/SQL packages, procedures, functions, triggers, and views.
• Develop and optimize complex SQL queries for high-performance enterprise applications.
• Analyze business requirements and translate them into efficient database solutions.
• Perform database performance tuning, query optimization, and execution plan analysis.
• Design and implement data models, database objects, and ETL processes.
• Develop and maintain stored procedures, indexes, materialized views, and database jobs.
• Support data migration, data validation, and database deployment activities.
• Troubleshoot production issues and resolve database-related defects.
• Collaborate with application developers, QA teams, business analysts, and DBAs throughout the software development lifecycle.
• Participate in code reviews and ensure adherence to database development standards and best practices.
• Create and maintain technical documentation for database objects and processes.

Required Skills

• 8–12 years of hands‑on experience in Oracle Database development.
• Strong expertise in Oracle SQL and PL/SQL programming.
• Experience developing packages, procedures, functions, triggers, cursors, collections, and exception handling.
• Strong understanding of database design, normalization, and data modeling.
• Experience with query optimization, indexing strategies, and performance tuning.
• Knowledge of Oracle execution plans, SQL Trace, AWR, and performance diagnostics.
• Experience with Oracle versions 12c/19c or later.
• Experience in data migration, data integration, and ETL processes.
• Familiarity with Oracle Scheduler and database security concepts.
• Experience with version control tools such as Git or SVN.
• Strong debugging, analytical, and problem‑solving skills.

Preferred Skills

• Experience with Oracle Forms & Reports (if applicable).
• Knowledge of Shell Scripting or Python for automation.
• Familiarity with Unix/Linux environments.
• Experience with cloud database platforms such as Oracle Cloud or AWS RDS for Oracle.
• Exposure to CI/CD pipelines and DevOps practices.
• Experience working in Agile/Scrum environments.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
• Oracle Database certification is a plus.