Overview
On Site
$60,000 - $80,000
Full Time
Skills
Oracle & PL/SQL
Database Design
Performance Tuning
Unix/Linux
DWH/ETL
SQL*Plus
Oracle Forms & Reports
Job Details
Technical Skills:
- SQL and PL/SQL Mastery:In-depth knowledge of SQL for data manipulation and querying, and advanced proficiency in PL/SQL for developing stored procedures, functions, packages, and triggers. This includes understanding PL/SQL blocks, data types, control structures, and error handling.
- Oracle Database Knowledge:Understanding of Oracle database architecture, including concepts like tablespaces, data files, control files, and redo logs. Familiarity with Oracle database management and administration tasks.
- Database Design:Ability to design and implement efficient and normalized database schemas, including creating tables, views, indexes, and constraints.
- Performance Tuning:Skills in optimizing SQL queries and PL/SQL code for performance, including using tools like SQL Tuning Advisor, Automatic Database Diagnostic Monitor (ADDM), and understanding concepts like quer
- Oracle Tools:Experience with Oracle development tools such as SQL Developer, SQL*Plus, and potentially Oracle Forms or Reports depending on the specific role.
- Operating System Knowledge:Basic understanding of Unix/Linux commands and shell scripting for interacting with the database server and automating tasks.
- Data Warehousing/ETL (Optional but beneficial):Knowledge of data warehousing concepts and experience with ETL tools like Informatica for data extraction, transformation, and loading.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.