Oracle PL/SQL Developer

Career Mentors, LLC•Mahwah, NJ

1d•$60 - $70•Onsite

About The Position

We are seeking a highly experienced Oracle PL/SQL Developer to design, develop, and optimize database-driven solutions that support critical business processes. The ideal candidate will have strong expertise in Oracle SQL/PLSQL development, database performance tuning, ETL pipelines, and Unix shell scripting, along with experience working in an Agile environment. This role requires close collaboration with business stakeholders and development teams to design scalable data solutions and ensure high data quality across Oracle and Vertica systems.

Requirements

10+ years of experience working with relational and non-relational databases, with a strong focus on Oracle SQL and PL/SQL.
Extensive experience developing Oracle data integration pipelines using SQL, PL/SQL, and Unix shell scripting.
Strong experience with PL/SQL packages, procedures, functions, triggers, and bulk processing.
Hands-on experience with Unix shell scripting (critical skill).
Experience working with job schedulers (Autosys preferred) to automate database processes.
Experience integrating heterogeneous databases such as Oracle and MS SQL Server.
Strong understanding of dimensional modeling, including star and snowflake schemas, facts, and dimensions.
Expertise in Oracle performance tuning using explain plans, indexing strategies, statistics, hints, and SQL optimization techniques.
Experience developing complex Oracle solutions used in APIs, reporting systems, and data warehouses.
Ability to perform POCs/spikes to test new Oracle features or solution approaches.
Strong problem-solving, analytical, and communication skills.
Experience working in Agile development environments.

Responsibilities

Understand stakeholder needs and translate them into scalable database-driven technical solutions.
Analyze existing business processes and implement Oracle-centric optimizations and automation.
Gather and document functional, non-functional, and technical requirements.
Perform data analysis and profiling to identify data quality issues.
Design and implement logical and physical data models, including Oracle schema design.
Develop and maintain complex PL/SQL packages, procedures, functions, and triggers.
Support application testing, data validation, and troubleshooting for Oracle and Vertica database processes.
Identify and resolve database performance issues and data integrity problems.
Document end-to-end workflows, database procedures, and operational runbooks.
Collaborate with development teams to design test cases, debug issues, and maintain high data quality.
Ensure software stability through code reviews, regression testing, unit testing, and UAT.
Support Agile development processes, including story refinement, requirement elaboration, and estimation.
Develop and maintain CI/CD pipelines and industry best practices for Oracle development.
Guide and mentor junior team members both onshore and offshore.
Utilize tools such as Github Copilot and AI-assisted development tools to improve productivity.