Job Details
Experience Needed:
Career Level:
Education Level:
Salary:
Job Categories:
Skills And Tools:
Job Description
- Write complex SQL Queries.
- Create Tables, Synonyms, Views, Global Temporary Table
- Use Index, Hints, Joins, Sequences and partitions
- SQL Queries performance tuning using Explain plan
- SQL Loader, External Table and UTL_FILE package.
- Extraction Transformation and Loading (ETL) processes using UNIX shells scripting, SQL, PL / SQL and SQL Loader.
- Perform design and development of Oracle applications according to project requirements.
- Design, code, and maintain the Oracle systems based on established standards.
- Understand project requirements and develop design specifications.
- Perform initial design reviews and recommend improvements.
- Write clear codes and prepare coding documentations.
- Provide technical assistance to other Developers as needed.
- Analyze and troubleshoot system issues in a timely manner.
- Develop Oracle reports, database procedures and UNIX shell scripts.
- Modify existing codes to optimize Oracle applications.
- Assist in system integration and acceptance testing and perform bug fixes less experienced staffs on programming guidelines.
Job Requirements
- Experience 3 – 5 Yrs. in SQL, PLSQL.
- Oracle Forms and Report experience