Oracle PL/SQL Developer

Job description

Oracle PL/SQL Developer

📍 Location: Jersey City, NJ / Addison, TX (Nearby candidates preferred)
💼 Employment Type: W2 Only
🧑‍💻 Experience Required: 10+ Years

Hourly rate: $60 - $70

Role Overview

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.

Work Allocation

• Oracle PL/SQL / Shell / Python / Vertica: 70%

• ETL Transformations (Informatica): 10%

• Unix Shell Scripting & Python: 20%

Primary Skill

• Oracle Database Development, Migration, and Database Testing

Required Qualifications

• 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 .

If you’re interested or know someone who might be a good fit, please share your resume or reach out directly.

Job requirements

Key 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.

Equal Employment Opportunity

TopTechTalent.ai believes that all persons are entitled to equal employment opportunities. TopTechTalent.ai recruits, hires, trains, promotes, disciplines and provides other conditions of employment without regard to a person's race, color, ethnicity, religion, gender, gender identity, or expression, age, national origin, citizenship status, disability, veteran's status, sexual orientation, marital status or other classifications protected under law or Company policy. This includes providing reasonable accommodation for team members' disabilities or religious beliefs and practices.

The government requires TopTechTalent.ai to maintain information on those who seek employment with the company, including their race and sex. Accordingly, to help us comply with this requirement, we encourage you to provide us with the following self-identification information. However, submission of this information is voluntary and refusal to provide it will not affect your opportunity for employment or terms and conditions of employment, if hired. If you do submit this information, it will be kept confidential and will be used in the compilation of data for reporting requirements.

🚫 Third-party recruiters, please do not reach out for this role.

All done!

Your application has been successfully submitted!