Oracle Developer

Russell Tobin

Downey, CA, United States

26 days ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

2 years minimum

Compensation

$114,400.0 - $124,800.0

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Bash Shell C Shell Client Server Models Databases Extract Transform Load (ETL) Data Warehousing Database Design Database Development Database Schema Disaster Recovery Korn Shell PostgreSQL

+19 more

Microsoft SQL Server MongoDB MySQL Oracle Databases Oracle (Applications) Pentaho Data Integration Performance Tuning Query Optimization Shell Script Software Engineering PL-SQL SQL*Plus SQL Databases Sql Optimization System Availability Analytic Functions Indexer Information Technology Toad (Software)

Job description

Design, develop, and maintain Oracle database solutions using Oracle 19c, PL/SQL, SQL*Plus, and TOAD.
Develop, optimize, and troubleshoot complex PL/SQL packages, procedures, functions, triggers, and SQL queries.
Design and implement efficient database schemas, data models, and performance optimization strategies.
Monitor and tune Oracle databases using Query Optimizer, Execution Plans, Indexing, and database statistics.
Develop and maintain Unix/Linux shell scripts to automate database operations and execute SQL scripts.
Implement database backup, recovery, and disaster recovery strategies to ensure data availability.
Work with advanced Oracle features including Table Partitioning, Materialized Views, Table Functions, Collections, Analytical Functions, Query Rewrite, and Transportable Tablespaces.
Support data warehouse initiatives and ETL processes using tools such as Actian/Pentaho.
Install, configure, administer, maintain, and troubleshoot Oracle and other database management systems.
Collaborate with cross-functional teams to support database development, maintenance, and production environments.

Requirements

Bachelor’’s degree in Computer Science, Information Technology, or a related field (or equivalent experience).
5+ years of experience as an Oracle PL/SQL Developer.
5+ years of hands-on experience with Oracle 19c, PL/SQL, SQL*Plus, TOAD, and client-server application development.
Strong experience with Oracle performance tuning including Query Optimizer, Execution Plans, SQL optimization, and Indexing.
Experience with advanced Oracle database features including Table Functions, Table Partitioning, Materialized Views, Collections, Analytical Functions, Query Rewrite, and Transportable Tablespaces.
3+ years of experience developing Unix/Linux Shell Scripts (Bash, KornShell, Bourne Shell, or C Shell).
2+ years of experience with Data Warehouse concepts and ETL processes.
Experience with database administration, backup and recovery, disaster recovery, database design, and data modeling.
Familiarity with Microsoft SQL Server, MySQL, PostgreSQL, and MongoDB is a plus.
Excellent verbal and written communication skills.

About the company

Russell Tobin offers eligible employee’s comprehensive healthcare coverage (medical, dental, and vision plans), supplemental coverage (accident insurance, critical illness insurance and hospital indemnity), 401(k)-retirement savings, life & disability insurance, an employee assistance program, legal support, auto, home insurance, pet insurance and employee discounts with preferred vendors.