Oracle PL/SQL Developer with SSIS Developer

Overview

On Site
$60,000 - $80,000
Full Time

Skills

Oracle
PL/SQL
Performance Tuning
SSIS
ADDM
Unix/Linux
DWH
ETL
T-SQL
Data Modelling
.NET
RDBMS

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.
  • Technical Skills
    • / T-SQL:
      Develop complex stored procedures, functions, and optimize queries.
    • SSIS:
      Design, develop, deploy, and maintain data integration (ETL) solutions, managing tasks, data flow components, and error handling
    • Data Modeling & Warehousing:
      Understand concepts like star schema, dimensional modeling, and data marts to build effective data warehouses.
    • .NET:
      Experience with the .NET platform can be beneficial for developing reusable components.
    • Database Knowledge:
      A good understanding of SQL Server and other relational database management systems (RDBMS).
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.