PL/SQL Developer - North Carolina, United States - SynapOne

SynapOne North Carolina, United States

4 weeks ago

Description

Title: NCDPI - Oracle PL SQL Developer

Location: NC(HYBRID)

Client: State of North Carolina

Short Description:

Oracle Developer responsible for PL/SQL and SQL programming, development, business analysis. Requires working knowledge of application architecture, analysis and design.

Onsite two days a week.

Specific tasks/deliverables and skills for this position include the following: 1. Review Functional and Technical requirements for clarity.

2. Research and analyze existing business documents and processes, including forms and reports, and assist in making recommendations about improvements to processes.

3. Business Rule identification and validation.

4. Assist with the Application design and analysis as well as provide input to the Database design.

5. Document application design and system architecture in accordance with NC DPI standards.

6. PL/SQL development and SQL programming, code documentation and unit testing.

7. Web development experience required.

8. Integration design for data exchange, import and export. 9. Enhance the data model and write stored procedures.

10. Build technical deliverables as directed by Project Manager and the Applications Development/Data Management Team Manager.

11. Report creation and validation (including record control counts, validation checks, etc. per specifications).

12. Resolve any issues found in functional, performance, regression or acceptance testing.

13. Document all technical deliverables (e.g. database schemas, file extracts, intermediate tables/files, reports, processes, procedures, scripts, etc.) as built.

14. Document the data retrieval methods via ETL, FTP and other means utilized to include source, destination, schedule and job controls.

15. Perform training to NC DPI support staff for the maintenance/support of technical deliverables built.

16. 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 DPI'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.

Required/Desired Skills

Required /DesirSolid developer - Oracle database development, code documentation and unit testing. PL/SQL development and SQL programming. Web development.

Enhance the data model and write stored procedures. Report creation and validation.

Strong support experience with ability to resolve application issues found during testing or in production.

Integration design for data exchange, import and export. Familiar with ETL and FTP to include source, destination, schedule and job controls.

Design application framework based on requirements documentation utilizing Oracle Database.

"As Built" application analysis/design and system architecture documentation including database schemas and data retrieval methods.

Transitioning application maintenance/support to others including providing PL SQL training and support to technical staff.

Researching/analyzing Functional requirements including Business Rule identification and validation, business documents and process improvements.

oracle pl/sql

3 weeks ago

Omni Inclusive Washington, United States

This position is for a highly motivated, driven individual with a passion for Application database development. The role is aligned with a project involving full software development lifecycle support (SDLC). The candidate must have 5+ years of experience in handling multi-databa ...
LU SQL Developer

3 weeks ago

Focused HR Solutions Columbia, United States Freelance

This job is 100% on-site in Columbia, SC. · Our direct client has an opening for a SQL Developer · This position is up to 12 months, with the option of extension, and is in Columbia, SC Corp to Corps are NOT allowed for this client. · General Information · Job Description:Scope ...
LU SQL Developer

1 week ago

Focused HR Solutions Columbia, United States Freelance

This job is 100% on-site in Columbia, SC. · Our direct client has an opening for a SQL Developer · This position is up to 12 months, with the option of extension, and is in Columbia, SC Corp to Corps are NOT allowed for this client. · General Information · Job Description:Scope ...
SQL Developer

2 days ago

ACL Digital Washington, United States

Primary Responsibilities and Duties Design stable, reliable, and effective databases · Optimize and maintain legacy systems · Modify databases according to requests and perform tests · Solve database usage issues and malfunctions · Liaise with developers to improve applications a ...
SQL Developer

3 weeks ago

Initiate Government Solutions Washington, United States

Founded in 2007, Initiate Government Solutions (IGS) a Woman Owned Small Business. We are a fully remote IT services provider that delivers innovative Enterprise IT and Health Services solutions across the federal sector. Our focus is on data analytics, health informatics, cloud ...
SQL Developer

3 weeks ago

DynaVet Solutions Washington, United States

Job Type · Full-time · Description · The SQL Developer will: · Design, develop, and maintain complex SQL code based on business requirements and new business processes. · The SQL Developer responsibilities include :Performing day to day querying and analysis using SQL queries ...
sql ssis developer

2 weeks ago

Randstad Washington, United States

sql ssis developer. · washington , district of columbia · posted 2 days ago · job details · summary · $35 - $41 per hour · contract · bachelor degree · category computer and mathematical occupations · reference · job details · job summary: · We are looking for a talented S ...
Senior SQL Developer

3 weeks ago

Syms Strategic Group, LLC Washington, United States

Syms Strategic Group (SSG) · is seeking a talented · Senior Structured Query Language (SQL) Developer · Department: · Veterans Affairs · Location: · On-site, Washington, DC · Type: · Full Time · Min. Experience: · Experienced · Security Clearance Level: · Public Trust (MBI ...
CL - Database Developer (sql) - Project Lead

1 week ago

vTech Solution Carolina, United States

Job Description · Job DescriptionRemote 100% · Mon -Fri 8am-5pm. Must be able to work EST standard hours. Could be occasional after-hours/weekend support. Will be coordinated as-needed. · This is EST Hours - please ensure candidates submitted understand and can work this time zon ...
SQL/Informatica ETL Developer

2 days ago

Fusion Technology Washington, United States

SQL/Informatica ETL Developer · Who is Fusion Technology? · Fusion Technology is a performance-driven HUBZone Small Business concern residing in the heart of the beautiful mountainsides of West Virginia, steps away from the Federal Bureau of Investigation's Criminal Justice Inf ...
SQL and .NET Developer

2 weeks ago

Randstad Washington, United States

job summary: · We are looking for a talented SQL Developer to join our team with a Randstad client in Washington, D.C. The ideal candidate will have solid experience with SQL Server Integration Services (SSIS) and be skilled in designing, developing, testing, and maintaining data ...
SQL and .NET Developer

2 weeks ago

Randstad North America, Inc. Washington, United States

We are seeking a skilled SQL & .NET Developer to join our team with a Randstad client in Washington, D.C. In this role, you will be responsible for designing, developing, testing, and maintaining software applications and solutions using Microsoft te .Net, SQL, Developer, Technic ...
SQL/ Talend Developer

1 week ago

Mondo Washington, United States

Apply now: SQL/ Talend Developer, this is a 100% remote opportunity. The start date is ASAP for this contract positio n · Job Title: SQL/ Talend Developer · Location-Type: 100% Remote · Start Date Is: ASAP · Duration: Contract · Compensation Range: $65-75 Per Hour W2 · The ...
SQL Server Developer

3 weeks ago

Recooty Washington, United States

Position · SQL Server Developer · Location · Washington DC · Duration · Long Term Contract · Mandatory Skills: · SQL · SSAS (SQL Server Analysis Services) · SSRS (SQL Server Integration Services · SSIS · Joins Queries · Requirements: · The primary skill requirement is for da ...
Senior SQL Developer

3 weeks ago

Syms Strategic Group, LLC Washington, United States

Syms Strategic Group (SSG) is seeking a talented Senior Structured Query Language (SQL) Developer · Department: Veterans Affairs · Location: On-site, Washington, DC · Type: Full Time · Min. Experience: Experienced · Security Clearance Level: Public Trust (MBI) · Salary Ran ...
SQL/Informatica ETL Developer

5 days ago

Fusion Technology Washington, United States

SQL/Informatica ETL Developer · Who is Fusion Technology? · Fusion Technology is a performance-driven HUBZone Small Business concern residing in the heart of the beautiful mountainsides of West Virginia, steps away from the Federal Bureau of Investigation's Criminal Justice Inf ...
SQL/Informatica ETL Developer

3 weeks ago

Fusion Technology Washington, United States

SQL/Informatica ETL Developer · Who is Fusion Technology? · Fusion Technology is a performance-driven HUBZone Small Business concern residing in the heart of the beautiful mountainsides of West Virginia, steps away from the Federal Bureau of Investigation's Criminal Justice Infor ...
Junior SQL/ETL Developer

3 weeks ago

Arena Technical Resources Washington, United States

Junior SQL/ETL Developer · Location: Washington, DC, US · Job ID: 16213 · Job Description · Job · Description: · Job Title: Junior SQL/Informatica ETL Developer · Job Location: Washington, DC (1 day telework) · clearance: Top Secret · What you?ll do: You will support the ...
Manager-Remote

3 days ago

The Vertex Company North Carolina, United States Full time

Working across the globe, V2X builds smart solutions designed to integrate physical and digital infrastructure from base to battlefield. We bring 120 years of successful mission support to improve security, streamline logistics, and enhance readiness. Aligned around a shared purp ...
Information Technology Support Administrator/ Assistant Manager-Remote

6 days ago

The Vertex Company North Carolina, United States Full time

Information Technology Support Administrator (ITSA) / Assistant Manager – Remote Role · This is a full-time Salary exempt Remote Role. · Working across the globe, V2X builds smart solutions designed to integrate physical and digital infrastructure from base to battlefield. We ...