Model scrisoare de intentie. Descarca modele pregatite de specialisti dn care merita sa te inspiri
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.roVezi toate job-urile in IT Software active pe Hipo.ro |
Angajator: | IT Smart Systems |
Domeniu: |
|
Tip job: | full-time |
Nivel job: | peste 5 ani experienta |
Orase: |
|
Actualizat la: | 26.06.2017 |
Remote work: | On-site |
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
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.
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: |
|
---|---|
Senior Full Stack PHP Developer Hybrid | |
Senior Associate - UI/UX Developer BUCURESTI, | |
Senior Fullstack Developer (.NET/Angular) Remote | |
Vezi job-uri similare (258) |
Raporteaza eroarea la