Oracle PL/SQL Developer

Veriipro; United States; On-site; USD 95,000 - 140,000; Full time

Job summary

Veriipro is seeking an Oracle PL/SQL Developer to design, develop, test, and maintain database-driven applications and data warehouses for North American clients. You will work across the full development lifecycle and translate requirements into robust technical solutions with application teams and stakeholders.

The ideal candidate has strong Oracle PL/SQL and SQL tuning skills, experience with Unix/Linux environments, and familiarity with data warehousing concepts.

Qualifications

• Strong Oracle PL/SQL and SQL skills.
• Experience tuning SQL queries for performance.
• Familiarity with Unix/Linux environments and shell scripting.
• Experience working with North American clients is a plus.

Responsibilities

• Design, develop, test, and maintain database-driven applications and data warehouses.
• Develop, optimize, and document PL/SQL programs, procedures, triggers, and functions.
• Collaborate with application teams, analysts, and stakeholders to translate requirements into solutions.
• Develop batch processes for data migration, transformation, and reporting.
• Perform performance tuning and optimization of SQL/PL/SQL code.
• Maintain project documentation and adhere to SDLC processes.
• Model and maintain data warehouse structures (tables, views, functions).
• Provide on-call support as needed, including weekends.

Skills

Oracle PL/SQL

SQL tuning

Unix/Linux scripting

Client communication

Data warehousing

Tools

Quest SQL Navigator

Toad

Job description

We are seeking a skilled Oracle PL/SQL Developer to join our team. The ideal candidate will have strong expertise in PL/SQL, experience working with North American clients, and exposure to Unix/Linux environments. You will be responsible for designing, developing, testing, and maintaining database-driven applications and data warehouses.

Roles & Responsibilities

• Design, develop, test, debug, and document applications to meet user requirements.
• Develop, maintain, and enhance existing PL/SQL programs, stored procedures, triggers, and functions.
• Collaborate with application teams, business analysts, and stakeholders to gather requirements and translate them into technical solutions.
• Develop batch processes for data migration, transformation, and reporting.
• Perform performance tuning and optimization of SQL queries and PL/SQL code.
• Maintain project documentation and adhere to SDLC processes.
• Model, design, and maintain data warehouse structures, including tables, views, and functions.
• Troubleshoot and resolve database-related issues; provide on-call support as needed, including weekends.
• Stay up-to‑date with new coding languages, database technologies, and industry best practices.
• Participate in process analysis, requirement refinement, and provide technical input for system improvements.
• Lead and support tasks in system implementation, operations & maintenance, and software development projects.
• Collaborate with Product Owners and Scrum Masters to assess impact, provide estimates, and participate in agile ceremonies.

Qualifications & Skills

• Strong expertise in Oracle PL/SQL and SQL (advanced queries, performance tuning).
• Experience with Quest SQL Navigator, Toad, or similar tools.
• Knowledge of Unix/Linux and shell scripting.
• Experience with Oracle RDBMS environments (8i, 10g, 11g, 12c).
• Exposure to debugging, troubleshooting, and software maintenance.
• Excellent communication and interpersonal skills, with experience interacting with North American clients.
• Familiarity with financial domain processes is a plus.
• Ability to implement shared components and frameworks in Linux/Solaris environments.
• Knowledge of data warehousing concepts, supply chain planning, or fulfillment modules is an advantage.
• Proven ability to work independently and in a collaborative team environment.
• Willingness to work in North American shift timings and provide on‑call support on weekends.