Oracle PL/SQL Programmer

Found in: Talent US C2 - 2 weeks ago


Trenton, United States Sunrise Systems Full time

Title: Oracle PL/SQL Programmer

Location: Trenton, NJ 08625

Duration: 6 months contract with possible extension.



The PL/SQL Programmer is responsible for writing stored procedures, packages, functions and triggers required by the Web application Team. CURRENT PL/SQL Programming Experience REQUIRED.


Work can be 100% Remote. Local candidates may be asked to work onsite as needed


The PL/SQL Programmer is responsible for writing stored procedures, packages, functions and triggers required by the Application Team. Programmer typically is involved in enhancement and development work. The Programmer works with the Functional Architect and Technical Architect Specialist on an as needed basis to ensure that design and code meets customer requirements.


Duties and Responsibilities:

  • Create PL/SQL packages, procedures, functions and triggers.
  • Write complex SQL queries with sub-queries, analytical functions and inline views.
  • Create technical specifications for junior oracle developers.
  • Review and understand the Application Team's work plan.
  • Provide status of work to Team Lead.
  • Work with Functional Architects to gather and interpret user requirements into design specifications.
  • Determine time estimates.
  • Assist in managing and directing Application Team processes.
  • Coordinate work with other software developers on Application Teams.
  • Problem solving using the functional and technical programming standards.
  • Execute all required process steps.
  • Utilize configuration management tools, design tools, debugging tools, and any other environment specific tools necessary to create, test, and implement an application.
  • Research problems before approaching the Team Lead or Functional Architect for assistance.
  • Follow quality standards and all process steps.


Knowledge and Experience:

  • Extensive expertise in PL/SQL.
  • Use Collections like variable arrays, nested tables.
  • Design, develop and maintain oracle database schemas, tables, standard views, materialized views, synonyms, unique indexes, non-unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors and other database objects.
  • Experience in designing backend Oracle modules for Java applications.
  • Create PL/SQL packages, procedures, functions and triggers.
  • Write complex SQL queries with sub-queries, analytical functions and inline views.


Required Skills:

  • PL/SQL, SQL Plus, SQL Loader - 5 years
  • Oracle 12C/11G - 5 years
  • System Study & Analysis - 5 years
  • Database Object creation (Tables, Views, Synonyms, Procedures, Functions, Triggers) - 5 years



Desired Skills:

  • SQL Tuning using Explain PLAN and TKPROF Utilities - 3 years

Education: Bachelor's Degree or equivalent certification



  • SQL Developer

    Found in: Talent US C2 - 1 week ago


    Trenton, United States Sunrise Systems Full time

    Title: Database Manager/Administrator Location: Hamilton, NJ Duration: 10 months contract with possible extensions. Provides technical leadership for architecture, design, documentation and maintenance of an internal database and related systems. Please note that this is a hybrid role that requires an in-person interview. This role is critical...

  • Project Lead

    1 week ago


    Trenton, United States Barnes & Noble Full time

    Barnes & Noble is the world’s largest retail bookseller and the leading retailer of content, digital media and educational products. We operate over 600 Barnes & Noble bookstores in 50 states and one of the web’s premier e-commerce sites, bn.com. Our Nook Digital business offers a lineup of popular NOOK® tablets and eReaders and an expansive collection...


  • Trenton, United States CareerBuilder Full time

    Responsibilities: Overseeing SAS programming activities from varying aspects: programming, statistical and clinical Create, manage, and maintain the SAS programming algorithm for the clinical study database and data analysis Peer review the submission packages and contribute to the input of SAP and mock TFLs Perform ad hoc analyses to support Phase I to IV...


  • Trenton, United States New York Technology Partners Full time

    Work under the direct supervision of the VP for Business Operations and Development and assist him with IT-related business development and management, proposal writing, financial analysis including: (a) identify, interview and work with IT subject matter experts to understand and gather Clients' business requirements and technical specifications,...


  • Trenton, United States iPivot Full time

    Gather user requirements, analyze procedures and problems to automate and improve existing systems, and review computer system capabilities, workflow, and scheduling limitations. Analyze and recommend commercially available software. Test, maintain, and monitor computer programs and systems. Provide staff and users with assistance solving computer related...


  • Trenton, United States ValueMomentum Full time

    TRAVEL: Must be willing to relocate and work anywhere in the US. Work in Insurance Domain with a focus on organizational deliverables, best practices and client management. Perform duties as Business and Application system analyst and support expert for Insurance frontend and backend applications, Rating Applications, Policy Administration Systems. Identify...

  • Pgr Mgr

    1 week ago


    Trenton, United States CyberTec Full time

    Job title : Pgr Mgr - Power BI Duration : 12 months + Location : Trenton,NJ (Local only, In Person INterview) Req Exp : 8+yrs Rate :$60/hr Client : confidential until I speak to the potential candidates for further details. Required Skills: •Senior level hands-on skills in building Reports, Dashboards, Scorecards and Reports using Power BI •7+ years of...


  • Trenton, United States Cybernetic Search Full time

    Job Type: Permanent/Fixed Term I'm working with a company that is looking to bring on a NetSuite Admin who will manage the daily operations and maintenance of the NetSuite accounting system. Requirements: Experience with SuiteScript, SuiteFlow, and SuiteBuilder. I'm working with a company that is looking to bring on a NetSuite Admin who will manage the daily...


  • Trenton, United States CareerBuilder Full time

    Job Description: Our client is a global consulting firm dedicated to helping the Life Science sector with invaluable insights. Their suite of data analytics and software platforms caters to diverse needs, spanning data science, commercial operations, real-world evidence, and cloud information management. They provide themselves on providing unique advantages...


  • Trenton, United States CareerBuilder Full time

    Job Type: Permanent/Fixed Term I'm working with a company that is looking to bring on a NetSuite Admin who will manage the daily operations and maintenance of the NetSuite accounting system. Requirements: Experience with SuiteScript, SuiteFlow, and SuiteBuilder. I'm working with a company that is looking to bring on a NetSuite Admin who will manage the daily...


  • Trenton, United States CareerBuilder Full time

    Required/Desired Skills Experience in Reporting Experience in Integration of applications using various methods available in PEGA. Primarily experience in SOAP, REST, DB, MQ and email Experience implementing SSO security for PEGA applications and security rule types of PEGA Experience inApplication design/Case design Data Modeling Experience in automation of...


  • Trenton, United States CareerBuilder Full time

    TRAVEL: Must be willing to relocate and work anywhere in the US. Plan and implement the project in a global delivery model, client & scrum team management for delivery of applications, online & batch interfaces, software, banking network and infrastructure using various methodologies Iterative, Waterfall and Scaled Agile (Scrum) Framework. Lead the...


  • Trenton, United States ValueMomentum Full time

    TRAVEL: Must be willing to relocate and work anywhere in the US. Plan and implement the project in a global delivery model, client & scrum team management for delivery of applications, online & batch interfaces, software, banking network and infrastructure using various methodologies – Iterative, Waterfall and Scaled Agile (Scrum) Framework. Lead the...

  • Pega Senior System Architect

    Found in: Appcast US C2 - 1 week ago


    Trenton, United States Software Technology PVT.LTD. Full time

    Required/Desired SkillsExperience in ReportingExperience in Integration of applications using various methods available in PEGA. Primarily experience in SOAP, REST, DB, MQ and emailExperience implementing SSO security for PEGA applications and security rule types of PEGAExperience inApplication design/Case designData ModelingExperience in automation of...


  • Trenton, United States Software Technology PVT.LTD. Full time

    Required/Desired Skills Experience in Reporting Experience in Integration of applications using various methods available in PEGA. Primarily experience in SOAP, REST, DB, MQ and email Experience implementing SSO security for PEGA applications and security rule types of PEGA Experience inApplication design/Case design Data Modeling Experience in automation of...

  • Pega Senior System Architect

    Found in: Appcast Linkedin GBL C2 - 2 weeks ago


    Trenton, United States Software Technology PVT.LTD. Full time

    Required/Desired SkillsExperience in ReportingExperience in Integration of applications using various methods available in PEGA. Primarily experience in SOAP, REST, DB, MQ and emailExperience implementing SSO security for PEGA applications and security rule types of PEGAExperience inApplication design/Case designData ModelingExperience in automation of...


  • Trenton, United States Software Technology PVT.LTD. Full time

    Required/Desired SkillsExperience in ReportingExperience in Integration of applications using various methods available in PEGA. Primarily experience in SOAP, REST, DB, MQ and emailExperience implementing SSO security for PEGA applications and security rule types of PEGAExperience inApplication design/Case designData ModelingExperience in automation of...


  • Trenton, United States Software Technology PVT.LTD. Full time

    Required/Desired Skills Experience in Reporting Experience in Integration of applications using various methods available in PEGA. Primarily experience in SOAP, REST, DB, MQ and email Experience implementing SSO security for PEGA applications and security rule types of PEGA Experience inApplication design/Case design Data Modeling Experience in automation of...

  • Sr.Consultant 2-Tableau

    Found in: beBee S US - 2 weeks ago


    Trenton, United States CapLeo Global Full time

    Title: Sr.Consultant 2-Tableau - Location: Trenton,NJ(REMOTE) Duration:1 year contractShort Description:Sr.Tableau Architect will be working with business and technical group to design, develop, and implement Tableau reporting solution from inception to implementation. Experience with Business Objects is Required.Complete Description:Note: Position can be...


  • Trenton, United States Biogensys Full time

    Job DescriptionJob DescriptionWe are hiring a Health Data Specialist II (USTF/ BEDS) for one of our clients in Hamilton, NJ.Job Description:Abstracts mental health services client and episode information for entry into USTF, QCMR, and other databases as instructed; mines and aggregates this information as needed in accordance with reporting...