Pl/Sql Developer

We are looking for a PL/SQL developer with 4+ Yrs exp.**Roles and Responsibilities**:- 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 Collectionsfor 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.**Required Skills**:- 4 Years of Oracle SQL PLSQL Development experience in Oracle SQL Unix Shell Scripting, Performance Query Tuning.- Exposure to reporting tool like SAP Business Objects, Tableau etc.- Good to have experience in some Microsoft Technology not mandatory like Access with understanding of GUI.- Strong experience in writing Functions Procedures packages etc.- Strong experience in writing complex SQL Queries using Joins Hints indexes etc.- Should have worked on different file handling techniques SQL Loader UTL File External Tables etc.- Should be aware of Oracle 11g features.- Oracle PL/SQL.- Unix Shell Scripting.- Performance tuning.Pay: From $40,000.00 per monthAbility to commute/relocate:- 44610, Guadalajara, Jal.: Reliably commute or planning to relocate before starting work (required)**Language**:- English (required)Work Location: Hybrid remote in 44610, Guadalajara, Jal.