Oracle PL SQL Developer

2 weeks ago


Raleigh, United States Serigor Inc. Full time
Job DescriptionJob DescriptionJob Title: Oracle PL SQL Developer (HYBRID)
Location: Raleigh, NC
Duration: 12+ Months

Job Description:
Specific tasks/deliverables and skills for this position include the following:
  • Review Functional and Technical requirements for clarity.
  • Research and analyze existing business documents and processes, including forms and reports, and assist in making recommendations about improvements to processes.
  • Business Rule identification and validation.
  • Assist with the Application design and analysis as well as provide input to the Database design.
  • Document application design and system architecture in accordance with NC DPI standards.
  • PL/SQL development and SQL programming, code documentation and unit testing.
  • Web development experience required.
  • Integration design for data exchange, import and export.
  • Enhance the data model and write stored procedures.
  • Build technical deliverables as directed by Project Manager and the Applications Development/Data Management Team Manager.
  • Report creation and validation (including record control counts, validation checks, etc. per specifications).
  • Resolve any issues found in functional, performance, regression or acceptance testing.
  • Document all technical deliverables (e.g. database schemas, file extracts, intermediate tables/files, reports, processes, procedures, scripts, etc.) as built.
  • Document the data retrieval methods via ETL, FTP and other means utilized to include source, destination, schedule and job controls.
  • Perform training to NC DPI support staff for the maintenance/support of technical deliverables built.
  • Any other duties as determined needed by the Project Manager and/or the Applications Development/Data Management Team Manager with regards to developing data extracts, ETL processes, reports, etc.

Application Developer and DBA tasks completed in accordance with client’s project methodology and to the satisfaction of the Project Manager and Applications Development/Data Management Team Manager.

Assignments are completed accurately and in a timely manner as determined and agreed to by management involved with the assignment of the tasks/deliverables.

Skills:
 SkillRequired / DesiredAmountof Experienceolid developer - Oracle database development, code documentation and unit testing. PL/SQL development and SQL programming. Web development.Required5YearsEnhance the data model and write stored procedures. Report creation and validation.Required5YearsStrong support experience with ability to resolve application issues found during testing or in production.Required5YearsIntegration design for data exchange, import and export. Familiar with ETL and FTP to include source, destination, schedule and job controls.Required3YearsDesign application framework based on requirements documentation utilizing Oracle Database.Nice to have3Years“As Built” application analysis/design and system architecture documentation including database schemas and data retrieval methods.Nice to have3YearsTransitioning application maintenance/support to others including providing PL SQL training and support to technical staff.Required3YearsResearching/analyzing Functional requirements including Business Rule identification and validation, business documents and process improvements.Required3Years

Powered by JazzHR

T4HlhrQobp



  • Raleigh, United States Serigor Inc Full time

    Job Title: Oracle PL SQL Developer (HYBRID) Location: Raleigh, NC Duration: 12+ Months Job Description: Specific tasks/deliverables and skills for this position include the following: Review Functional and Technical requirements for clarity. Research and analyze existing business documents and processes, including forms and reports, and assist in making...


  • Raleigh, United States Serigor Inc Full time

    Job Title: Oracle PL SQL Developer (HYBRID) Location: Raleigh, NC Duration: 12+ Months Job Description: Specific tasks/deliverables and skills for this position include the following: Review Functional and Technical requirements for clarity. Research and analyze existing business documents and processes, including forms and reports, and assist in making...


  • Raleigh, United States Siri InfoSolutions Inc Full time

    Job DescriptionJob DescriptionHi Professional,I hope you are doing good.Please find below requirement and let me know your interest?PL/SQL Developer with AWS Aurora postgresSQLLocation: Raleigh, NC OnsiteDuration: Long termRole Description:elopment with 4 to 6years of experience in PL/SQl Help team with modernizing database code by porting the code to AWS...


  • Raleigh, United States Extreme Networks Full time

    Extreme Networks Named to Computerworld’s 2023 List of Best Places to Work in IT! Over 50,000 customers globally trust our end-to-end, cloud-driven networking solutions and rely on our top-rated services and support to accelerate their digital transformation efforts and deliver progress like never before and with double digit growth year over year, no...


  • Raleigh, United States Focused HR Solutions LLC Full time

    This job is remote and has been since 2020 and has not changed. All work will be completed onsite at the manager's discretion which will most likely not occurOur client has an opening for an Oracle OWD Developer (710923)This position is for 12 months, with the option of an extension, and the client is in Raleigh, NC Experience programming and design of large...


  • Raleigh, United States Focused HR Solutions LLC Full time

    This job is remote and has been since 2020 and has not changed. All work will be completed onsite at the manager's discretion which will most likely not occurOur client has an opening for an Oracle OWD Developer (710923)This position is for 12 months, with the option of an extension, and the client is in Raleigh, NC Experience programming and design of large...

  • Sr. Informatica PC

    2 weeks ago


    Raleigh, United States Omni Inclusive Full time

    Job Description : Minimum 8 years exp as Informatica PC Developer Strong knowledge of ETL testing, with experience in Informatica PowerCenter. Good understanding and experience in writing complex SQL queries (Oracle DB) Basic understanding of PL SQL ? procedures, functions, packages etc. Experience in working in Unix environments, with proficiency in basic...


  • Raleigh, United States Serigor Inc. Full time

    Job DescriptionJob DescriptionJob Title: Senior Applications DBA (HYBRID)Location: Raleigh, NCDuration: 12+ MonthsJob Description:The Client requires a Senior Applications DBA to support migration of Oracle database effort from on-prem to AWS cloud and development support of various applications for the client in AWS Cloud. Primary responsibilities include...


  • Raleigh, United States Serigor Inc. Full time

    Job DescriptionJob DescriptionJob Title: Senior Applications DBA (HYBRID)Location: Durham NCDuration: 12+ MonthsJob Description:The client requires a Senior Applications DBA to support migration of Oracle database effort from on-prem to AWS cloud and development support of various applications for client in AWS Cloud.Primary responsibilities include managing...

  • Software Engineer

    2 weeks ago


    Raleigh, United States PMG Global Full time

    We are sourcing a " Software Engineer - Java/AWS " to work at our client's location in Durham-NC . The Expertise and Skills You Bring Bachelor’s degree in a technology-related field (e.g. Engineering, Computer Science, etc.) 3+ years of experience designing, developing, and deploying cloud-based applications in a financial services environment in AWS or...

  • OIM Developer

    3 days ago


    Raleigh, United States Zortech Solutions Full time

    Job DescriptionJob DescriptionRole: OIM DeveloperLocation: Raleigh NC (100% Onsite) Need email confirmation from candidate along with submissionDuration: 6+ MonthsJob Description:5+ years' experience in working in OIM (Oracle Identity Manager) & have handled completed lifecycle of integration. Have deployed various connectors including AD, RACF,...


  • Raleigh, United States Cynet Systems Full time

    Job Description: Responsibilities: Build a framework within MS PowerApps Portal to enable self-service case management, including opening and reviewing cases, appending notes, and attachments. Implement a SQL database connector within Dataverse to enable PowerApps to query a local SQL database, automate cross-checks between a currently authenticated...

  • Senior .NET

    2 weeks ago


    Raleigh, United States Indotronix International Corporation Full time

    Position: Senior .NET / Angular / SQL Server Developer Location: Plano, TX, Charlotte, NC, Hopewell, NJ Duration: 6 Months • Looking for min 8+ years of experience • We are seeking a highly skilled and experienced Senior .NET / Angular / SQL Server Developer • Designing, developing, and maintaining robust and scalable applications using the .NET...


  • Raleigh, United States Serigor Inc. Full time

    Job DescriptionJob DescriptionJob Title: MS Power Platform Developer & Architect (Remote)Location: Raleigh, NCDuration: 6 TO 12+ MonthsJob Description:We are seeking a highly skilled and motivated MS Power Platform Business Analyst to join our team. The successful candidate will be responsible for building and implementing innovative solutions using...


  • Raleigh, United States forhyre.com Full time

    Job Description Job Description We are looking for a Middleware Administrator to provide enterprise-level assistance to our customers. This position will be an administrator for Day-to-day Middleware operations and support work for on-premise data center. For example: creating and modifying instances for Apache web server, WebLogic, Tomcat / JBoss instances,...


  • Raleigh, United States Cynet Systems Full time

    Job Description: Responsibilities: Build a framework within the MS PowerApps Portal to enable self-service case management, including opening and reviewing cases, and appending notes and attachments. Implement a SQL database connector within Dataverse to enable PowerApps to query a local SQL database, automate cross-checks between a currently...


  • Raleigh, United States Crescens Full time

    Job title : MS SQL Server Consultant Location: Raleigh, NC / REMOTE Duration : 3+ Months Job Description: Serve as a lead in drafting of requirements document to support development of a web-based data entry portal. The requirements document will entail analysis of current data organization and storage as well as technical guidance and recommendations for...


  • Raleigh, United States JSM Consulting Full time

    Required Experience Minimum of 7 years’ experience training Oracle Financials - Required 7Years Minimum 7 years’ experience developing training content with Articulate Storyline and/or other tools for building simulations and interactive games - Required 7Years Strong interpersonal skills be able to perform in a team environment collaborate with...


  • Raleigh, United States Crescens Full time

    Job title : MS SQL Server Consultant Location: Raleigh, NC / REMOTE Duration : 3+ Months Job Description: Serve as a lead in drafting of requirements document to support development of a web-based data entry portal. The requirements document will entail analysis of current data organization and storage as well as technical guidance and recommendations...


  • Raleigh, United States Crescens Full time

    Job title : MS SQL Server Consultant Location: Raleigh, NC / REMOTE Duration : 3+ Months Job Description: Serve as a lead in drafting of requirements document to support development of a web-based data entry portal. The requirements document will entail analysis of current data organization and storage as well as technical guidance and recommendations...