Description
RESPONSIBILITIES:
Installation, administration, back up, restore and update Oracle databases running Windows, Linux operating systems.
Monitor and optimization of Oracle databases, using administrative tools and utilities, SQL scripts.
Design and execution of data export, functions synchronization, including modifications of existing procedures. Assistance in specifications and implementation of tables, views, indexes, data integrity, business rules using DDL, DCL, DML and PL / SQL functions, procedures and packages.
Development and modification of stored procedures, triggers, packages for process automation and transactions in an OLTP environment.
Support and adjustment of packages and tasks in the schedulers of Windows, database and OEM.
Creation and management of database schemas.
Manage existing data, correct errors and discrepancies on a daily basis
Management of the database administration department. Assistance in DBMS support MS SQL Server, PostgreSQL.
REQUIREMENTS:
Higher technical education
At least 4 years of technical support experience, minimum 2 years of experience with Oracle databases 10/11/12.
Experience in Linux / Windows environment is required.
Knowledge of Windows, Linux operating systems.
Experience with Oracle eBusiness Suite and Hyperion.
Knowledge of English at least upper intermediate level.
Knowledge of Oracle utilities and tools, relational model, SQL programming.
Oracle certification welcomed. Strong communication skills, ability to work as a team and individually.
Ability to work on a free schedule if necessary.