Oracle PL/SQL Developer - Richmond, United States - HexaQuEST Global, Inc.

    Default job background
    Description

    Job Description:

    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

    RDMS

    • 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

    • SQLServer experience - 3 years nice to have
    • Teradata/Neteeza - 1 year nice to have
    ETL development - 5 years (any of the tools below)


    • SSIS
    • Informatica
    • DataStage
    • Data Integrator