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 month
Ability 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.