Oracle SQL / PLSQL Developer

Oracle SQL / PLSQL Developer

15 Mar 2025
New Jersey, Jerseycity, 07302 Jerseycity USA

Oracle SQL / PLSQL Developer

Vacancy expired!

job summary:

Position Summary



  • Resource to design, develop, maintain and test software, collaborating with the development team and business partners to ensure successful delivery and implementation of application solutions in an agile environment.
  • Should be hands on and able to successfully deliver on time without defects. Ability to analyze, design and support implementation of Oracle PL/SQL, Views, create/modify database tables based on business requirements and specifications

Responsibilities



  • Responsible to develop/modify PL/SQL, SQL Views in Oracle
  • Responsible to create a new tables/modify existing table structure.
  • Performance tuning and good understanding of explain plan
  • Normalization, renormalization and star schema
  • Develops stored procedures, database triggers and SQL queries
  • Must be able to work independently with minimum supervision.
  • Responsible to develop test cases and perform unit testing.
  • Must be able to interact and co-ordinate with distributed team.
  • Must be good in communication skills.
  • Responsible to provide regular task status update to the management

Primary Skill: Oracle SQL / PLSQL


Secondary Skill: Informatica


Tertiary Skill: Agile tools (Bitbucket)


Required Skills



  • Oracle version 11.x & above
  • Experience in Procedures, Functions, Packages, views, Materialized Views, Indexes, Triggers, Constraints, Snapshots, Synonyms, Sequences, Database Links, Bulk collect, Forall, ref cursor, partition tables, Analytical functions, collections, objects and writing complex queries
  • Any version control tool (SVN/Bitbucket)

Desired Skills



  • Informatica, Autosys
  • Unix Concepts
  • Experience on SDM Adoption / Horizon onboarding tools (Bit Bucket, Datical, Jenkins)
  • Agile best practices



location: Jersey City, New Jersey

job type: Contract

salary: $58.26 - 68.26 per hour

work hours: 9am to 5pm

education: Bachelors



responsibilities:


  • Responsible to develop/modify PL/SQL, SQL Views in Oracle
  • Responsible to create a new tables/modify existing table structure.
  • Performance tuning and good understanding of explain plan
  • Normalization, renormalization and star schema
  • Develops stored procedures, database triggers and SQL queries
  • Must be able to work independently with minimum supervision.
  • Responsible to develop test cases and perform unit testing.
  • Must be able to interact and co-ordinate with distributed team.
  • Must be good in communication skills.
  • Responsible to provide regular task status update to the management





qualifications:


  • Experience level: Experienced
  • Minimum 10 years of experience
  • Education: Bachelors


skills:
  • Oracle
  • PL/SQL




  • Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

    At Randstad, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com.

    Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility).



    For certain assignments, Covid-19 vaccination and/or testing may be required by Randstad's client or applicable federal mandate, subject to approved medical or religious accommodations. Carefully review the job posting for details on vaccine/testing requirements or ask your Randstad representative for more information.

    Related jobs

    Job Details

    • ID
      JC49477103
    • State
    • City
    • Job type
      Contract
    • Salary
      USD58 - USD68
    • Hiring Company
      Randstad Technologies
    • Date
      2023-03-15
    • Deadline
      2023-05-14
    • Category

    Jocancy Online Job Portal by jobSearchi.