Oracle PL/SQL Developer Job at Career Mentors, LLC, Addison, TX

R003dlRvYmxYWExIVElKeEgwL0MrcDVob3c9PQ==
  • Career Mentors, LLC
  • Addison, TX

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.

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.

Job Tags

Hourly pay, Contract work

Similar Jobs

Digitive Health INC

Travel Licensed Practical Nurse (LPN) Job at Digitive Health INC

 ...Job Title: Travel Licensed Practical Nurse (LPN) Location: Clovis, NM Job Type: Travel Contract Contract Length: 13 Weeks Shift: Night Pay Rate ~$40 $45/hour Job Overview We are seeking a dedicated and compassionate... 

Wyndy

Sitter Job at Wyndy

 ...Pay: $18 - $29 per hour Start Date: In 2 Days Location: Tempe, AZ Part-time sitter needed near the Arizona State University for two kids and a dog. Must be reliable, trustworthy, and experienced in caring for children and pets. Duties include supervising kids... 

BJC Healthcare

Occupational Therapist Home Health Job at BJC Healthcare

 ...Additional Information About the Role B JC Home Health is looking for an Occupational Therapist to help patients build independence and confidence in their own home environments. Service Area : Belleville, Shiloh & OFallon Schedule: MondayFriday... 

MidWestern IT

Entry-Level Junior Financial Analyst - Opening. Job at MidWestern IT

Junior Financial Analyst (0 5 Years) Role Summary: Assist in financial reporting, budgeting, forecasting, and data analysis to support business decision-making. Work closely with senior finance team members to analyze financial performance and identify trends...

Kaleidoscope ABA

ABA Therapist Job at Kaleidoscope ABA

 ...Behavior Therapist (BT) Welcome to Kaleidoscope ABA Therapy, where your passion for making a difference takes center stage! We are on the lookout for dynamic and compassionate Behavior Therapists to join our dedicated team and be part of a transformative journey....