Pl SQL Lead - Guadalajara, México - The Brick Soluciones

The Brick Soluciones

Empresa verificada

Guadalajara, México

hace 2 semanas

Publicado por:

Rodrigo Fernández

Reclutador de talento para beBee

Descripción

Acerca del puesto PL SQL Lead (Inglés Avanzado):

Buscamos
PL SQL Lead para trabajar en modalidad Híbrida en una importante empresa transnacional de tecnología ubicada en la ciudad de Guadalajara Jalisco.

OFRECEMOS
**Sueldo de $60,000 a $80,000 pesos mensuales brutos, Negociables
Esquema de bonos por objetivos

Prestaciones de Ley

Esquema de trabajo; Híbrido (2 días de Home Office a la semana)

Zona de trabajo:
Guadalajara Zona Country Club, Av. Américas

Requisitos:

Inglés Avanzado (Las entrevistas se realizarán en inglés)

Vivir en Guadalajara o estar dispuesto a reubicarse

EXPERIENCIA REQUERIDA
Exp

en PL/SQL:
5 años +

Exp

en creación de APIs:
5 años +

Exp.

con Linux / Shell Scripting:
5 años +

Exp

con Ansible script:
3 años

Exp

con SQL Developer:
5 años +

Exp

migrando SQL a Oracle:
3 años +

We are looking for a technical lead with 8+ Yrs exp who should have Coordinated with team in understanding the business requirements and delivering the deliverables to the business users.

Design, develop, and support PL/SQL, ETL processes for loading data from external as well as internal systems using SQL Loader and External tables.

Roles and Responsibilities:

Should have hands on experience and be able to guide the team of developers
Design, develop and maintain tables, standard views, materialized views, synonyms,

unique indexes, non-unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors and other database objects.

Extensively worked on creating database objects including tables, indexes, views,
sequences, packages.

Worked with Bulk Collections for bulk load processing. Involved in code walk through and review sessions with the development team.
Extensively done performance tuning of oracle databases by rewriting optimized SQL queries.
Worked on Partitioning large tables using rollback tablespace, range partitioning and
created indexes on various tables to improve query performance.
Extensively worked on SQL commands including all DDL (Data Definition Language), DML(data manipulation language), and DCL (Data Control Language).
Interacted with Business Analysts and Users for gathering and analyzing the Business Report requirements.
Requirements gathering for the Interfaces and custom programs development through meetings with functional team and business users.
Analysis (Business and Technical) of existing system with objective of improving &
optimizing the system performance.
Handled a project where it involved building a process for BEx Team.