Detalle Vacante

Oracle PL/ SQL Developer



Creado desde:
2019-09-06 10:48:27
Ubicación:
MONTERREY,Nuevo León
Vacantes:
2


REQUISITOS Y EXPERIENCIA
REQUISITOS Y EXPERIENCIA

- 3 ?? 5 years experience working with Oracle as an application DBA, primarily PL/SQL in packages
- 1 ?? 2 years experience working with UNIX shell scripting and Cron jobs
- Computer Science or compatible Bachelors Degree
- Excellent communication and teamwork skills (Intermediate to Advance English level)
-Strong initiative & personal accountability

HABILIDADES TECNICAS INDISPENSABLES

Oracle - Required

Experience with Oracle PL/SQL specifically


Oracle Packages

Procedures

Functions

Exception handling

Built-in Packages (DBMS_OUTPUT)

Knowledge of Oracle roles and their usage

Experience with creation of Oracle DDL (Data Definition Language) commands


Table Creation

Table Alterations

Database Normalization

Database Design

Experience with Oracle DML (Data Manipulation Language) commands


Synonyms

Views

Constraints (Primary Keys, Foreign Keys and Indexes)

Merge Command

Insert

Update

Truncate

Data Migration Scripts

Performance monitoring and Tuning


Detail oriented (making changes to production data)
-Follow Standard work
-Write and Maintain Standard work
-Creation of Implementation Plans
-Creation of Testing Plans
-Creation of Backout Plans
-Experience with SQL*PLUS

UNIX - Required


Knowledge of PUTTY (UNIX access)

Understanding of basic UNIX commands

Ability to set up, understand, and maintain Cron jobs

Ability to understand and maintain UNIX shell scripts

Ability to set up and call PL/SQL scripts from UNIX shell scripts

Knowledge of FTP for file transfer between UNIX and Windows

FUNCIONES A REALIZAR

Candidate will work closely with web application development and support team to maintain and improve the Product Lifecycle Management (PLM) applications as an application DBA.

Responsibilities include design, implementation, support, performance tuning, data integrity, data modeling and data refresh of Oracle application databases. It also includes responsibility for following the corporate ITSM policies for data modifications, creating and enhancing the Oracle procedure code for process changes, performing Database updates, migrations and enhancements, maintaining and creating UNIX scripts.





TRABAJA CON NOSOTROS