Senior Oracle Developer # 26-16705

US Tech Solutions, Inc.

Downey, CA, United States

about 1 month ago

Role details

Contract type

Temporary contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

2 years minimum

Compensation

$104,000.0 - $124,800.0

Working hours

Regular working hours

Job source

dejobs.org

Tech stack

C (Programming Language) Backup Devices Bash Shell Unix Client Server Models Computer Programming Databases Data Integration Data Integrity Extract Transform Load (ETL) Data Warehousing Database Design

+20 more

Database Storage Structures Korn Shell PostgreSQL Microsoft SQL Server MongoDB MySQL Oracle (Applications) Oracle SQL Developer Pentaho Data Integration Query Optimization Shell Script Software Engineering PL-SQL SQL*Plus SQL Databases Backup and Restore Database Optimization Analytic Functions Database Performance Toad (Software)

Requirements

language i.e., Bash, C, KornShell, Bourne shell - Knowledgeable about data integration tools like Actian/Pentaho
Excellent verbal and written communication
Extensive expertise in one or multiple database management systems (DBMS) such as Oracle, Microsoft SQL Server, MySQL, PostgreSQL, or MongoDB, encompassing tasks such as installation, configuration, maintenance, and troubleshooting of these systems
Robust abilities in database design and data modeling, encompassing tasks such as crafting efficient database schemas, establishing relationships between tables, maintaining data integrity, and enhancing database structures for optimal performance
Comprehensive grasp of backup and recovery strategies to formulate backup plans, schedule backup procedures, validate restore processes through testing, and execute disaster recovery plans.
Skilled in monitoring and enhancing database performance by addressing performance bottlenecks, fine-tuning SQL queries, adjusting database parameters, deploying indexing strategies, and analyzing database statistics
Proficient in one more Unix scripting Experience Required:
5 years of programming experience as an Oracle PL/SQL Developer
3 years of creating Shell Scripts experience for invoking SQL scripts
5 years of Oracle performance-related features such as Query Optimizer, Execution Plans, and Indexes.
5 years of client-server application development using Oracle 19c, PL/SQL, SQL *Plus, and TOAD
5 years of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-write and Transportable table spaces
2 years of experience with data warehouse concepts, ETL