Senior PL/SQL Developer

Acest job nu mai este activ!

Vezi toate job-urile IT Smart Systems active.


Vezi toate job-urile Senior PL/SQL Developer active pe Hipo.ro

Vezi toate job-urile in IT Software active pe Hipo.ro

Angajator: IT Smart Systems
Domeniu:
  • IT Software
  • Tip job: full-time
    Nivel job: peste 5 ani experienta
    Orase:
  • BUCURESTI
  • Actualizat la: 26.06.2017
    Remote work: On-site
    Scurta descriere a companiei

    We are #ITSS Community – proud, fun and very much alive, always eager to discover, create, succeed and deliver excellency. We are one of the largest Romanian Digital Business Transformation and Fintech Player organization, founded in 2002 in Bucharest.

    Cerinte

    - At least 5 years active in PL/SQL development
    - Experience with leading a team
    - English on good or fluent level

    PL/SQL Knowledge:
    SQL queries and subqueries
    Projections - joins, Cross join (Cartesian product)
    Agregation - group by, having, order by
    Operations with sets – union, union all, minus, intersect, exists, in
    Transactions – savepoint, commit, rollback, autonomous transaction
    Blocks in PL/SQL - Anonymous, Nested
    Procedure, function, package definitions
    Conditions - if-then-else/elsif, case when
    Loops - for, while, exit when
    Variables - scope local vs. global, data types (difference in usage of char.types)
    Dynamical SQL - binding of variables, execute immediate
    Exceptions
    Sequences
    Indexes - primary, unique, secondary, functional indexes
    Explicit cursors
    Collections - bulk collect, forall, values of, indices of
    Triggers - before/after, insert/update/delete, for each row
    Jobs - dba_jobs and dbms_scheduler jobs
    External tables
    Hints
    Materialized views
    Row_id and how to use it
    ORACLE Data Dictionary (basic knowledge about existence of views dba_tables, dynamic views v$xxx, etc.)
    Basic knowledge of some system packages like dbms_xplan, dbms_application_info, utl_file
    Execution plan

    Responsabilitati

    Develop software by scenarios.
    Execute unit tests.
    Cooperate with the test department during testing.
    Cooperate with team leader during creation of technical specification.
    Create and maintenance of programmer documentation.
    If necessary, participate in the deployment of software into the test and development environment.
    Use the following documents and records: technical specification (TS); JIRA; programmer documentation, module documentation.

    Alte informatii

    An international banking services and consumer loan product provider operating in more than 10 countries is about to expand his business across the globe

    Job-uri similare care te-ar putea interesa:

    Hybrid

    Hybrid

    Remote

    Vezi job-uri similare (279)