Job Title: Oracle PL/SQL Developer

Location: Richmond, VA /Day -1 Onsite (Hybrid 3 days office 2 days remote)

Duration: 12 months

Position Summary:

Responsible for developing and delivering complex software requirements to accomplish business goals. Ensures that software is developed to meet functional, non-functional, and compliance requirements.

As part of the PTS/R technology team providing services to internal clients.

The duties and responsibilities include but are not limited to:

Serve as a fully seasoned/proficient technical resource. Will not have direct reports, however may provide technical leadership on projects and direct activities of a team related to projects.

May collaborate with external programmers to coordinate delivery of software application.

Routine accountability is for technical knowledge and capabilities.

Work with minimal supervision, with general guidance from more seasoned team members.

Drive process improvements and innovation

Interpret business requirements into design solutions and understand design and development of project lifecycle

Design the conceptual and physical data model

Adapts best Database design and coding standards, Database coding, Code Unit Testing and Component Integration Testing.

Creation and maintenance of system, functional and reference documentation.

Provide support during testing phases as required, analysis and recommend bug fixes for production incidents, Performance tuning

Report root cause of the incidents and present ideas on how to prevent the incidents from occurring in future

Primary Skill:

Oracle SQL / PLSQL

Secondary Skill

Informatica

Tertiary Skill

MicroStrategy

Required Skills:

OS

Linux

Windows 7

RDBMS

Oracle (Oracle 11g or higher) - 7 years must

PL/SQL, Stored Procedure/Package development

Query Tuning and Optimization

Data Analysis

Strong Communication Skills

Desired Skills:

OS

Hadoop

RDBMS

SQL Server 2012-2014 experience - 3 years nice to have

Teradata/Netezza - 1 year nice to have

ETL development - 5 years (any of the tools below)

SSIS

Informatica

DataStage

Data Integrator

Job Type: Contract

Pay: $60.00 - $65.00 per hour

Expected hours: 40 per week

Benefits:

• 401(k)
• Dental insurance
• Health insurance

Experience level:

• 10 years
• 7 years
• 8 years
• 9 years

Schedule:

• 8 hour shift
• Day shift

Experience:

• Informatica: 2 years (Required)
• Oracle: 7 years (Required)
• PL/SQL: 6 years (Required)

Ability to Commute:

• Richmond, VA 23173 (Required)

Ability to Relocate:

• Richmond, VA 23173: Relocate before starting work (Required)

Work Location: Hybrid remote in Richmond, VA 23173